finance 304
these are given data
needed to fill up yellow highlighted part
thank you
Get Office 365 A B 3 4 D E F G H K COMPARATIVE SIZE BALANCE SHEETS - Allied Food Products - December 31 (in millions of dollars) L M 2017 2016 $ 6 7 8 9 10 11 12 13 14 15 16 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,600 80 315 415 810 870 $ $ 2.600 $ 1,680 Ilahi L M N $ Llabilities and equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total debt Common stock (SOM shares) Retained earnings Total common equity Total liabilities and equity $ $ 60 $ 110 140 310 $ 750 1,060 $ 130 810 940 $ 2.000 30 60 130 220 580 800 130 750 880 1,680 $ $ INCOMIC ETAP M N 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 2017 2016 $ 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 $ 283.8 $ 263.0 88.0 60.0 $ 195.8 $ 203.0 78.3 81.2 $ 117.5 $ 121.8 B F G . K L M N O D E EBITDA Calculation Net Income Interest Taxes Depreciation/Amortization EBITDA SECTIONS 4-1 TO 4-6, RATIO ANALYSIS 2017 2016 Ind Avg 4.20 2.20 Liquidity ratios Current Ratio Quick Ratio Asset Management ratios Inventory Turnover Days Sales Outstanding Debt Management ratios Debt to EBITDA 10.90 36.00 Bank Not Required B E G H K L M N O Profitability ratios Gross Margin% EBITDA Margin % Operating Margin Profit Margin Return on Equity Market Value ratios EBITDA Multiple @ 5X 50% 15% 10% 5% 15% + 5.00 Pictures Are Good!!! N ROE o Trend Analysis: Allied's ROE 0.18 0.17 0.16 0.15 Industry + 0.14 0.13 0.12 0.11 Allied 0.1 2007 2008 2009 Year 2010 2011