All electronic files to be returned on Brightspace in the assignment 1 space Before 11
pm Ottawa time.
Late submissions will be penalized 20% per day. Assignments will not be accepted
after 3 days past the deadline.
Please start this assignment early in case you have questions. If you wait until the
last minute, we might not have time to get to your questions.
Fall 2020
Professor: Marc Prud’Homme
[email protected]
Guidelines
- Please respect the following guidelines to avoid possible grade deductions:
a. If you should have questions related to the assignment, you can ask them
in the Discussion forum dedicated for assignment 1 in Brightspace. Also,
before asking a question, look through the forum in case someone has
already asked the question. In the subject box please be specific with
regards to the nature of your question (e.g., Prob 2 how to download
data?).
b. You are free to discuss the assignment with as many classmates as you
want. However, this is an individual assignment, and everyone should
submit their own copy in the assignment space in Brighspace.
c. Those questions of the assignment that require written answers should be
produced in a Word processing software such as MS Word and then
saved as a PDF file. Please ensure that your written part of the assignment
is well organized and structured and follows the chronology of the
assignment. In other words, clearly identify the problem number and that
problem 1 precedes problem 2, etc. This PDF file is the one that should be
submitted on Brightspace. So you will be submitting two files: the PDF file
with your written answers and the MS Excel template with your answers.
d. When asked to include a graph in your assignment paper, make sure that
2
it has been created in colour so we can easily identify the different data
series.
e. Include a cover page with your assignment paper (The MS Word version).
f. In the MS Excel template, do not move or change the parameters that
appear in this file. Simply fill in the blanks without moving or changing
the set ups or layouts of these various sheets. Include your answers in the
cells that have been reserved for this purpose (look for the yellow
highlighted cells).
g. When looking for the Statistics Canada V number codes (you will know
what I mean when you see them in exercise statement) you start by going
to the Data link on the Statistics Canada home page
(https://www150.statcan.gc.ca ) … once there, look in the right hand
corner and you will see a box that reads “Search by Vector”. Once on that
page you can enter the vector numbers as they appear in the exercises to
find your data. However, once that page appears, you will need you will
need to click on the number that appears under the SOURCE heading in
the box to have access to the full historical data needed to complete some
of these exercises.
h. Please use the Forum for asking questions about the assignment.
Remember that before asking a question, check on the forum, perhaps
someone has already asked the same question for which an answer will
likely be available.
i. In your calculations, limit the number of digits after the decimal to one
(e.g., 12.1 and not 12.1234).
j. Labels all graphs with titles and axis labels.
k. Failure to respect these instructions will result in a loss of grades.
To learn more about Statistics Canada data and how to download the data please
look at these links:
https://www.statcan.gc.ca/eng/developers/csv/user-guide
https://www.statcan.gc.ca/eng/about/website-faq
https://www.youtube.com/watch?v=8u1I8AWL-Q0
https://www.youtube.com/watch?v=4jdlqFu6Yak
3 - Page 17 in the textbook in the data analysis section. Do the following:
Exercise 1 – Start both series in January 2000 such as is stated in the exercise but extend
your series to August 2020. See the MS Excel template for details. This period is different
than that of the book so that we can have access the most recent data available. Include
your data and do your calculations on sheet Prob 1. Include your graph on the sheet
Graph 1. Answer parts a) to c) in your MS Word document). - Do the financial calculations on the three MS Excel sheets named Financial Calculations
1, 2, and 3. Replace the “ ? ” in these sheets by your calculated value. Your calculations
must use the financial functions built into MS Excel for this purpose. For a list of these
functions go here: https://support.microsoft.com/en-us/office/financial-functionsreference-5658d81e-6035-4f24-89c1-fbf124c2b1d8 You will likely need to use only one of
these functions for your calculations.
a. From your calculations on sheet Financial Calculations 3, do you observe a
pattern in the results as the parameters (e.g., the discount rate) change? Explain.
(Answer this question in your MS Word document). - Do Exercise 1 on Page 48 in the textbook in the Data Analysis section but replace
September 2017 by August 2020. See the MS Excel template sheet Prob 3 for more
details.
a. Which bank asset increased the most over this period? (Answer this question in
your MS Word document).
b. Which bank asset increased the least. (Answer this question in your MS Word
document). - Do Exercise 1 on Page 48 in the textbook in the Web Exercises section. Provide the
estimates for the period “as of July 31, 2020 except for part c) where your data should be
drawn from year 2015 (the latest available year for which numbers are available on this
website). Note that you may have to do some minor digging on the OSFI website to find
these data. (Answer this question in your MS Word document). - Do Exercise 2 on Page 65 in the textbook in the Data Analysis section but replace
September 2017 by August 2020. See the MS Excel template for more details. Calculate
the average growth rate and standard deviation as it is stated in the question in your
Excel template on sheet Prob 5. - Do Exercise 2 on Page 65 in the textbook in the Web Exercises. (Answer this question in
your MS Word document). - Do Exercise 1 on Page 88 in the textbook in the Data Analysis section but replace the
provided period to this one: January 1962 to August 2020. See the MS Excel template for
more details.