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 |