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!
