In: Finance
Delsing Canning Company is considering an expansion of its
facilities. Its current income statement is as follows:
| Sales | $ | 6,800,000 | 
| Variable costs (50% of sales) | 3,400,000 | |
| Fixed costs | 1,980,000 | |
| Earnings before interest and taxes (EBIT) | $ | 1,420,000 | 
| Interest (10% cost) | 560,000 | |
| Earnings before taxes (EBT) | $ | 860,000 | 
| Tax (30%) | 258,000 | |
| Earnings after taxes (EAT) | $ | 602,000 | 
| Shares of common stock | 380,000 | |
| Earnings per share | $ | 1.58 | 
The company is currently financed with 50 percent debt and 50
percent equity (common stock, par value of $10). In order to expand
the facilities, Mr. Delsing estimates a need for $3.8 million in
additional financing. His investment banker has laid out three
plans for him to consider:
  
Variable costs are expected to stay at 50 percent of sales,
while fixed expenses will increase to $2,480,000 per year. Delsing
is not sure how much this expansion will add to sales, but he
estimates that sales will rise by $1 million per year for the next
five years.
Delsing is interested in a thorough analysis of his expansion plans
and methods of financing.He would like you to analyze the
following:
a. The break-even point for operating expenses
before and after expansion (in sales dollars). (Enter your
answers in dollars not in millions, i.e, $1,234,567.)
  
b. The degree of operating leverage before and
after expansion. Assume sales of $6.8 million before expansion and
$7.8 million after expansion. Use the formula: DOL = (S −
TVC) / (S − TVC − FC). (Round
your answers to 2 decimal places.)
  
c-1. The degree of financial leverage before
expansion. (Round your answer to 2 decimal places.)
  
c-2. The degree of financial leverage for all
three methods after expansion. Assume sales of $7.8 million for
this question. (Round your answers to 2 decimal
places.)
  
d. Compute EPS under all three methods of
financing the expansion at $7.8 million in sales (first year) and
$10.7 million in sales (last year). (Round your answers to
2 decimal places.)
  
| Answer A :- | ||||
| Breakeven Point = | Fixed Cost / Contribution % | |||
| Particulars | Before Expansion | Expansion Option 1 | Expansion Option 2 | Expansion option 3 | 
| Fixed Cost | 1980000 | 2480000 | 2480000 | 2480000 | 
| Interest | 560000 | 1092000 | 560000 | 826000 | 
| Total FC | 2540000 | 3572000 | 3040000 | 3306000 | 
| Cont. % | 50% | 50% | 50% | 50% | 
| BEP Sales | 5080000 | 7144000 | 6080000 | 6612000 | 
| Answer B : - | ||||
| Operating Leverage = | Contribution / Contribution - FC | |||
| Particulars | Before Expansion | Expansion Option 1 | Expansion Option 2 | Expansion option 3 | 
| Sales | 6800000 | 7800000 | 7800000 | 7800000 | 
| Variable cost | 3400000 | 3900000 | 3900000 | 3900000 | 
| Contribution | 3400000 | 3900000 | 3900000 | 3900000 | 
| Fixed Cost | 1980000 | 2480000 | 2480000 | 2480000 | 
| Cont. - Fixed cost (EBIT) | 1420000 | 1420000 | 1420000 | 1420000 | 
| Opearing Leverage | 1.39 | 1.75 | 1.75 | 1.75 | 
| Answer C-1 :- | ||||
| Financial leverage | EBIT / EBT | |||
| Before Expansion | ||||
| EBIT | 1420000 | |||
| EBT | 860000 | |||
| Financial Leverage | 1.65 | |||
| Answer C-2 :- | ||||
| Financial Leverage (After Expansion0 | ||||
| Particulars | Expansion Option 1 | Expansion Option 2 | Expansion option 3 | |
| Sales | 7800000 | 7800000 | 7800000 | |
| Variable cost | 3900000 | 3900000 | 3900000 | |
| Contribution | 3900000 | 3900000 | 3900000 | |
| Fixed Cost | 2480000 | 2480000 | 2480000 | |
| Earning before Int & Tax | 1420000 | 1420000 | 1420000 | |
| Interest | 1092000 | 560000 | 826000 | |
| Earning before Tax | 328000 | 860000 | 594000 | |
| Fiancial Leverage | 4.33 | 1.65 | 2.39 | |
| Comments :- Higher the Interest cos, Higher the Financial leverage | ||||
| Answer D :- | ||||
| Option 1 - First Year | Option 2 - First Year | Option 3 - First Year | ||
| Particulars | Expansion Option 1 | Expansion Option 2 | Expansion option 3 | |
| Sales | 7800000 | 7800000 | 7800000 | |
| Variable cost | 3900000 | 3900000 | 3900000 | |
| Contribution | 3900000 | 3900000 | 3900000 | |
| Fixed Cost | 2480000 | 2480000 | 2480000 | |
| Earning before Int & Tax | 1420000 | 1420000 | 1420000 | |
| Interest | 1092000 | 560000 | 826000 | |
| Earning before Tax | 328000 | 860000 | 594000 | |
| Earning after Tax | 229,600 | 602,000 | 415,800 | |
| Total Shares | 380000 | 540000 | 475000 | |
| EPS | 0.60 | 1.11 | 0.88 | |
| Option 1 - First Year | Option 2 - First Year | Option 3 - First Year | ||
| Particulars | Expansion Option 1 | Expansion Option 2 | Expansion option 3 | |
| Sales | 10700000 | 10700000 | 10700000 | |
| Variable cost | 5350000 | 5350000 | 5350000 | |
| Contribution | 5350000 | 5350000 | 5350000 | |
| Fixed Cost | 2480000 | 2480000 | 2480000 | |
| Earning before Int & Tax | 2870000 | 2870000 | 2870000 | |
| Interest | 1092000 | 560000 | 826000 | |
| Earning before Tax | 1778000 | 2310000 | 2044000 | |
| Earning after Tax | 1244600 | 1617000 | 1430800 | |
| Total Shares | 380000 | 540000 | 475000 | |
| EPS | 3.28 | 2.99 | 3.01 | |
Thanks & Regards,
Devendra Agarwal