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.
Watch video Top 10 Excel Financial Formulas From Beginner to PRO online without registration, duration hours minute second in high quality. This video was added by user Kenji Explains 25 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 72,164 once and liked it 2.3 thousand people.