View the step-by-step solution to:

Question

This question was created from fin480 hw.docx https://www.coursehero.com/file/35312888/fin480-hwdocx/

Your success in business thus far has put you in a position to purchase a home for
\$500,000 located in Nashville, TN. You plan to pay a 20% down payment of \$100,000
and borrow the remaining \$400,000. You need to decide on a mortgage, and realize
you can apply the skills you have acquired in the last several chapters to evaluate your
choices. To find the available options, go to www.bankrate.com (Links to an external
site.)Links to an external site.. Select “Mortgages,” then &quot;Mortgage Rates.” For location,
enter a zip code for Nashville; for mortgage type, choose purchase (not refinance). Consider 30-year fixed rate mortgages with 20% down, and assume your credit score is
the highest possible. Consider all the options by selecting loans with “All points.” Update rates and sort by
“Rate” to find the loan with the lowest rate (not APR). Record the rate, points, fees,
“APR,” and monthly payment for this loan. Next consider only loans with &quot;0 points” and find the loan with the lowest fees. Again,
record the rate, points, fees, “APR,” and monthly payment for this loan. First, use the annuity formula or PMT function in Excel to verify the monthly payment for
each loan. (Note that to convert the “Rate” to a monthly interest rate you must divide by
12. Your result may differ slightly due to rounding.) Next, calculate the actual amount you will receive from each loan after both fees and
points. (Note that fees are a fixed dollar amount; points are also paid up front and are
calculated as a % of the loan amount.) Using this net amount as the amount you will
receive (rather than \$400,000), show that the quoted “APR” of the loan is the effective
lRR of the loan once all fees are included (you may use the Rate function in Excel, or
calculate the NPV at the quoted &quot;APR”). Compare the loans, assuming you will keep them for 30 years, as follows: 1. Compute the incremental cash flows of the lower rate loan; that is, determine
how much more you will pay in fees, and how much you will save on your monthly
payment.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents