https://www.mathsisfun.com/money/internal-rate-return.html
you have to guess what it is and I guess it to be 34.696 percent
From finance theory this is the finance formula
fv=pv(1+int)^n+pv2(1+int)^n2+pv3(1+int)^n3+pv4(1+int)^n4
10500=2000*(1.34696)^4+2500*(1.34696)^3+1500*(1.34696)^2+2000*(1.34696)^1
but I just used a spreadsheet and calculated the interest earned each year
So in cell c2 formula is =b2+(b2*$b$9/100) d2 you copy cell c2 to it and the interest rate will not alter its cell position
f6 formula is =sum(f1:f5)
then when you finish you just keep altering irr value to get 10500.
The reason for irr is to compare putting your money say in a bank account or in the government bonds market and comparing it to the IRR for your investment in question to see if it is worthwhile .
A true outlook would be to also factor in inflation over this time frame however the other investments are also affected by deflation so you are comparing like returns
×