x 5 Calculating EFN- Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 AA % Paste BIU- - Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D18 A B E F G H J 4 5 6 Assets $ $ 7 8 Income statement Sales $ 36,000 Costs 29,800 Net income $ 6,200 Balance sheet 26,400 Debt Equity 26,400 Total 6,300 20,100 26,400 9 Total $ $ 10 11 Sales increase Payout rate 15% 50% 12 13 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 18 Assets Pro forma income statement Sales Costs Net income Pro forma balance sheet Debt Equity Total 19 20 21 Total 22 Dividends Add. To RE External financing needed 23 24 25 26 27 Sheet1 ES + 100% READY Attempt(s) 3/3 Hint