8 Must-Know Financial Modeling Functions in Excel
In this video we'll look at 8 of the most common functions used in financial modeling. Just to set the stage, please know that financial modeling is a very broad, deep and intense field of study. This video is in no way intended to be comprehensive; rather the goal is to focus on common excel functions used within most modeling schools and to distill the concepts covered into their purest essence.
⌚** TIMESTAMPS**
0:00 Intro | Setting the baseline goals
0:32 What is Financial Modeling
0:53 Functions covered in this video
1:04 Payment Function (PMT)
2:36 Calculating Compound Interest
4:04 A simple definition of the time value of money
4:29 Future Value (FV)
5:34 Present Value (PV)
6:38 Number of Periods (NPER)
7:43 Net Present Value (NPV)
11:30 Internal Rate of Return (IRR)
13:36 AGGREGATE Function Overview
💾 *DOWNLOAD SAMPLE FILE*
https://1drv.ms/x/s!AgnhzVKiTqWmgSMBW...
📄 * FREE RESOURCES*
Mega Cheat Sheet
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...
Смотрите видео 8 Must-Know Financial Modeling Functions in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 02 Ноябрь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 294 раз и оно понравилось 11 людям.