Start to Finish | Coffee Shop Financial Model From Scratch (Excel)

Поділитися
Вставка
  • Опубліковано 7 лис 2024

КОМЕНТАРІ • 40

  • @josejac94
    @josejac94 2 роки тому +3

    Appreciate your time and thanks for sharing your knowledge.

    • @kileyg
      @kileyg  2 роки тому

      Thanks! Hope you received some value.

  • @wildpoka
    @wildpoka Рік тому +2

    Cool T shirt and insightful video. Oss

  • @Majaijaaa
    @Majaijaaa Рік тому +1

    Thank you, been following along for 2 days, now I just need to make it in my currency 😅 it was great help!

    • @kileyg
      @kileyg  Рік тому

      Glad to help! Best of luck!

  • @chopandprop1811
    @chopandprop1811 2 роки тому +6

    Hey Kiley. Thanks for a really helpful resource! i'd love a link to the spreadsheet if it's available? Cheers!

    • @kileyg
      @kileyg  2 роки тому +2

      Thanks! Sorry, I don't have the spreadsheet available to link. Good idea for future videos though.

    • @candiceheyns5535
      @candiceheyns5535 Рік тому

      agreed :)
      @@kileyg

  • @lintanghutama
    @lintanghutama Рік тому

    thanks Kiley. 🎉

  • @moietmoi5933
    @moietmoi5933 2 роки тому +2

    good job! where did you get the starting cost 15 000 number from? Thanks!

    • @kileyg
      @kileyg  2 роки тому +2

      Thank you! That is just an assumption. The sheet is made so that you can change that number to whatever winds up being accurate and see the effect.

    • @moietmoi5933
      @moietmoi5933 2 роки тому +1

      @@kileyg haha thank you so much. Do you know where I can get this realistic numbers not assumption. I really need to have an accarate idea about the budget to open a coffee shop :D

  • @gencgashi631
    @gencgashi631 Рік тому +1

    Great video just one question why does the manager make less then the barista?

  • @rickerber7741
    @rickerber7741 Рік тому

    Wow. You certainly have some talent. Would you be willing to share the spreadsheet. Thanks

  • @fooguoyuan8682
    @fooguoyuan8682 2 роки тому +2

    Hey! I've been watching your content for a good while now! Any thoughts on a vending machine business? Keep up the good work btw, really enjoy your content

    • @kileyg
      @kileyg  2 роки тому +1

      Thanks! I’ve actually owned a vending machine business in the past. I can do a video on it. Great suggestion!

  • @carolineinnewyork
    @carolineinnewyork Рік тому +1

    Thank you!

    • @kileyg
      @kileyg  Рік тому

      You’re welcome!

  • @SophieGausden
    @SophieGausden Рік тому

    Hey, brilliant video. Any chance of being able to use the spreadsheet? Thanks, Sophie :)

    • @kileyg
      @kileyg  Рік тому

      Thanks for the support!

    • @SophieGausden
      @SophieGausden Рік тому

      @@kileyg Is it possible to use the spreadsheet? :)

    • @thrawn8840
      @thrawn8840 Рік тому

      @@SophieGausden previous comment state he didnt have the spreadsheet available to link

  • @priankagilmour959
    @priankagilmour959 Рік тому +1

    Does the average daily receipts mean the average daily customers? Are those two synonymous?

    • @kileyg
      @kileyg  Рік тому +1

      Yes, in this case they are synonymous. Daily receipts times the average receipt equals daily revenue.

    • @priankagilmour959
      @priankagilmour959 Рік тому

      @@kileyg Thank you :)

  • @yahya9814
    @yahya9814 Рік тому

    Thank you for making this video
    Just have a concern.
    Isn't the Monthly Hours Supposed to be 30*14= 420
    The number is way high for both Monthly Hours and Yearly Hours

    • @omidmohamadian8335
      @omidmohamadian8335 Рік тому

      mistake is
      weakly hours *30 ??

    • @yahya9814
      @yahya9814 Рік тому

      ⁠@@omidmohamadian8335Yes instead of multiplying daily hours to 30 he multiplied weekly hours by 30

  • @glentacinelli5954
    @glentacinelli5954 7 місяців тому

    How do I get a link to this.. ive spent like 3 hours trying to recreate this.

  • @candiceheyns5535
    @candiceheyns5535 Рік тому

    This is absolutely brilliant. Thank you so much. I'm actually setting up a coffee shop for morning traffic around our hood, using hawkers to sell it :) This is so helpful :) Thank you have any ideas on a spreadsheet for a 2-3day sports conference? or am I pushing my luck :) this wouldn't be seen as an expo, so there won't be sales on merchandise.

  • @matthewalbritton258
    @matthewalbritton258 Рік тому

    Would you be willing to explain what you mean by scale up (% of breakeven receipts)?

  • @renaldoriggon1290
    @renaldoriggon1290 10 місяців тому

    Hi, would you be able to send me a link for this excel sheet ?

  • @Pchinburi
    @Pchinburi 11 місяців тому

    Just wanted to say that you got your monthly hours wrong. Assuming there are 4 weeks in a month 98*4 = 392 hours but you multiplied it by 30 ... hence the 2940

  • @gregghenry7536
    @gregghenry7536 3 місяці тому

    Link please?

  • @chase11chase
    @chase11chase Рік тому

    Link to spreadsheet please?

  • @chuuck
    @chuuck Рік тому +1

    I'm only 19 minutes in but please help me god if he doesnt realize tht he calculated monthly hours as (weekly hours * 30) I'm going to lose it. This assumes 30 weeks in a month. How to you not think something is off with the theoretial rev

    • @chuuck
      @chuuck Рік тому

      just adding too my complaints here (I really do appreciate this video)
      - Why did you hardcode 7 days a week in mktg expense when you have an assumption field for that value?
      - you keep hardcoding "60" without any explanation of where that comes from with regards to salary

  • @davidstevens6991
    @davidstevens6991 11 місяців тому

    If anyone has re-created this spreadsheet, I would be interested in it.

  • @lorenzofeijoo4284
    @lorenzofeijoo4284 9 місяців тому

    Spreadsheet link!? Thanks