Kenji your excel and ppt videos are so good that at this rate you might as well make a course of even better a series on youtube. Great work bro, looking forward to watching more videos next year. Please make a few vids on the inner workings and strategies of investment banks and hedge funds as you are someone in the youtube space who has actually been there. Thanks :)
I had just finished learning about DFC. Although I graduated with a degree in economic and finance. Now, I’m pursuing an MBA. I learn so much about putting finance into work from you. I learn mor from your videos than from class. Now, I’m learning this. Your videos are helpful and a great refresher for me. Thank you for your time and knowledge Kenji :)
Kenji - just want to say Ive watched around 30 of your videos in the past couple of weeks. Ive learnt so much and have carried it into my small business. Brilliant stuff, really appreciate it
*Nice video !! I am convinced that the poor too could be rich , if they invest wisely and diversify their income. Investment isn’t a get rich scheme but key towards financial growth and stability*
@Gabriel Marc I have always wanted to invest in this crypto of a thing but I do not know how to go about it if you don’t mind , Can you share some ideas out here ?
@Gabriel Marc Thanks for the advise and you are right about the rumors regarding financial adviser . But I’m ready to try. If you do not mind , How can I contact Mr Rodney Hamilton Steve?
I tell everyone who would listen don’t rely on just salaries and do not save all your money in the bank as bank wouldn’t give you any returns. Invest your money and diversify your income on something productive so in the long run, you will be happy with your decision.
I got to know Rodney Hamilton Steve on a UA-cam video , where I read a comment of his great works. I had my doubts just as anyone reading these now. So , I did some research and decided to give him a try . Today, I’m glad I did as I’ve made $100k working with him. I would advise that you do a proper research when you something keeps repeating so that you don’t miss out on any opportunity as a result of doubts.
The Key to becoming successful, never give up , try and try again until you’ve succeeded. Failing doesn’t mean the end of the road . A failure is one who gives up when down. Don’t let anyone stop you from trying out any investment. Lastly , Fears and doubts kills ,never procrastinate. Just do it for it is best trying than not trying at all.
Hi, thank you for your great work. I’d like to know how do I modify a home loan formula to calculate how much interest is saved if I make two payments per month. I’ll appreciate your response God bless
Dejar Kenji, Is amazing you effort on the financial fórmulas, thanks for share It. May I want to asking you if you can re-check your calculation. cause I have a doubts, the reason Is If you asking for 5K a credit with 5% of rate during 2 years, eventualy the net debts for compount interés Will be 5,512 please, but with the payment calculate in the video for 115*48 you get 5520.can you re-evaluate the formula PMT with amortización table that check if match the payment with that futuro value under interés compount.
hi bro, i recently started following your content it's great and very useful in our day to day work.thanks for this valuable content....i have a query...i have spent my 5 yrs in construction industry as accounts person...now i want to switch to finance sector and the co. u mention u have exp. from are dream for me...how can i get job in these co. and what skills i need develop to get selected in these companies...will be avaiting for ur positive reply
What about if you're starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added accrued interest affecting the daily rate that is only charged based on the principal and not the principal + interest?
Hey Kenji, great videos, just wanted to check, i stumbled across an article that says that MIRR is a better formula to use instead of IRR, as it does not assume that the money would be invested at the same rate. Would love to hear your thoughts about it.
It depends. If you do annual time periods the IRR works well, like in this example. But if your cash flows aren't annual (like quarterly or even variable cash flows) then it makes more sense to use the XIRR formula :)
too vague, you dint specify if the interest rate is effective or anual, if it's not effective you can't just divide it like this. You have to take into consideration the compounding effect of the value of money over time
📝 Our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
Kenji your excel and ppt videos are so good that at this rate you might as well make a course of even better a series on youtube. Great work bro, looking forward to watching more videos next year. Please make a few vids on the inner workings and strategies of investment banks and hedge funds as you are someone in the youtube space who has actually been there. Thanks :)
@@rehanqureshi2609 thank you for the suggestions! More to come in 2022, appreciate your support :)
I had just finished learning about DFC. Although I graduated with a degree in economic and finance. Now, I’m pursuing an MBA. I learn so much about putting finance into work from you. I learn mor from your videos than from class. Now, I’m learning this. Your videos are helpful and a great refresher for me. Thank you for your time and knowledge Kenji :)
appreciate it thanks for watching my videos :)
Great video, can't thank you enough, please continue making videos about how to use excel in a finance context. Thank you again!
Really appreciate the comment Christian! More to come in 2022 😄
Kenji - just want to say Ive watched around 30 of your videos in the past couple of weeks. Ive learnt so much and have carried it into my small business. Brilliant stuff, really appreciate it
Hey Andy! That’s awesome to hear thank you for the comment made my day 🙌
Wish you all the best with your business 👍
@@KenjiExplains I'm Pivot tabling everthing now.. 🤣
Bro your channel is the best thing in UA-cam.
I love how simple and direct your videos are. Makes it easy to follow along.
Thank you!
*Nice video !! I am convinced that the poor too could be rich , if they invest wisely and diversify their income. Investment isn’t a get rich scheme but key towards financial growth and stability*
@Gabriel Marc I have always wanted to invest in this crypto of a thing but I do not know how to go about it if you don’t mind , Can you share some ideas out here ?
@Gabriel Marc Thanks for the advise and you are right about the rumors regarding financial adviser . But I’m ready to try. If you do not mind , How can I contact Mr Rodney Hamilton Steve?
I tell everyone who would listen don’t rely on just salaries and do not save all your money in the bank as bank wouldn’t give you any returns. Invest your money and diversify your income on something productive so in the long run, you will be happy with your decision.
I got to know Rodney Hamilton Steve on a UA-cam video , where I read a comment of his great works. I had my doubts just as anyone reading these now. So , I did some research and decided to give him a try . Today, I’m glad I did as I’ve made $100k working with him. I would advise that you do a proper research when you something keeps repeating so that you don’t miss out on any opportunity as a result of doubts.
The Key to becoming successful, never give up , try and try again until you’ve succeeded. Failing doesn’t mean the end of the road . A failure is one who gives up when down. Don’t let anyone stop you from trying out any investment. Lastly , Fears and doubts kills ,never procrastinate. Just do it for it is best trying than not trying at all.
Thanks a lot , Kenji for all your good hints on Excel. I really enjoy every video. Well done, mate !!
The education GOAT 🙌🐐
Cheers Solomon!
Great great videos!! As a finance student, none of my teachers made me get this so easily! Great content
Use SEQUENCE() with the number of payments as the rownumber. That way, everything is fully adjustable when the number of payments changes.
this was a great explanation. Now i know what I need to do. Thanks
Simply awesome. Thanks for all your very useful finance and excel videos :)
Keep them Excel videos coming!
Will do!
Simple and Pragmatic explanations. Kudos to you
Glad you liked it!
It's amazing how much to the point your videos are. Thank you
Glad you like them!
extremely helpful, thanks mate
man i learn a lot more in one video than my whole semester
Hi, thank you for your great work. I’d like to know how do I modify a home loan formula to calculate how much interest is saved if I make two payments per month. I’ll appreciate your response
God bless
GZ with 500.000 subs!!
Really helpful!! Thanks Kenji
Thanks for watching!
Hey Kenji, can you make a similar video on Cover letters as you made on CV, I found that video quite helpful. cheers!
Yes it’s pending! Hopefully out soon stay tuned :)
Here's the video if you haven't seen it! ua-cam.com/video/cvkjI0k71v0/v-deo.html
@@KenjiExplains I have seen it, it’s quite insightful, thank you
Dejar Kenji, Is amazing you effort on the financial fórmulas, thanks for share It. May I want to asking you if you can re-check your calculation. cause I have a doubts, the reason Is If you asking for 5K a credit with 5% of rate during 2 years, eventualy the net debts for compount interés Will be 5,512 please, but with the payment calculate in the video for 115*48 you get 5520.can you re-evaluate the formula PMT with amortización table that check if match the payment with that futuro value under interés compount.
hi bro, i recently started following your content it's great and very useful in our day to day work.thanks for this valuable content....i have a query...i have spent my 5 yrs in construction industry as accounts person...now i want to switch to finance sector and the co. u mention u have exp. from are dream for me...how can i get job in these co. and what skills i need develop to get selected in these companies...will be avaiting for ur positive reply
What about if you're starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added accrued interest affecting the daily rate that is only charged based on the principal and not the principal + interest?
Excellent video Kenji, thanks!!!!!
Thanks for watching!
This was super helpful! Do you think you could make a video on VBA?
Noted thank you!
Great video really helps!
very simple and very well done
Amazing channel! 👍🏿 If there's no end term for a loan payback period, could you still complete the loan amortization schedule?
Don't think so...you'd have to assume an end period
Very much understandable
Thank u sir pls make more of um !!!!!
Hey Kenji, great videos, just wanted to check, i stumbled across an article that says that MIRR is a better formula to use instead of IRR, as it does not assume that the money would be invested at the same rate. Would love to hear your thoughts about it.
Honestly the IRR is more common, but if you have a different reinvested rate then it could make more sense...just really depends on your scenario.
thank you thank you for everything
Could you do more excel ones like this sir?
Noted !
this is gold. subscribed.
Thank you Max, more to come :)
How do you create the scenarios?
Great content
Love your videos, very helpful
Thank you for watching 😄
Thank you
Awesome 👌
Excellent video.
Thank you!
U should again upload video like this👌
More coming this Sunday!
Thanks sir
this looks tough kenji
Haha hopefully useful though!
thanks so much
Thanks for watching!
Thank you sir.
Thanks for watching!
Perfect
🙌🙌🙌
Your videos are too good. But u do too fast commands on screen. Difficult to understand quickly. Plz press commands slowly. Thanks
Sorry for that! Appreciate the feedback :)
@@KenjiExplains thanks bro
No XIRR KENJI!?
I get an error whenever trying to choose the second value on the =CHOOSE( formula, it says smth about minuses etc
It says there is a problem with this formula
what did people do 50 years ago? before these computer programs
My corporate finance teacher said that the IRR formula is not good in excel
It depends. If you do annual time periods the IRR works well, like in this example. But if your cash flows aren't annual (like quarterly or even variable cash flows) then it makes more sense to use the XIRR formula :)
Borat approved loan table
😂😂😂
too vague, you dint specify if the interest rate is effective or anual, if it's not effective you can't just divide it like this. You have to take into consideration the compounding effect of the value of money over time
Please explain slow
It's amazing how much to the point your videos are. Thank you
Thanks for watching!