Chester Tugwell asked: 1. Mortgage repayment calculations are possible is Excel using the PMT function. The PMT function has the following arguments:Rate – this is interest rate on the mortgage loan divided by 12Nper – this is the term of the mortgage or the number of monthly repayments you will make. For example with a [...]
Continue Reading Excel Mortgage Payment Formula
Tags: Blank Spreadsheet, Column Headers, Excel Mortgage, Mortgage Calculations, Mortgage Loan, Mortgage Payment Formula, Pmt Function, Repayment Calculations, Search Box Type, Year Mortgage
