In: Finance
|
A project has the following estimated data: price = $79 per unit; variable costs = $41.87 per unit; fixed costs = $6,900; required return = 9 percent; initial investment = $10,000; life = six years. Ignore the effect of taxes. |
| a. What is the accounting break-even quantity? |
| b. What is the cash break-even quantity? |
| c. What is the financial break-even quantity? |
|
d. What is the degree of operating leverage at the financial break-even level of output? |
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |
| Units | Calculated | 200.983872 | 200.983872 | 200.983872 | 200.983872 | 200.983872 | 200.983872 | |
| SP | Given | 79 | 79 | 79 | 79 | 79 | 79 | |
| Sale | SP x BEP units | 15877.72589 | 15877.72589 | 15877.72589 | 15877.72589 | 15877.72589 | 15877.72589 | |
| VC per unit | Given | 41.87 | 41.87 | 41.87 | 41.87 | 41.87 | 41.87 | |
| Total VC | VC per unit x BEP units | 8415.194719 | 8415.194719 | 8415.194719 | 8415.194719 | 8415.194719 | 8415.194719 | |
| Fixed cost | Given | 6900 | 6900 | 6900 | 6900 | 6900 | 6900 | |
| Depreciation | Calculated above | 1666.666667 | 1666.666667 | 1666.666667 | 1666.666667 | 1666.666667 | 1666.666667 | |
| EAT | Sale-VC-FC+Depreciation | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | |
| FCINV | Given | -10000 | ||||||
| FCF | -10000 | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | 2229.197833 | |
| Discount rate factor | 1/1.09^0 | 1/1.09^1 | 1/1.09^2 | 1/1.09^3 | 1/1.09^4 | 1/1.09^5 | 1/1.09^6 | |
| Discount factor | 1 | 0.917431193 | 0.841679993 | 0.77218348 | 0.708425211 | 0.649931386 | 0.596267327 | |
| DCF | FCF x Discount factor | -10000 | 2045.135627 | 1876.271217 | 1721.34974 | 1579.219945 | 1448.825638 | 1329.197833 |
| NPV | Sum of all DCF | 0 |