Answered step by step
Verified Expert Solution
Link Copied!

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 :)
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Art Of Distressed M And A Buying Selling And Financing Troubled And Insolvent Companies

Authors: H. Peter Nesvold, Jeffrey Anapolsky , Alexandra Reed Lajoux

1st Edition

0071750193,0071750304

More Books

Students also viewed these Finance questions

Question

Innovative financing

Answered: 1 week ago