SmartHelping / 5-Year Financial Model / Excel
Coffee Shop & Café
Plan a coffee shop, café or restaurant from menu-level sales and costs. Forecast cash flow, funding needs and investment returns over five years, then test how pricing and sales volumes affect the results.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow the menu plan through the financial forecast.
Watch the walkthrough to review the menu inputs, operating assumptions and financial outputs. Open the screenshots below for a closer look at the workbook.
Financial statements and funding needs
Connect menu economics to the cash required to operate.
The five-year model brings the menu assumptions into a three-statement forecast and calculates the equity needed under your plan.
Monthly and annual statements
Review the income statement, balance sheet and statement of cash flows in monthly and annual views.
Detailed pro forma cash flow
Use the monthly and annual pro forma detail to review cash flow per period alongside the financial statements.
Minimum equity requirement
The model solves for the minimum equity investment required to keep the cash balance above zero, based on the assumptions for startup costs, capital expenditures and operating cash burn.
Output reports and investment analysis
Review pricing sensitivity, break-even and investment returns.
Use the reporting and analysis tools to evaluate how the proposed menu and operating plan affect the financial outcome.
IRR sensitivity for sales and pricing
Use the sensitivity data table to review low, base and high assumptions for sales counts and pricing and their effect on IRR.
DCF and return metrics
Review discounted cash flow (DCF) analysis together with IRR, equity multiple, ROI and NPV.
Enterprise valuation calculator
Use the standalone enterprise valuation calculator included in the workbook.
Outside investor option
Include outside investors when evaluating the investment structure and financial plan.
Break-even calculator
Use the break-even calculator to review the operating requirements under the model assumptions.
Sales summaries and visualizations
Review sales by year and by menu type, supported by visualizations of the results.
How to use the model
Turn the menu and sales assumptions into a financial plan.
Configure the menu
Choose the hot coffee, cold coffee and food items to include. Switch individual items on or off and set the three pricing options for each type.
Set sales, pricing mix and unit costs
Enter average monthly sales for each item over time, the share of sales in each pricing option and average cost of goods sold per unit.
Review inventory, cash flow and funding
Work through the inventory purchasing logic, startup costs, capital expenditures and cash flow forecast, then review the minimum equity requirement.
Test the plan and review returns
Compare low, base and high sales-count and pricing assumptions. Review break-even, valuation, return metrics and financial statements, including outside investors when applicable.
Who this model is for
For coffee shops, cafés and restaurant concepts.
Coffee shop founders
Plan a new coffee shop using menu-level sales, pricing, product costs, inventory purchasing and the cash required to get the operation running.
Café and restaurant operators
Use the flexible menu framework to evaluate a café or restaurant plan, compare pricing and sales assumptions and review the resulting financial reports.
Also available in these bundles
Need models for more than one business or concept?
This template is included in the Industry-Specific, Retail Trade and Hospitality bundles. The Super Smart Bundle provides access to the complete public SmartHelping template collection.
Industry-Specific Financial Models
Explore financial models built around the operating assumptions of different businesses and industries.
View the Industry-Specific bundleRetail Trade Models
Access financial models for retail and product-selling businesses.
View the Retail Trade bundleHospitality Financial Models
Explore financial planning templates for hospitality businesses.
View the Hospitality bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleAdditional planning resources
Explore customer analysis and other business-planning tools.
Customer Spend and Retention
Explore a separate template for analyzing customer spending and retention patterns.
Explore the templateStartup Marketing Guide
Read about approaching marketing for a startup business.
Read the guideReal Estate IRR Sensitivity
Explore a separate sensitivity-analysis template for real estate investment returns.
Explore the templateSaaS & Recurring Revenue Models
Browse models built for subscription and recurring revenue businesses.
View recurring revenue modelsQuestions before you buy
A few useful details.
Can this model be used for a café or restaurant?
Yes. It is designed for a coffee shop and can also be used for a café or general restaurant through its flexible menu, sales and cost assumptions.
How many menu items are supported?
The menu builder supports up to 26 hot coffee types, 23 cold coffee types and 6 food items. Each type has three configurable pricing options.
Can I change the sales mix between pricing options?
Yes. Define the average percentage of sales falling into each of the three pricing options, along with average monthly sales for each menu item over time.
Can I turn individual menu items off?
Yes. Individual menu items can be switched on or off within the menu builder.
Does the model show the equity required?
Yes. It calculates the minimum equity investment needed to keep cash above zero based on startup costs, capital expenditures and operating cash burn under the model assumptions.
What does the IRR sensitivity table vary?
The data table uses low, base and high variables for sales counts and pricing to show how those assumptions affect IRR.
Which reports and valuation tools are included?
The workbook includes monthly and annual financial statements and pro forma cash flow, DCF analysis, IRR, equity multiple, ROI, NPV, a standalone enterprise valuation calculator, a break-even calculator and sales summaries with visualizations. It also includes an outside-investor option.
Build the financial plan behind the menu
Connect every menu assumption to cash flow and returns.
Get the Coffee Shop, Café and Restaurant Financial Model for $45 and evaluate the sales, costs and funding needs of your five-year plan.
