Select Page

# Course quiz

The online Excel modelling course quiz is provided below:

Links to sections from the financial modelling course and hints, should you need them, are available at the bottom of this page.

## Links to the financial modelling course

• Question 1
• Relevant section from the financial modelling course = compounding
• Hints for answering the question = set out a table as per the downloadable spreadsheet in the compounding course challenge.  Alternatively, take a short cut and construct the following formula in Excel: “=10*(1+8%)^3”
• Question 2
• Relevant section = calculating IRR using algebra
• Hint A = we know that the 20m has been compounded at a growth rate so that it has turned into 60m in five years
• Hint B = 20x(1+IRR)^5 = 60
• Hint C = use a bit of algebra (which admittedly you may be a bit rusty on) to re-arrange the equation
• Hint D = IRR = (60/20)^(1/5)-1
• Hint E = enter the above formula into a cell in the Excel spreadsheet: “=(60/20)^(1/5)-1”
• Question 3
• Relevant section = DCF
• Hints = none!
• Question 4
• Relevant section = NPV
• Hints = none
• Question 5
• Section = NPV
• Hints = none
• Question 6
• Question 7
• Section = Excel’s XIRR formula
• Hints = none
• Question 8
• Section = Excel’s XIRR formula