Question

D Question 4 8 pts Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales7 72,429 Assets 178,884 Debt 44,955 Costs 43,457 Equity 133,929 EBIT 28,972 Taxes@ 11,009 Total 178,884 Total 178,884 38% Net 17,963 Income Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2.577 was ichoc to. nintin a constant navout ratio. Next vears sales are

Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,577 was paid, and the company wishes to maintain a constant payout ratio, Next years sales are projected to grow by 24%. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet, such as the Taxes and Net income. Take them as given.). What is the external financing needed using the pro-forma approach? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet, such as the Taxes and Net income. Take them as given.). What is the internal growth rate? (Report answer in percentage terms and round to 2 decimal places. Do not round intermediate calculations). What is the sustainable growth rate? (Report answer in percentage terms and round to 2 decimal places. Do not round intermediate calculations) Topic: Financial Models (EFN & Growth

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year Recent Year Basis for projections Next year
INCOME STATEMENT:
Sales 72429 +24% 89812
Costs 43457 60% of sales 53887
EBIT 28972 35925
Taxes at 38% 11009 13651
Net income 17963 22273
Dividends (14.35%) 2577 3196
Addition to retained earnings 15386 19077
BALANCE SHEET:
Assets 178884 246.98% of sales 221818
Debt 44955 44955
Equity 133929 +19077 153006
Total debt and equity 178884 197961
EFN 23856
ANSWERS:
Proforma value for equity 153006
EFN required 23856
IGR = ROA*b/(1-ROA*b)
where ROA = return on assets,
b = retention ratio.
ROA = 17963/178884 = 10.04%
Retention ratio = 15386/17963 = 85.65%
IGR = 0.1004*0.8565/(1-0.1004*0.8565) = 9.41%
IGR = ROE*b/(1-ROE*b)
where ROE = return on equity,
b = retention ratio.
ROA = 17963/133929 = 13.41%
Retention ratio = 15386/17963 = 85.65%
IGR = 0.1341*0.8565/(1-0.1341*0.8565) = 12.98%
Add a comment
Know the answer?
Add Answer to:
D Question 4 8 pts Consider the following recent financials for XYZ Corporation: Income Statement Balance...
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
  • Question 4 Consider the following recent financials for XYZ Corporation Income Statement Balance Sheet Sales 72,429Assets...

    Question 4 Consider the following recent financials for XYZ Corporation Income Statement Balance Sheet Sales 72,429Assets 178,884 Debt 44,955 Costs 43,457 Equity 133,929 EBIT 28,972 Taxes @ 38% 11,009Total 178,884Total 178,884 Net Income 17,963 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2.577 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are projected to grow by 24%. What is the pro-forma value for equity? (Round answer...

  • Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 72,429Assets 178,884 Debt...

    Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 72,429Assets 178,884 Debt 44,955 Costs 43,457 Equity 133,929 EBIT 28,972 Taxes @ 38% 11,009 Total 178,884Total 178,884 Net income|17963 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2.57 Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,577 was paid, and the company wishes to maintain a constant payout ratio. Next year's sales are...

  • Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 73,802 Assets 209,087...

    Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 73,802 Assets 209,087 Debt 38,278 Costs 44,281 Equity 170,809 EBIT 29,521 Taxes @ 38% 11,218 Total 209,087 Total 209,087 Net Income 18,303      Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,907 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to grow by 25%. What is the pro-forma value for equity?...

  • Please adhere closely to the rounding instructions(in red). Thanks! Question 4 Consider the following recent financials...

    Please adhere closely to the rounding instructions(in red). Thanks! Question 4 Consider the following recent financials for XYZ Corporation: Income Statement Balance Sheet Sales 72,429 Assets 178,884 Debt 44,955 Costs 43,457 Equity 133,929 EBIT 28,972 11,009 Total 178,884 Total 178,884 38% Net Income 17,963 We were unable to transcribe this image

  • Consider the following income statement for the Heir Jordan Corporation: The balance sheet for the Heir...

    Consider the following income statement for the Heir Jordan Corporation: The balance sheet for the Heir Jordan Corporation follows. Prepare a pro forma balance sheet, assuming a sales increase of 15 percent, no new external debt or equity financing, and a constant payout ratio. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Calculate the EFN. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your...

  • 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....

  • 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...

  • 1. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not...

    1. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet, such as the Taxes and Net income. Take them as given.). 2. What is the external financing needed using the pro-forma approach? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet,...

  • Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,907...

    Assets and costs are proportional to sales. Debt and equity are not. A dividend of $2,907 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to grow by 25%. 1. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet, such as the Taxes and Net income. Take them as...

  • 1. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not...

    1. What is the pro-forma value for equity? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet, such as the Taxes and Net income. Take them as given.). 2. What is the external financing needed using the pro-forma approach? (Round answer to 2 decimal places. Do not round intermediate calculations. Also, do not calculate the numbers given in the income statement and balance sheet,...

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
ADVERTISEMENT