All you need to do is put the Numbers for each month (what you pay and what you get) .. Because you have put the numbers for each month, the IRR you will get will be for same duration (monthly) ., all you then need to do is convert it as yearly IRR to see whats the CAGR return . If your monthly IRR is mIRR , then you need to do this
Yearly-IRR = [(1+mIRR)^(1/12)] -1 …. If you get .09 as answer , it means the answer is 9% ..
Manish has only written an article about it. Because of the bidding system I think IRR may not work. As a mathematical exercise it is curious to try but I find some who already has
You can use the same IRR calculator ..
All you need to do is put the Numbers for each month (what you pay and what you get) .. Because you have put the numbers for each month, the IRR you will get will be for same duration (monthly) ., all you then need to do is convert it as yearly IRR to see whats the CAGR return . If your monthly IRR is mIRR , then you need to do this
Yearly-IRR = [(1+mIRR)^(1/12)] -1 …. If you get .09 as answer , it means the answer is 9% ..
Manish has only written an article about it. Because of the bidding system I think IRR may not work. As a mathematical exercise it is curious to try but I find some who already has
http://www.taxalertindia.com/2010/03/excel-based-committee-calculator-and.html