We’ll cover the Time Value Of Money reading of the Quantitative Methods topic within the CFA Level 1 syllabus. The time value of money forms the basis for cash flow and security valuation. The purpose of this video is to provide a summary of the main formulae you need to know and to practise using them through exercises. We’ll start by introducing the main types of formulae and we’ll then go through 7 exercises to consolidate your understanding of these. Content covered includes: calculating the future value - both discrete and continuous compounding, the effective annual rate, the future and present value of an annuity, the growth rate of an investment and the present value of a perpetuity.
Disclaimer: This video will not provide you with an all-encompassing overview of this CFA Level 1 reading and therefore, should not be relied on exclusively for your revision.
Access the templates featured in The Excel Hub's video tutorials here:
https://theexcelhub.myshopify.com/
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/ApbGBgvsOuE
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Main formulae: (0:45)
Future value - discrete compounding: (2:07)
Future value - continuous compounding: (3:40)
Effective annual rate: (4:35)
Future value of an annuity: (6:26)
Present value of an annuity: (9:07)
Calculate a growth rate: (10:27)
Present value of a perpetuity: (11:38)