6.28% Return rate YEARS Complete Investment Returns Net Present Net Present Net Present IRR of the Financial value of Value using Value using investment the years Expenditure flow each future EXCEL using a your formula formula formula year 1 (150,000) 2 45,000 3 45,000 4 45,000 5 45,000 6 (10,000) 45,000 7 45,000 8 45,000 45,000 45,000 10 45,000 11 45,000 12 45,000 13 14 (10,000) 45,000 45,000 15 45,000 16 45,000 17 18 (5,000.00) 45,000 45,000 19 45,000 20