Mortgage Loan IRR Calculator

Developer's DescriptionBy Shahed AhmmedCalculate 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.