Coffee Shop Financial Model Template

Start with the Assumptions sheet. Enter your estimated daily customer count — if you have an existing shop, pull it from your POS report for last month. If you're projecting a new location, research foot traffic at the address and use conservative estimates based on comparable cafés in your market. Then enter your average ticket size (for most coffee shops this is $6–$10), your target beverage cost percentage, and your fixed overhead amounts. The entire model recalculates from these inputs, so take your time getting the daily count and average ticket right — they are the two assumptions that drive everything else.

Coffee shops look financially simple from the outside — sell drinks, collect cash, repeat. The reality is that the business model is operationally demanding: high transaction volume at low ticket sizes, labor that has to be staffed for morning rush even when afternoons are slow, and equipment costs (a quality espresso machine, grinder, and brewing setup can run $30,000–$60,000 for a new build) that require financing or a substantial capital reserve. Most coffee shop closures happen not because demand dried up but because the owner ran out of cash before the business reached the daily customer volume needed to sustain overhead. A financial model is the tool that shows you what that target volume looks like before you sign a lease.

Key Performance Indicators