Course curriculum

  • 1

    Introduction

    • Welcome

    • Course introduction

    • Downloadable files

  • 2

    Discounted Cash Flows

    • Session objectives

    • The basic idea

    • The discount rate

    • Which is more valuable to you?

    • The time value of money

    • A simple example

    • Compounding and discounting

    • Interactive exercise 1

    • NPV introduction

    • NPV demonstration

    • NPV exercise

    • Annuities introduction

    • Understanding annuities

    • The annuity factor

    • Interactive exercise 2

    • Annuity tables

    • Annuity demonstration

    • Annuity exercise

    • Perpetuity

    • Perpetuity example

    • Constant perpetuity

    • Growing perpetuity

    • Interactive exercise 3

    • Perpetuity demonstration

    • Prize draw exercise

    • Session conlusion

  • 3

    Bond Pricing and Yields

    • Session objectives

    • Bonds

    • Par value

    • Forecasting cash flows

    • Coupon rate and yield to maturity

    • Interactive exercise 4

    • Valuing a bond

    • Setting up the cash flow

    • Annual bond demonstration

    • Annual bond exercise

    • Semi annual bond cash flows

    • Semi annual bond yield to maturity

    • Semi annual diagram of cash flow

    • Interactive exercise 5

    • Semi annual bond demonstration

    • Semi annual bond exercise

    • Yield to maturity

    • Break down of YTM

    • Bond prices and yield

    • YTM and current yield

    • Relationship between yields

    • Interactive exercise 6

    • Bond pricing and yields exercise

    • Session conclusion

  • 4

    Key Statistical Skills

    • Session objectives

    • Measures of central tendency

    • Arithmetic mean

    • Weighted mean

    • WACC

    • Quiz

    • WACC equation

    • Expected values

    • Expected values demonstration

    • Expected values exercise

    • Moving averages

    • Simple moving average

    • Simple moving example

    • Interactive exercise 7

    • Weighted moving average

    • Weighted moving example

    • Weighted moving average demonstration

    • Moving average exercise

    • Measures of dispersion

    • Range

    • Variance

    • Variance example

    • Quiz

    • Population vs. sample variance

    • Standard deviation

    • Variance vs. standard deviation

    • Interactive exercise 8

    • Mean and standard deviation demonstration

    • Mean and standard deviation exercise

    • Session conclusion

  • 5

    Covariance, Correlation and Regression

    • Session objectives

    • Relationship between variables

    • Covariance and correlation

    • Covariance

    • Calculating the covariance

    • Drivers of covariance

    • Population vs. Sample Data (Covariance)

    • Interactive exercise 9

    • Correlation

    • Covariance and correlation demonstration

    • Covariance and correlation exericse

    • Regression analysis

    • Simple linear regression

    • The regression equation

    • Sum of squares

    • R squared and the correlation coefficient

    • Interactive exercise 10

    • Regression demonstration

    • Target exercise

    • Session conclusion

    • Summary

  • 6

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion