Mortgage Calculator

Use the PMT Function to Determine House loan Payments and Cost of Financing





Demo file:

The PMT function in Excel can be be utilized to ascertain the month-to-month payment for any fastened-fee bank loan. By delivering details like property finance loan (household bank loan) sum, amount of decades, and fee, we can determine the precise month-to-month property finance loan payment. Then, we can ascertain the expense of financing and carry out what-if examination to see the impression of 15-calendar year mortgages vs 30-calendar year.

source

1 comment

  1. Cost of finance should be E8-E4 right? Instead of E8-E2

    Reply

Leave a Reply