Excel Model for calculating the effective borrowing cost for residential mortgage?

I am in the process of purchasing a home. I am evaluating various loans. First loan has closing costs of $ 5000 and I.R of 7%. Second loan has closing costs of $ 5500 and I.R of 6.5%. I want an excel model which will tell me the lowest cost of the two options.

Register New Account
Reset Password