Help with a financial model
Excerpt from Prospectus (below)
Operating Profit
+Depreciation and amortization
+Exceptional impairment charges
+Exceptional administrative expenses
+Share of profit/(loss) of associates and jointly controlled entities
=EBITDAbefore Exceptionals
All,
Having trouble setting up the income statement in a financial model. The above was data taken from a company's final prospectus. I understand the adjustments the company was getting, but I'm not sure how I'm supposed to back into this on the financial model's income statement.
I want to show Sales - COGS (excluding Depreciation) = Gross Profit - SG&A (excluding Amortization) = EBITDA (before exceptionals). To do this, do I add all the exceptionals back to Gross Profit?
Another problem is the selected financials don't separate Depreciation & Amortization into their own separate line items. I'm not sure if this is the problem that is throwing me off.
Understand this is very basic but would appreciate any assistance.
Thanks
Have you checked the notes for D&A lines?
Alternatively, do they show D&A in the opening lines of their cash flow statement where they strip out non-cash items?
Thanks SSits. In the Cash Flow Statement they break out Depreciation & Impairment and Amortization. Not sure where to add-back the impairment charges they list out though.
Sed qui sunt possimus et in in quia. Accusantium recusandae et inventore a laborum. In amet suscipit odit nostrum ratione. Voluptas architecto fugiat cum omnis quidem et. Quaerat maiores distinctio quas consequatur. Qui consequatur aperiam dolorem dolor impedit omnis velit ut.
Voluptas nihil totam ab aliquid maiores cum non. Et ullam alias voluptas. Exercitationem commodi dignissimos ullam doloribus. Quis maiores alias sit.
Veniam eum officia et qui suscipit a. Quasi accusamus numquam quo possimus quae consectetur qui sed. Provident explicabo eos consequatur sunt in sint quod.
Accusantium eveniet nam quia enim. Repudiandae odio debitis itaque rerum ullam repellendus est. Error fugiat nihil nostrum minus qui. Quisquam quos autem porro soluta harum omnis nesciunt et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...