Forecast pro-forma unlevered income statements for the next 3 years (2020-2022) using percent of sales forecasting...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Forecast pro-forma unlevered income statements for the next 3 years (2020-2022) using percent of sales forecasting (assume it is the beginning of 2020). You don't need to forecast the balance sheet. Use the following assumptions: Sales will grow by 2% each year All recurring operating expenses and depreciation are a percent of sales based on 2019 levels. The tax rate is 21%. Find the value per share by discounting the unlevered free cash flows at the WACC assuming that, after year 3 of the forecast, free cash flows will grow by 2%. Assume that working capital is a constant percent of sales based on 2019 levels and capital spending equals depreciation each year. Assume that they will use 50% debt financing and use the WACC from problem 1A above. There are 40 million shares outstanding. (Show work on the 'Problem 1' Excel worksheet.) Forecast pro-forma unlevered income statements for the next 3 years (2020-2022) using percent of sales forecasting (assume it is the beginning of 2020). You don't need to forecast the balance sheet. Use the following assumptions: Sales will grow by 2% each year All recurring operating expenses and depreciation are a percent of sales based on 2019 levels. The tax rate is 21%. Find the value per share by discounting the unlevered free cash flows at the WACC assuming that, after year 3 of the forecast, free cash flows will grow by 2%. Assume that working capital is a constant percent of sales based on 2019 levels and capital spending equals depreciation each year. Assume that they will use 50% debt financing and use the WACC from problem 1A above. There are 40 million shares outstanding. (Show work on the 'Problem 1' Excel worksheet.)
Expert Answer:
Answer rating: 100% (QA)
Forecasted Income Statements 20202022 Percent of Sales Method Assumptions Sales growth 2 per year Recurring operating expenses and depreciation Percen... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Please make a 2-way data table (using the attached excel data) that calculates the value per share that varies the terminal growth rate and WACC. Please explain the steps on excel for how to make...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Broussard Skateboard's sales are expected to increase by 25% from $7.6 million in 2019 to $9.50 million in 2020. Its assets totaled $5 million at the end of 2019. Broussard is already at full...
-
Find a harmonic function (x, y) in the right-half plane x > -1 such that on the boundary (-1, y) = 0, y
-
The following selected transactions were completed during August between Salem Company and Boulder Co.: Aug. 1. Salem Company sold merchandise on account to Boulder Co., $28,600, terms FOB...
-
In a clinical trial of 2053 subjects treated with a certain drug, 28 reported headaches. In a control group of 1652 subjects given a placebo, 25 reported headaches. Denoting the proportion of...
-
Riverwood International Corporation, a leading provider of paperboard, announced the following: Discuss why, and under what conditions, FIFO might enable Riverwood International to more closely match...
-
The president of Mission Inc. has been concerned about the growth in costs over the last several years. The president asked the controller to perform an activity analysis to gain a better insight...
-
CASE STUDY The term ordinary share is usually applied to a share where the holder has no priority in being a dividend or receiving a capital contribution in the event of the firm going into...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
Parte A. Indique el tipo de hiptesis y las variables de acuerdo a la siguiente leyenda. Debe identificar el tipo de hipotesis y ambas variables: (18 puntos) Utilice la nomenclatura: Nula - N Simple -...
-
A bank starts with ALL of $2.965 million at the beginning of the year, charges off worthless loans of $0.436 million during the year, recovers $0.068 million on loans previously charged off, and...
-
In this figure, as group size goes above 4, the payoff decreases. What is a reason that this might happen? Individual net benefit (benefit - costs) 1 2 ECOLOGY 3e, Figure 8.22 2014 Sinauer...
-
The annual return on the S&P 500 Index was 12.4 percent. The annual T-bill yield during the same period was 5.7 percent. What was the market risk premium during that year?
-
Mint Cleaning Incorporated prepared the following unadjusted trial balance at the end of its second year of operations ending December 31. (Assume amounts are reported in thousands of dollars.)...
-
Coram Audio makes wireless headphones. Each pair of headphones comes with a travel case. Since its founding, Coram has manufactured its own travel cases. Recently, Holmur Travel Gear (HTG), a local...
-
Let us look at a prominent, tragic incident in labor history to begin our journey in understanding why employment laws were developed. Read/watch a description of these events:...
-
Find the inverse, if it exists, for the matrix. -1
-
Under what condition would firms return on net operating assets (RNOA) be equal to its return on operating assets (ROOA)?
-
Firms with anticipated earnings-per-share growth are worth more. Is this statement always correct?
-
The following numbers appeared in the annual report of General Mills, Inc., the consumer foods manufacturer, for the fiscal year ending May 2008 (in millions of dollars): The firm has no preferred...
-
What are trend percentages and how are they calculated? What pitfalls must financial statement users avoid when preparing trend percentages?
-
During the past year, Lite Company had net income of \(\$ 5\) million, and Scanlon Company had net income of \(\$ 8\) million. Both companies manufacture electrical components for the construction...
-
Blare Company had a return on sales of 6.5 percent and an asset turnover of 2.40. What is Blare's return on assets?
Study smarter with the SolutionInn App