In: Finance
The Spitfire Model Airplane Company has the following modified income statement ($000) at 100,000 units of production.
| Revenue | $14,000 | 
| Variable Cost | 6,500 | 
| Fixed Cost | 6200 | 
| EBIT | $1,300 | 
| Interest(@10%) | 500 | 
| EBT | $800 | 
| Tax (@40%) | 320 | 
| EAT | $480 | 
| Number of shares | 20,000 | 
| CM (to two decimal places) | |
| SB/E (to the nearest dollar) | $ | 
| DFL | |
| DOL | |
| DTL | 
| EPS (using DTL) | $ | 
| EPS (using modified income statement) | $ | 
Feedback
| Production = 100,000 Units | |||
| Income Satement | |||
| Particulars | Amount | Per Unit | |
| A | Revenue | $ 14,000,000 | $ 140 | 
| B | Variabe Cost | $ 6,500,000 | $ 65 | 
| C | Contribution (A-B) | $ 7,500,000 | $ 75 | 
| D | Fixed Cost | $ 6,200,000 | |
| E | EBIT (C-D) | $ 1,300,000 | |
| F | Interest (@10%) | $ 500,000 | |
| G | EBT (E-F) | $ 800,000 | |
| F | Tax (@40%) | $ 320,000 | |
| G | EAT (G-F) | $ 480,000 | |
| H | No. of Shares | 20,000 | |
| i | EPS (G/H) | 24 | 
| a. | Contribution Margin = | Net sales - Variable Cost | 
| = | $ 7,500,000 | |
| Break Even Sales (in units) = | Fixed Cost/Contribution Margin per Unit | |
| = | $ 6,200,000/$ 75 | |
| = | 82,667 | |
| Break Even Sales (in $) = | 82,667 Unitis * $ 140 per Unit | |
| = | $ 11,573,380 | 
| b. | Degree of Financial Leverage = | EBIT / EBT | 
| = | $ 1,300,000/$800,000 | |
| DFL= | 1.63 | |
| Degree of Operating Leverage = | Contribution / EBIT | |
| = | $ 7,500,000/$ 1,300,000 | |
| DOL = | 5.77 | |
| Degree of Total Leverage = | EBT/ Contribution | |
| DTL = | 9.38 | 
(c) EPS Using DTL = (DTL shows Percentage change in Earnings for a one percentage change in Sales)
For 25 % decrease in Sales, EPS will decrease by (9.375 % * 25 times) = 234%
EPS using DTL = $ 24 - ($ 24 * 234%) = -$ 32
| If Sales Declined by 25% | |||
| Revised Sales = 100,000- 25% = 75,000 | |||
| Modified Income Satement | |||
| Particulars | Amount | ||
| A | Revenue | $ 10,500,000 | (75,000 * $ 140) | 
| B | Variabe Cost | $ 4,875,000 | (75,000 * $ 65) | 
| C | Contribution (A-B) | $ 5,625,000 | |
| D | Fixed Cost | $ 6,200,000 | |
| E | EBIT (C-D) | $ (575,000) | |
| F | Interest (@10%) | $ 500,000 | |
| G | EBT (E-F) | $ (1,075,000) | |
| F | Tax (@40%) | $ (430,000) | |
| G | EAT (G-F) | $ (645,000) | |
| H | No. of Shares | 20,000 | |
| i | EPS (G/H) | ($ 32) | 
EPS using DCL will be same as EPS as per Modified Income Statement.