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!
Hey Kenji, thanks very much for sharing. Do you have a detailed 3-year financial model for tech companies to help small businesses automate their customer support processes? I'm new to finance modelling course. Thanks very much.
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 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 :)
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?
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 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
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
Thanks so much Kenji for your videos ! really helps in my work ! I plan to bing watch all your videos !
One of my favorite financial models! Good work Kenji!
thanks bro!
I needed this video! Nicee Kenjii!!
Glad I could help!
Hey Kenji, thanks very much for sharing. Do you have a detailed 3-year financial model for tech companies to help small businesses automate their customer support processes? I'm new to finance modelling course. Thanks very much.
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 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 :)
Is any prerequisite to watching this session or helpful for any background?
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
Great video! Is there a reason why you don't take the weighted average for conversion at 2:20 ?
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 :)
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?
when you say manufacturing cost per order, how can you calculate this if you have numerous items that cost different prices to manufacturer? thanks!
Good idea, thanks mr kenji.
Nice tutorial
🔥🔥🔥🔥 as always 🙌❤️
Just gonna go through it 😅😂
Thank you! Appreciate your support :)
Can you make a video for unit economics metrics for startups ?
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...
Amazing thanks. Can you make one on a subscription model too?
Thanks for the suggestion! Will note it for the future
Thank You so much! helped a lot!!!
Thank you for the video. This model doesn't account for previous tax losses carried over to offset profits.
Can you show us how to make a learning and development dashboard?
Sir where do you get assumptions value for a company
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.
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!
Wow really helpful!!
Glad it was helpful!
Hey kenji i really love your videos can you please make a video on conditional fomating
Hi Kenji, Can you please do a video on Costing.. Especially related to FMCG business.
would be great if you cover budget and forecast
Will keep it in mind for the next one. Thanks for the support!
When i grow up i wanna be like kenji
Hahaha thanks for watching the videos! Best of luck in your career Rodgers
Love these videos
Thanks Solomon!
Thank youuuuu!!!!!
Hi
I am Alisher
How can I get a course
great video!
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. 🫡
Teşekkürler
Make financial model on Private Educational institution more than 40 branches, waiting for your response
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 :)
Sir , i did not find downlink this xls file ...
Link should be in your downloads in your browser/computer
Do you have personal coaching?
Hi there, I currently don't offer personal coaching unfortunately
Make Financial model on Private Educational institute. More than 40 branches
Morgan Freeman is a wise man.
Ai can do it easily