I used to refer to this channel for learning basics of finance and ended up doing a degree in it. Now, I'm here to revise for am exam. Thanks a lot!
@i1234569876542 жыл бұрын
Wow, you did a very good job with explaining the steps to goal seek and constraints...I love how you put on the screen the keystrokes...super helpful, thanks!
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@sammy88l992 жыл бұрын
Thank you so much Kenji for making these videos. Thank you for making education free 🙏
@KenjiExplains2 жыл бұрын
Glad you like them!
@brocklee37687 ай бұрын
Better than all of my professors combined.
@SOCI4BLE4 ай бұрын
Absolutely clear, no BS, straight to the point and you make the content very easy to understand. Much love Kenji.
@Fant0me9722 жыл бұрын
I really like this modelling series more DCF's please
@gfzubia1618 күн бұрын
Grande Kenji, un crack
@tushargarg91182 жыл бұрын
Your videos helps Please make a video on how to take assumptions to forcast financial statements like BS cashflow P&L
@anthonyvazquez87422 жыл бұрын
Excellent video. Love the examples directly in excel. It really helps give us the viewers a look at the practical applications of the theoritical concepts we are taught in school. This help bridge the gap. Thank you
@KenjiExplains2 жыл бұрын
Great to hear! thanks for the awesome comment :)
@tanyasachdeva30088 күн бұрын
Thanks a lot. Very helpful
@mhknowledgeacademy6420 Жыл бұрын
Mr. Kenji. I love your videos. You explain very nicely and make it very easy to understand. Please make video on WACC calculation and modeling in excel.
@Sj-vs6mn Жыл бұрын
You're videos are amazing! Very straight forward and easy to digest. I am learning so much, thank you!
@nywzhizhang2 жыл бұрын
Yeay finally you make this video. Thanks for considering your subscriber's request. Tons of thank you, Kenji. Keep it up!
@KenjiExplains2 жыл бұрын
Thanks for the idea!
@jayxpea2 жыл бұрын
This was great. Simple, to the point and very practical for every day business use.
@KenjiExplains2 жыл бұрын
Great to hear thanks!
@pinareruelkeroglu4832 Жыл бұрын
First of all, I have watched many Finance videos and paid a fortune on Udemy. But you are outstanding! Well done and please keep going. Now, a serious question, I am actually doing exactly what you are doing. However, I get completely different values when I run the sensitivity calculation in the matrix. How is this possible? (*confused smile).
@derp.28982 жыл бұрын
Instant subscriber, great job. I'll be bingeing your videos buddy thank you very much.
@KenjiExplains2 жыл бұрын
awesome to hear!
@aliikhlaq2 жыл бұрын
Best video of the Excel tutorial
@jamessibanda28492 жыл бұрын
very simplified explanation and easy to understand. i just have one question though, when doing sensitivity analysis, you used price as a variable in the column section instead of units but when i look in the table its indicating the opposite. why did you do like that. Also when i selected units as variables for column section and price as variable for row section, the results are different, do you know the reason for this?
@zzaryee35724 ай бұрын
Thanks Teachers
@jp_skywalker Жыл бұрын
Thank you so much. Now I have a better understanding on how to create sensitivity analysis. Do have a video or article about how to calculate company valuation or discounted cash flow?
@m.ssharma535 Жыл бұрын
Sensitivity & Scenario Analysis super useful
@nicogerst60072 жыл бұрын
Just FYI for the 2nd example (data table) the values in the video of the table are different than if you were to input product price manually; even though it says integers of 6-10 in the column, the actual value is the goal seek approximation of 8.2134.... ±1. Thus, the values in the table differ if you input price manually or copy/paste the values
@alexrosen8762 Жыл бұрын
Your tutorials are just amazing. Very comprehensive with that extra touch. Thanks so much 🙏
@kingwei18389 ай бұрын
Awesome video, thank you!
@SimoneDoyle-e8t3 ай бұрын
Your tutorials are great! Thanks Curious, how would you connect the 3 dynamic financial statements to different scenarios analysis with an existing small business and 3 years of historical data? Would you be able to do a tutorial on 3 connected dynamic financial statements for an existing small business (less than $1M revenue) with multiple debt assumptions?
@rupomExcel Жыл бұрын
I loved the way you presented.
@gvinodnair2 жыл бұрын
Simply brilliant and adds value to a subscriber. Keep it up Kenji!
@KenjiExplains2 жыл бұрын
Much appreciated!
@giorgilobjanidze8297 Жыл бұрын
Very useful. Many thanks for your videos. Greate job
@A-broken-clay-jar2 жыл бұрын
The sensitivity analysis is great!
@KenjiExplains2 жыл бұрын
Great to hear!
@MuslimIslam012 жыл бұрын
You are an amazing and thanks for sharing useful knowledge
@tinanguyen8425 Жыл бұрын
thank you so much, you are the best excel for business and finance tutor, your practical examples made me addicted to excel
@Believeit_2 жыл бұрын
Keep it up bro.. Love from India🇮🇳❤
@KenjiExplains2 жыл бұрын
thank you Sachin!
@duggie882 жыл бұрын
Very nice video. Learned some good excel shortcuts and ways to do analysis
@malikkngn Жыл бұрын
Thank you a lot for this amazing step by step content!
@rohanagnelo70742 жыл бұрын
Love this guys tutorials !!!
@shreyansh12468 ай бұрын
you are simply the best ❤
@Ari-lu5ve2 жыл бұрын
Great video. I loved how you included the keyboard shortcuts. It would be cool if we could look at more interesting/real world application data instead of sticking with the lemonade stand example. Also, I thought you moved a little fast but I was able to pause the video to catch up so its all good. Thanks again.
@KenjiExplains2 жыл бұрын
Noted!
@melvinsimbar7060 Жыл бұрын
You are actually amazing
@ahnafjawadkhan2269 Жыл бұрын
Hey kinji thanks for the videos. It helps a lot. Can you make a video on FCFE and FCFF models
@prathmeshsharma4258 Жыл бұрын
Thankyou so much Kenji💪
@angelclarke19422 жыл бұрын
Thanks very much for this explanation, the instructions were clear and I was able to build a scenario analysis
@qikong72696 ай бұрын
Thank you for sharing your video Kenji! I really like your tutorials - they helped me a lot during my interviews in PE shops.
@KenjiExplains6 ай бұрын
That’s awesome to hear thank you for your comment 🚀
@loremipsum36252 жыл бұрын
Thank you very much for your knowledge, Sir. 🙏
@josephdelgado36192 жыл бұрын
your videos are invaluable to those entering or looking to enter jobs in finance, thanks
@normang663 Жыл бұрын
Thanks Kenji, something about your videos that make excel really exciting to learn.
@weiyingchen2518 Жыл бұрын
I worked out another answer with solver: price = 9.99, unit sold = 18865. The price is up to the constraint in this way while the unit sold is to the maximum in the video. How can I tell the solver to give me both answers?
@arslan_TM7 ай бұрын
Hello Sir In order to be a financial analyst, do you need to have a deep understanding of GL accounting processes and procedures, I mean practical exposure?
@i1234569876542 жыл бұрын
Ah, goal seek, takes me back to my business analytics class
@KenjiExplains2 жыл бұрын
haha the good stuff
@erickportuguez3906 Жыл бұрын
wonderful and brilliant! the best
@gurharkrishanbureau1872 жыл бұрын
Amazing. Pls post for trading and transactions comps
@ukemeisaac2 жыл бұрын
Great content! Great teaching. Thank you.
@camlex63102 жыл бұрын
Really helpful!! Thanks Kenji
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@asmaaljneibi881 Жыл бұрын
You are amazing! Thank you!
@abhishekthakur1109 ай бұрын
Thanks a lot
@Investment_Tradingstrategies2 жыл бұрын
wow ...Great wor k thanks for such nice video
@nikospaparis55002 жыл бұрын
Great instructions
@paulcompetente43292 жыл бұрын
You're a legend bro! ✊ Amazing content! Keep it up! 🍻
@KenjiExplains2 жыл бұрын
Thank you 🙌
@michaelquach70462 жыл бұрын
Another banger video, keep up the good work!
@KenjiExplains2 жыл бұрын
Thanks! Will do!
@YusufZiyaYİĞİT-e9c Жыл бұрын
First thank you for your well-designed education program. When I use SOLVER, solving your SOLVER example, I encountered different solution pair sets like (22,626 #units; 8,79 usd/units), (18,865; 9,99), (24,026; 8,43), (24,394; 8,35) and so forth other than your base pair set (25,000; 8,21). I guess they are endless. My question is, is that correct? And if so whether we can make an automated table like "DATA TABLE"?
@ariesinlalaland99592 жыл бұрын
Very useful, thanks for sharing!
@KenjiExplains2 жыл бұрын
Glad it was helpful!
@ankitaagrawal8273 Жыл бұрын
Thanks for the great content. You explain all the concepts in simple and effective way..
@richfrill2 жыл бұрын
thank you i learned a lot
@adilsiddique9802 жыл бұрын
Well explained 👍
@nelsonlim84377 ай бұрын
If I were to have more than one type of units and price points. Eg. 20. Do I have the create this type of assumption 20 times or are there better options? Thanks
@angelmaravilla4708 Жыл бұрын
Amazing Video!, Just one doubt: Why do you choose the "GRG Nonlinear" algorithm instead of tge "Evolutionary" Algorith??, what's the statistical reason???? (I used the second approach, and it provided other series of values for "price" and "quantity")
@pulnisav.4956 Жыл бұрын
Thank you for your knowledge sharing. I really love your channel. It's very useful tips and inspire me to do better.
@applytocanada Жыл бұрын
best of best . just be slow in explanaions . tnx
@mrCetus2 жыл бұрын
Hi bro can you explain DCF and football field please? With a real case? Maybe one company? And can you please please explain wacc? And the inflation
@samanthaaaz222 ай бұрын
Very helpful!
@paradigm3174 Жыл бұрын
thanks
@luckylucky7916 Жыл бұрын
About price and quantity sensitive, do you have any advice for Co., with multi products? G&A cost not easy to separate for each product, will we use average value of G&A?
@neilr87382 жыл бұрын
Thanks for putting out in depth content like this.
@HimanshuKumar-my2vs Жыл бұрын
You look like Trent Bolt ⚡
@mostxtremenoob63842 жыл бұрын
Kenji, could you do a video of monte carlo simulations for financial modeling?
@hankdikoma70875 ай бұрын
Hi what could be the reason why my sensitivity table does not change when the variable changes
@tryme1139 ай бұрын
Great!
@imirosmanov2745 Жыл бұрын
Dear Kenji, could you please explain how to carry out sensitivity analysis for operational risk stress testing?
@A-broken-clay-jar2 жыл бұрын
I have used solver before, and it’s pretty awesome!
@tristanchiu69442 жыл бұрын
wow very thorough
@KenjiExplains2 жыл бұрын
thank you! waiting for your next vid!
@imrandaud4782 жыл бұрын
God Bless you
@jarisstarling66962 жыл бұрын
A must Subscribe Channel !!! Thank you for your videos. I am currently working for Vanguard, which Series Licenses do you suggest offer the highest pay ? thanks for the insight
@Falkland82 Жыл бұрын
Can i kindly have guidance to down load the spread sheet used in the example.
@arindambhattacharya7848 Жыл бұрын
I agree we can do goal seek and solver to get the value of the equation we want..but does it work when I need to share the file to an audience and the audience be given the choice of choosing/changing variables
@tillysimmons38592 жыл бұрын
Can you please make a video on spreading comps? thank you
@balaramsprasad2 жыл бұрын
Super video brother. Thanks for taking the time and making useful content for fin enthusiasts. Expecting more of these. Thanks
@hariadiksa5312 жыл бұрын
Hi Kenji, thanks a lot for this lesson. How about forecast with pandemic issue ?
@kemalserkanozturk9060 Жыл бұрын
you are the best
@mahimachoudhary45622 ай бұрын
What to do if sensitivity analysis isn't working ?
@xWarPlays Жыл бұрын
I have a question, I get a numbers report every week and it’s a pain to keep copying and pasting the numbers in a new table. Is there a way to have specific parts of the numbers Im sent to be automatically transferred to the new table?
@Anon191462 жыл бұрын
Great content! Keep it up
@parisaemkani57306 ай бұрын
when i try to use solver for practicing my price per unite does not change. I checked everything. what is wrong with that?
@beckysu97282 жыл бұрын
very good video
@exodus32432 жыл бұрын
Really good content. Amazing, thanks for charing this knowledge :)
@KenjiExplains2 жыл бұрын
Thanks for the nice comment! :)
@mohsinbaig93269 ай бұрын
My Data Table shows the constant result for every input. Why this is so happening?
@francisxl3686 ай бұрын
How do you the control page down for the scenario & sensitivity analysis at 6:30 in the video?
@Ockin4982 Жыл бұрын
Hello Kenji! Thank you for the quick tips and lessons, you really helped me in my career. If I may request a topic, can you bring up sensitivity analysis in the perspective of risk management? As in trying to find out from a financial model which change in an independent variable contributes the most to the change of the output. So that we can find out which independent variable to keep an eye on and divide our risk management resources accordingly.
@pritamkundu2779 Жыл бұрын
He is like I only use keyboard, how do you remember these shortcuts
@rockj8197 Жыл бұрын
On the solver, the first time I did it, it maxed out the Units sold at 25k and adjusted the Cost per unit just like yours. On all subsequent tries, it maxed out the Cost per unit sold and left the Units sold at 18,865. Is there a reason it chooses one constraint over the other to max out? Can I control this? FYI: using excel for mac.
@jaimemoran54282 жыл бұрын
insane, keep this way!
@KenjiExplains2 жыл бұрын
thank you Jaime!
@maxmood192 жыл бұрын
Hi Kenji or Everyone else that can help. Thanks for this insightful video. I am trying to build a model with 3 interactive scenario (base, best and worst) that I want to show and interact on each tab of the worksheet. By interactive, I mean every scenario change on one tab affects other tabs of the model also. Is that even possible? if yes, please help.