502.xlsx - ACI December 31 Balance Sheet($ million except for per share data 2014 2015 2016 2017 2018 Assets Cash and cash Equivalents Accounts

502.xlsx - ACI December 31 Balance Sheet($ million except...

This preview shows page 1 - 5 out of 28 pages.

ACI: December 31 Balance Sheet ($ million, except for per share data) 2014 2015 2016 2017 2018 Assets: Cash and cash Equivalents 15 45 50 12 5 Accounts Receivables 180 195 221 210 250 Inventory 270 225 240 350 410 Total Currents Assets 465 465 511 572 665 Net plant and equipment 280 290 308 130 90 Total Non-Currents Assets 280 290 308 130 90 TOTAL ASSETS 745 755 819 702 755 Liabilities and Equity: Accounts payable 40 44 40 80 60 Accurals 60 50 50 20 70 Notes payable 60 50 55 140 230 Total Currents Liabilities 160 144 145 240 360 Long term Bonds 305 287 280 119 116 Total Non-Currents Liabilities 305 287 280 119 116 TOTAL LIABILITIES 465 431 425 359 476 Common Stock (25 million shares ) 130 130 130 130 130 Retained Earnings 150 194 264 213 149 TOTAL COMMON EQUITY 280 324 394 343 279 TOTAL LIABILITIES AND EQUITY 745 755 819 702 755 Book value per share 11.2 12.9 15.7 13.7 11.1 Market value per share 23 25 26 5 3
Image of page 1

Subscribe to view the full document.

ACI: Income Statement for Years Ending December 31 ($ million, except for per share data) 2014 2015 2016 2017 2018 Net Sales 1500 1550 1700 650 430 Variable Operating Cost (82% of sales) 1230 1271 1394 533 352 Gross Profit 270.0 279.0 306.0 117.0 78.0 Fixed operating cost except depreciation 90 85 70 75 75 EBITDA 180.0 194.0 236.0 42.0 3.0 Depreciation 50 40 35 45 40 EBIT/NOI 130.0 154.0 201.0 -3.0 -37.0 Interest 40 35 38 65 70 EBT 90.0 119.0 163.0 -68.0 -107.0 Taxes (40%) 36 #NAME? #NAME? #NAME? #NAME? Net Income 54.0 #NAME? #NAME? #NAME? #NAME? Preferred Dividends 0 0 0 0 0 Earning available to common shareholders 54.0 #NAME? #NAME? #NAME? #NAME? Common Dividends 29 27 28 10 0 Additional to Retained earnings 25.0 #NAME? #NAME? #NAME? #NAME? Per share data (25 million shares) Earnings per share =(NI/shares) 2.16 2.86 3.91 -1.63 -2.58 Dividend per share=(Common dividend/shares) 1.16 1.08 1.12 0.4 0
Image of page 2
Financial Ratios of ACI Liquidity Ratios : 2014 2015 2016 2017 2018 1. Current ratio 2.9 3.2 3.5 2.4 1.8 2. Quick Ratio 1.2 1.7 1.9 0.9 0.7 1. Current ratio = Current Assets / Current Liabilities 2. Quick Ratio = (Current Assets - Inventories) / Current Liabilities Asset Management Ratios : 2014 2015 2016 2017 2018 1. Inventory Turnover 4.6 5.6 5.8 1.5 0.9 2. Accounts Receivable Turnover 8.3 7.9 7.7 3.1 1.7 3. Days Sales Outstanding 43.8 45.9 47.5 117.9 212.2 4. Days Inventory Held 80.1 64.6 62.8 239.7 425.1 5. Fixed Assets Turnover 5.4 5.3 5.5 5.0 4.8 6. Total Assets Turnover 2.0 2.1 2.1 0.9 0.6 1. Inventory Turnover = COGS / Average Inventory 2. Accounts Receivable Turnover = Sales / Average Accounts Receivable 3. Days Sales Outstanding = 365 / Accounts Receivable Turnover 4. Days Inventory Held = 365 / Inventory Turnover 5. Fixed Assets Turnover = Net Sales / Total Fixed Assets 6. Total Assets Turnover = Net Sales / Total Assets Debt Management Ratios : 2014 2015 2016 2017 2018 1. Debt Ratio 62% 57% 52% 51% 63% 2. Debt to Capital 62% 57% 52% 51% 63% 3. Debt to Equity 166% 133% 108% 105% 171% 4. Time Interest Earned 3.25 4.40 5.29 -0.05 -0.53 1. Debt Ratio = Total Liabilities / Total Assets 2. Debt to Capital = Total Liabilities / (Total Liabilities + Total Equity) 3. Debt to Equity = Total Liabilities / Total Equity 4. Time Interest Earned = EBIT / Interest Charges
Image of page 3

Subscribe to view the full document.

Profitability Ratios : 2014 2015 2016 2017 2018 1. GP Margin 18% 18% 18% 18% 18% 2. NP Margin 9% 10% 12% 0% -9% 3. ROA 10% 12% 15% 0% -3% 4. Pretax ROA 17% 20% 25% 0% -5% 5. ROE 19% 22% 25% -12% -23% 6. ROIC 11% 13% 16% 0% -3% 1. GP Margin = GP / Net Sales 2. NP Margin = NP / Net Sales 3. ROA = EBIT (1-T) / Total Assets 4. Pretax ROA = EBIT / Total Assets 5. ROE = NI / Shareholder's Equity 6. ROIC = EBIT (1-T) / (Debt + Equity - Cash) Profitability Ratios : 2014
Image of page 4
Image of page 5
  • Summer '17
  • Abu Taher Sir

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes