Hi Kenji, great video. Would your excel course be relevant for someone looking to operate in google sheets instead of excel, or are there too many differences between the two?
This was incredibly helpful. I realize it's simple but for a non-financial person, it was just what I needed to put into my business plan. At least as a starting point. Thanks so much!
This was so incredibly helpful! It was a great starting place for me to understand its build so I can make it more complex for an even more precise financial picture. Thank you!
Hi Kenji, if you’re making a model similar to this at work from scratch. What source(s) would you use for your assumptions, such as the growth rate, and other line items?
Hi Dylan, because we are calculating the whole amount (including the existing portion of the current year (100% or 1) and the increasing portion of next year, so that why we have to plus 1)
Hi Kenji I’ve been following all your guidance to help improve my office work, and I’m really grateful for your insights. I do have a concern about one of my files. It has too many columns, and most rows include sub-rows. I need to filter based on the main column title, but I’m worried the sub-rows won’t remain linked to their corresponding main rows when filtered. Could you please guide me on how to arrange or manage this?
Hello Kenji! Thank you always for an informative video! Was wondering if you are using excel on Mac using parallels? It will be greatly appreciated if I could get an answer to this!
9:33 year 2 you would actually only have to pay tax for $80800 (Y2 profit + Y1 loss), not $87200, as you can offset the loss from the previous year (I think)
please can you guide me on what my mistake could be? I practiced everything and it was going well until I pressed ctrl+alt+v and everything in the live case became #value! except for the 2000
@kenjiExplains I always find difficult to have a reasonable projection for Goodwill, Debt and Interest... Even the companies financial statements sometimes are really subjective about this point. I saw so many different approaches for this topics that is crazy :D. Amazing video and simple straight forward.
🔥 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
2gud
Hi Kenji, great video. Would your excel course be relevant for someone looking to operate in google sheets instead of excel, or are there too many differences between the two?
Very good 😊
do you have any promotions?
Investments are the roots of financial security; the deeper they grow, the stronger your future will be."
The deeper your investment roots, the stronger your financial security will be in the future.
Exactly! With my adviser, I’ve cultivated deep investment roots, strengthening my financial security for the future.
My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further.
This was incredibly helpful. I realize it's simple but for a non-financial person, it was just what I needed to put into my business plan. At least as a starting point. Thanks so much!
You're a lovely person to listen to an your depth of knowledge is quite impressive.
I thank you for restoring my previously lost enjoyment of excel.
That was very basic but excellent fundamental modeling there👍, a dashboard on trends and visuals on P&L would have been just perfect 👌.
What's more advance?
whats more advance?
Well done. Super straightforward and cool scenario switch 👍
Thanks!
Guys, what's the most important financial statement if you have to choose one only to assess a company's financial health?
financial modelling is such a difficult subject for me, you made it seem so easy! thank you :)
This was so incredibly helpful! It was a great starting place for me to understand its build so I can make it more complex for an even more precise financial picture. Thank you!
Kenji this is brilliant I must confess.
Hi Kenji, if you’re making a model similar to this at work from scratch. What source(s) would you use for your assumptions, such as the growth rate, and other line items?
Hey Kenji, may I know why we have to (1+...) before multiplying the percentages for the order growth rate, what does it do ? @1:35
Thank you !
Hi Dylan, because we are calculating the whole amount (including the existing portion of the current year (100% or 1) and the increasing portion of next year, so that why we have to plus 1)
Keep doing the good job mate, excel and finance simplified for everyone.
Thank you mate appreciate your support 👍
I am glad i found your videos. They are really helpful
Excellent content for beginners
Hi Kenji
I’ve been following all your guidance to help improve my office work, and I’m really grateful for your insights.
I do have a concern about one of my files. It has too many columns, and most rows include sub-rows. I need to filter based on the main column title, but I’m worried the sub-rows won’t remain linked to their corresponding main rows when filtered.
Could you please guide me on how to arrange or manage this?
Thank you this is an awesome video! Only learning about financial modelling for the first time today :)
I love hou video’s, i have learned a lot. Thanks👊🏽
Great instruction, clear and cogent. Curious if you have one of these customized for a restaurant or would you consider this model adaptable.
Fabulous 😍 well explained everything was on point lots of love for you Kenji 💗
best video I've seen
I learned more about excel functions than about financial modeling from this video. hahaha
Great 😃
Thank you so much
Really helpful explanation!! Thanks
Great Job...Please how can i ignore an outlier when calculating an average value in a model
@kenjiexplains Can you please also show this model for a mortgage and auto lender (from Bank’s perspective)…!!
Thankyou so much ❤
Hello Kenji! Thank you always for an informative video! Was wondering if you are using excel on Mac using parallels? It will be greatly appreciated if I could get an answer to this!
Hi Kenji. Please teach also how to alphabetize tabs in workbook.
Dear, kindly also make a video on Management accounts in Excel. Thanks
Very good , man!
You can add data validation in cell J4 and toggle between 1 and 2
thanks, it is really helpful
9:33
year 2 you would actually only have to pay tax for $80800 (Y2 profit + Y1 loss), not $87200, as you can offset the loss from the previous year (I think)
Thanks teacher
please can you guide me on what my mistake could be? I practiced everything and it was going well until I pressed ctrl+alt+v and everything in the live case became #value! except for the 2000
Very helpful!!
@kenji, great video.....
Fantastic!
Very nice explanation 😊 and file can't download
Does sb know hot to show the Live case as well?
Thank you.
very very nice
thank you
just thanks teacher
the best, compact and comprehensive.
@kenjiExplains I always find difficult to have a reasonable projection for Goodwill, Debt and Interest... Even the companies financial statements sometimes are really subjective about this point. I saw so many different approaches for this topics that is crazy :D. Amazing video and simple straight forward.
Your videos are helping me a lot. Can you please make a relative valuation model please, sir?
I have it here: th-cam.com/video/CPtBJN3SAvs/w-d-xo.html
My forecasted years changing dynamically after using the choose function. Could someone kindly help out
can you make a saas one as well please sir?
Noted!
can somebody help me with the excel file , i am unable to download!
Hi. What is a dynamic financial model?
does anyone have the excel file to work alongside Kenji? I am not able to access it from the description.
Hey once you click the link it should reach your downloads folder
Still isn't showing up. What should I do?@@KenjiExplains
I cannot download the excel file :((
thanks g
I dig it… lol am I a nerd!?!?
Never apologise for this. Nerds rule the world.
shouldnt you get like a negative value in operating profit since 119850-100000-26250=-6400
it is negative. parentheses indicate negative in accounting.
🙌
5:21
On what basis you've made Assumptions?
Based pn track record or the company
Or track record of the Industry, which company is operating
13:00
where do you get your assumptions?
😊
Ola🙂 🙏
Hello!
@@KenjiExplains 🙏❤️
How you locked D30?
WOW