In: Accounting
Given the following information, calculate the Net Present Value for a capital budget proposal? Show your work. Machine Cost: $6,000,000 Salvage Value: $50,000 Setup Costs: $45,000 Training Costs: $25,000 Annual maintenance costs: $45,000 Anticipated annual savings: $560,000 Annual labor savings: $25,000 Expected useful life in years: 12 Overhaul costs in year 4: $50,000 Annual operating costs: $25,000 Hurdle rate: 8%
| NPV | |||
| Initial Investment | |||
| Machine Cost | $6,000,000.00 | ||
| Setup Cost | $45,000.00 | ||
| Training Cost | $25,000.00 | ||
| Initial Investment | $6,070,000.00 | ||
| Anticipated annual savings | $560,000.00 | ||
| Annual labor savings | $25,000.00 | ||
| Less: | |||
| Annual maintenance costs | -$45,000.00 | ||
| Annual operating costs | -$25,000.00 | ||
| Net Annual Savings | $515,000.00 | ||
| Year | Cash Flow | PV @ 8% | PV |
| 0 | -$6,070,000.00 | 1.0000 | -$6,070,000.00 |
| 1 | $515,000.00 | 0.9259 | $476,851.85 |
| 2 | $515,000.00 | 0.8573 | $441,529.49 |
| 3 | $515,000.00 | 0.7938 | $408,823.60 |
| 4 | $465,000.00 | 0.7350 | $341,788.88 |
| 5 | $515,000.00 | 0.6806 | $350,500.35 |
| 6 | $515,000.00 | 0.6302 | $324,537.36 |
| 7 | $515,000.00 | 0.5835 | $300,497.55 |
| 8 | $515,000.00 | 0.5403 | $278,238.48 |
| 9 | $515,000.00 | 0.5002 | $257,628.22 |
| 10 | $515,000.00 | 0.4632 | $238,544.65 |
| 11 | $515,000.00 | 0.4289 | $220,874.67 |
| 12 | $565,000.00 | 0.3971 | $224,369.27 |
| NPV | -$2,205,815.63 | ||
| Year 4 Cash flow = $515000 - 50000 = $465000 | |||
| Year 12 Cash flow = $515000 + 50000 = $565000 |