T2 EIC 3 (Lecture)

This EIC question provides specific guidance on the best practice of adjusting per annum discount or compounding rates in Excel. It directly builds on the Excel demonstrations in Video Lecture B, where you are required to setup Excel calculators to bring into your Tutorial. If you have not completed Video Lecture B nor setup the Excel Calculators in your Excel Class Workbook (as required in Video Lecture B), you will not be able to complete this question nor EIC 4. 

You are given a 5% per annum discount rate that you need to convert to a monthly discount rate. This is because the future cash flow that you wish to discount is a monthly cash flow. What is the monthly discount rate? Enter your answer below to 2 decimal places. In these Moodle numerical questions, you need to enter you anwers without units (i.e. no $ or %) and no formatting (no commas) except for a decimal place (an appropriately formated answer is 0.11). 

The way you achieve your answer is by typing in the Excel formula =5%/12 directly into the i variable of a copy of the PV or FV Excel calculators. This will provide an exact answer with all decimal places captured, though only 2 decimal places are displayed.

Do not calculate the answer separately (e.g. on your phone or another place in Excel) and then type in the discount rate.