POSTED BY January 9, 2013 4:22 pm COMMENTS (3)ON
I was just trying out some “math” and trying to arrive at some figures. However, i got confused and not sure if was doing it right! Can you please help me out?
1. Finding a Future Value of Current Expense.
Assume that i have an expense of 2Lakhs per year, Then how much would it be considering –
Number of Years to Retire : 25
Present Value : -200000 (-ve so that i get a positive value in excel)
Future Value =FV(8%,25,,-200000). I get a value of 13,69,695.04. So a Expense of 2L will be 13.6L after 25 years. Is this correct?
2. Assuming i would need the above value (13.6Laks) for 10 Years, what is the corpus required? Considering
Real Rate of Return = (Rate of Return/Rate of Inflation) – 1 * 100
I Considered, Rate of Return = 10%, Inflation = 8%, so real rate of return = 1.85%
So Corpus Required = FV(185/100, 10, 13,69,695.04,,1). I got a value of 1,51,72,459.78. Around 1.5Crore. So i would need a corpus 1.5Crore then it would last me 10 years while withdrawing 13.6Lakhs per year. Is this right?
3. How much do i need to SIP to generate a corpus of 1.5Crore.
Assuming Rate of Return = 12%
Years of Investment = 25
Corpus Required = 1,51,72,459.78
Using Excel, =PMT(12%/12, 25*12, ,-1,51,72,459.78). I got a value of 8,075.41. This is the amount i need to SIP every month. Is this correct?
4. Finally, I tried to verify if this correct using the FV forumla in Excel,
=FV(12%, 25, 8075.41*12). This is to check if can generate a Corpus of 1.5Cr assuming i SIP 8K per month of the next 25 years with a Rate of return = 12%. I got a value 1,29,20,710.52. Which is like 30Lakhs short of 1.5Cr!!
What am i doing wrong here? Any help please! Am i even doing it right or is the whole thing a waste of time?