Тёмный

Top 10 Excel Financial Formulas From Beginner to PRO 

Kenji Explains
Подписаться 526 тыс.
Просмотров 65 тыс.
50% 1

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/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: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / 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.

Опубликовано:

 

19 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 64   
@KenjiExplains
@KenjiExplains Год назад
See NordPass Business in action with a 3-month free trial with code KENJIEXPLAINS at nordpass.com/kenjiexplains/
@solomonbhandari-young4154
@solomonbhandari-young4154 Год назад
Awesome
@Dhiyaneshwar_Vlogger_12
@Dhiyaneshwar_Vlogger_12 Год назад
I highly recommend these videos to anyone who uses financials Excel. Kenji Sir, I would like to thank you very much for doing this amazing video! We'd like to see financial videos related to Excel! Thank you!
@karimsalah5747
@karimsalah5747 Год назад
It is amazing from you to explain finance formulas and I'd like to explain how I calculate Profitability Index & Payback Period & Discounted Payback Period, Thanks for sharing 😍
@Bitactile
@Bitactile 6 месяцев назад
thank god you just answered all of my questions. my teacher teaches me the same thing but more complicated and with a longer duration.
@romeshkirpalani848
@romeshkirpalani848 7 месяцев назад
Wonderful sir, thank you😊
@solomonbhandari-young4154
@solomonbhandari-young4154 Год назад
Great video Kenji!
@giselajesusjonnyalvarez8291
I loved your videos on Finance applications using Excel. I would like to see a video on how to calculate the average IRR and MIRR (or even XIRR) of a portfolio of investments, when all these investments have different duration, different start and end date and different cash flow profile,
@giselajesusjonnyalvarez8291
Hi Kenji...Any update/comment? Thanks
@azudaros
@azudaros Год назад
HI from Greece i am a student in the university in accounting and finance and i cant thank you in enough for your wonderful content thank so much you explain everything crystal clear.
@KenjiExplains
@KenjiExplains Год назад
Thats awesome to hear Thanasis! Thanks so much for supporting the channel and dropping a comment :)
@pairnipa4442
@pairnipa4442 Год назад
Thanks a lot for this amazing advice ❤️
@KenjiExplains
@KenjiExplains Год назад
Glad it was helpful!
@flourishwithMJ
@flourishwithMJ 11 месяцев назад
Thank you❤
@camlex6310
@camlex6310 Год назад
You explain things so clearly!! Cheers
@KenjiExplains
@KenjiExplains Год назад
Glad it was helpful!
@Dhaval_Khatri
@Dhaval_Khatri Год назад
Informative and insightful ! I recently came across your channel and found out to be one of the hidden gems, you are doing a great job by sharing your knowledge on excel and tips and tricks Thank You :)
@KenjiExplains
@KenjiExplains Год назад
Thank you for the nice comment man!
@dadada3195
@dadada3195 Год назад
You are amazing, thank you ♥
@KenjiExplains
@KenjiExplains Год назад
Thank you for watching!
@JuhoKim-Jayden
@JuhoKim-Jayden Год назад
Kenji Thank you for your Video. I want to ask how to find out the FV including the payment of the dividend?
@michaelquach7046
@michaelquach7046 Год назад
Always solid with a loan table 👍
@KenjiExplains
@KenjiExplains Год назад
It sure is!
@StoaSessions
@StoaSessions Год назад
Great video editing!!
@KenjiExplains
@KenjiExplains Год назад
Glad you liked it!!
@exafin
@exafin Год назад
so accurate and simple ;)
@KenjiExplains
@KenjiExplains Год назад
Great to hear thanks for watching!
@mohammedabrarjawad8586
@mohammedabrarjawad8586 Год назад
Really love the way you explain it, Could you please create similar videos for HR and Marketing professionals? It would be a great help.
@KenjiExplains
@KenjiExplains Год назад
Thank you! Not sure but will look further into it :)
@AdeKaryadi
@AdeKaryadi Год назад
Nice tutorial, thanks
@KenjiExplains
@KenjiExplains Год назад
Glad you liked it!
@serranosmie
@serranosmie Год назад
Hi Kenji! New subscriber here. I tried finding videos of sumproduct. Hope you can make a video of it in the future. Your videos are amazing! Thank you for sharing your knowledge with us.
@ellywang5457
@ellywang5457 Год назад
For NPV and XNPV part, is the discount rate 6% annual rate or semi-annual rate?
@hunterburns
@hunterburns Год назад
Bro you are genius !!! 😲😲
@KenjiExplains
@KenjiExplains Год назад
Haha I'm just another guy XD Thank you for supporting man
@CaptAnthonyPowell
@CaptAnthonyPowell Год назад
How can the daily interest be added to the loan schedule?
@Perfectsound88
@Perfectsound88 Год назад
Amazing VIdeo
@KenjiExplains
@KenjiExplains Год назад
Glad you think so!
@aryansingh-gv7xn
@aryansingh-gv7xn Год назад
Can you reduce your FEE for excel course for some financially weak student ???
@qasimhameed3988
@qasimhameed3988 Год назад
Awesome. Now ur teaching and clicking speed is too good and slow, we can understand easily. Thanks sir
@KenjiExplains
@KenjiExplains Год назад
Love to hear it! Thank you
@riccardozorzi9678
@riccardozorzi9678 Год назад
isn't the monthly interest rate (1+7%)^(1/12)-1??
@wrentic
@wrentic Год назад
Why using minus sign (-) in future, present values?
@walidalayoubi114
@walidalayoubi114 7 месяцев назад
I am having hard time when to lock a cell, why didn't we lock the cell in principle column but lock it in the interest payment column in the 3rd sheet (loan payments) thnx
@edwinpina4388
@edwinpina4388 Год назад
Hey Kenji, I had a question for you: do you think is a great idea to pursue the CFA after graduating. (Currently still a College Student).
@KenjiExplains
@KenjiExplains Год назад
It’s common to pursue it alongside your fulltime job yes. Some people do pursue the level 1 while being a college senior but if you have a job lined up then I’d recommend just enjoying your final year of school
@ChasingMyLiberty
@ChasingMyLiberty Год назад
Doing Composition 2 classes remove too much time and energy. Making me question the value of this Finance degree. Could you give advice on how to getting a position at a company in a foreign country? CV or any advice helps.
@KenjiExplains
@KenjiExplains Год назад
Its always difficult as they typically prioritize university students from the country they’re based in. I’d say network and reaching out to recruiters/employees will help you stand out from the candidate pool
@alessandrobozzini8144
@alessandrobozzini8144 Год назад
Hey Kenji, do people in consulting usually make powerpoint presentation from scratch or there are some ppt templates that can be used? Anyway, do you know any good ppt business template that I can buy to make some cases presentation? =)
@KenjiExplains
@KenjiExplains Год назад
Hi Alessandro, they usually have templates with the company's font, color palette etc. Also, they sometimes use a team based in Asia to make the powerpoint edits for them (banks also do this).As for presentation templates, unfortunately I don't have any. I have a PPT video going over some slides here though: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AC0abCLA4dE.html
@willzinner8813
@willzinner8813 Год назад
The loan schedule also works for a mortgage right?
@KenjiExplains
@KenjiExplains Год назад
Yes, it can work for a mortgage as well :)
@pritamkundu2779
@pritamkundu2779 Год назад
Why there is no sequence function in my computer
@albertk3896
@albertk3896 Год назад
Kenji is Financial edge legit? Like does GS and JP Morgan etc really use this to train new people? Great video btw!
@KenjiExplains
@KenjiExplains Год назад
Hi Albert, yes, they train the new interns/analysts in-person every year/recruiting cycle
@albertk3896
@albertk3896 Год назад
@@KenjiExplains Thank for replying I’ve learned a lot from you
@ellywang5457
@ellywang5457 Год назад
Why present value and future value is negative number?
@Samtravelandtourmaldives
@Samtravelandtourmaldives Год назад
Do you have any free excel sheets
@KenjiExplains
@KenjiExplains Год назад
Hi you can get this excel sheet for free (like all my other videos) in the description.
@ibrahimahmad1725
@ibrahimahmad1725 Год назад
As the economic crisis keep rising, one needs to have different streams of income, a well detailed diversified investment portfolio in the financial markets is needed to survive, as well as secure a profitable investment future, Thanks so much 😇Dr. Catherine Nathan for improving my folio
@fredrickcollins6935
@fredrickcollins6935 Год назад
@pascalgeorge9074
@pascalgeorge9074 Год назад
@hisokaamorou4211
@hisokaamorou4211 Год назад
bRILLIANT !
Далее
TOP 10 Excel Formulas to Make You a PRO User
17:00
Просмотров 736 тыс.
Проверил на логику певца L’one
00:17
Top Excel Formulas You Should Know in 2024
14:30
Просмотров 15 тыс.
20 Excel Shortcuts to Save You HOURS of Work
13:01
Просмотров 714 тыс.
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Valuation Modeling: Excel as a tool
49:11
Просмотров 216 тыс.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
REAL Excel Interview Tests for Business & Finance Roles
13:23
Excel Interview Questions for the Financial Analyst
11:49
10 Awesome Time Saving Hacks in Excel
13:35
Просмотров 36 тыс.