To calculate a mortgage payment in Excel with a formula, you can use the PMT function. If you want to get the interest and principal amounts separately, you can use IPMT (interest component) and PPMT (principal component) functions. Before we begin, I recommend that you download the Excel spreadsheet. It includes all the formulas used […]