Part 1: Loan Options
Research the current mortgage interest rates for a 10-year, 15-year, 20-year, and 30-year loan.
In Excel, graph the interest rates using years as the X-axis and interest rates as the Y-axis.
Using the graph, describe the following:
Type of yield curve presented in the graph
Relationship between interest rates and number of years to maturity
Impact that risk and inflation has on the interest rates as the maturity date is lengthened
Part 2: Recommendation
Make a recommendation to Ms. Jacobsen on what mortgage loan to take (10-year, 15-year, 20-year, or 30-year).
Justify your recommendation.