Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Computron's
|
Projection | |||||
2018 | 2019 | 2020E | ||||
Assets | ||||||
Cash and equivalents | $ 60 | $ 50 | $ 60 | |||
Short-term investments | 100 | 10 | 50 | |||
Accounts receivable | 400 | 520 | 530 | |||
Inventories | 620 | 820 | 660 | |||
Total current assets | $ 1,180 | $ 1,400 | $ 1,300 | |||
Net Fixed Assets | 2,900 | 3,500 | 3,700 | |||
Total Assets | $ 4,080 | $ 4,900 | $ 5,000 | |||
Liabilities and equity | ||||||
Accounts payable | $ 300 | $ 400 | $ 330 | |||
Notes payable | 50 | 250 | 100 | |||
Accruals | 200 | 240 | 270 | |||
Total current liabilities | $ 550 | $ 890 | $ 700 | |||
Long-term bonds | 800 | 1,100 | 1,100 | |||
Total liabilities | $ 1,350 | $ 1,990 | $ 1,800 | |||
Common stock (100,000 shares) | 1,000 | 1,000 | 1,000 | |||
1,730 | 1,910 | 2,200 | ||||
Total common equity | $ 2,730 | $ 2,910 | $ 3,200 | |||
Total liabilities and equity | $ 4,080 | $ 4,900 | $ 5,000 | |||
Income Statements (Millions of Dollars) | Projection | |||||
2018 | 2019 | 2020E | ||||
Net sales | $ 5,500 | $ 6,000 | $ 6,600 | |||
Cost of goods sold (Excluding depr.) | $ 4,300 | $ 4,800 | $ 5,210 | |||
Depreciationa | $ 290 | $ 320 | $ 370 | |||
Other operating expenses | $ 350 | $ 420 | $ 400 | |||
Earnings before interest and taxes (EBIT) | $ 560 | $ 460 | $ 620 | |||
Less interest | $ 68 | $ 108 | $ 100 | |||
Pre-tax earnings | $ 492 | $ 352 | $ 520 | |||
Taxes (25%) | $ 123 | $ 88 | $ 130 | |||
Net Income | $ 369 | $ 264 | $ 390 | |||
Notes: | ||||||
a Computron has no amortization charges. | ||||||
Additional Information | Projection | |||||
2018 | 2019 | 2020E | ||||
Year-end common stock price | $50.00 | $30.00 | $49.00 | |||
Shares outstanding (millions) | 100 | 100 | 100 | |||
Common dividends (millions) | $90 | $84 | $100 | |||
Tax rate | 25% | 25% | 25% | |||
Additions to retained earnings (millions) | $279 | $180 | $290 | |||
Lease payments (millions) | $20 | $20 | $20 | |||
Per Share Information | Projection | |||||
2018 | 2019 | 2020E | ||||
EPS | $3.69 | $2.64 | $3.90 | |||
DPS | $0.90 | $0.84 | $1.00 | |||
Book Value Per Share | $27.30 | $29.10 | $32.00 | |||
Ratio Analysis |
2018
|
2019
|
2020E
|
Industry
Average |
||
Profit margin | 6.7% | 4.4% | 7.2% | |||
Operating profit margin | 10.2% | 7.7% | 10.4% | |||
Basic earning power | 13.7% | 9.4% | 15.6% | |||
9.0% | 5.4% | 10.8% | ||||
13.5% | 9.1% | 15.4% | ||||
Inventory turnover | 7.4 | 6.2 | 9.0 | |||
Days sales outstanding | 26.5 | 31.6 | 28.0 | |||
Fixed assets turnover | 1.9 | 1.7 | 3.0 | |||
Total assets turnover | 1.348 | 1.224 | 1.5 | |||
Current | 2.1 | 1.6 | 2.5 | |||
Quick | 1.0 | 0.7 | 1.9 | |||
Debt ratio | 20.8% | 27.6% | 15.0% | |||
Debt-to-equity ratio | 0.31 | 0.46 | 0.22 | |||
Liabilities-to-assets ratio | 33.1% | 40.6% | 32.0% | |||
Earnings multiplier | 1.5 | 1.7 | 1.5 | |||
TIE | 8.2 | 4.3 | 13.0 | |||
EBITDA coverage | 9.9 | 6.3 | 17.2 | |||
Price/earnings (P/E) | 13.6 | 11.4 | 16.8 | |||
Market/book | 1.8 | 1.0 | 2.7 | |||
- Calculate the projected debt ratio, debt-to-equity ratio, liabilities-to-assets ratio, times-interest-earned ratio, and EBITDA coverage ratios. Explain how Computron compares with the industry with respect to financial leverage. What can you conclude from these ratios?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
perform a common size analysis and percentage change
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
perform a common size analysis and percentage change
Solution
by Bartleby Expert
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Additional information: 2018 current ratio: 1.4:1 debt to total assets: 61.1% Question: find working capital for 2018 Additional information: 2017 current ratio 1.5:1 working capital: 214,500 Question find debt to total assets for 2017arrow_forwardLendell Company has these comparative balance sheet data: Lendell CompanyBalance SheetsDecember 31 2020 2019 Cash $ 16,000 $ 31,000 Accounts receivable (net) 69,000 60,000 Inventory 59,000 51,000 Plant assets (net) 198,000 179,000 $342,000 $321,000 Accounts payable $50,000 $60,700 Mortgage payable (15%) 107,500 107,500 Common stock, $10 par 136,500 121,000 Retained earnings 48,000 31,800 $342,000 $321,000 Additional information for 2020: 1. Net income was $24,700. 2. Sales on account were $414,050. Sales returns and allowances amounted to $20,600. 3. Cost of goods sold was $198,000. 4. Net cash provided by operating activities was $44,300. 5. Capital expenditures were $26,400, and cash dividends were $8,800. Compute the following ratios at December 31, 2020. (Round current ratio to 2 decimal places, e.g. 1.67. Round…arrow_forwardBalance Sheets 2019 2018 Assets Cash and equivalents $100 $85 Accounts receivable 275 300 Inventories 375 250 Total current assets $750 $635 Net plant and equipment 2,300 1,490 Total assets $3,050 $2,125 Liabilities and Equity Accounts payable $150 $85 Accruals 75 50 Notes payable 150 75 Total current liabilities $375 $210 Long-term debt 450 290 Total liabilities 825 500 Common stock 1,225 1,225 Retained earnings 1,000 400 Common equity 2,225 1,625 Total liabilities and equity $3,050 $2,125 Income Statements 2019 2018 Sales $2,065 $1,525 Operating costs excluding depreciation and amortization 1,250 1,000 EBITDA $815 $525 Depreciation and amortization 100 75 EBIT $715 $450 Interest 63 46 EBT $652 $404 Taxes (25%) 163 101 Net income $489 $303 Dividends paid $54 $48 Addition to…arrow_forward
- Quantitative Problem: Rosnan Industries' 2022 and 2021 balance sheets and income statements are shown below. Balance Sheets: 2022 2021 Assets Cash and equivalents $ 100 $ 85 Accounts receivable 275 300 Inventories 375 250 Total current assets $ 750 $ 635 Net plant and equipment 2,300 1,490 Total assets $ 3,050 $ 2,125 Liabilities and Equity Accounts payable $ 150 $ 85 Accruals 75 50 Notes payable 150 75 Total current liabilities $ 375 $ 210 Long-term debt 450 290 Total liabilities $ 825 $ 500 Common stock 1,225 1,225 Retained earnings 1,000 400 Total common equity $ 2,225 $ 1,625 Total liabilities and equity $ 3,050 $ 2,125 Income Statements: 2022 2021 Sales $ 2,405 $ 1,585 Operating costs excluding depreciation 1,250 1,000 EBITDA $…arrow_forwardReturn on Assets Calculate the company's return on assets for 2020 and compare the result to the industry average.arrow_forwardCurrent Attempt in Progress Suppose McDonald's 2025 financial statements contain the following selected data (in millions). Current assets Total assets Current liabilities Total liabilities (a1) a. b. C. $3,330.0 Compute the following values. d. 30,230.0 3,000.0 15,719.6 Interest expense Income taxes Net income $480.0 1,938.0 4,542.0 Working capital. (Round to 1 decimal place in millions, e.g. 5,275.5.) Current ratio. (Round to 2 decimal places, e.g. 6.25:1.) Debt to assets ratio. (Round to O decimal places, e.g. 62%.) Times interest earned. (Round to 2 decimal places, e.g. 6.25.) $ millions :1 % timesarrow_forward
- Using Financial Statements for 2020, sales to working capital for the year 2020 is 2.41. True or False?arrow_forwardFind return on financial leverage and return of financial leverage ratio for years 2017, 2018, and 2019.arrow_forwardGIVE THE COMPARATIVE BALANCE SHEET HORIZONTAL ANALYSIS FROM THE GIVEN BALANCE SHEET BELOW JOLLIBEE BALANCE SHEET ASSETS ITEM 2016 2017 2018 2019 2020 Cash & Short Term Investments 17.46B 22.52B 24.17B 23.02B 57.46B Cash & Short Term Investments Growth - 28.99% 7.32% -4.75% 149.59% Cash Only 16.73B 21.11B 23.29B 20.89B 21.36B Short-Term Investments 726M 1.41B 883.2M 2.13B 36.1B Cash & ST Investments / Total Assets 23.96% 25.08% 16.06% 12.28% 27.26% Total Accounts Receivable 3.59B 4.02B 4.86B 5.91B 7.05B Total Accounts Receivable Growth - 11.86% 21.04% 21.46% 19.36% Accounts Receivables, Net 3.03B 3.39B 4.41B 5.37B 5.8B Accounts Receivables, Gross 3.61B 4.08B 5.09B 5.76B 6.46B Bad Debt/Doubtful Accounts (579.79M) (690.12M) (676.91M) (392.36M) (658.63M) Other Receivable 562.75M 630.06M 451.73M 536.62M 1.25B…arrow_forward
- GIVE THE COMPARATIVE BALANCE SHEET HORIZONTAL AND VERTICAL ANALYSIS FROM THE GIVEN BALANCE SHEET BELOW JOLLIBEE BALANCE SHEET ASSETS ITEM 2016 2017 2018 2019 2020 Cash & Short Term Investments 17.46B 22.52B 24.17B 23.02B 57.46B Cash & Short Term Investments Growth - 28.99% 7.32% -4.75% 149.59% Cash Only 16.73B 21.11B 23.29B 20.89B 21.36B Short-Term Investments 726M 1.41B 883.2M 2.13B 36.1B Cash & ST Investments / Total Assets 23.96% 25.08% 16.06% 12.28% 27.26% Total Accounts Receivable 3.59B 4.02B 4.86B 5.91B 7.05B Total Accounts Receivable Growth - 11.86% 21.04% 21.46% 19.36% Accounts Receivables, Net 3.03B 3.39B 4.41B 5.37B 5.8B Accounts Receivables, Gross 3.61B 4.08B 5.09B 5.76B 6.46B Bad Debt/Doubtful Accounts (579.79M) (690.12M) (676.91M) (392.36M) (658.63M) Other Receivable 562.75M 630.06M 451.73M…arrow_forwardCalculate Debt-to-equity Times interest earned Return on Financial leveragearrow_forwardwhat was the net capital spending in 2021 and 2022 please avoid solutions image based thnxarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education