Learn to make a financial model to forecast your P&L and make it dynamic. Take our Finance & Valuation Course: …
source
Learn to make a financial model to forecast your P&L and make it dynamic. Take our Finance & Valuation Course: …
source
Input your search keywords and press Enter.
50 comments
🔥 Take our Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
to copy a formula- select the cells and ctrl+r
f4 to lock a cell's value if its a constant
I have a question: why did you paste live case in it?
Hey Kenji, can you explain why did you use the ctrl+alt+v?
How to download free templates
Very impressive – am taking a Financial Planning and Analysis Module at University and the excel formats are horrible, we now have an assessment to complete and not willing to use what is provided – this looks much more professional, so am going to learn YOUR method – many thanks!
@kenjiExplains sir how did you get the first data (assumptions part)
You did a great job man !! pretty good to understand in on go !!
doing an assignment and actually wanted to jump until i found this video, i was trying to do everything at one where this saved it so much keep these videos man life saver.
The business content is great, many thanks! Side note: very curious about your accent. Is that… Icelandic? Basque?
what if , we want 3 scenarios i.e. Upper Case, Lower case, and base or present scenario , then ??
superb explanation… i have seen numerous videos but didn't find an explanation like this it's very crucial to comprehend the fundamentals
You are just going to skip interest?
The usage of choose function was awesome!!!
Incredible video!!!
I love finance 😭😭😭❤️❤️❤️💯💯🎉🎉
Thank you so much @kenjiExplains, but can you share a video on how one can start without the Excel you shared?
If someone need custom financial model for startup or established business, reply to my comment.
very good
Try listening to it at 2x, thank me later!
Dynamic financial
Incredible helpful
Meow meow meow meoooooooow
Excellent straightforward, simple and quick tutorial Kenji
Thanks for sharing 😊
😊
@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.
Great video.
Investments are the roots of financial security; the deeper they grow, the stronger your future will be."
Great 😃
Thank you so much
I learned more about excel functions than about financial modeling from this video. hahaha
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?
best video I've seen
@kenji, great video…..
How you locked D30?
My forecasted years changing dynamically after using the choose function. Could someone kindly help out
Kenji this is brilliant I must confess.
5:21
financial modelling is such a difficult subject for me, you made it seem so easy! thank you 🙂
can somebody help me with the excel file , i am unable to download!
Thank you this is an awesome video! Only learning about financial modelling for the first time today 🙂
where do you get your assumptions?
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)
🙌
shouldnt you get like a negative value in operating profit since 119850-100000-26250=-6400
Thank you.
Very helpful!!
I dig it… lol am I a nerd!?!?
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
just thanks teacher