Hi Michael, thanks for the tips!

Andy: For my never ending thirst of knowledge :)

Actually, this is part of it:

Given:

// E9 Principal Amount (in Dollars)
// D11 Payments per Year (12=Monthly, 26=Bi-Weekly, 52=Weekly)
// D12 Published Interest Rate (i.e. 9% = 0.09)
// D13 Times per Year Interest Calculated (12=Normal/US Mortage 2=CDN Mortgage)

Find:
// D10 Amortization Period (in Years i.e. 6 months = 0.5)

I have looked around everywhere and there are many formulas to solve for Payments (D10) and even some which will solve for the Period of the loan (D10). The problem is, they do not take D13 into account (Times per year interest is compounded).


http://www.iuni.com/...tware/web/index.html
Links Plugins