In: Finance
Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires $750,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life (ignore the half-year convention for the straight-line method). The applicable MACRS depreciation rates are 33%, 45%, 15%, and 7%. The company's WACC is 10%, and its tax rate is 30%.
| Year | Scenario 1 (Straight-Line)  | 
Scenario 2 (MACRS)  | 
| 1 | $ | $ | 
| 2 | $ | $ | 
| 3 | $ | $ | 
| 4 | $ | $ | 
How much higher would the NPV be under the preferred method? Round
your answer to the nearest cent.
$  
NPV Calculation using straight line Depreciation:
| Year (t) | Intial outlay | Depreciation (straight line) (%) : 100%/4 | Depreciation (Intial outlay *%depr.) | Before taxes cash flow (BTCF) | Taxable Income (BTCF - depreciation) | Income taxes (Taxable Income *30%) | After Tax Net Income (taxable income - taxes) | Net Cash Flow = ( Net Income + depreciation) | PV of Net cash flow @10%= NCF/ (1+10%)^t | 
| 0 | -$750,000 | -$750,000 | -$750,000 | ||||||
| 1 | 25% | $187,500 | $0 | ($187,500) | ($56,250) | ($131,250) | $56,250 | $51,136 | |
| 2 | 25% | $187,500 | $0 | ($187,500) | ($56,250) | ($131,250) | $56,250 | $46,488 | |
| 3 | 25% | $187,500 | $0 | ($187,500) | ($56,250) | ($131,250) | $56,250 | $42,261 | |
| 4 | 25% | $187,500 | $0 | ($187,500) | ($56,250) | ($131,250) | $56,250 | $38,420 | |
| NPV (sum of PVs) | -$571,695.07 | 
Note: Assuming Before tax cash flow (BTCF) = 0 as no value is given
NPV Calculation using MACRS Depreciation:
| Year (t) | Intial outlay | 3-Year MACRS depreciation percentage | Depreciation (Intial outlay *% depr) | Before tax cash flow (BTCF) | Taxable Income (BTCF - depreciation) | Income taxes (Taxable Income *30%) | After Tax Net Income (taxable income - taxes) | Net Cash Flow = ( Net Income + depreciation) | PV of Net cash flow @10%= NCF/ (1+10%)^t | 
| 0 | -$750,000 | -$750,000 | -$750,000 | ||||||
| 1 | 33% | $247,500 | $0 | ($247,500) | ($74,250) | ($173,250) | $74,250 | $67,500 | |
| 2 | 45% | $337,500 | $0 | ($337,500) | ($101,250) | ($236,250) | $101,250 | $83,678 | |
| 3 | 15% | $112,500 | $0 | ($112,500) | ($33,750) | ($78,750) | $33,750 | $25,357 | |
| 4 | 7% | $52,500 | $0 | ($52,500) | ($15,750) | ($36,750) | $15,750 | $10,757 | |
| NPV (sum of PVs) | -$562,707.98 | 
a.
| Year | Scenario 1 | Scenario 2 | 
| (Straight-Line) | (MACRS) | |
| 1 | $187,500 | $247,500 | 
| 2 | $187,500 | $337,500 | 
| 3 | $187,500 | $112,500 | 
| 4 | $187,500 | $52,500 | 
b. MACRS depreciation method would produce the higher NPV
Higher would the NPV be under the preferred method = -$562,707.98 –
(-$571,695.07) = $8,987.09