Percentage of Sales Models. Here are abbreviated financial statements for Planners Peanuts:
|
Income statement 2019 |
|
|
Sales |
$2000 |
|
cost |
$1500 |
|
Net Income |
$500 |
|
Balance Sheet, year-end |
|||||
|
2018 |
2019 |
2018 |
2019 |
||
|
Assets |
$2500 |
$3000 |
Debt |
$833 |
$1000 |
|
Equity |
$1667 |
$2000 |
|||
|
Total |
$2500 |
Total |
$2500 |
$3000 |
|
If sales increase by 20% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 20%, what must be the balancing item?
What will be the value of this balancing item?
What is the maximum possible growth rate for Planners Peanuts if the payout ratio remains at 50%? 3a. What if no Debt or equity is to be issued?
3b. What if the firm maintains a fixed debt ratio, but issues no equity?Answer-1:
The balancing item will be equity , its value = $2,000 + (20% of $2,000) = $2,000 + $400 = $2,400
Answer-3a:
Maximum possible growth rate if no Debt or equity is to be issued:
= retained earnings / assets
= ($500 - 50% of $500) / $3,000 = 83.33%
Answer-3b:
Maximum possible growth rate if the firm maintains a fixed debt ratio, but issues no equity:
= (retained earnings(1 +D/E)) / (debt + equity) = 6.37%
Percentage of Sales Models. Here are abbreviated financial statements for Planners Peanuts: Income statement 2019 Sales...
The most recent financial statements for Schenkel Co. are shown here: Income Statement Sales $ 17,600 Costs 12,000 Current assets Fixed assets Balance Sheet $10,700 Debt 25,750 Equity $ 15,200 21,250 Taxable income $ 5,600 Total $36,450 Total $36,450 Taxes (40%) 2.240 Net income $ 3,360 Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 40 percent dividend payout ratio. No external equity financing is possible. What is the sustainable growth rate?...
The most recent financial statements for Mc Govney Co. are shown here: Income Statement Sales $47152 Costs $36870 Taxable Income ? Taxes (34%) ? Net Income ? Balance Sheet Current Asset $21260 Long-term Debt $48216 Fixed Asset $85534 Equity ? Assets and costs are proportional to sales. The company maintains a constant 19 percent dividend payout ratio and a constant debt–equity ratio. What is the maximum increase in sales (in $) that can be sustained assuming no new equity is...
The most recent financial statements for Alexander Co. are shown here: Balance Sheet Income Statement Sales $45,350 Costs 36,350 $18.860 Long-term Current assets Fixed assets $ 37,870 50,140 debt Equity 69,150 Taxable income $ 9,000 Total $88,010 Total $ 88,010 Taxes (22%) 1,980 Net income $ 7,020 Assets and costs are proportional to sales. The company maintains a constant 35 percent dividend payout ratio and a constant debt-equity ratio. What is the maximum dollar increase in sales that can be...
The most recent financial statements for Assouad, Inc., are shown here: Income Statement Sales Costs Balance Sheet Current 4,800 liabilities Current $3000 $10.300 Current Long term 4,540 7,300 Fixed ässets 9,800 . debt Taxable$3,000 income Equity 7060 Taxes (24%) 720 Total $14.600 Total $14.600 Net income $ 2,280 Assets, costs, and current liabilities are proportional to sales. Long-term debt and equity are not. The company maintains a constant 40 percent dividend payout ratio. As with every other firm in its...
Abbreviated financial statements for Archimedes Levers are shown in the table below. Assume sales and expenses increase by 18% in 2017 and all assets and liabilities increase correspondingly. Income Statement Sales Costs, including interest Net income S 5,600 4,300 S 1,300 Balance Sheet, Year-End 2016 4,7044,300 2015 2016 2015 Net assets Debt s 1,904$1,833 Equity0 46 S 4,704 Total S 4,704 $4,300 Total S 4,300 a. If the payout ratio is set at 50% and no external debt or equity...
Help Save & Exit Submit Check my work Problem 18-12 Using Percentage of Sales (LO2) Eagle Sports Supply has the following financial statements. Assume that Eagle's assets are proportional to its sales. INCOME STATEMENT, 2019 Sales $1,15e Costs 22e Interest Taxes Net Income Hint 2018 3,200 Assets $ BALANCE SHEET, YEAR-END 2019 $ 3,500 Debt Equity Total $ $ 2018 1.400 1.800 3,200 2019 1.500 2.689 3,5ee Total $ 3. $ $ a. Find Eagle's required external funds if it...
The most recent financial statements for Alexander Co. are shown here: Income Statement Sales Costs Taxable Balance Sheet $44,450 Current assets 18,380 Long-term debt 36,050 Fixed assets 68,850 Equity 49,660 $8,400 Total $ 87,230 Total $87,230 income Taxes (21%) 1.764 Net income$6,636 Assets and costs are proportional to sales. The company maintains a constant 45 percent dividend payout ratio and a constant debt-equity ratio. What is the maximum dollar increase in sales that can be sustained assuming no new equity...
The most recent financial statements for Wise Co. are shown here: Income Statement Balance Sheet Sales $ 53,200 Current assets $ 25,000 Long-term debt $ 53,500 Costs 42,600 Fixed assets 96,000 Equity 67,500 Taxable income $ 10,600 Total $ 121,000 Total $ 121,000 Taxes (34%) 3,604 Net income $ 6,996 Assets and costs are proportional to sales. The company maintains a constant 30 percent dividend payout ratio and a constant debt–equity ratio. What is the...
Eagle Sports Supply has the following financial statements.
Assume that Eagle’s assets are proportional to its sales.
INCOME STATEMENT, 2019
Sales
$
1,500
Costs
290
Interest
30
Taxes
240
Net income
$
940
BALANCE SHEET, YEAR-END
2018
2019
2018
2019
Assets
$
3,900
$
4,200
Debt
$
1,200
$
1,300
Equity
2,700
2,900
Total
$
3,900
$
4,200
Total
$
3,900
$
4,200
a. Find Eagle’s required external funds if it
maintains a dividend payout ratio of 50% and plans...
The most recent financial statements for Hailey Co. are shown here: Income Statement Balance Sheet Sales $ 57,000 Current assets $ 28,500 Long-term debt $ 62,000 Costs 24,600 Fixed assets 122,500 Equity 89,000 Taxable income $ 32,400 Total $ 151,000 Total $ 151,000 Taxes (25%) 8,100 Net income $ 24,300 Assets and costs are proportional to sales. The company maintains a constant 25 percent dividend payout ratio and a constant debt-equity ratio. What is the maximum increase in...