Ok, I know the formula for future value.
MYMONEY=C2*(1+F2)^G3
C2 = Source $$
F2 = Interest rate
G3 = Periods.
All 3 can be adjusted for what iffs.
G3 usualy changed to 5,10,20,22 (yrs to retirement)
to see what the $$ will be in a future time.
I built the spreadsheet to see if I could let the inheritance pay certain bills ... but I assumed the periods would be yearly.
I forgot that the investments pay off more often.
I relize using a yearly period is very conservative to what funds would actually earn over a years time?
How would u adjust the above, with what Ive given here?
Dont give editorials about interest rates etc..I have averaged 10%-18% for decades..(and during certain years did better).
My dad has done 12-20% for at least 8 years.
But I agreee that the calculation above should be unusually conservative.
2006-12-29
11:58:23
·
1 answers
·
asked by
pcreamer2000
5