Present Value

Present Value

Cash we receive in the future is worth less than cash now. Find out how to calculate the Present Value of future cash.We will use this in future videos to understand Net Present Value and IRR.  

R1C1 Part 2 – Finding different formulae

R1C1 - Different Formulae

Following up from last week. R1C1 helps identify which formulae are copied from other cells. This micro lesson shows how to find formulae that are different in a row or column. Such rogue formulae can be the source of errors.  

The Monty Hall Problem

The Monty Hall Problem

A slight change this week, and a slightly longer video. We explore the ‘Monty Hall Problem’, a deceptively simple probability problem which most people get wrong. This involves a game show with a game of chance to win a car. We built a simulation of the probabilities to prove the correct solution.