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
-
Consider the following coal gasifier proposed for supplying a syngas fuel to a gas turbine power plant. Fifty kilograms per second of dry coal (represented as 48 kg C plus 2 kg H) enter the gasifier,...
-
The accompanying table shows the Canadian domestic demand schedule and domestic supply schedule for apples. Suppose that the world price of apples is $0.30 per apple. a. Draw the Canadian domestic...
-
Presented below is a draft set of financial statements for Chips Limited. The following additional information is available: 1 Purchase invoices for goods received on 29 June 2016 amounting to 23,000...
-
Given the following four cost behaviors and expected levels of cost-driver activity, predict total costs: 1. Fuel costs of driving vehicles, $0.40 per mile, driven 16,000 miles per month 2. Equipment...
-
Quiz Me: Quiz Me: 12.5-1 Find the conditional probability of an event. Let P(E) 0.75, P(F)=0.37, and P(EUF) 0.91. Find (a) P(EIF) and (b) P(FIE). (a) P(EIF)= (Type an integer or decimal rounded to...
-
The first quarter tax return needs to be filed for Prevosti Farms and Sugarhouse by April 15, 2021. For the taxes, assume the second February payroll amounts were duplicated for the March 5 and March...
-
Consider the oxidation of solid titanium to solid rutile (TO2). 1. Get the heat capacities of the products and reactants (unit: Joules) and derive the equation which gives Acpas a function of...
-
An employee of Kindler Orthopedics stole thousands of dollars from the company: Suppose Kindler has installed a new system of internal controls. As a consultant for Kindler Orthopedics, write a memo...
-
Navarro Company's Cash account shows an ending balance of \(\$ 770\). The bank statement shows a \(\$ 20\) service charge and an NSF check for \(\$ 100\). A \(\$ 250\) deposit is in transit, and...
-
Supplies has a $6,000 unadjusted balance on your trial balance. At year-end you count supplies of $2,000. What adjustment will appear on your work sheet? a. Supplies. 4,000 Supplies Expense.. 4,000...
-
Which columns of the work sheet show net income? a. Trial Balance b. Adjustments c. Income Statement d. Both b and c
-
Diedre Chevis sells furniture for DuBois Furniture Company. Chevis is having financial problems and takes \(\$ 500\) that she received from a customer. She rang up the sale through the cash register....
-
Let's assume that before international trade opens up, Russia is at a point on its production possibility curve (PPC) where it produces 40 apples and 40 computers. Once trade opens up, the price of a...
-
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...
-
Find a currency of your choice. How has its value changed against the U.S. dollar over the last ninety days? What about since January 3, 1975?
-
Why is the accounting function of a firm likely to be centralized? What aspects of the accounting function should be centralized?
-
The implication from the discussion in this chapter is that as a company becomes more global, it concentrates more on the informal and subtle mechanisms for controlling global operations than it does...
Study smarter with the SolutionInn App