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% |
p0 The Optical Scam Company has forecast a sales growth rate of 25 percent for next...
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 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 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 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 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 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 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 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 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 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...