required to calculate various financial ratios.

Please put in the Formulas in Excel.

A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B C D E F I 04 Chapter model COMPARATIVE SIZE BALANCE SHEETS - Allied Food Products - December 31 (in millions of dollars) 2013 Assets Cash and equivalents Accounts receivable Inventories Total current assets Net plant and equipment Other LT assets Total assets $ $ $ 10 $ 375 615 1,000 $ 1,000 2,000 $ 2012 80 315 415 810 870 1,680 A 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 B C Liabilities and equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total debt Common stock (50M shares) Retained earnings Total common equity Total liabilities and equity D $ $ $ $ $ 60 110 140 310 750 1,060 130 1,410 1,540 2,600 E $ $ $ $ $ F 30 60 130 220 580 800 130 750 880 1,680 INCOME STATEMENTS - Allied Food Products - Years Ending December 31 (in millions of dollars) Net sales COGS Gross Margin Oper costs except depr'n & amort. Depreciation and amortization Operating income (EBIT) Less interest Earnings before taxes (EBT) Taxes Net income EBITDA Calculation Net Income Interest Taxes Depreciation/Amortization EBITDA 2013 2012 $ 3,000.0 $ 2,850.0 $ 1,000.0 $ 1,000.0 $ 2,000.0 $ 1,850.0 1,616.2 1,497.0 100.0 90.0 $ 1,283.8 $ 1,263.0 88.0 60.0 $ 1,195.8 $ 1,203.0 478.3 481.2 $ 717.5 $ 721.8 I A 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 B C D E F I SECTIONS 4-1 TO 4-6, RATIO ANALYSIS Liquidity ratios Current Ratio Quick Ratio Asset Management ratios Inventory Turnover Days Sales Outstanding Debt Management ratios Debt to EBITDA Loan to Value Profitability ratios Gross Margin % EBITDA Margin % Operating Margin Profit Margin Return on Equity Market Value ratios EBITDA Multiple @ 5X 2011 2010 Ind Avg 4.20 2.20 10.90 36.00 400 Bank Bank 50% 15% 10% 5% 15% 5.00