How do you calculate a mortgage loan in Excel?
You can calculate the interest on your mortgage in Excel. Open Excel on your computer. Enter "Mortgage Amount" in cell A1, "Term in Years" in cell A2, "Interest Rate as a Percent" in cell A3, "Monthly Payment" in cell A4, "Total Payments" in cell A5 and "Interest Payments" in cell A6.
DA: 69 PA: 62 MOZ Rank: 49