How To Calculate Your Mortgage Payment Using Spreadsheet Formulas In Excel, Numbers, and Google Docs

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.