EBK FUNDAMENTALS OF CORPORATE FINANCE
3rd Edition
ISBN: 9780133762808
Author: Harford
Publisher: PEARSON CUSTOM PUB.(CONSIGNMENT)
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 20, Problem 1CQ
Based on the
1 | Year | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
2 | Income Statement ($000s) | ||||||
3 | Sales | 100,000 | |||||
4 | Cost of Goods Sold | -45,333 | |||||
5 | Gross Profit | 54,667 | |||||
6 | Sales and Marketing | -15,000 | |||||
7 | Administration | -18,000 | |||||
8 | EBITDA | 21,667 | |||||
9 | -6,667 | ||||||
10 | EBIT | 15,000 | |||||
11 | Interest Expense (net) | -1,021 | |||||
12 | Pretax Income | 13,979 | |||||
13 | Income Tax | -4,893 | |||||
14 | Net Income | 9,086 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Suppose a firm has had the following historic sales figures.
Year:
Sales
2016
$1,900,000
2017
$2,150,000
2018
$1,800,000
2019
$2,400,000
2020
$2,000,000
What would be the forecast for next year's sales using the average approach?
Next year's sales
Suppose a firm has had the following historic sales figures.
Year:
2016
Sales $1,420,000
2017
$1,720,000
Next year's sales
2018
2019
2020
$1,600,000 $2,010,000 $1,770,000
What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend?
Note: Round your answer to the nearest whole dollar.
27
Suppose a firm has had the following historic sales figures.
Year:
2016
2017
2018
2019
2020
Sales $1,500,000 $1,670,000 $1,580,000 $2,160,000 $1,890,000
What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend?
Note: Round your answer to the nearest whole dollar.
Next year's sales
Chapter 20 Solutions
EBK FUNDAMENTALS OF CORPORATE FINANCE
Ch. 20 - Prob. 1CCCh. 20 - 2. What is the effect of seasonalities on...Ch. 20 - Prob. 3CCCh. 20 - Prob. 4CCCh. 20 - Prob. 5CCCh. 20 - Prob. 6CCCh. 20 - Prob. 7CCCh. 20 - Prob. 8CCCh. 20 - Prob. 9CCCh. 20 - Prob. 10CC
Ch. 20 - Based on the forecasts in this case, use the...Ch. 20 - Use the following spreadsheet to project Idexo’s...Ch. 20 - Based on the forecasts you have already developed,...Ch. 20 - Prob. 4CQCh. 20 - Prob. 5CQCh. 20 - Prob. 1CTCh. 20 - Prob. 2CTCh. 20 - Which of the following companies are likely to...Ch. 20 - Prob. 4CTCh. 20 - Prob. 5CTCh. 20 - Prob. 6CTCh. 20 - Prob. 7CTCh. 20 - What is the difference between evergreen credit...Ch. 20 - Prob. 9CTCh. 20 - Prob. 10CTCh. 20 - Prob. 11CTCh. 20 - Prob. 1PCh. 20 - Prob. 2PCh. 20 - Prob. 3PCh. 20 - The following table includes quarterly working...Ch. 20 - Prob. 5PCh. 20 - Prob. 6PCh. 20 - Prob. 7PCh. 20 - Hand-to-Mouth (H2M) is currently cash-constrained,...Ch. 20 - Prob. 9PCh. 20 - Prob. 10PCh. 20 - Prob. 11PCh. 20 - Prob. 12PCh. 20 - Prob. 13PCh. 20 - Prob. 14PCh. 20 - Prob. 15PCh. 20 - Prob. 16PCh. 20 - The Rasputin Brewery is considering using a public...Ch. 20 - Prob. 18P
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
- Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,530,000 $1,720,000 $1,560,000 $2,100,000 $1,850,000 What would be the forecast for next year’s sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar.arrow_forwardA company has the following items for the fiscal year 2020: Revenue = 10 million EBIT = 4 million Net income = 2 million Total Equity = 15 million Total Assets = 30 million Calculate the company’s net profit margin, asset turnover, equity multiplier and ROEarrow_forward
- Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000arrow_forwardNikularrow_forwardA. Wally asks you to create an Income Statement for 2020 using the information below. 1. 2020 sales were 150% of last year’s sales2. Gross profit margin was 55%3. Operating profit margins were 15% 4. Interest expense fell to 7%, given a change in interest rates 5. The tax rate was 30% B. Based on the change in Income between 2020 and 2019, how would you say AndrewCo is doing?arrow_forward
- Using Yahoo Finance for your data & information, calculate the following items for the public company, WK Kellogg Co (KLG), showing your work: a. Value using industry average P/E ratio for trailing 12 months EPS. b. P/E ratio for most recent fiscal year end earnings. c. How does Kellogg's P/E ratio compare to others in the industry?arrow_forwardForecast the next year Income Statement using the base year and growth rates. Use all formulas, not numbers. Sales Cost of Sales Gross Margin Operating Expenses R&D Operating Profit Interest Expense Income before taxes Income Taxes Net Income Base Year Forecast Growth rate 100 888898 50 50 20 10 20 4 16 4 12 20% 15% 15% 25% 100% 25% RATEarrow_forwardThe current year financial statements of Your Health Corporation reported sales of $142,021 million and accounts receivable of $9,731 million. If sales are projected to increase 4% next year, what is the projected accounts receivable balance for the following year? Note: Use a rounded forecasting factor in your computations (for example, 0.044555 = 4.5%). Select one: O a. $8,659 million O O O O b. $9,920 million c. $8,330 million d. $10,191 million e. $9,731 millionarrow_forward
- Using data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be rounded to two decimals (e.g., 12.77%). > Answer is complete but not entirely correct. 2021 2020 2020-2021 Revenue 2,057,622 1,736,432 18.50 % Cost of Goods Sold 1,259,830 921,980 36.64 % Gross Profit 797,792 814,452 (1.02) % Operating Expenses 789,795 570,245 38.50 % Operating Income 7,997 244,207 2,953.73% Net Income 14,553 191,960 (92.42) %arrow_forwardMuscat Industrial Company has the following data which is extracting from its financial statements at the beginning 2020. Calculate the following ratios : Total Asset Turnover (TAT). Debt Ratio (DR%). Net Profit Margin 10% Sales 2500 thousand (OMR) Financial Leverage Multiplier 1.5 Times Return on Asset (ROA) 8 %arrow_forwardThe Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here: Sales Costs Taxable income Taxes Net income Dividends Addition to retained earnings Current assets Fixed assets Total assets Assets Current assets Fixed assets INCOME STATEMENT Total assets $ 7,230,000 18,390,000 $ 1,149,982 1,724,853 Assets b-2. External financing needed c. Sustainable growth rate $ 25,620,000 a. Calculate the external funds needed for next year using the equation from the chapter. Note: Do not round intermediate calculations. External financing needed b-1. Prepare the firm's pro forma balance sheet for next year. Note: Do not round intermediate calculations. BALANCE SHEET Short-term debt Long-tern debt Common stock Accumulated retained earnings $ 30,500,000 26,077,300 $ 4,422,700 1,547,945 $ 2,874,755 Liabilities and Equity Total equity Total liabilities and…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Financial Projections for Startups Basic Walkthrough; Author: Mike Lingle;https://www.youtube.com/watch?v=7avegQF4dxI;License: Standard youtube license