I got the data that I need to use for this problem but I am having difficulty solving the NPVs for the different rates. Along with that, I have no idea what to do after this step. Please help? *The cost of capital is 4.375% (highlighted in yellow).

You have just purchased a house for $500,000 that is located very close to the university you attend. You plan to put $100,000 down and borrow $400,000. You need to decide which mortgage deal to take. To find out what your choices are, go to www.bankrate.com and select the appropriate buttons to get a quote for a 30-year fixed rate mortgage on a new purchase (not refinancing). Assume your FICO score is very high and you are looking for a zero point mortgage. Find the best coupon rate on a mortgage that requires paying no upfront fees or points. We will refer to this mortgage as the no-fee mortgage and assume that the rate on this mortgage is your cost of capital.

You are going to make the decision about which mortgage to consider by calculating the NPV of switching from the no-fee mortgage to each of the top six mortgages listed. To calculate the difference in payments today, and over the life of the mortgage, by subtracting the alternative mortgage payments from the no-fee mortgage payments and calculating the NPV. For good measure, calculate the IRR as well. Assume that you will be living in the house for the next 30 years for certain and you will never repay the mortgage early. Which mortgage should you undertake? Do the NPV and IRR rules agree?

Next, assume that the bank will allow you to borrow any fees and points, so the loan amount will increase by these charges.Repeat the above calculations.

Finally, repeat the calculations assuming that you will repay the outstanding balance on the mortgage after 5 years, using the same cost of capital. What can you say about which mortgage you should choose if you have a long horizon versus a shorter one?

Of course, the choice of capital will vary by individual. Because your cost of capital might be different to the one used above, for both horizons, pick the option with the largest NPV and plot the NPV profile.

	Name	Rate %	Fees	Points	Down Payment	Intial Investment	Loan Amount
Lowest Rate with no points or fees:	First Internet Bank	4.375%	0	0	$ 100,000.00	$ 500,000.00	$ 400,000.00
Six rates sorted ascendingly
1	Raymond James Bank, NA	4.750%	$ 1,299.00	0
2	Citizens Bank, NA	4.625%	$ 998.00	0.125
3	HSBC Bank, USA, N.A.	4.500%	$ 705.00	0.417
4	Bank of America	4.375%	$ 1,329.00	0.944
5	Flagstar Bank	4.125%	$ 3,047.00	1.100
6	eRates Mortgage	4.000%	$ 1,500.00	1.100