math of investing spreadsheet?

Question

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.

Answer 1

If you have investments that pay 12% yearly and they pay dividens quarterly you could adjust the formula by dividing the interest by 4 and then multiply g3 by 4. This will show more the benefit of compounding.