Coffee Shop Pro Forma Template

Start on the Assumptions sheet and work through it top to bottom. The most important inputs are average daily transactions and average ticket size — if you have an existing location, pull these from your POS system. If you're projecting a new location, use 100–150 transactions per day as a conservative starting point for a neighborhood cafe, and $7–8 as your average ticket. Set your beverage-to-food revenue split (most cafes run 70–80% beverage) and your monthly transaction growth rate. Everything else in the model flows from these numbers, so getting them right upfront saves you time later.

Once the Assumptions sheet is set, review the Revenue Projections and COGS & Labor sheets to confirm the outputs look realistic. Check that your projected beverage cost percentage lands in the 25–35% range and that your labor percentage is in the 35–40% range — if either is significantly off, adjust the corresponding assumption rather than editing individual cells. If you're projecting a new location, fill in the startup costs section of the Cash Flow sheet: buildout, equipment, initial inventory (roughly 2–3 weeks of COGS), security deposits, and a working capital reserve of at least 3 months of operating expenses.

The Projected P&L and Dashboard sheets will show you whether the business pencils out. Pay attention to two ratios in particular: occupancy cost as a percentage of revenue (rent plus utilities should ideally stay under 15% of revenue — if it's higher, you need higher transaction volume or a rent renegotiation) and your net margin projection (sustainable coffee shops typically run 8–15% net margins at steady state). If you're presenting to a lender or investor, the Dashboard sheet pulls everything together in a format they'll recognize immediately.

Coffee shops are one of the most financially complex small businesses to open — they look simple from the outside but operate on thin margins with high fixed costs. Rent alone can sink a location if transaction volume doesn't ramp fast enough. A pro forma forces you to work through the math before you sign a lease: at 150 transactions per day with a $7.50 average ticket, you're generating $1,125 in daily revenue. With a six-day week, that's roughly $288,000 per year. Once you subtract COGS (30%), labor (38%), and rent ($3,500/month), you may realize you need 200 daily transactions to be profitable — which completely changes your site selection criteria.

The beverage-first economics of coffee are what make the category interesting. A well-run cafe runs 60–70% gross margins on drinks — one of the highest gross margins in food service — because a $5.50 latte costs less than $2 to produce. The margin compression happens at the net level: labor is high because coffee service is labor-intensive during rush periods, and equipment costs are significant. The pro forma helps you stress-test these dynamics: what happens to net margin if milk prices rise 15%? What if you add a second barista during the morning rush? What does the business look like in year two when training costs drop and the team is more efficient?

For new locations, the pro forma is also your fundraising document. SBA lenders, equipment finance companies, and local investors all want to see the same three things: how revenue is projected (and what it's based on), that fixed costs are covered at conservative volume assumptions, and that there's enough cash to survive the ramp-up period before the location reaches break-even. Most new coffee shops take 6–12 months to hit sustainable volume. This template includes startup costs and a month-by-month cash flow projection specifically to show that the business stays solvent through that ramp — which is the piece most handbuilt projections miss.