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!
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.
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,
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 😍
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.
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 :)
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
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.
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
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
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? =)
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: ruclips.net/video/AC0abCLA4dE/видео.html
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
See NordPass Business in action with a 3-month free trial with code KENJIEXPLAINS at nordpass.com/kenjiexplains/
Awesome
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!
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.
Thats awesome to hear Thanasis! Thanks so much for supporting the channel and dropping a comment :)
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,
Hi Kenji...Any update/comment? Thanks
thank god you just answered all of my questions. my teacher teaches me the same thing but more complicated and with a longer duration.
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 😍
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.
Can you reduce your FEE for excel course for some financially weak student ???
Awesome. Now ur teaching and clicking speed is too good and slow, we can understand easily. Thanks sir
Love to hear it! Thank you
Always solid with a loan table 👍
It sure is!
Bro you are genius !!! 😲😲
Haha I'm just another guy XD Thank you for supporting man
so helpful, thank you Kenji
You explain things so clearly!! Cheers
Glad it was helpful!
Wonderful sir, thank you😊
For NPV and XNPV part, is the discount rate 6% annual rate or semi-annual rate?
Why using minus sign (-) in future, present values?
How can the daily interest be added to the loan schedule?
Great video Kenji!
Kenji Thank you for your Video. I want to ask how to find out the FV including the payment of the dividend?
isn't the monthly interest rate (1+7%)^(1/12)-1??
Thanks a lot for this amazing advice ❤️
Glad it was helpful!
Great video editing!!
Glad you liked it!!
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 :)
Thank you for the nice comment man!
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
Nice tutorial, thanks
Glad you liked it!
Thank you❤
Really love the way you explain it, Could you please create similar videos for HR and Marketing professionals? It would be a great help.
Thank you! Not sure but will look further into it :)
You are amazing, thank you ♥
Thank you for watching!
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.
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
The loan schedule also works for a mortgage right?
Yes, it can work for a mortgage as well :)
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).
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
Amazing VIdeo
Glad you think so!
so accurate and simple ;)
Great to hear thanks for watching!
Why present value and future value is negative number?
Why there is no sequence function in my computer
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? =)
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: ruclips.net/video/AC0abCLA4dE/видео.html
Kenji is Financial edge legit? Like does GS and JP Morgan etc really use this to train new people? Great video btw!
Hi Albert, yes, they train the new interns/analysts in-person every year/recruiting cycle
@@KenjiExplains Thank for replying I’ve learned a lot from you
Do you have any free excel sheets
Hi you can get this excel sheet for free (like all my other videos) in the description.
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
bRILLIANT !