Please help me correct the wrong answers!!! (the costs, assets, and external financing needed)

Calculating EFN - Excel ?A X Sign In FILE INSERT FORMULAS REVIEW PAGE LAYOUT DATA VIEW Arial 12 A A % Cell I U Alignment Number Conditional Format as Cells Editing Paste A Formatting Table Styles Clipboard Styles Font Consider the following simplified financial statements for the Yoo Corporation fox D I E F G A 1 2 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. 4 5 6 Income statement Balance sheet $ Sales 36,000 Assets 26,400 Debt 6,300 7 20,100 Costs 29,800 Equity 26,400 Total 8 $ $ $ 26,400 Net income 6,200 Total 10 15% Sales increase 11 Payout rate 50% 12 13 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 Pro forma income statement Pro forma balance sheet 41,400 34,270 $ Sales Assets 30,360 Debt 6,300 18 |Equity 30,360 Total 23,665 Costs 19 $ 29,965 20 Net income 7,130 Total 21 $ Dividends 3,565 395 22 External financing needed Add. To RE 3,565 23 24 25 26 27. Sheet1 + 100% READY Attempt(s) Hint