Internal Rate Of Return _irr_calculator

[Company Name] Internal Rate of Return (IRR) Calculator [Date] Operational Costs Cost of equipment Fixed costs Vehicle insurance Driver pay Miscellaneous Maintenance Depreciation New sales Profit per sale Courier delivery charge Number of deliveries Sale of equipment Interest rate

Value $14,500 $0 $1,600 $16,200 $0 Variable N/A 125 $5 $16 1,250 $2,300 5%

Gray cells will be calculated for you or do not require any input.

[Company name] CONFIDENTIAL

Expenses Term in years 0 1 2 3 4 5 6 7 8 9 10

Fixed costs $14,500 17,800 17,800 17,800 17,800 17,800 17,800

Income

Other costs $0 200 250 300 400 550 700

Total $14,500 18,000 18,050 18,100 18,200 18,350 18,500 0 0 0 0

Money saved by project $0 20,000 20,000 20,000 20,000 20,000 20,000

New sales generated by project

Equipment sales $0 625 625 625 625 625 625

Total $0

2,300

$0 20,625 20,625 20,625 20,625 20,625 22,925 0 0 0 0

Cash flows $14,500 2,625 2,575 2,525 2,425 2,275 4,425 0 0 0 0 $2,350.00

IRR =

4.18%

Net Cash Flow =

1 of 3

10/18/2008

Cash Flow 5,000

Cash Inflow

4,000 3,000 2,000 1,000 0

Row 24

Row 25

Row 26

Row 27

Year

Row

Row 27

Row 28

Row 29