| [Company Name] |
|
|
|
|
|
|
|
|
| Internal Rate of Return (IRR) Calculator |
|
|
|
|
|
|
|
|
| [Date] |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| Operational Costs |
Value |
|
|
|
|
|
|
| Cost of equipment |
$14,500 |
|
|
|
|
|
|
| Fixed costs |
$0 |
|
|
|
|
|
|
| Vehicle insurance |
$1,600 |
|
|
|
|
|
|
| Driver pay |
$16,200 |
|
|
|
|
|
|
| Miscellaneous |
$0 |
|
|
|
|
|
|
| Maintenance |
Variable |
|
|
|
|
|
|
| Depreciation |
N/A |
|
|
|
|
|
|
| New sales |
125 |
|
|
|
|
|
|
| Profit per sale |
$5 |
|
|
|
|
|
|
| Courier delivery charge |
$16 |
|
|
|
|
|
|
| Number of deliveries |
1,250 |
|
|
|
|
|
|
| Sale of equipment |
$2,300 |
|
|
|
|
|
|
| Interest rate |
5% |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
| Gray cells will be calculated for you or do not require any input. |
|
|
|
|
|
|
|
[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 flows |
| 0 |
$14,500 |
$0 |
$14,500 |
$0 |
$0 |
$0 |
$0 |
$14,500 |
| 1 |
17,800 |
200 |
18,000 |
20,000 |
625 |
|
20,625 |
2,625 |
| 2 |
17,800 |
250 |
18,050 |
20,000 |
625 |
|
20,625 |
2,575 |
| 3 |
17,800 |
300 |
18,100 |
20,000 |
625 |
|
20,625 |
2,525 |
| 4 |
17,800 |
400 |
18,200 |
20,000 |
625 |
|
20,625 |
2,425 |
| 5 |
17,800 |
550 |
18,350 |
20,000 |
625 |
|
20,625 |
2,275 |
| 6 |
17,800 |
700 |
18,500 |
20,000 |
625 |
2,300 |
22,925 |
4,425 |
| 7 |
|
|
0 |
|
|
|
0 |
0 |
| 8 |
|
|
0 |
|
|
|
0 |
0 |
| 9 |
|
|
0 |
|
|
|
0 |
0 |
| 10 |
|
|
0 |
|
|
|
0 |
0 |
| |
|
|
|
|
Net Cash Flow = |
|
|
$2,350.00 |
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
IRR = |
4.18% |
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
