See Attachments. Excel attachment is for question# 2

1. Pro Forma Statements [LO1] Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. What is the plug variable here? 2. Calculating Internal Growth [LO3] The most recent financial statements for Schenkel Co. are shown here: Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the internal growth rate? Chapter 4 Problems 5, 6, 20, 22 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." equire that Input area: Sales Costs Taxable income Taxes Net income $ Current assets Fixed assets Total - $ - Payout ratio Tax rate Output area: Return on assets Retention ratio Internal growth rate #DIV/0! 100% #DIV/0! $ Debt Equity - Total $