Build a Startup Financial Model | The ULTIMATE Guide With Free Template
Вставка
- Опубліковано 26 чер 2024
- Build a financial model for an e-commerce startup. Free template included
👉 Get 25% OFF all Financial Edge Courses using code KENJI25: bit.ly/3RuHCO9
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/631af3...
In this video you learn to create a financial model for a startup.
This is for an ecommerce startup.
First, we'll create assumptions for how we plan to drive traffic and revenue to the company.
Then, we'll create assumptions for our costs, split into fixed and variable. Thirdly, we'll create a full income statement for 12months to determine whether our startup will be profitable.
Lastly, we'll create some chart visuals to showcase the overall traffic, revenue, and cost trends.
LEARN:
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Revenue Assumptions
4:14 - Cost Assumptions
6:45 - Building an Income Statement
13:50 - Data Visuals
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
👉 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!
One of my favorite financial models! Good work Kenji!
thanks bro!
Very helpful for all startups. Includes all possible expenses
Thank You so much! helped a lot!!!
Good idea, thanks mr kenji.
Nice tutorial
You saved my capstone bless you I will keep watching you!
I needed this video! Nicee Kenjii!!
Glad I could help!
Thank youuuuu!!!!!
great video!
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!
Love these videos
Thanks Solomon!
Hey kenji i really love your videos can you please make a video on conditional fomating
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!
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 :)
Great video! Is there a reason why you don't take the weighted average for conversion at 2:20 ?
🔥🔥🔥🔥 as always 🙌❤️
Just gonna go through it 😅😂
Thank you! Appreciate your support :)
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...
Hi Kenji, Can you please do a video on Costing.. Especially related to FMCG business.
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
Is any prerequisite to watching this session or helpful for any background?
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
Can you show us how to make a learning and development dashboard?
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 :)
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
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?
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. 🫡
Make financial model on Private Educational institution more than 40 branches, waiting for your response
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 institute. More than 40 branches
Do you have personal coaching?
Hi there, I currently don't offer personal coaching unfortunately
Ai can do it easily
Morgan Freeman is a wise man.