Hello,

Could you please help me in completing Pro Forma Balance sheet?

Thanks,

TA

Calculating EFN - Excel 6 - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 - A" A" % Paste BIU- - DA- Alignment Number Conditional Format as Cell Cells Editing Formatting * Table Styles Clipboard Font Styles J25 X V A B C D E F G H K N P Consider the following simplified financial statements for the Yoo Corporation. Assume 3 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 Balance sheet Sales $ 36,000 Assets $ 26,400 Deb 6,300 Costs 29,800 Equity 20, 100 Net income $ 6,200 Total $ 26,400 Total $ 26,400 Sales increase 15% Payout rate 50% 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 Pro forma income statement Pro forma balance sheet 18 Sales $ 41,400 Assets $ 30,360 Debt $ 6,300 19 Costs 34,270 Equity 20 Net income $ 7, 130 Total $ 30,360 Total 21 1 Sheet1 + READY 100% Attempt(s) Hint Show Me5 6 Income statement Balance sheet 7 Sela $ 36.000 Assets $ 26.400 Debt $ 6,300 8 Costs 29.800 Equity 20,100 9 Net income $ 6:200 Total $ 26:400 Total $ 26:400 10 11 Sales increase 15% 12 Payout rate 50% 13 14 15 Complete the following analysis. Do not hard code values in your calculations. 16 17 Proforma income statement Pro fonna balance sheet 18 Sales Assets $ 30,360 Debt $ 6,300 19 Costs 34,270 Equity 20 Net income $ 7:130 Total $ 30:360 Total 21 22 Dividends $ 3,565 External nancing needed 23 Add. To RE 3,565 24 E |:.' 26 27 ml . Sheen a: READY ."I -I + 100% Attempt(s) Hint Show Me