Case study

lafette.szmmoqs
Financialsheet.xlsx
Home>Business & Finance homework help>Accounting homework help>Case study

13.6

Income statement Balance sheet Ratios
2008 2009 2010 2011 2008 2009 2010 2011 2008 2009 2010 2011
Net Sales 1697 2013 2694 Cash 58 48 41 Curr 1.80 1.59 1.45
CGS 1222 1437 1950 AR 171 222 317 Quick 0.88 0.72 0.67
Gross Margin 475 576 744 Inv 239 326 418 Debt 0.55 0.59 0.63
CA 468 596 776 TIE 3.85 3.05 2.61
Operating Exp 425 515 658 Inv Turn 8.04 7.13 7.24
EBIT 50 61 86 Net Fixed 126 140 157 DSO 36.78 40.25 42.95
Interest 13 20 33 APO 26.67 34.81 34.68
EBT 37 41 53 Total 594 736 933
Taxs 6 7 9
NI 31 34 44 Notes Bank 0 146 233 2008 2009 2010 2011
Notes Stark 105 0 0 PM 1.83% 1.69% 1.63%
Notes Trade 0 0 0 ROI 11.48% 11.18% 12.64%
Total 105 146 233 ROA 5.22% 4.62% 4.72%
Beg. Inv 183 239 326
Purchases 1278 1524 2042 AP 124 192 256
Ending Inventory 239 326 418 Accruals 24 30 39
Cost of Goods Sold 1222 1437 1950 L-T Debt-Current 7 7 7
Total CL 260 375 535
L-T Debt 64 57 50
Total Liabilities 324 432 585
OE 270 304 348

Sheet2