Question: plz write all equations From the textbook in the DATA ANALYSIS PROBLEMS section (towards the end of the chapter) from Chapter 4. Do the following:

plz write all equations

From the textbook in the DATA ANALYSIS PROBLEMS section (towards the end of the chapter) from Chapter 4. Do the following: Exercise 1 But make the following adjustments: the start date is January 1962, and the end date is August 2021. In addition to what is being asked for in the question, calculate the monthly real interest rate and draw a line graph showing these three series over the period: the monthly inflation rate, the monthly T-bill rate, and the monthly real interest rate. Save this graph as a separate sheet in Excel and name this sheet REAL (in the excel file). Use different colour lines to identify these series in the graph.

DATA ANALYSIS PROBLEMS:

Go to the CANSIM database and download monthly data from January 1953 to October 2017 for the three-month T-bill rate (series V122541)... What is the average year-over-year inflation rate, using the following formula below?

A) What is the average year-over-year inflation rate, using the following formula below?

What is the average year-over-year inflation rate, using the following formula below?

t = 100 (PtPt-12) / Pt-12

B) What is the average T-bill rate?

c) Assume that the expected inflation rate is the same as the actual inflation rate (a restrictive assumption!) and calculate the average real interest rate, r.

1 month 3 month 6 month 1 year 2 year 3 year 5 year 10 year long term
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!