Compounding Formula problems

R

Ryan Sheepwash

Does Anyone know a formula for Calculating monthly compounding and Semi
annual compounding, but not in advance.

Thank you
Ryan
 
D

Domenic

Are you looking for the monthly payment? If so, try the following...

Assumptions:

A1 contains the principle amount

A2 contains the percentage amount, such 6 (for 6 percentage)

A3 contains the amortization period, such as 25 (for 25 years)

Formulas:

For the monthly payment, based on monthly compounding, not in advance...

=PMT(A2/100/12,A3*12,A1)

For the monthly payment, based on semi-annual compounding, not in
advance...

=PMT(((A2/100/2+1)^2)^(1/12)-1,A3*12,A1)

Hope this helps!
 
Top