Problem 4-2 Pro Forma Statements and EFN. B (I) " C) " VB " ; Calculating EEN - Excel ? E - 5 X HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In ll \"1 I5 3') - - _ .._.. Ca'bri - 11 - ' ' E % m I l 1 H D Ea ' l . A A El 3' D. E} Paste , 3 I U - 51::11: - 5;. - A. - Alignment Number Conditional Farm-ates Cell Cells Editing . ' F ' v v v v v ormattlng Table Styles v v C proard II =ort I'- St)r as A A1 cl fr v A B C D E F G H | .I K ' Consider the following simplied nancial 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 proforma statements and determine the external nancing needed. 4 5 6 Income statement Balance sheet ? Sales $ 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 forma balance sheet 18 Sales Assets Debt 19 Costs Equity 20 Net income Total Total