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.
