01
Assumptions Sheet
Covers a day, average spend, the ramp, every cost percentage, rent, salaries, the loan and the tax rate. One place to argue with, and the only sheet you type in.
Restaurant Financial Projections Template Free Excel Model for Indian Owner-Operators
Build three years of revenue, cost and profit from the numbers you already know: covers a day, average spend, and what the rent is. Ramped for the months it takes a new restaurant to fill. Updated for FY 2026-27.
- Revenue built from covers times average spend times days open, not typed in as a guess
- Year 1 month by month, Years 2 and 3 by quarter, with rent escalation and salary increments
- EBITDA, break-even, payback and debt service cover on one page a lender can read
No spam. Instant download link to your
email.
Petpooja presents
3-Year Financial Projections
For Indian Restaurant Owners
6
Sheets · Excel model
FY 2026-27
What's Inside
Six sheets that turn an opening plan into three years of numbers
02
Year 1, Month by Month
Twelve months from utilisation and revenue down to profit before tax, so you can see which month the restaurant stops losing money.
03
Years 2 and 3 by Quarter
Eight more quarters with your growth rates and seasonality, and with rent escalation, salary increments and inflation applied to the fixed costs.
04
Three-Year Summary
The investor page. Revenue to profit after tax for all three years, with income tax charged only after carried-forward losses are set off.
05
Benchmarks and the Three Questions
Your ratios against industry bands, plus break-even revenue a month, payback on the investment, and debt service cover for the loan.
06
How It Works
A walkthrough of the sample restaurant, the four assumptions that move the answer most, and what the model deliberately does not do.
Stop projecting from memory with Petpooja POSS
Covers, average spend per cover, channel mix and food cost all sit in your POS reports already. Petpooja POSS gives you the real numbers to project from, so year two is built on what actually happened in year one.
Explore Petpooja POSS
Why This Matters
Every lender asks for projections, and most restaurants hand over a guess
The bank asks for three years of numbers. Somebody opens a spreadsheet, types a monthly sales figure that feels about right, grows it 20 percent a year, and calls it a projection. Everyone in the room knows it is a guess. Nobody says so.
The problem is not optimism. It is that the number has nothing underneath it. Ask where the revenue comes from and there is no answer, because it was never built from covers, spend and days open.
A model that starts from those three things behaves differently. Change the average spend by ₹50 and every line moves, including the ones you would rather not look at.
Three things sink most restaurant projections. The first is opening at full capacity: a new restaurant does not fill in month one, but rent and salaries run at full rate from day one, which is where the first-year loss comes from.
The second is treating delivery like dine-in. Delivery revenue arrives with commission, packaging and, if you charge 5 percent GST, non-creditable GST on that commission. Growing through delivery grows costs faster than profit, which is the arithmetic behind the commission squeeze on Swiggy and Zomato.
The third is confusing profit with cash. Depreciation is not a payment, the loan principal is not an expense, and tax in year two depends on the loss you carried out of year one. A profit and loss statement answers a different question from a bank balance.
This template does all three properly. It ramps the first year, charges delivery its own costs, and stops at profit before tax each month so tax can be worked out once a year, after set-off, which is what actually happens.
It is built for a single outlet, the way most Indian restaurants actually start. If you already trade and want to project from real history rather than assumptions, pull the covers and spend out of your POS first, the way sales forecasting for restaurants works.
Sample Preview
What the model shows for a 45 seat restaurant in Pune
Here's a preview of what you'll get inside:
The outlet: 45 seats in Pune, opening on an investment of
₹77,50,000, funded with ₹47,50,000 of own money and a ₹30,00,000 term loan at 13 percent
Revenue at the full run rate: ₹17,23,500 a month, from 75 covers
a day at ₹500, which is 1.7 turns on those 45 seats, plus 35 delivery orders at ₹450 and 12 takeaway orders
at ₹350
Year 1 after the ramp: ₹1,82,06,253 of revenue, because the
restaurant opens at 45 percent of that run rate and only reaches full by month 6
Year 1 EBITDA: ₹25,18,655, a margin of 13.8 percent, below the
15 to 20 percent benchmark precisely because the ramp year carries full rent and full payroll
Year 3: ₹2,40,61,384 of revenue at a 19.7 percent EBITDA margin,
with food at 30.8 percent, staff at 21.0 percent, rent at 8.6 percent and delivery at 27 percent of revenue,
all inside benchmark
The three lender answers: break-even at ₹11,55,690 a month,
which is 1.7 table turns a day just to cover fixed costs, payback of the ₹77,50,000 in 35 months, and debt
service cover of 4.4 times in Year 2
... plus the month-by-month path to profitability, the eight quarters after that, and
an assumptions page you can defend line by line, across 6 sheets.
Key Stats
The market your projection is arguing about is real
₹5.69 lakh crore
The size of India's food services industry in FY24, on its way to ₹7.77 lakh crore by 2028 at 8.1 percent a year. A lender is not doubting the market. They are doubting your share of it.
Source: NRAI India Food Services Report 2024, as widely reported in the trade press13.2% a year
Growth of the organised segment, which is set to be 52.9 percent of the market by 2028. Chain and organised formats are taking share, and a single outlet plan has to say why it holds its own.
Source: NRAI India Food Services Report 2024, as widely reported in the trade press85 lakh jobs
People employed by Indian food services, contributing 1.9 percent of GDP. Payroll is the second largest line in your model after food, which is why the staff assumption deserves as much thought as the sales one.
Source: NRAI India Food Services Report 2024, as widely reported in the trade press
Common Mistakes
7 mistakes that sink a restaurant projection
01
Opening at full capacity in month one
A new restaurant fills over months, not on day one. Rent, salaries and licences run at full rate from the first day regardless, which is exactly why the first year usually loses money and the projection that ignores the ramp never shows it.
02
Treating delivery revenue like dine-in revenue
Commission, packaging and, on the 5 percent GST position, non-creditable GST on that commission all come out of delivery revenue before you see a rupee. Charge them on total revenue, or forget them, and the model flatters every delivery-heavy plan. A free GST calculator settles the tax on any one order, and the delivery commission calculator works the same numbers order by order.
03
Using a food cost you have never measured
Thirty percent is the number everyone writes down. Three points either way is three points of net margin, so it deserves a recipe-level check rather than a benchmark copied off a blog. The food cost calculator settles it dish by dish.
04
Holding rent and salaries flat for three years
Leases escalate, usually 5 to 10 percent a year, and staff expect an increment. A model with flat fixed costs shows margins improving every year for no reason other than arithmetic that was never done.
05
Reading profit before tax as cash in the bank
Depreciation never leaves the account, loan principal does but is not an expense, and stock and deposits swallow cash before they touch profit. Profit and cash are different questions, and lenders ask both.
06
Forgetting the loss carried out of year one
A first-year loss is set off against the next year's profit, so tax usually starts later than a naive model shows. Charging full tax in year two understates profit; charging none in year three overstates it.
07
Handing over numbers with no assumptions page
A projection is an argument. Without covers, spend, ramp and cost percentages visible, there is nothing to discuss and no reason to believe any of it. Print the assumptions next to the summary, every time, and list the licences you actually pay for, since FSSAI registration, shop and establishment and trade licence all come up for renewal on their own cycles.
Comparison
A number in a slide vs a model
| Aspect | The usual projection | With this model |
|---|---|---|
| Where the revenue number comes from | A figure that felt about right | Covers a day times average spend times days open, per channel |
| The first year | Twelve equal months | A ramp from your month 1 utilisation to the full run rate, month by month |
| Delivery costs | Buried in one overall cost percentage | Commission, packaging and non-creditable GST charged on delivery revenue only |
| Fixed costs over three years | Held flat | Rent escalated, salaries incremented, other costs inflated each year |
| Tax | A flat percentage on every year | Charged after the earlier year's loss is set off, once a year |
| What a lender asks for | Not answered | Break-even a month, payback in months, and debt service cover |
| Changing an assumption | Retyping the whole sheet | One cell on the Assumptions page, and all three years move |
Build the numbers before you walk into the bank
Download the free model, fill in the assumptions page, and print the summary.
FAQ
Frequently asked questions
How do I build a restaurant revenue projection?
Build it from three numbers you can defend: covers a day, average spend per cover net of GST, and days open a month. Multiply them for each channel separately, because dine-in, delivery and takeaway carry different costs. Then apply a ramp, since a new restaurant reaches its run rate over months, not on opening day. If you already trade, take covers and spend from your POS history rather than estimating. If it is the average spend that has to move, that is a menu problem before it is a footfall problem, and menu engineering is where it gets solved.
What is a realistic ramp-up for a new restaurant in India?
There is no single answer, which is why the template makes it an input rather than a rule. The sample opens at 45 percent of its full run rate and reaches 100 percent by month 6, which suits a casual dining restaurant in a city with some footfall. A destination format in a new catchment takes longer, and a delivery-led kitchen listed on the aggregators from day one can be faster. Whatever you choose, the cost of the ramp is real, because rent and salaries run at full rate throughout.
How much of my revenue should food cost and rent be?
For Indian full-service and casual dining, food and beverage cost usually runs 28 to 35 percent of revenue and rent 8 to 12 percent, with staff at 20 to 25 percent and EBITDA at 15 to 20 percent. These are the ranges the industry works to rather than a published standard, so treat them as a sense check against your own lease and city. QSR and cloud kitchens sit differently, with food cost often higher and rent much lower. The Summary sheet scores your model against these bands automatically, and the food cost definition matters here, since it should include everything that goes into the dish.
Do delivery orders make a restaurant more profitable?
Not automatically. Delivery revenue arrives after aggregator commission, packaging, and, if you charge 5 percent GST without input tax credit, the 18 percent GST the aggregator charges on its own commission, which you cannot claim back. That is why the template charges those costs against delivery revenue alone. Delivery adds volume without adding seats, which is genuinely valuable, but a plan that grows mainly through delivery has to show the margin surviving it. The kitchen metrics worth tracking will tell you whether it does.
What will a bank look at in a restaurant projection?
Three things, mostly. Whether the business breaks even at a believable level of sales, how long the money takes to come back, and whether earnings cover the loan, which lenders usually want at 1.25 times or better. All three sit on the Summary sheet. They will also want your assumptions visible and your promoter contribution clear, commonly 25 to 30 percent of project cost. A restaurant of this size usually qualifies as an MSME, which affects the lending schemes open to you. Once you are trading, the same lines are what a monthly restaurant profit and loss statement tracks against this plan.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement Petpooja helps Indian businesses run better, every day.
Project year two from what actually happened in year one
Petpooja POSS reports covers, average spend, channel mix and item-level sales across 80+ reports, so your next projection starts from measured numbers rather than remembered ones.
Book a Free Demo
Call: +91-9104369797