Financials Revised - Working Capitals (Group 2) Modeling...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: Working Capitals (Group 2) Modeling Exercise June 16, 2011 Hypothetical Modeling ABC Company Ratio Analysis Ratio Analysis Integration with Financial Statement Modeling and Valuation (In millions of dollars) Balance Sheet 2007 2009 2010 201 1 2012 Cash 4.46 28.22 41.08 54. 48 68.48 Accounts Receivable 3.7 4.3 4.7 5.1 5.5 Accounts Receivable days formula Inventory 6.11 7.10 7.70 8.3 8 9.15 Inventory days formula Other current assets 1.76 1.9 2.0 2.2 2.4 Percentage of Sales from 2007 Total current assets 16.02 41.50 55.49 70. 16 85.60 Capital assets 40.0 40.0 40.0 40. 40.0 Other long term 12.4 13.5 14. 16.0 Percentage of Working Capitals (Group 2) Modeling Exercise June 16, 2011 assets 10.54 6 Sales from 2007 Total assets 66.56 93.90 108.94 1 24. 80 141.59 Accounts payable 9.16 10.6 11.5 12. 6 13.7 AP days formula Deferred tax liability 7.00 7.0 7.0 7.0 13.9 Other current liabilities 0.74 0.0 0.0 0.0 0.0 Percentage of Sales from 2007 Total current liabilities 16.9 17.6 18.5 19. 5 27.6 External debt 16.9 25.2 30.0 35....
View Full Document

Page1 / 7

Financials Revised - Working Capitals (Group 2) Modeling...

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

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