Thank you, Kenji, for making this awesome video. Just one minor issue, I think you cannot calculate the "Average Conversion" simply by averaging the Organic and Paid Conversion Rates in that Organic and Paid Page Traffic are not the same. That is to say, the weights of their respective Page Traffic should be taken into consideration. (For Month 1, it would be (1500*2%+1000*1%)/2500 ) Thanks!
Thank you Kenji, your videos prepare best for interviews, i love the way you explain and show shortcuts, and keep it simple to follow. Could please to more relating to Tech Investment banks? :) like deferred revenues scenarios etc and working capital :)
Love the models you make Kenji! One question, would you really build your variable costs this way? When building variable costs in models I think its best practice to tie the variable costs directly to the sales forecast, the way this model is built is very approachable but not very dynamic, ie you would have to manually change the inflection points of your variable costs after adjusting your sales forecast. To do this I generally use a range table and a lookup function, I am sure that when you are building professional models you also have a fully dynamic approach, I would love to see you provide a window into how you build models at that level of complexity as my experience is that most professional modelers are always looking for a fresh perspective on how to complete a task. Love your work!
Pls make a video on how to analyse, study and research the BS, IS and CF on Excel of a Financial or A Banking company.. Pls would love to watch this as it's a part of many finance topics...
I have a stupid question. If I’m asking an investor, for example $250,000 for 10%, should my financial model include this investment from the investor or do they want to see the financial model without the investment to see what the company will do on its own without the investment?
I have a question. If we took gross margins for contribution margin instead of revenue is fine but to calculate contribution margin percentage is it okay to tak revenue? Somebody please explain me.
👉 Get 25% OFF all Financial Edge courses using code KENJI25: bit.ly/3RuHCO9
Awesome
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.
I would love an introduction to an adviser who can help me strengthen my financial roots.
My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further.
Thank you for this amazing tip. I just looked the name up and wrote her.
I don’t binge watch Netflix. I binge watch Kenji Explains. May the Force be with you, Jedi Master Kenji.
Hahaha love to hear it! Thanks for your support :)
@@KenjiExplains thanks kenji I'm improving my excel skills.
@@KenjiExplainsLove you bro what a legend, your videos are super duper awesome
I cannot explain how INCREDIBLY useful these videos have been! Thank you so much!
You saved my capstone bless you I will keep watching you!
i don't know how much i can thank you for this video!!! YOU ARE AMAZING!! THANK YOU FOR MAKING THIS EASY FOR ME!! whewwww😅
Thank you, Kenji, for making this awesome video.
Just one minor issue, I think you cannot calculate the "Average Conversion" simply by averaging the Organic and Paid Conversion Rates in that Organic and Paid Page Traffic are not the same. That is to say, the weights of their respective Page Traffic should be taken into consideration. (For Month 1, it would be (1500*2%+1000*1%)/2500 )
Thanks!
Very helpful for all startups. Includes all possible expenses
One of my favorite financial models! Good work Kenji!
thanks bro!
I needed this video! Nicee Kenjii!!
Glad I could help!
Thanks so much Kenji for your videos ! really helps in my work ! I plan to bing watch all your videos !
Thanks Kenji!! That was quite helpful!!
Can we please also have a session on cash flow model and esg rating?
Thanks Abhiral! Will keep it in mind :)
🔥🔥🔥🔥 as always 🙌❤️
Just gonna go through it 😅😂
Thank you! Appreciate your support :)
Thank you Kenji, your videos prepare best for interviews, i love the way you explain and show shortcuts, and keep it simple to follow.
Could please to more relating to Tech Investment banks? :) like deferred revenues scenarios etc and working capital :)
Wow really helpful!!
Glad it was helpful!
Good idea, thanks mr kenji.
Nice tutorial
Thank You so much! helped a lot!!!
Love these videos
Thanks Solomon!
Love the models you make Kenji! One question, would you really build your variable costs this way? When building variable costs in models I think its best practice to tie the variable costs directly to the sales forecast, the way this model is built is very approachable but not very dynamic, ie you would have to manually change the inflection points of your variable costs after adjusting your sales forecast. To do this I generally use a range table and a lookup function, I am sure that when you are building professional models you also have a fully dynamic approach, I would love to see you provide a window into how you build models at that level of complexity as my experience is that most professional modelers are always looking for a fresh perspective on how to complete a task. Love your work!
Thank youuuuu!!!!!
Pls make a video on how to analyse, study and research the BS, IS and CF on Excel of a Financial or A Banking company..
Pls would love to watch this as it's a part of many finance topics...
great video!
Saw you at Let’s Eat. Sorrry I was so awk!
Not sure I've been to a let's eat tbh haha. Maybe it was me though come say hi next time!
Amazing thanks. Can you make one on a subscription model too?
Thanks for the suggestion! Will note it for the future
Thank you for the video. This model doesn't account for previous tax losses carried over to offset profits.
Can you make a video for unit economics metrics for startups ?
When i grow up i wanna be like kenji
Hahaha thanks for watching the videos! Best of luck in your career Rodgers
would be great if you cover budget and forecast
Will keep it in mind for the next one. Thanks for the support!
Thank you for your nice work and clarity, but How did you come about your growth rate of 1.25 for the revenue assumptions?
Thanks
Hey kenji i really love your videos can you please make a video on conditional fomating
Is any prerequisite to watching this session or helpful for any background?
when you say manufacturing cost per order, how can you calculate this if you have numerous items that cost different prices to manufacturer? thanks!
Can you show us how to make a learning and development dashboard?
Hi Kenji, Can you please do a video on Costing.. Especially related to FMCG business.
Great video! Is there a reason why you don't take the weighted average for conversion at 2:20 ?
I have a stupid question. If I’m asking an investor, for example $250,000 for 10%, should my financial model include this investment from the investor or do they want to see the financial model without the investment to see what the company will do on its own without the investment?
Sir where do you get assumptions value for a company
Hi Kenji you are an amazing person.
You are doing an amazing Job here.
Do you mind sharing the excel file with me?
Thank you,
In the description
@@KenjiExplains Thanks mate. 🫡
Good job Kenji the quality of your video and the contents are incredible!
Can you make in the future a video about the oil and gas valuation model?
Thanks Andrea, I'll keep that one in mind :)
I have a question. If we took gross margins for contribution margin instead of revenue is fine but to calculate contribution margin percentage is it okay to tak revenue? Somebody please explain me.
Hi
I am Alisher
How can I get a course
Teşekkürler
Sir , i did not find downlink this xls file ...
Link should be in your downloads in your browser/computer
Make financial model on Private Educational institution more than 40 branches, waiting for your response
Make Financial model on Private Educational institute. More than 40 branches
Do you have personal coaching?
Hi there, I currently don't offer personal coaching unfortunately
Morgan Freeman is a wise man.
Ai can do it easily