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

  • @KenjiExplains
    @KenjiExplains Жыл бұрын

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

  • @solomonbhandari-young4154

    @solomonbhandari-young4154

    Жыл бұрын

    Awesome

  • @mengsangchen9635
    @mengsangchen96353 күн бұрын

    Thanks so much Kenji for your videos ! really helps in my work ! I plan to bing watch all your videos !

  • @ChasingMyLiberty
    @ChasingMyLiberty Жыл бұрын

    I don’t binge watch Netflix. I binge watch Kenji Explains. May the Force be with you, Jedi Master Kenji.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Hahaha love to hear it! Thanks for your support :)

  • @JASHVEER22

    @JASHVEER22

    Жыл бұрын

    @@KenjiExplains thanks kenji I'm improving my excel skills.

  • @mikes3637

    @mikes3637

    9 ай бұрын

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

  • @brocklee3768
    @brocklee37685 ай бұрын

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

  • @hannahmsiqf2048
    @hannahmsiqf20483 ай бұрын

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

  • @vrushalikamble7191
    @vrushalikamble7191 Жыл бұрын

    Very helpful for all startups. Includes all possible expenses

  • @ramsharma5036
    @ramsharma5036 Жыл бұрын

    Thank You so much! helped a lot!!!

  • @AdeKaryadi
    @AdeKaryadi Жыл бұрын

    Good idea, thanks mr kenji. Nice tutorial

  • @michaelquach7046
    @michaelquach7046 Жыл бұрын

    One of my favorite financial models! Good work Kenji!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    thanks bro!

  • @AyCarumba1000
    @AyCarumba10002 ай бұрын

    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
    @andymarci6766 Жыл бұрын

    I needed this video! Nicee Kenjii!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad I could help!

  • @malisway9907
    @malisway9907Ай бұрын

    Thank youuuuu!!!!!

  • @hisokaamorou4211
    @hisokaamorou4211 Жыл бұрын

    great video!

  • @CaptainUnitas
    @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!

  • @shubhamsingla1787
    @shubhamsingla1787 Жыл бұрын

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

  • @Bhavik_Khatri
    @Bhavik_Khatri5 күн бұрын

    Thank you for the video. This model doesn't account for previous tax losses carried over to offset profits.

  • @abhiralpandey
    @abhiralpandey Жыл бұрын

    Thanks Kenji!! That was quite helpful!! Can we please also have a session on cash flow model and esg rating?

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks Abhiral! Will keep it in mind :)

  • @camlex6310
    @camlex6310 Жыл бұрын

    Wow really helpful!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad it was helpful!

  • @AbbasAdejonwo
    @AbbasAdejonwo Жыл бұрын

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

  • @KrishnaShah-hp7su
    @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
    @solomonbhandari-young4154 Жыл бұрын

    Love these videos

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks Solomon!

  • @anasyusuf1607
    @anasyusuf1607 Жыл бұрын

    🔥🔥🔥🔥 as always 🙌❤️

  • @anasyusuf1607

    @anasyusuf1607

    Жыл бұрын

    Just gonna go through it 😅😂

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you! Appreciate your support :)

  • @sreekanth006
    @sreekanth006 Жыл бұрын

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

  • @TheWisdomPotChannel
    @TheWisdomPotChannel2 ай бұрын

    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

  • @m.mubashir2140
    @m.mubashir2140 Жыл бұрын

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

  • @willzinner8813
    @willzinner8813 Жыл бұрын

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for the suggestion! Will note it for the future

  • @denzelvisser1307
    @denzelvisser13078 ай бұрын

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

  • @Gang1955
    @Gang1955 Жыл бұрын

    Saw you at Let’s Eat. Sorrry I was so awk!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Not sure I've been to a let's eat tbh haha. Maybe it was me though come say hi next time!

  • @rodgersnyaga4627
    @rodgersnyaga4627 Жыл бұрын

    When i grow up i wanna be like kenji

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

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

  • @andreachiavazza1420
    @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

    @KenjiExplains

    Жыл бұрын

    Thanks Andrea, I'll keep that one in mind :)

  • @scotolivera8207
    @scotolivera8207 Жыл бұрын

    would be great if you cover budget and forecast

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

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

  • @soundaryasuresh1845
    @soundaryasuresh184518 сағат бұрын

    Sir where do you get assumptions value for a company

  • @otuefiom5730
    @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

    @KenjiExplains

    Жыл бұрын

    In the description

  • @otuefiom5730

    @otuefiom5730

    Жыл бұрын

    @@KenjiExplains Thanks mate. 🫡

  • @RebeccaLawson-nt9lr
    @RebeccaLawson-nt9lr2 ай бұрын

    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?

  • @muhammadrehan3612
    @muhammadrehan3612 Жыл бұрын

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

  • @muhammadrehan3612
    @muhammadrehan3612 Жыл бұрын

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

  • @saliksubedi5961
    @saliksubedi5961 Жыл бұрын

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Link should be in your downloads in your browser/computer

  • @czache
    @czache Жыл бұрын

    Do you have personal coaching?

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

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

  • @ZahraMov-zh2om
    @ZahraMov-zh2om Жыл бұрын

    Ai can do it easily

  • @marius9897
    @marius98973 ай бұрын

    Morgan Freeman is a wise man.