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.

[@KenjiExplains]

👉 Get 25% OFF all Financial Edge courses using code KENJI25: bit.ly/3RuHCO9

[@solomonbhandari-young4154]

Awesome

[@ChasingMyLiberty]

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]

@@KenjiExplainsLove you bro what a legend, your videos are super duper awesome

[@brocklee3768]

I cannot explain how INCREDIBLY useful these videos have been! Thank you so much!

[@hannahmsiqf2048]

You saved my capstone bless you I will keep watching you!

[@michaelquach7046]

One of my favorite financial models! Good work Kenji!

[@KenjiExplains]

thanks bro!

[@vrushalikamble7191]

Very helpful for all startups. Includes all possible expenses

[@ramsharma5036]

Thank You so much! helped a lot!!!

[@AdeKaryadi]

Good idea, thanks mr kenji. Nice tutorial

[@malisway9907]

Thank youuuuu!!!!!

[@AyCarumba1000]

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 :)

[@andymarci6766]

I needed this video! Nicee Kenjii!!

[@KenjiExplains]

Glad I could help!

[@abhiralpandey]

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 :)

[@CaptainUnitas]

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!

[@hisokaamorou4211]

great video!

[@TheWisdomPotChannel]

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

[@shubhamsingla1787]

Hey kenji i really love your videos can you please make a video on conditional fomating

[@AbbasAdejonwo]

Great video! Is there a reason why you don't take the weighted average for conversion at 2:20 ?

[@camlex6310]

Wow really helpful!!

[@KenjiExplains]

Glad it was helpful!

[@KrishnaShah-hp7su]

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...

[@solomonbhandari-young4154]

Love these videos

[@KenjiExplains]

Thanks Solomon!

[@sreekanth006]

Hi Kenji, Can you please do a video on Costing.. Especially related to FMCG business.

[@anasyusuf1607]

🔥🔥🔥🔥 as always 🙌❤️

[@anasyusuf1607]

Just gonna go through it 😅😂

[@KenjiExplains]

Thank you! Appreciate your support :)

[@m.mubashir2140]

Is any prerequisite to watching this session or helpful for any background?

[@willzinner8813]

Amazing thanks. Can you make one on a subscription model too?

[@KenjiExplains]

Thanks for the suggestion! Will note it for the future

[@Gang1955]

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!

[@scotolivera8207]

would be great if you cover budget and forecast

[@KenjiExplains]

Will keep it in mind for the next one. Thanks for the support!

[@denzelvisser1307]

Can you show us how to make a learning and development dashboard?

[@rodgersnyaga4627]

When i grow up i wanna be like kenji

[@KenjiExplains]

Hahaha thanks for watching the videos! Best of luck in your career Rodgers

[@andreachiavazza1420]

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 :)

[@RebeccaLawson-nt9lr]

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?

[@otuefiom5730]

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. 🫡

[@muhammadrehan3612]

Make financial model on Private Educational institution more than 40 branches, waiting for your response

[@saliksubedi5961]

Sir , i did not find downlink this xls file ...

[@KenjiExplains]

Link should be in your downloads in your browser/computer

[@muhammadrehan3612]

Make Financial model on Private Educational institute. More than 40 branches

[@czache]

Do you have personal coaching?

[@KenjiExplains]

Hi there, I currently don't offer personal coaching unfortunately

[@ZahraMov-zh2om]

Ai can do it easily

[@marius9897]

Morgan Freeman is a wise man.