Summary
Keywords
Full Transcript
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/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: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Present Value & Future Value 3:46 - Capital Budgeting (NPV, IRR) 9:12 - Loan Schedule Table
