Build a Startup Financial Model | The ULTIMATE Guide With Free Template
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.
Пікірлер: 60
👉 Get 25% OFF all Financial Edge courses using code KENJI25: bit.ly/3RuHCO9
@solomonbhandari-young4154
Жыл бұрын
Awesome
Thanks so much Kenji for your videos ! really helps in my work ! I plan to bing watch all your videos !
I don’t binge watch Netflix. I binge watch Kenji Explains. May the Force be with you, Jedi Master Kenji.
@KenjiExplains
Жыл бұрын
Hahaha love to hear it! Thanks for your support :)
@JASHVEER22
Жыл бұрын
@@KenjiExplains thanks kenji I'm improving my excel skills.
@mikes3637
9 ай бұрын
@@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!
Very helpful for all startups. Includes all possible expenses
Thank You so much! helped a lot!!!
Good idea, thanks mr kenji. Nice tutorial
One of my favorite financial models! Good work Kenji!
@KenjiExplains
Жыл бұрын
thanks bro!
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 needed this video! Nicee Kenjii!!
@KenjiExplains
Жыл бұрын
Glad I could help!
Thank youuuuu!!!!!
great video!
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!
Hey kenji i really love your videos can you please make a video on conditional fomating
Thank you for the video. This model doesn't account for previous tax losses carried over to offset profits.
Thanks Kenji!! That was quite helpful!! Can we please also have a session on cash flow model and esg rating?
@KenjiExplains
Жыл бұрын
Thanks Abhiral! Will keep it in mind :)
Wow really helpful!!
@KenjiExplains
Жыл бұрын
Glad it was helpful!
Great video! Is there a reason why you don't take the weighted average for conversion at 2:20 ?
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...
Love these videos
@KenjiExplains
Жыл бұрын
Thanks Solomon!
🔥🔥🔥🔥 as always 🙌❤️
@anasyusuf1607
Жыл бұрын
Just gonna go through it 😅😂
@KenjiExplains
Жыл бұрын
Thank you! Appreciate your support :)
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?
Amazing thanks. Can you make one on a subscription model too?
@KenjiExplains
Жыл бұрын
Thanks for the suggestion! Will note it for the future
Can you show us how to make a learning and development dashboard?
Saw you at Let’s Eat. Sorrry I was so awk!
@KenjiExplains
Жыл бұрын
Not sure I've been to a let's eat tbh haha. Maybe it was me though come say hi next time!
When i grow up i wanna be like kenji
@KenjiExplains
Жыл бұрын
Hahaha thanks for watching the videos! Best of luck in your career Rodgers
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?
@KenjiExplains
Жыл бұрын
Thanks Andrea, I'll keep that one in mind :)
would be great if you cover budget and forecast
@KenjiExplains
Жыл бұрын
Will keep it in mind for the next one. Thanks for the support!
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,
@KenjiExplains
Жыл бұрын
In the description
@otuefiom5730
Жыл бұрын
@@KenjiExplains Thanks mate. 🫡
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?
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
Sir , i did not find downlink this xls file ...
@KenjiExplains
Жыл бұрын
Link should be in your downloads in your browser/computer
Do you have personal coaching?
@KenjiExplains
Жыл бұрын
Hi there, I currently don't offer personal coaching unfortunately
Ai can do it easily
Morgan Freeman is a wise man.