One way:
Take a look at the FV function
=FV(i/12, n*12, pmt, PV)
where i = the annual interest rate, and n = the number of years. PV =
the present value of the investment/loan, and pmt is any periodic
payment (or 0, if none).
Note: if pmt = 0, FV and PV will be of opposite signs. Think of negative
numbers as outflows of cash, and positive numbers as inflows.
You could also use (assuming pmt = 0)
=PV*(1+i/12)^(n*12)
In article ,
"lax_fan" wrote:
Trying to compound interest earned every 12 months, so setting up an @if
formula based on month equally divisible by 12.
|