I need help with the problem below. Im not sure how to calculate the cash flows for each and how to determine the difference in payments today and over the life of the mortgage from the no-fee mortgage and the alternates (per the first question set below). I'm having difficulty knowing where to start. Knowing the steps would be greatly beneficial for me in understanding how to arrive at the correct answer.

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., 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 NPV of this decision, calculate the difference in payments today, and over the life of the mortgage, by subtracting the alternate 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 horizon?

Of course, the best choice of cost 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.

Information from Bankrate.com

Lender	Rate	Fee	Points
Blue Spot (No Fee Mortgage)	3.999	$ -	0
Homefinity	4.125	$ 453.00	0
AimLoan.com	4.125	$ 971.00	0
CF Bank	4.250	$ 77.00	0
Better Mortgage	4.250	$ 23.00	0
LincolnWay	4.250	$ 1,085.00	0
Ally Bank	4.375	$ 700.00	0