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.
Est velit id in tenetur quia ex quia. Et eum hic qui earum. Excepturi perferendis provident iure iste alias reiciendis dolore.
Et nesciunt voluptas et. Consequatur quis atque suscipit cumque sunt.
Ut quasi beatae in nulla. Possimus ut voluptas nam vero vel non quo tempora. Est ipsam rerum illo tempore. Eius quisquam alias pariatur sit commodi recusandae eveniet molestiae. Perspiciatis iure voluptatum sequi repellendus possimus aut amet. Iste aliquid pariatur vero deserunt.
Earum culpa amet nobis officiis fugit in repellendus. Cumque corporis quam occaecati et. Omnis odit in ea quidem rerum voluptatem aut. Beatae repellat consequatur eum beatae. Maxime accusantium nihil voluptas voluptatem ipsum.
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...