Question
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes):
The company has predicted a sales increase of 15 percent. Assume Wims 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. (Input all amounts as positive values. Do not round intermediate calculations.)

Determine the external financing needed. (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.)
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Sales $38,000 Assets $27,300 Debt$ 6,700 Balance Sheet Costs 32,600 Equity 20,600 Net inconte $ 5,400 Total $27,300 Total $27300 The company has predicted a sales increase of 15 percent. Assume Wims 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. (Input all amounts as positive values. Do not round intermediate calculations.) Pro forma income statement Pro forma balance sheet Sales Costs Net income Debt Equity Assets Total Determine the external financing needed. (Do not round intermediate Iculations. A negative answer should be indicated by a minus sign.) External financing needed
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Calculate the external financing needed as follows:

Income statement Projected Amount 3 Particulars 4 Sales 5 COGS 6 Net income 7 Dividend 8 Retained earnings $2,700.00 Amount $38,000.00S43,700.00 $32,600.00 S37,490.00 S6,210.00 $3,105.00 $3,105.00 $5,400.00 $2,700.00 10 Balance sheet Proiected Amount Particular Amount Calculation Proiected 12 Particular 13 14 Assets 15 16 Total 17 Amount Amount $27,300.00S31,395.00 Debt $6,700.00S7,690.00 $20,600.00 $23,705.00 $23,705.00 $27,300.00$30,405.00 S31,395.00 $6,700.00 Equit $27.300.00 31,395.00 External funds needed S990.00

Formulas:

Income statement Proiected 2 3 Particulars 4 Sales 5 COGS 6 Net income 7 Dividend 8 Retained earningsB6-B7 9 10 Amount 38000 32600 Amount B4*(1+15% B5*(1+15% D4-D5 D6*50% D6-D7 B4-B5 B6*5090 Balance sheet Proiected Calculation Proiected 12 Particular 13 14 Assets 15 16 Total 17 Amount Amount Particular Amount Amount B14*(1+1590) Debt Equit 16700 20600 F14 F15+D8 SUM(H13:H15) SUMI13:115) H14+E17 H15 27300 SUM(B13:B15 External funds needed SUMD13:D15 SUM(F13:F15 D16-H16

Add a comment
Know the answer?
Add Answer to:
Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): The company...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Sales $34,000 Costs 27,330 Assets Balance Sheet $26,500 Debt Equity $ 7.000 19,500 Net income $ 6,670 Total $26,500 Total $26,500 The company has predicted a sales increase of 15 percent. Assume 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....

  • 1.Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming no income...

    1.Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $38,000 Assets $27,300 Debt $ 6,700 Costs 32,600 Equity 20,600 Net income $ 5,400 Total $27,300 Total $27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. What is the plug variable...

  • S04-02 Pro Forma Statements and EFN (LO1, 2] Consider the following simplified financial statements for the...

    S04-02 Pro Forma Statements and EFN (LO1, 2] Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes) Income Statement Balance Sheet Sales Costs $38,000 Assets $27,300 Debt $6,700 Equity 20,600 32,600 Net income 5,400 Total $27,300 Total $27,300 The company has predicted a sales increase of 15 percent. Assume Wims 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....

  • Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 38,000 Assets $ 27,300 Debt $ 6,700 Costs 32,600 Equity 20,600 Net income $ 5,400 Total $ 27,300 Total $ 27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well. Create the pro forma statements and reconcile them. (Input all amounts as...

  • Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Income Statement Sales Costs Balance Sheet $6,650 15,500 $33,200 Assets $22,150Debt 25,440 Equity Net income $ 7,760 Total $22,150 Total $22,150 The company has predicted a sales increase of 16 percent. Assume Yoo pays form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. out half of net income in the Prepare the pro forma statements. (Input all amounts...

  • S04-01 Pro Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming...

    S04-01 Pro Forma Statements [LO1] Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes) Income Statement Sales $38,000 Balance Sheet Assets $27,300 Debt 6,700 Equity 20,600 Costs 32,600 Net income 5,400 Total $27,300 Total $27,300 The company has predicted a sales increase of 15 percent. It has predicted that every item on the balance sheet will increase by 15 percent as well Create the pro forma statements and reconcile them. (Input all amounts as positive...

  • Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement ♡ Balance Sheet Sales $33,600 Assets $24,350 Debt $ 6,850 Costs 27,800 Equity 17,500 Net income $ 5,800 Total $24,350 Total $24,350 The company has predicted a sales increase of 20 percent. It has predicted that every item on the balance sheet will increase by 20 percent as well. Create the pro forma statements and reconcile them. (Input all answers as positive values. Do...

  • Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Balance Sheet...

    Consider the following simplified financial statements for the Yoo Corporation (assuming no income taxes): Balance Sheet Income Statement Sales Costs $33,600 Assets $24,350 Debt 6,850 17,500 27,800 Equity Net income 5,800 Total $24,350 Total $24,350 The company has predicted a sales increase of 20 percent. Assume Yoo 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. (Input all amounts...

  • Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): Income Statement Balance Sheet   Sales $ 34,000   Assets $ 26,500   Debt $ 7,000   Costs 27,330   Equity 19,500     Net income $ 6,670     Total $ 26,500     Total $ 26,500 The company has predicted a sales increase of 15 percent. Assume 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...

  • Consider the following simplified financial statements for the Fire Corporation (assuming no income taxes): Income Statement...

    Consider the following simplified financial statements for the Fire Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 46,900 Assets $ 22,700 Debt $ 6,700 Costs 41,140 Equity 16,000 Net income $ 5,760 Total $ 22,700 Total $ 22,700 The company has predicted a sales increase of 18 percent. Assume Fire 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT