» Calculating Canadian Mortgage Payments
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
Problem: The following PMT formula calculates the monthly payment for a $100,000 mortgage, repaid over a period of 20 years, at 8% annual interest:
=PMT(8%/12,12*20,100000,0,0)
As Canadian interest rates are calculated semi-annually, rather than annually, the above formula will not calculate the payments correctly.
How can we modify the above PMT formula to calculate monthly payments for Canadian mortgages?
Solution:
With interest rate in column A, period (years) in column B, and mortgage sum in column C, use the PMT function as shown in the following formula:
=PMT((A2/2+1)^(2/12)-1,12*B2,C2,0,0)
Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
No comments have been submitted.
