Build a Dynamic Financial Model in Just 15 Minutes

  Рет қаралды 225,577

Kenji Explains

Kenji Explains

Күн бұрын

Пікірлер: 86
@KenjiExplains
@KenjiExplains Жыл бұрын
🔥 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
@solomonbhandari-young4154
@solomonbhandari-young4154 Жыл бұрын
2gud
@mitchclearyPTBO
@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
@olukotunbukola4959 Жыл бұрын
Very good 😊
@apidanial8139
@apidanial8139 2 ай бұрын
do you have any promotions?
@TonySpagnoli
@TonySpagnoli 11 ай бұрын
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!
@JulianBenjamin3d
@JulianBenjamin3d 8 күн бұрын
Investments are the roots of financial security; the deeper they grow, the stronger your future will be."
@NicholasJames3l
@NicholasJames3l 8 күн бұрын
The deeper your investment roots, the stronger your financial security will be in the future.
@SofiaJames9H
@SofiaJames9H 8 күн бұрын
Exactly! With my adviser, I’ve cultivated deep investment roots, strengthening my financial security for the future.
@ChristopherJeffreynx8
@ChristopherJeffreynx8 8 күн бұрын
I would love an introduction to an adviser who can help me strengthen my financial roots.
@SofiaJames9H
@SofiaJames9H 8 күн бұрын
My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further.
@ChristopherJeffreynx8
@ChristopherJeffreynx8 8 күн бұрын
Thank you for this amazing tip. I just looked the name up and wrote her.
@vibhutidwivedi
@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
@JunLiSF 5 ай бұрын
What's more advance?
@mark-ish
@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
@michaelquach6655 Жыл бұрын
Well done. Super straightforward and cool scenario switch 👍
@KenjiExplains
@KenjiExplains Жыл бұрын
Thanks!
@alial5027
@alial5027 Жыл бұрын
Guys, what's the most important financial statement if you have to choose one only to assess a company's financial health?
@achuupri
@achuupri 3 ай бұрын
financial modelling is such a difficult subject for me, you made it seem so easy! thank you :)
@michellethaghost
@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!
@hafizagboola7819
@hafizagboola7819 3 ай бұрын
Kenji this is brilliant I must confess.
@vikramadityarathore97
@vikramadityarathore97 Жыл бұрын
Keep doing the good job mate, excel and finance simplified for everyone.
@KenjiExplains
@KenjiExplains Жыл бұрын
Thank you mate appreciate your support 👍
@abundantlythreesixfive1263
@abundantlythreesixfive1263 4 ай бұрын
Thank you this is an awesome video! Only learning about financial modelling for the first time today :)
@African.Tales.and.folklores
@African.Tales.and.folklores 10 ай бұрын
I am glad i found your videos. They are really helpful
@hunterburns
@hunterburns Жыл бұрын
Fabulous 😍 well explained everything was on point lots of love for you Kenji 💗
@brian5220
@brian5220 Жыл бұрын
I love hou video’s, i have learned a lot. Thanks👊🏽
@journeyaddictman35
@journeyaddictman35 Жыл бұрын
Excellent content for beginners
@ross3412
@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
@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
@SufiyanAhmad-r3k 10 күн бұрын
I learned more about excel functions than about financial modeling from this video. hahaha
@camlex6310
@camlex6310 Жыл бұрын
Really helpful explanation!! Thanks
@ameliabatiancila
@ameliabatiancila 15 күн бұрын
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?
@MaZeYoutube
@MaZeYoutube 24 күн бұрын
best video I've seen
@dylanlim684
@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
@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)
@sandipverma8388
@sandipverma8388 10 күн бұрын
Great 😃 Thank you so much
@nicholaspetre1
@nicholaspetre1 Жыл бұрын
Very good , man!
@preyaljain6995
@preyaljain6995 Жыл бұрын
Thankyou so much ❤
@rukat6550
@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!
@CalHounsome
@CalHounsome 5 ай бұрын
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)
@gregsnyder5325
@gregsnyder5325 27 күн бұрын
@kenji, great video.....
@MuhammadIsmail-xy4tb
@MuhammadIsmail-xy4tb Жыл бұрын
Dear, kindly also make a video on Management accounts in Excel. Thanks
@seanchen2783
@seanchen2783 7 ай бұрын
Very helpful!!
@HammedAkogun-m6l
@HammedAkogun-m6l Жыл бұрын
Great Job...Please how can i ignore an outlier when calculating an average value in a model
@erumshafi6562
@erumshafi6562 Жыл бұрын
thanks, it is really helpful
@wilmarobles4717
@wilmarobles4717 Жыл бұрын
Hi Kenji. Please teach also how to alphabetize tabs in workbook.
@samnangchim5758
@samnangchim5758 Жыл бұрын
Thanks teacher
@fernandoarroyo9357
@fernandoarroyo9357 Жыл бұрын
Does sb know hot to show the Live case as well?
@sivaprakasam6550
@sivaprakasam6550 8 ай бұрын
Very nice explanation 😊 and file can't download
@AnthonyIsmael-b5g
@AnthonyIsmael-b5g Жыл бұрын
Fantastic!
@ahnafjawadkhan2269
@ahnafjawadkhan2269 Жыл бұрын
Your videos are helping me a lot. Can you please make a relative valuation model please, sir?
@KenjiExplains
@KenjiExplains Жыл бұрын
I have it here: kzbin.info/www/bejne/eYHXc32EaLh0rNU
@gamernihad
@gamernihad Ай бұрын
You can add data validation in cell J4 and toggle between 1 and 2
@theelephantchasingrm8427
@theelephantchasingrm8427 9 ай бұрын
@kenjiexplains Can you please also show this model for a mortgage and auto lender (from Bank’s perspective)…!!
@ethiopiagirma3923
@ethiopiagirma3923 6 ай бұрын
Thank you.
@masumbillah1077
@masumbillah1077 7 ай бұрын
just thanks teacher
@hassan3792
@hassan3792 10 ай бұрын
very very nice thank you
@teofilanguema1645
@teofilanguema1645 7 ай бұрын
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
@brianfretes3033
@brianfretes3033 9 ай бұрын
does anyone have the excel file to work alongside Kenji? I am not able to access it from the description.
@KenjiExplains
@KenjiExplains 9 ай бұрын
Hey once you click the link it should reach your downloads folder
@brianfretes3033
@brianfretes3033 9 ай бұрын
Still isn't showing up. What should I do?@@KenjiExplains
@aqsashahzad4810
@aqsashahzad4810 Жыл бұрын
Hi. What is a dynamic financial model?
@jaspritsingh8228
@jaspritsingh8228 3 ай бұрын
can somebody help me with the excel file , i am unable to download!
@aspectoflife
@aspectoflife 9 ай бұрын
the best, compact and comprehensive.
@marcblaze1820
@marcblaze1820 Жыл бұрын
thanks g
@willzinner8813
@willzinner8813 Жыл бұрын
can you make a saas one as well please sir?
@KenjiExplains
@KenjiExplains Жыл бұрын
Noted!
@baonguyen4278
@baonguyen4278 10 ай бұрын
I cannot download the excel file :((
@nikhilagrawal6834
@nikhilagrawal6834 Жыл бұрын
How actually we got the growth rate/order growth rate for making models ??
@jemimahkuteesa8911
@jemimahkuteesa8911 2 ай бұрын
My forecasted years changing dynamically after using the choose function. Could someone kindly help out
@RandomPerson-y9c
@RandomPerson-y9c 7 ай бұрын
I dig it… lol am I a nerd!?!?
@philmbu6741
@philmbu6741 4 ай бұрын
Never apologise for this. Nerds rule the world.
@thobuladeepshika6859
@thobuladeepshika6859 3 ай бұрын
5:21
@arsalanahmed5706
@arsalanahmed5706 6 ай бұрын
shouldnt you get like a negative value in operating profit since 119850-100000-26250=-6400
@niccolosichirollo5258
@niccolosichirollo5258 5 ай бұрын
it is negative. parentheses indicate negative in accounting.
@knight9040
@knight9040 Жыл бұрын
On what basis you've made Assumptions?
@VijayaNarasimha522
@VijayaNarasimha522 8 ай бұрын
Based pn track record or the company Or track record of the Industry, which company is operating
@gaurabdeb1511
@gaurabdeb1511 Жыл бұрын
13:00
@lovelyGhada
@lovelyGhada 6 ай бұрын
🙌
@nishanth4323
@nishanth4323 Жыл бұрын
Ola🙂 🙏
@KenjiExplains
@KenjiExplains Жыл бұрын
Hello!
@nishanth4323
@nishanth4323 Жыл бұрын
​@@KenjiExplains 🙏❤️
@AliAlsailani-t5l
@AliAlsailani-t5l 4 ай бұрын
where do you get your assumptions?
@utpalmahmud9829
@utpalmahmud9829 Ай бұрын
How you locked D30?
@solomonbhandari-young4154
@solomonbhandari-young4154 Жыл бұрын
WOW
Build a Dynamic 3 Statement Financial Model From Scratch
32:26
Kenji Explains
Рет қаралды 1,1 МЛН
Don't underestimate anyone
00:47
奇軒Tricking
Рет қаралды 34 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
Симбочка Пимпочка
Рет қаралды 3,9 МЛН
Build a Monthly Budgeting & Forecasting Model in Excel
20:07
Kenji Explains
Рет қаралды 25 М.
Try This Function Instead of IF Statements
12:51
Kenji Explains
Рет қаралды 28 М.
Why Net Worth EXPLODES After $100K: Learn The Secret!
11:08
ClearValue Tax
Рет қаралды 1,3 МЛН
15 Ways to Increase Your Financial IQ
30:31
Alux.com
Рет қаралды 715 М.
Discounted Cash Flow | DCF Model Step by Step Guide
21:42
Kenji Explains
Рет қаралды 1 МЛН
What is Financial Modeling? Explanation & Setup of a Financial Model
22:58
Can You Pass This Excel Interview Test?
11:20
Kenji Explains
Рет қаралды 983 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 334 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,6 МЛН
ACCOUNTING BASICS: a Guide to (Almost) Everything
14:13
Accounting Stuff
Рет қаралды 3,1 МЛН
Don't underestimate anyone
00:47
奇軒Tricking
Рет қаралды 34 МЛН