Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 4-2 Pro Forma Statements and EFN. B (I) C) VB ; Calculating EEN - Excel ? E - 5 X HOME
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started