Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please can someone help answer the questions below! thank you :) PROJECT 1: FINANCE 20% OF COURSE GRADE 1. You are required to research and
Please can someone help answer the questions below! thank you :)
PROJECT 1: FINANCE 20% OF COURSE GRADE 1. You are required to research and graph a yield curve for Guaranteed Investment Certificates (GIC) versus mortgage interest rates from ONE (1) financial institution. You may rely on primary research, such as visiting a bank and discussing the rates with staff, or secondary research, such as finding the rates on the internet. (a) Find the current interest rates for GICs and closed mortgages for terms or maturity dates of 6 months, 1 year, 2 years, 3 years, 4 years, and 5 years. Using a spreadsheet program, create a line graph (not a bar chart) with the interest rate on the vertical (Y) axis and time to maturity on the horizontal (X) axis. Include a table of rates by time to maturity. Plot both the GIC and mortgage rates on one graph In your answer, ensure that you specify the source of the information and the date on which it was obtained. For GIC rates, indicate the deposit range for which the rates are valid, i.e., $5,000 to $50,000. (10 marks) (b) Interpret the results. In your answer, ensure that you explain why the lines in your graph slope positively or negatively. Also explain why you think there is a "spread" between the two rates. In your discussion, consider risk, opportunity cost of capital, liquidity, administration costs, and matching assets and liabilities. (10 marks) PROJECT 1: FINANCE 20% OF COURSE GRADE 1. You are required to research and graph a yield curve for Guaranteed Investment Certificates (GIC) versus mortgage interest rates from ONE (1) financial institution. You may rely on primary research, such as visiting a bank and discussing the rates with staff, or secondary research, such as finding the rates on the internet. (a) Find the current interest rates for GICs and closed mortgages for terms or maturity dates of 6 months, 1 year, 2 years, 3 years, 4 years, and 5 years. Using a spreadsheet program, create a line graph (not a bar chart) with the interest rate on the vertical (Y) axis and time to maturity on the horizontal (X) axis. Include a table of rates by time to maturity. Plot both the GIC and mortgage rates on one graph In your answer, ensure that you specify the source of the information and the date on which it was obtained. For GIC rates, indicate the deposit range for which the rates are valid, i.e., $5,000 to $50,000. (10 marks) (b) Interpret the results. In your answer, ensure that you explain why the lines in your graph slope positively or negatively. Also explain why you think there is a "spread" between the two rates. In your discussion, consider risk, opportunity cost of capital, liquidity, administration costs, and matching assets and liabilities. (10 marks) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started