Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Top 10 Excel Financial Formulas From Beginner to PRO
Play lesson

💰 Financial Analysis in Excel - Top 10 Excel Financial Formulas From Beginner to PRO

4.0 (1)
8 learners

What you'll learn

This course includes

  • 6.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere