Top 10 Excel Financial Formulas From Beginner to PRO
See NordPass Business in action with a 3-month free trial with code KENJIEXPLAINS at https://nordpass.com/kenjiexplains/
Learn the best Excel financial formulas like XNPV, XIRR, PMT, PV, FV, and more.
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/632d8f...
The video is split into 3 levels:
1. Present value and future value: Here we cover basic excel formulas like the PV, FV, and PMT.
2. Capital Budgeting: We use the NPV, XNPV, IRR, and XIRR to determine whether Nike should open up a new store.
3. Loan Schedule: Here we create a loan amortisation schedule to see how much it would costs us to take out a loan. This involves using formulas like PMT, PPMT, IPMT and more.
All of these examples are taught using real-life scenarios you might encounter in your day to day.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Present Value & Future Value
3:46 - Capital Budgeting (NPV, IRR)
9:12 - Loan Schedule Table
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Смотрите видео Top 10 Excel Financial Formulas From Beginner to PRO онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Kenji Explains 25 Сентябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 72,164 раз и оно понравилось 2.3 тысяч людям.