Question

The Optical Scam Company has forecast a sales growth rate of 25 percent for next year. The current financial statements are shown here Income Statement Sales Costs $ 32,000,000 26,309,400 Taxable income Taxes $ 5,690,600 1,991,710 Net income $3,698,890 Dividends Addition to retained earnings $ 1,479,556 2,219,334 Balance Sheet Assets Liabilities and Equity Current assets $ 7,360,000 Short-term debt Long-term debt $7,040,000 2,240,000 Fixed assets 18,560,000 Common stock Accumulated retained earnings $ 6,070,000 10,570,000 $ 16,640,000 $ 25,920,000 Total equity Total assets$25,920,000 Tota liabilities and equity a. Calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed b-1. Prepare the firms pro forma balance sheet for next year. (Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32.) Balance Sheet Assets Current assets Liabilities and equity Short-term debtp0

Long-term debt Fixed assets Common stock Accumulated retained earnings Total equity Total assets Total liabilities and equity b-2. Calculate the external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed c. Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g, 32.16.) Sustainable growth rate

0 0
Add a comment Improve this question Transcribed image text
Answer #1
a) EFN = [(Assets / Sales) x Δ sales] - [(Debt / Sales) x Δ sales] - [(Projected sales x Profit margin) x (1-Dividend payout ratio)]
= (25920000/32000000)*32000000*25%-(7040000/32000000)*32000000*25%-32000000*125%*11.56%*60% =
= $1945600 (EFN)
b-1) Year Current Year Basis for projections Next year
INCOME STATEMENT:
Sales 32000000 +25% 40000000
Costs 26309400 82.22% of sales 32886750
EBIT 5690600 7113250
Taxes at 35% 1991710 2489638
Net income 3698890 0.115590313 4623613
Dividends (40%) 1479556 1849445
Addition to retained earnings 2219334 2774168
BALANCE SHEET:
Current assets 7360000 23% of sales 9200000
Fixed assets 18560000 58% of sales 23200000
25920000 32400000
Short term debt 7040000 22% of sales 8800000
Long term debt 2240000 2240000
Common stock 6070000 6070000
Accumulated retained earnings 10570000 +2774168 13344168
Total debt and equity 25920000 30454168
b-2) EFN 1945833
Difference in answers under [a] and [b-2] is due to approximation.
c) SGR = ROE*b/(1-ROE*b)
where ROE = return on equity,
b = retention ratio.
ROE = 3698890/(6070000+10570000) = 22.23%
Retention ratio = 60%
SGR = 0.2223*0.60/(1-0.2223*0.60) = 15.39%
Add a comment
Know the answer?
Add Answer to:
p0 The Optical Scam Company has forecast a sales growth rate of 25 percent for next...
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
  • The Optical Scam Company has forecast a sales growth rate of 25 percent for next year....

    The Optical Scam Company has forecast a sales growth rate of 25 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 32,000,000 Costs 26,309,400 Taxable income $ 5,690,600 Taxes 1,991,710 Net income $ 3,698,890 Dividends $ 1,479,556 Addition to retained earnings 2,219,334    BALANCE SHEET Assets Liabilities and Equity Current assets $ 7,360,000 Short-term debt $ 7,040,000 Long-term debt 2,240,000 Fixed assets...

  • The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The...

    The Optical Scam Company has forecast an 17 percent sales growth rate for next year. The current financial statements are shown below. Current assets, fixed assets, and short-term debt are proportional to sales. INCOME STATEMENT   Sales $ 44,000,000   Costs 35,200,000   Taxable income $ 8,800,000   Taxes 3,080,000   Net income $ 5,720,000        Dividends $ 1,430,000        Additions to retained earnings $ 4,290,000   BALANCE SHEET Assets Liabilities and Equity   Current assets $ 14,040,000   Short-term debt $ 10,560,000   Long-term debt 11,060,000   Fixed assets 37,000,000   Common...

  • 13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The cu...

    13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $ 3,745,000 Taxable income 1,498,000 Taxes $ 2,247,000 Net income $ 786,450 Dividends Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17,600,000 $ 3,200,000 Common stock 10,400,000 Accumulated retained earnings Total...

  • 13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The cu...

    13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $3,745,000 Taxable income Taxes 1,498,000 Net income $2247,000 Dividends $786,450 Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17.600,000 $3,200,000 Common stock 10,400,000 Accumulated retained earnings Total equity $13,600,000 Total assets...

  • 32. (15 points) The Optical Scam Company has forecast a sales growth rate of 20 percent...

    32. (15 points) The Optical Scam Company has forecast a sales growth rate of 20 percent for next year The current financial statements are shown below. Assuming that assets, COGS, and short-term carnave the same growth rate as sales, and that the retention ratio does not change, what is the external financing needed for next year? Income Statement Sales COGS 31,700,000 26,426,900 Taxable income Taxes 5,273,100 1,845,585 Net income $ 3,427,515 Dividends Addition to retained earnings $1,371,006 2,056,509 Balance Sheet...

  • External Funds Needed The Optical Scan Company has forecast a 20 percent sales growth rate for...

    External Funds Needed The Optical Scan Company has forecast a 20 percent sales growth rate for next year. The current financial statements are shown here: 3.8 Statement of Comprehensive Income Sales Costs Taxable income Taxes Net income $30,400,000 26,720,000 $ 3,680,000 1,288,000 $ 2,392,000 Dividends Addition to retained earnings $ 956,800 1,435,200 Statement of Financial Position Assets Liabilities and shareholder's equity Current assets 7,200,000 Short-term debt Fixed assets 17,600,000 Long-term debt Common stock $6,400,000 4,800,000 $3,200,000 10,400,000 $13,600,000 $24.800,000 Accumulated...

  • I have used the suggested formulas I have found for this problem but the answers keep...

    I have used the suggested formulas I have found for this problem but the answers keep coming out wrong. Please help! The Optical Scam Company has forecast a sales growth rate of 20 percent for next year. Current assets, fixed assets, and short-term debt are proportional to sales. The current financial statements are shown here:    INCOME STATEMENT Sales $ 32,200,000 Costs 27,743,800 Taxable income $ 4,456,200 Taxes 1,559,670 Net income $ 2,896,530 Dividends $ 1,158,612 Addition to retained earnings...

  • The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected...

    The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. MOOSE TOURS, INC. 2015 Income Statement   Sales $ 725,000   Costs 591,000   Other expenses 12,000   Earnings before interest and taxes $ 122,000   Interest expense 14,000   Taxable income $ 108,000...

  • The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected...

    The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected to grow by 25 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. MOOSE TOURS, INC 2015 Income Statement Sales Costs Other expenses $744,000 579,000 15,000 Earnings before interest and taxes Interest expense $150,000 11,000 Taxable income Taxes (20%) $139,000 27,800...

  • The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected...

    The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected to grow by 25 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. MOOSE TOURS, INC 2015 Income Statement Sales Costs Other expenses $744,000 579,000 15,000 Earnings before interest and taxes Interest expense $150,000 11,000 Taxable income Taxes (20%) $139,000 27,800...

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