fbpx
Search
Close this search box.

All articles with 'calculations' 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 »

Calculating Paydays in a calendar year using Excel

Published on Sep 17, 2008 in america, Learn Excel
Calculating Paydays in a calendar year using Excel

In India salary is usually paid on the last working day of a month – the payday. It is slightly different in countries where payrolls are processed every 2 weeks. For eg. in US most companies pay salary on every 2nd Friday / Thursday. We can calculate the paydays / payroll periods in excel with […]

Continue »