Enter "=PMT(A1/12,A2*12,A3)-A4-A5/12" in cell A6 to calculate your monthly payment. The result appears parenthesized and red, which indicates a negative value, or cost. Advertisement ...

Use Excel to get a handle on your mortgage or loan by determining your monthly payment, your interest rate, and your loan schedule. You can take a more in-depth look at the breakdown of a loan ...