Top 10 Excel Financial Formulas From Beginner To Pro

See NordPass Business in action with a 3-month free trial with code KENJIEXPLAINS at nordpass.com/kenjiexplains/
Learn the best Excel financial formulas like XNPV, XIRR, PMT, PV, FV, and more.

🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/632d8fd1ff6e9a5490d00774

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: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS

SOCIALS:
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑‍💻 LinkedIn - linkedin.com/company/careerprinciples/

GEAR:
📹 My Favorite Books & Gear: 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.

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk