11. Feasible Growth Rates. a. What is the maximum possible growth rate in 2016 for Planners Peanuts (see problem 9) if the payout ratio remains at 50% and i. No external debt or equity is to be issued? (L04) i. The firm maintains its 2015 debt-to-equity ratio but issues no equity? (L04) b. Calculate the required external financing and the new capital structure for the two growth rates. (L04) TERMEDIATE 9. Percentage-of-Sales Models. Here are the abbreviated financial statements for Planners Peanuts Income Statement, 2015 Sales $2,000 Costs 1.500 Net income $ 500 Balance Sheet, Year-End 2014 2015 2014 2015 Assets $2,500 $3,000 Debt $ 833 $1,000 Equity 1.667 2.000 Total $2,500 $3,000 Total $2,500 $3,000 If sales increase by 20% in 2016, and the company uses a strict percentage-of-sales planning model (meaning that all items on the income and balance sheet also increase by 20%), what must be the balancing item? What will be its value? (LO2) 10 Required External Financing. If the dividend payout ratio in problem 9 is fixed at 50%, calculate the required total external financing for growth rates in 2016 of 15%, 20%, and 25% (L04) Excel Template 19-10 11. Feasible Growth Rates. a. What is the maximum possible growth rate in 2016 for Planners Peanuts (see problem 9) if the payout ratio remains at 50% and i. No external debt or equity is to be issued? (L04) i. The firm maintains its 2015 debt-to-equity ratio but issues no equity? (L04) b. Calculate the required external financing and the new capital structure for the two growth rates. (L04) TERMEDIATE 9. Percentage-of-Sales Models. Here are the abbreviated financial statements for Planners Peanuts Income Statement, 2015 Sales $2,000 Costs 1.500 Net income $ 500 Balance Sheet, Year-End 2014 2015 2014 2015 Assets $2,500 $3,000 Debt $ 833 $1,000 Equity 1.667 2.000 Total $2,500 $3,000 Total $2,500 $3,000 If sales increase by 20% in 2016, and the company uses a strict percentage-of-sales planning model (meaning that all items on the income and balance sheet also increase by 20%), what must be the balancing item? What will be its value? (LO2) 10 Required External Financing. If the dividend payout ratio in problem 9 is fixed at 50%, calculate the required total external financing for growth rates in 2016 of 15%, 20%, and 25% (L04) Excel Template 19-10