Complete Financial Analysis Report

5 PAGES ALL TOGETHER: (3) page report plus cover page (1) and reference page(1)

Background Information: 

Demonstrate your ability to illustrate the functions and impact of banking and monetary institutions and to provide a recommendation guided by them.

In your role as a financial advisor at Eagle Consulting, you are performing a complete financial analysis for Melinda Jacobsen, a successful business executive who is retiring in 10 years. A portion of this analysis covers the question of whether Ms. Jacobsen should refinance her home in order to provide additional funding for a long-term retirement investment.

Because “above and beyond” customer service is critical to the success of Eagle Consulting, in addition to providing a recommendation on possible refinancing options, you want to provide Ms. Jacobsen with some background information on the Federal Reserve and how it affects interest rates.

Using the information about Melinda Jacobsen’s goals and the information you uncover during your research, you will write a recommendation document that explains the Federal Reserve, how the Federal Reserve affects interest rates, possible loan options, and a final recommendation for what loan she should choose.  

Assignment: 

To complete this assignment, do the following: 

A. Download and read the Eagle Consulting Info Sheet (Attached).

B. Write a 3 page recommendation structured in three parts: 

1) Explanation of how the Federal Reserve impacts interest rates (1.5 pages)      

2) Explanation of loan options (1 page + Excel chart)      

3) Recommendation for a loan (0.5 page)  

See below for details on each of the three parts:

Part 1: Federal Reserve’s Impact on Interest Rates 

1. Discuss how the Federal Reserve uses the following tools to impact interest rates and the economy:

a) Open market operations

b) Discount rate

c) Reserve requirements

Part 2: Loan Options 

1. Research the current mortgage interest rates for a 10-year, 15-year, 20-year, and 30-year loan.  (Use the internet to research the current mortgage interest rates for a 10-year, 15-year, 20-year, and 30-year loan. You can usually find these rates on any bank/financial institution website, www.bankrate.com, or other sources online. Should be one page long)

2. In Excel, graph the interest rates using years as the X-axis and interest rates as the Y-axis. (Please view the attached an Excel Yield Curve example worksheet that you can use. Just change the numbers to the interest rates you find and the years)

3. Using the graph, describe the following:

    a) Type of yield curve presented in the graph

 b) Relationship between interest rates and number of years to maturity

c) Impact that risk and inflation has on the interest rates as the maturity date is lengthened

Part 3: Recommendation 

1. Make a recommendation to Ms. Jacobsen on what mortgage loan to take (10-year, 15-year, 20-year, or 30-year).

2. Justify your recommendation. (You would include the reasons why you think this is the best mortgage loan option for her based on your research)