BEST Financial Formulas on Excel | For Business & Finance Professionals

[@KenjiExplains]

📝 Our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

[@rehanqureshi2609]

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 :)

[@KenjiExplains]

@@rehanqureshi2609 thank you for the suggestions! More to come in 2022, appreciate your support :)

[@vanillalatte5227]

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 :)

[@KenjiExplains]

appreciate it thanks for watching my videos :)

[@FlyingAndy]

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

[@KenjiExplains]

Hey Andy! That’s awesome to hear thank you for the comment made my day 🙌 Wish you all the best with your business 👍

[@FlyingAndy]

@@KenjiExplains I'm Pivot tabling everthing now.. 🤣

[@osindez]

Thanks a lot , Kenji for all your good hints on Excel. I really enjoy every video. Well done, mate !!

[@victorehigiamusoe6087]

I love how simple and direct your videos are. Makes it easy to follow along.

[@KenjiExplains]

Thank you!

[@etiennetremblay2154]

Great great videos!! As a finance student, none of my teachers made me get this so easily! Great content

[@giorgimodebadze1869]

Bro your channel is the best thing in KZbin.

[@christiancoronado]

Great video, can't thank you enough, please continue making videos about how to use excel in a finance context. Thank you again!

[@KenjiExplains]

Really appreciate the comment Christian! More to come in 2022 😄

[@solomonbhandari-young4154]

The education GOAT 🙌🐐

[@KenjiExplains]

Cheers Solomon!

[@ddp2049]

this was a great explanation. Now i know what I need to do. Thanks

[@beatriceottilie3655]

*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*

[@christinabecker5495]

@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 ?

[@christinabecker5495]

@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?

[@theresamaddison1304]

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.

[@lucasferari4515]

I got to know Rodney Hamilton Steve on a KZbin 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.

[@theodorerossi7998]

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.

[@balaramsprasad]

Simple and Pragmatic explanations. Kudos to you

[@KenjiExplains]

Glad you liked it!

[@Pietsuttaja]

Keep them Excel videos coming!

[@KenjiExplains]

Will do!

[@mebandohling5505]

man i learn a lot more in one video than my whole semester

[@chensebassen]

GZ with 500.000 subs!!

[@davidtomasgaitanrodriguez1356]

Simply awesome. Thanks for all your very useful finance and excel videos :)

[@camlex6310]

Really helpful!! Thanks Kenji

[@KenjiExplains]

Thanks for watching!

[@konstantinosl6992]

It's amazing how much to the point your videos are. Thank you

[@KenjiExplains]

Glad you like them!

[@arslan3108]

extremely helpful, thanks mate

[@harissiddiqui9336]

This was super helpful! Do you think you could make a video on VBA?

[@KenjiExplains]

Noted thank you!

[@manuelalejandrocutirodrigu7080]

Excellent video Kenji, thanks!!!!!

[@KenjiExplains]

Thanks for watching!

[@abhinavyadav7362]

Hey Kenji, can you make a similar video on Cover letters as you made on CV, I found that video quite helpful. cheers!

[@KenjiExplains]

Yes it’s pending! Hopefully out soon stay tuned :)

[@KenjiExplains]

Here's the video if you haven't seen it! kzbin.info/www/bejne/mafOm3xmoJxkrJI

[@abhinavyadav7362]

@@KenjiExplains I have seen it, it’s quite insightful, thank you

[@bhagyeshbalte5461]

Thank u sir pls make more of um !!!!!

[@marslanyousaf4908]

very simple and very well done

[@novamputra4120]

Great video really helps!

[@seanmichael6579]

Use SEQUENCE() with the number of payments as the rownumber. That way, everything is fully adjustable when the number of payments changes.

[@quietside1380]

Great content

[@Max-ns3db]

this is gold. subscribed.

[@KenjiExplains]

Thank you Max, more to come :)

[@ourbd5044]

Very much understandable

[@muhammadimtiazimtiaz3210]

Awesome 👌

[@binoddhamala532]

thank you thank you for everything

[@ourbd5044]

U should again upload video like this👌

[@KenjiExplains]

More coming this Sunday!

[@khamikajung]

Love your videos, very helpful

[@KenjiExplains]

Thank you for watching 😄

[@tryme113]

Thank you

[@sgopalakrishnan8715]

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

[@farhanhasan4391]

Excellent video.

[@KenjiExplains]

Thank you!

[@willzinner8813]

Could you do more excel ones like this sir?

[@KenjiExplains]

Noted !

[@economics_stats]

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

[@omerainanshe1760]

Amazing channel! 👍🏿 If there's no end term for a loan payback period, could you still complete the loan amortization schedule?

[@KenjiExplains]

Don't think so...you'd have to assume an end period

[@robertross3188]

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?

[@RahulKumar-ly6ly]

Thanks sir

[@albertopenalver1435]

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.

[@kalulemarvin4144]

How do you create the scenarios?

[@puggi1997]

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.

[@KenjiExplains]

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.

[@tristanchiu6944]

this looks tough kenji

[@KenjiExplains]

Haha hopefully useful though!

[@hamedalcherif9064]

Thank you sir.

[@KenjiExplains]

Thanks for watching!

[@nikhilshetty5944]

thanks so much

[@KenjiExplains]

Thanks for watching!

[@1KJW]

Perfect

[@KenjiExplains]

🙌🙌🙌

[@qasimhameed3988]

Your videos are too good. But u do too fast commands on screen. Difficult to understand quickly. Plz press commands slowly. Thanks

[@KenjiExplains]

Sorry for that! Appreciate the feedback :)

[@qasimhameed3988]

@@KenjiExplains thanks bro

[@user-xx1gq7nr9o]

I get an error whenever trying to choose the second value on the =CHOOSE( formula, it says smth about minuses etc

[@user-xx1gq7nr9o]

It says there is a problem with this formula

[@bklwealth1132]

No XIRR KENJI!?

[@HomoOeconomicus999]

My corporate finance teacher said that the IRR formula is not good in excel

[@KenjiExplains]

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 :)

[@michaelquach7046]

Borat approved loan table

[@KenjiExplains]

😂😂😂

[@robroby7416]

what did people do 50 years ago? before these computer programs

[@FoodNation-f9f]

Dollar is not money. It's reserve currency for now.

[@luismariabarreiros2693]

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

[@rajashekark6532]

Please explain slow

[@mrCetus]

It's amazing how much to the point your videos are. Thank you

[@KenjiExplains]

Thanks for watching!