fbpx
Search
Close this search box.

All articles with 'amortization schedule' Tag

Interactive Mortgage Calculator to know how much you can borrow (with Excel)

Published on Jan 20, 2010 in excel apps, Featured, Learn Excel
Interactive Mortgage Calculator to know how much you can borrow (with Excel)

Today we will build a mortgage payment calculator (and amortization schedule) using excel. But we will not build a boring excel sheet, we will build a mortgage calculator that is easy to play with.

A mortgage payment is a monthly installment that you pay towards a loan. Any mortgage loan will typically have, (1) loan amount, (2) duration of the loan in years, (3) interest rate per year

Given these 3 parameters, we can easily determine the monthly installment amount (this will be the same amount for all months during loan tenure)

We are going to use Excel’s form controls (more on this below) to build a mortgage payment calculator like this.

Continue »