{"product_id":"1232847_acca-learning","title":"Introduction to Financial Modelling and Valuation","description":"\u003cb\u003eAbout this webinar\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eThe basics of being efficient at Excel\u003c\/li\u003e\n\u003cli\u003eNavigation\u003c\/li\u003e\n\u003cli\u003eShort cuts - use of the keyboard!\u003c\/li\u003e\n\u003cli\u003eThe start of the model:\u003c\/li\u003e\n\u003cli\u003eSetting up the individual pages\u003c\/li\u003e\n\u003cli\u003eGetting the input page and forecast drivers\u003c\/li\u003e\n\u003cli\u003eCreating the Income Statement, Cash Flow Statement and Balance sheet pages and getting the base data in\u003c\/li\u003e\n\u003cli\u003ePushing that base data into a clean modelling proforma, building the links between the sheets to drive the model.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\n\u003cb\u003eForecast Drivers\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eWe know work through all the things we think drive the value of a company and see how this fills out the future financial statements\u003c\/li\u003e\n\u003cli\u003eWe keep working down all of those forecast drivers\u003c\/li\u003e\n\u003cli\u003eThe focus here is making sure the financial statements balance, and we check the ‘flow’ of the forecast drivers through the model\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\n\u003cb\u003eBuilding a Discounted Cash Flow\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eThe concept of DCF\u003c\/li\u003e\n\u003cli\u003eBringing in EBITDA and the relevant cash flows\u003c\/li\u003e\n\u003cli\u003eBuilding out a WACC – getting the cost of Debt and the cost of Equity\u003c\/li\u003e\n\u003cli\u003eDiscounting the cashflows to get Enterprise Value\u003c\/li\u003e\n\u003cli\u003eMaking the adjustments to get back to value of Equity.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\n\u003cb\u003eComparable Analysis\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003ePutting together a peer group, selecting the group from data\u003c\/li\u003e\n\u003cli\u003eIdentifying key ratios to apply analysis\u003c\/li\u003e\n\u003cli\u003eCalculating the peer group multiples\u003c\/li\u003e\n\u003cli\u003eApplying to our numbers and getting a valuation.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\n\u003cb\u003eSpeaker\u003c\/b\u003e\u003cbr\u003e\nRob Morgan CFA","brand":"acca-learning","offers":[{"title":"Standard price \/ 0","offer_id":45022667243771,"sku":"100184","price":475.0,"currency_code":"GBP","in_stock":true},{"title":"Aramco - Tenant user \/ 1208826","offer_id":45022667374843,"sku":"100184","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"Students \/ 110169","offer_id":45022667342075,"sku":"100184","price":475.0,"currency_code":"GBP","in_stock":true},{"title":"Members \/ 110167","offer_id":45022667309307,"sku":"100184","price":450.0,"currency_code":"GBP","in_stock":true},{"title":"Continuous learners \/ 3","offer_id":45022667276539,"sku":"100184","price":475.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0535\/6057\/4115\/files\/MS_WEB_MAY23_FM_IMAGE_1232830.jpg?v=1780723243","url":"https:\/\/acca-learning.myshopify.com\/products\/1232847_acca-learning","provider":"acca-learning","version":"1.0","type":"link"}