Flexible Mortgage Calculator

Download the file : Flexible Mortgage Computations.xls

A friend stopped by to take my advice about repaying his outstanding personal loan.

I recalled creating an Excel Spreadsheet a few years back for myself. The spreadsheet uses Excel Function PMT to compute the EMI. Websites like EMICalc are very useful to check the schedule based on initial values of Principal, Term and Rate of Interest. But I wanted to build a sheet to check the effect of change of interest rates, partial repayment and modifying the term.

My friend found this sheet useful. Hopefully others will too.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s