Help Save & Exit ? H5... FILE HOME INSERT Calculating EFN- Excel FORMULAS DATA REVIEW 6 x Sign in PAGE LAYOUT VIEW - 11-AA 33. A.Alignment Number Conditional Format as Cell Formatting Table Styles BIU- Cells Editing 12.5 points Styles Book DE Print References Consider the following simplified financial statements for the Yoo Corporation. Assume there are no income taxes and the company pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the pro forma statements and determine the external financing needed. Income statement Sales $ 36,000 Costs 29,800 Net income $ 6,200 Assets $ $ Balance sheet 26,400 Debt Equity 26,400 Total 6,300 20,100 26,400 Total $ $ Sales increase 15% Q 3 5 FILE .3. HOME Calculating EFN. Excel FORMULAS DATA REVIEW ? X INSERT PAGE LAYOUT - Sign In VIEW 2.5 oints B I U. Cells Paste Clipboards .A Alignment Number Conditional Format as Cell Formatting Table Styles Editing B. for Book Sales increase Payout rate Complete the following analysis. Do not hard code values in your calculations. Assets Pro forma income statement Sales Costs Net income Pro forma balance sheet Debt Equity Total Total External financing needed Dividends Add. To RE