Using the RATE formula in Excel the rate per period r for a Canadian mortgage compounded semi-annually of 100000 with a monthly payment of 58445 amortized over 25 years is 041647 calculated using rRATE 2512-58445100000. Since this loan is paid in monthly installments the. The fixed monthly mortgage repayment calculation is based on the annuity formula and it is mathematically represented as Fixed Monthly Mortgage Repayment Calculation.
The formula will tell you how much each payment will be.
Monthly payment 200000 00916671009166736010091667360-1 Monthly payment 200000 00916672670841526708415-1 Monthly payment. Note that this number will be negative this is simply the program expressing it as a payment or expense. P V P M T i 1 1 1 i n PV is the loan amount PMT is the monthly payment. Monthly Payment PMT Interest Rate Number of Payments To Pay Off Loan Amount 0.