nharr06
New member
- Joined
- Dec 6, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I'm looking for a VBA code to calculate a Canadian mortgage payment (interest compounded semi-annually). I found the PMT code online, but it was for US mortgage calculations.
The regular PMT formula would be: =PMT(($A$2/2+1)^(2/12)-1,12*$A$6,AF30,0,0)*-1 where A2 would be the interest rate, A6 the amortization, and AF30 the mortgage amount.
I'm just doing a simple page to compare four different mortgage options side by side. There would be three variables that I would like to be able to solve for: payment (based on inputting a rate, mortgage amount and amortization), amortization (based on inputting a rate, mortgage payment and mortgage amount), and mortgage amount (based on inputting a rate, payment and an amortization).
It should also have the ability to calculate monthly, bi-weekly, weekly, semi-monthly, accelerated bi-weekly, and accelerated weekly.
Is this something someone could help me out with?
Thanks.
The regular PMT formula would be: =PMT(($A$2/2+1)^(2/12)-1,12*$A$6,AF30,0,0)*-1 where A2 would be the interest rate, A6 the amortization, and AF30 the mortgage amount.
I'm just doing a simple page to compare four different mortgage options side by side. There would be three variables that I would like to be able to solve for: payment (based on inputting a rate, mortgage amount and amortization), amortization (based on inputting a rate, mortgage payment and mortgage amount), and mortgage amount (based on inputting a rate, payment and an amortization).
It should also have the ability to calculate monthly, bi-weekly, weekly, semi-monthly, accelerated bi-weekly, and accelerated weekly.
Is this something someone could help me out with?
Thanks.