Archives

Teaching you how to calculate your mortgage payment using Microsoft Excel, Numbers for Macintosh, or Google Docs -- complete with formulas and graphics. (1) How to calculate the monthly mortgage payment on a Principal + Interest loan, (2) How to calculate the monthly mortgage payment on an Interest Only loan, (3) How to calculate the principal paid to the mortgage in a given month, and (4) How to calculate the principal paid to the mortgage in a given year.