ABC Modeling Exercise Financials

ABC Modeling Exercise Financials - Hypothetical Modeling...

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 4.46 15.83 28.22 41.08 54.48 68.48 Accounts Receivable 3.7 4.0 4.3 4.7 5.1 5.5 Accounts Receivable days formula Inventory 6.11 6.57 7.10 7.70 8.38 9.15 Inventory days formula Other current assets 1.76 1.7 1.9 2.0 2.2 2.4 Percentage of Sales from 2007 Total current assets 16.02 28.13 41.50 55.49 70.16 85.60 Capital assets 40.0 40.0 40.0 40.0 40.0 40.0 Other long term assets 10.54 11.5 12.4 13.5 14.6 16.0 Percentage of Sales from 2007 Total assets 66.56 79.60 93.90 108.94 124.80 141.59 Accounts payable 9.16 9.9 10.6 11.5 12.6 13.7 AP days formula Deferred tax liability 7.00 7.0 7.0 7.0 7.0 13.9 Other current liabilities 0.74 0.0 0.0 0.0 0.0 0.0 Percentage of Sales from 2007 Total current liabilities 16.9 16.8 17.6 18.5 19.5 27.6 External debt 16.9 20.9 25.2 30.0 35.3 41.2 External debt to equity ratio Total debt 33.8 37.7
Background image of page 1

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

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

This note was uploaded on 02/09/2012 for the course ECON 440 taught by Professor Fenn during the Spring '11 term at American Internation College.

Page1 / 4

ABC Modeling Exercise Financials - Hypothetical Modeling...

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