Modeling Exercise Financials

Modeling Exercise Financials - Hypothetical Modeling ABC...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Hypothetical Modeling ABC Company Ratio Analysis Ratio Analysis Integration with Financial Statement Modeling and Valuation (In millions of dollars) Balance Sheet 2007 2008 2009 2010 2011 2012 Cash 5.40 17.3 29.9 43.2 57.4 72.6 Accounts Receivable 3.70 4.0 4.3 4.7 5.1 5.5 Accounts Receivable days formula Inventory 6.10 6.6 7.2 7.9 8.6 9.5 Inventory days formula Other current assets 1.70 1.8 1.9 2.1 2.3 2.5 Percentage of Sales from 2007 Total current assets 16.90 29.7 43.4 57.9 73.5 90.2 Capital assets 40.0 40.0 40.0 40.0 40.0 40.0 Other long term assets 10.60 11.4 12.4 13.4 14.6 16.0 Percentage of Sales from 2007 Total assets 67.50 81.2 95.8 111.3 128.1 146.1 Accounts payable 9.20 9.9 10.8 11.8 13.0 14.3 AP days formula Deferred tax liability 7.00 7.0 7.0 7.0 7.0 13.9 Other current liabilities 0.70 0.0 0.0 0.0 0.0 0.0 Percentage of Sales from 2007 Total current liabilities 16.90 16.9 21.2 18.8 20.0 28.2 External debt 16.90 20.8 24.9 29.2 33.9 39.0 External debt to equity ratio Total debt
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

Modeling Exercise Financials - Hypothetical Modeling ABC...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online