Mortgage Loan IRR Calculator for Windows

Name: Mortgage Loan IRR Calculator
Rating: 4 (1 reviews)
Author: Shahed Ahmmed

By Shahed Ahmmed
Free
User Rating

Download now

Key Details of Mortgage Loan IRR Calculator

Calculate the IRR of equal monthly installment mortgage loan.
Last updated on January 27, 2015
There have been 5 updates
Virus scan status:
Clean (it's extremely likely that this software program is clean)

Developer's Description

By Shahed Ahmmed

Calculate the IRR of equal monthly installment mortgage loan.

If you are an MBA student having Real Estate Finance as one of the major courses, you are familiar to the difficulties in calculating the IRR of mortgage loans. Excel 2003 cannot solve these IRRs, and sometimes provides inaccurate results. Having a financial calculator is perhaps the best option. However, if you do not have a financial calculator, you may try out this program.

This Windows based program calculates the IRR (internal rate of return) of mortgage loan with good accuracy. It only works for EMI or equal monthly installment loans (also known as CPM or constant payment mortgage), which is the most common type of mortgage loan. This software should not be used for CAM (constant amortization mortgage, which is far less common) loans, because that kind of loan requires a completely different formula to find out their IRR.

It requires these variables to find out the IRR: (1) Net PV or NPV, (2) loan maturity in month, (3) monthly payment or installment, and (4) Loan Closing Fees.