Question: Go back to problem 12 and build a financial planning model based on percentage of sales for Eagle Sports Supply using a spreadsheet similar to
Go back to problem 12 and build a financial planning model based on percentage of sales for Eagle Sports Supply using a spreadsheet similar to Figure 19.2.
-1.png)
a. Assume 2013 sales grow at the sustainable growth rate calculated in problem 13 and produce the pro forma income statement and balance sheet. Is the forecasted capital structure consistent with 2012 capital structure?
b. Assuming 2013 sales grow at the internal growth rate calculated in problem 13, produce the pro forma income statement and balance sheet. Is the required external financing zero, the same as what you found in problem 13? Is the forecasted net income the same as the forecasted net income in problem 13? What is going on?
c. Calculate an alternative growth rate using the following formula.
-2.png)
The ROE is the same as the one used in the other growth rate formulas. It is based on beginning equity, 2012 net income/2011 equity. Use this new growth rate to produce the 2013 pro forma statements. What is the required external financing? How does it compare to the result in 34(b)?
Step by Step Solution
There are 3 Steps involved in it
a Sustainablegrowth rate Plowback ratio ROE 1 70 08333 8333 If the sustainable growth rate works the firm does not needto issue equity to finance its ... View full answer
Get step-by-step solutions from verified subject matter experts
