Please help! Everything filled in is correct, but I am struggling with debt and
ID: 2382447 • Letter: P
Question
Please help! Everything filled in is correct, but I am struggling with debt and accumulated retained earnings in the second pro forma balance sheet. Please show steps! Thanks!
The Optical Scam Company has forecast a 15 percent sales growth rate for next year. The current financial statements are shown here: Income Statement $ 30,400,000 26,720,000 Sales Costs $ 3,680,000 1,288,000 Taxable income Taxes Net income Dividends $ 2,392,000 $ 956,800 1,435,200 Addition to retained earnings Balance Sheet Assets Liabilities and Equity Current assets $ 7,200,000 Short-term debt Long-term debt $ 6,400,000 4,800,000 Fixed assets 17,600,000 Common stock Accumulated retained earnings $ 3,200,000 10,400,000 $ 13,600,000 $ 24,800,000 Total equity Total assets 24,800,000 Total liabilities and equity a. Calculate the external funds needed for next year. (Do not round intermediate calculation and round your final answer to the nearest whole dollar amount. (e.g., 32)) External financing needed $ 11,09,520Explanation / Answer
Ans
Details Current Year Next Year with 10% growth rate in Sales Sales 304,00,000.00 334,40,000.00 Costs 267,20,000.00 293,92,000.00 Taxable Income 36,80,000.00 40,48,000.00 Taxes 35% 12,88,000.00 14,16,800.00 Net Icome 23,92,000.00 26,31,200.00 Dividend Pay out @40@ 9,56,800.00 10,52,480.00 Addition to Retained earnings 14,35,200.00 15,78,720.00 Note: Assume that Cost also varies in the same 10% rate.