Build a Dynamic Financial Model in Just 15 Minutes

[@KenjiExplains]

🔥 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

[@solomonbhandari-young4154]

2gud

[@mitchclearyPTBO]

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?

[@olukotunbukola4959]

Very good 😊

[@apidanial8139]

do you have any promotions?

[@JulianBenjamin3d]

Investments are the roots of financial security; the deeper they grow, the stronger your future will be."

[@NicholasJames3l]

The deeper your investment roots, the stronger your financial security will be in the future.

[@SofiaJames9H]

Exactly! With my adviser, I’ve cultivated deep investment roots, strengthening my financial security for the future.

[@ChristopherJeffreynx8]

I would love an introduction to an adviser who can help me strengthen my financial roots.

[@SofiaJames9H]

My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further.

[@ChristopherJeffreynx8]

Thank you for this amazing tip. I just looked the name up and wrote her.

[@TonySpagnoli]

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!

[@mark-ish]

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.

[@michaelquach6655]

Well done. Super straightforward and cool scenario switch 👍

[@KenjiExplains]

Thanks!

[@alial5027]

Guys, what's the most important financial statement if you have to choose one only to assess a company's financial health?

[@vibhutidwivedi]

That was very basic but excellent fundamental modeling there👍, a dashboard on trends and visuals on P&L would have been just perfect 👌.

[@JunLiSF]

What's more advance?

[@achuupri]

financial modelling is such a difficult subject for me, you made it seem so easy! thank you :)

[@hafizagboola7819]

Kenji this is brilliant I must confess.

[@michellethaghost]

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!

[@journeyaddictman35]

Excellent content for beginners

[@ross3412]

Great instruction, clear and cogent. Curious if you have one of these customized for a restaurant or would you consider this model adaptable.

[@minhajghayur6437]

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?

[@SufiyanAhmad-r3k]

I learned more about excel functions than about financial modeling from this video. hahaha

[@vikramadityarathore97]

Keep doing the good job mate, excel and finance simplified for everyone.

[@KenjiExplains]

Thank you mate appreciate your support 👍

[@African.Tales.and.folklores]

I am glad i found your videos. They are really helpful

[@ameliabatiancila]

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?

[@abundantlythreesixfive1263]

Thank you this is an awesome video! Only learning about financial modelling for the first time today :)

[@sandipverma8388]

Great 😃 Thank you so much

[@MuhammadIsmail-xy4tb]

Dear, kindly also make a video on Management accounts in Excel. Thanks

[@theelephantchasingrm8427]

@kenjiexplains Can you please also show this model for a mortgage and auto lender (from Bank’s perspective)…!!

[@brian5220]

I love hou video’s, i have learned a lot. Thanks👊🏽

[@gamernihad]

You can add data validation in cell J4 and toggle between 1 and 2

[@wilmarobles4717]

Hi Kenji. Please teach also how to alphabetize tabs in workbook.

[@HammedAkogun-m6l]

Great Job...Please how can i ignore an outlier when calculating an average value in a model

[@camlex6310]

Really helpful explanation!! Thanks

[@MaZeYoutube]

best video I've seen

[@hunterburns]

Fabulous 😍 well explained everything was on point lots of love for you Kenji 💗

[@gregsnyder5325]

@kenji, great video.....

[@rukat6550]

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!

[@preyaljain6995]

Thankyou so much ❤

[@dylanlim684]

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 !

[@AnCai-gj3cp]

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)

[@CalHounsome]

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)

[@samnangchim5758]

Thanks teacher

[@sivaprakasam6550]

Very nice explanation 😊 and file can't download

[@erumshafi6562]

thanks, it is really helpful

[@nicholaspetre1]

Very good , man!

[@willzinner8813]

can you make a saas one as well please sir?

[@KenjiExplains]

Noted!

[@fernandoarroyo9357]

Does sb know hot to show the Live case as well?

[@ahnafjawadkhan2269]

Your videos are helping me a lot. Can you please make a relative valuation model please, sir?

[@KenjiExplains]

I have it here: kzbin.info/www/bejne/eYHXc32EaLh0rNU

[@aspectoflife]

the best, compact and comprehensive.

[@masumbillah1077]

just thanks teacher

[@ethiopiagirma3923]

Thank you.

[@aqsashahzad4810]

Hi. What is a dynamic financial model?

[@hassan3792]

very very nice thank you

[@seanchen2783]

Very helpful!!

[@AnthonyIsmael-b5g]

Fantastic!

[@nikhilagrawal6834]

How actually we got the growth rate/order growth rate for making models ??

[@teofilanguema1645]

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

[@RandomPerson-y9c]

I dig it… lol am I a nerd!?!?

[@philmbu6741]

Never apologise for this. Nerds rule the world.

[@jemimahkuteesa8911]

My forecasted years changing dynamically after using the choose function. Could someone kindly help out

[@marcblaze1820]

thanks g

[@brianfretes3033]

does anyone have the excel file to work alongside Kenji? I am not able to access it from the description.

[@KenjiExplains]

Hey once you click the link it should reach your downloads folder

[@brianfretes3033]

Still isn't showing up. What should I do?@@KenjiExplains

[@thobuladeepshika6859]

5:21

[@jaspritsingh8228]

can somebody help me with the excel file , i am unable to download!

[@baonguyen4278]

I cannot download the excel file :((

[@arsalanahmed5706]

shouldnt you get like a negative value in operating profit since 119850-100000-26250=-6400

[@niccolosichirollo5258]

it is negative. parentheses indicate negative in accounting.

[@gaurabdeb1511]

13:00

[@knight9040]

On what basis you've made Assumptions?

[@VijayaNarasimha522]

Based pn track record or the company Or track record of the Industry, which company is operating

[@utpalmahmud9829]

How you locked D30?

[@AliAlsailani-t5l]

where do you get your assumptions?

[@lovelyGhada]

🙌

[@nishanth4323]

Ola🙂 🙏

[@KenjiExplains]

Hello!

[@nishanth4323]

​@@KenjiExplains 🙏❤️

[@solomonbhandari-young4154]

WOW