| [Company Name] |
|
|
|
|
|
|
|
|
|
| Net Present Value — [Equipment] |
|
|
|
|
|
|
|
|
|
| [Date] |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Operational Costs |
Value |
|
|
|
|
|
|
|
| Cost of equipment |
$20,000 |
|
|
|
|
|
|
|
| Fixed costs |
$0 |
|
|
|
|
|
|
|
| Vehicle insurance |
$1,800 |
|
|
|
|
|
|
|
| Driver pay |
$15,000 |
|
|
|
|
|
|
|
| Miscellaneous |
$0 |
|
|
|
|
|
|
|
| Maintenance |
Variable |
|
|
|
|
|
|
|
| Depreciation |
N/A |
|
|
|
|
|
|
|
| New sales |
125 |
|
|
|
|
|
|
|
| Profit per sale |
$10 |
|
|
|
|
|
|
|
| Courier delivery charge |
$15 |
|
|
|
|
|
|
|
| Number of deliveries |
2,000 |
|
|
|
|
|
|
|
| Sale of equipment |
$15,000 |
|
|
|
|
|
|
|
| Interest rate |
6% |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Gray cells will be calculated for you and do not require any entry. |
|
|
|
|
[Company Name] CONFIDENTIAL |
| |
Expenses |
Income |
|
|
| Term in years |
Fixed costs |
Other costs |
Total |
Money saved
by project |
New sales generated by project |
Equipment sales |
Total |
Cash flow |
Cumulative cash flow |
| 0 |
$20,000 |
|
$20,000 |
|
|
|
|
$20,000 |
$20,000 |
| 1 |
16,800 |
$200 |
17,000 |
$30,000 |
$1,250 |
|
$31,250 |
14,250 |
5,750 |
| 2 |
16,800 |
250 |
17,050 |
30,000 |
1,250 |
|
31,250 |
14,200 |
8,450 |
| 3 |
16,800 |
300 |
17,100 |
30,000 |
1,250 |
|
31,250 |
14,150 |
22,600 |
| 4 |
16,800 |
400 |
17,200 |
30,000 |
1,250 |
|
31,250 |
14,050 |
36,650 |
| 5 |
16,800 |
550 |
17,350 |
30,000 |
1,250 |
|
31,250 |
13,900 |
50,550 |
| 6 |
16,800 |
700 |
17,500 |
30,000 |
1,250 |
15,000 |
46,250 |
28,750 |
79,300 |
| 7 |
|
|
0 |
|
|
|
0 |
0 |
0 |
| 8 |
|
|
0 |
|
|
|
0 |
0 |
0 |
| 9 |
|
|
0 |
|
|
|
0 |
0 |
0 |
| 10 |
|
|
0 |
|
|
|
0 |
0 |
0 |
| |
|
|
|
|
|
|
|
79,300 |
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
NPV = |
$59,745 |
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
