Financial Model "Coffee Shop"

You can view the model file in PDF format through the link.

Financial model template in Google Sheets and Excel for a coffee shop. Allows you to calculate the cost of opening a coffee shop and the profit it will generate. Includes calculations for two revenue streams: takeout sales and sit-in service. Suitable for calculating the business plan for a coffee shop from scratch.

  • Automatic calculation of required investments and break-even point.
  • Input of all data in separate tabs.
  • Automatic calculation of P&L, Cash Flow, Balance Sheet.
  • Ability to set the dynamics of indicators.
  • Dashboard with visualization of key metrics.
  • Ability to compare the commercial potential of different scenarios and choose the best one.


The financial model is a key component of a business plan that allows evaluating the real commercial potential of a new business. A well-crafted financial model for a coffee shop will enable you to calculate the revenues and profits of the coffee shop with specific target audience, capacity, assortment, and operating hours.

With our financial model template, you can answer the following questions:

  • How much does it cost to open a coffee shop?
  • What profit will the coffee shop generate?
  • When will the coffee shop break even when starting from scratch?
  • What will be the expense structure of the coffee shop?
  • What is more profitable: 'takeaway' or 'sit-in service'?
  • How does the occupancy of the coffee shop impact profits?


A ready-to-use and easily customizable financial model template designed specifically for a coffee shop, available in Google Sheets and Excel formats. You fill in the tabs with input data specific to your case (number of seats, rent cost, renovation expenses, assortment and prices, salary levels, operating hours, etc.). The table includes comments for filling in all cells. Based on the entered data, calculations are made for income, expenses, and key indicators of the coffee shop on a monthly basis, with forecasts of profit and loss reports, cash flow, and balance sheet. Separate sheets display data on the amount of necessary investments, the break-even point timeframe, and charts with the dynamics and structure of income and expenses.

You can view the model file in PDF format through the link.


  • Two revenue streams: 'Takeaway Coffee' and 'Sit-in Service'.
  • Calculation of the maximum capacity of the coffee shop.
  • Profit calculation based on the occupancy of the coffee shop.
  • Ability to set different operating hours and occupancy rates for weekdays and weekends.
  • Multiple product categories in the coffee shop with the option to set different costs and purchase frequencies.
  • Consideration of packaging costs for takeout sales.
  • Automatic calculation of depreciation of fixed assets.
  • Automatic calculation of salary increases.
  • Determination of the break-even point and the amount of investment required to open the coffee shop.
  • Visualization of key indicators through graphs.