Skip to content
Browse Calculators
Finance

Restaurant Capital Budgeting Calculator

Evaluate restaurant capital projects with NPV, profitability index, and simple or discounted payback before you approve remodel or equipment spend.

Restaurant capital budgeting formulas

Formula
Present Value
Cash Flow / (1 + Discount Rate)^Year

Net Present Value
Sum of Present Values - Initial Investment

Profitability Index
Present Value of Future Cash Flows / Initial Investment

Simple Payback
Initial Investment / Annual Cash Flow

Discounted Payback
First year where cumulative discounted cash flow exceeds investment

Benchmark (Profitability Index):
  Excellent: 2.00 or above
  Good: 1.50 to below 2.00
  Average: 1.20 to below 1.50
  Low: 1.00 to below 1.20
  Critical: below 1.00

What it means

Simple mode discounts equal annual cash flows and reports simple payback. Advanced mode discounts each yearly row, adds residual value to the final year, and reports discounted payback. This page is not the NPV Calculator alone, IRR (rate solve), ROI (undiscounted return), Payback Period alone, Revenue Forecast, Loan, DSCR, or Working Capital.

Good to know

  • Cash flows occur at the end of each year.
  • Discount rate stays constant across the project life.
  • Initial investment occurs at time zero.

Ideal range

  • Not the NPV Calculator alone. That tool focuses on accept or reject NPV.
  • Not IRR, ROI, or Payback Period as standalone tools.
  • Not Loan, DSCR, Working Capital, or Revenue Forecast.

Variables

NPVNet present value
Discounted project value minus initial investment.
PIProfitability index
Present value of cash flows per dollar invested.
rDiscount rate
Hurdle or cost of capital as a decimal.
PaybackPayback period
Years to recover investment on a simple or discounted basis.

Assumptions

  • Residual value is added to the final project year before discounting.

Limitations

  • No tax shield, inflation indexing, or mutually exclusive project ranking table.

Worked examples

Real numbers through the same formula this tool uses.

  1. 1
    Restaurant scenarioExample 1

    Simple 100k remodel screen

    100000 investment, 30000 annual cash flow for 5 years at 10% yields NPV about 13724 and PI about 1.14, low status, accept.

  2. 2
    Restaurant scenarioExample 2

    Advanced project with residual

    150000 investment with rising yearly cash flows and 20000 residual at 8% yields positive NPV and low PI status.

How to use the restaurant capital budgeting calculator

Pick simple or advanced mode, enter capital and cash flows, then read NPV, PI, and payback together.

  1. Choose simple or advanced evaluation

    Use simple mode for equal annual cash flows. Use advanced mode for uneven years and residual value.

  2. Enter investment and discount rate

    Set upfront capital and the hurdle rate you would actually require.

  3. Enter cash flows

    Add annual cash flow and project life, or add yearly rows plus residual value.

  4. Read NPV, PI, and payback

    Accept only when NPV is non-negative and PI is at least 1.00, then check recovery timing.

  5. Cross-check with NPV and IRR tools

    Confirm the discounted call and, if needed, solve IRR for stakeholders who want a rate metric.

How to read capital budgeting results

This tool discounts restaurant project cash flows to NPV and profitability index, then shows simple or discounted payback. It is not an IRR solve, a plain ROI score, or a loan coverage check.

  • Start with net present value

    NPV is the sum of discounted project cash flows minus the initial investment. Positive NPV supports an accept call at your discount rate.

  • Use profitability index for ranking

    PI divides the present value of future cash flows by investment. A PI of 1.00 is break-even. Higher PI means more value per dollar of capital.

  • Read payback as timing, not return

    Simple payback ignores discounting. Discounted payback waits until cumulative present values recover the investment.

  • Include residual value in advanced mode

    Equipment salvage or lease exit value belongs in the final year so the discounted table is complete.

  • Not an IRR calculator

    Use the Restaurant IRR Calculator when you need the rate that sets NPV to zero. This page scores NPV, PI, and payback together.

Best practices for restaurant capital budgeting

Capital decisions stay honest when the discount rate, cash flows, and residual value match how the project will actually run.

  • Match the discount rate to capital cost

    Use a lender or ownership hurdle you would really require, not a round number pulled from a blog.

  • Stress a slower sales year

    Re-run advanced mode with a weaker middle year before you treat a strong PI as safe.

  • Keep NPV and IRR roles clear

    Use this page for PI and payback with NPV. Use IRR when stakeholders want a single rate of return.

  • Pair with cash flow timing

    Discounted accept still needs bank timing. Confirm deposits and buildout draws with Cash Flow Forecast.

Common capital budgeting mistakes

These errors make a remodel or equipment project look fundable when discounted cash still falls short.

  • Judging only simple payback

    A three-year payback can still fail NPV when the discount rate is high. Read discounted payback and PI together.

  • Leaving residual value at zero by habit

    Kitchen equipment and build-out often retain exit value. Omitting it understates PI.

  • Treating ROI as a substitute for NPV

    ROI ignores the time value of money. Capital budgeting discounts each year at your hurdle rate.

  • Mixing debt service with project cash flow

    Model operating project cash flows here. Size loan payments and DSCR with the Loan and DSCR calculators.

People also ask

Short answers operators ask when ranking restaurant capital projects.

  • What is capital budgeting for a restaurant?

    Capital budgeting compares upfront investment to discounted future cash flows so you can accept, reject, or rank remodel and equipment projects.

  • What is a good profitability index?

    This calculator treats 2.00 or higher as excellent, 1.50 to 2.00 as good, and below 1.00 as critical because discounted cash flows do not cover capital.

  • How is this different from the restaurant NPV calculator?

    The NPV calculator focuses on discounted value and accept or reject. Capital budgeting adds profitability index and payback in one project screen.

  • How is this different from the restaurant IRR calculator?

    IRR solves the return rate that sets NPV to zero. Capital budgeting keeps your discount rate fixed and scores NPV, PI, and payback.

  • How is this different from the payback period calculator?

    Payback Period focuses on recovery timing. Capital budgeting pairs payback with discounted NPV and profitability index.

  • What is discounted payback?

    Discounted payback is the first year when cumulative present values of project cash flows exceed the initial investment.

References and further reading

Use these internal tools after you rank a capital project.

  • Restaurant NPV Calculator

    Run a second discounted NPV read with fixed or variable cash flows.

  • Restaurant IRR Calculator

    Solve the internal rate of return when stakeholders want a single rate metric.

  • Restaurant Payback Period Calculator

    Focus on recovery timing without profitability index.

  • Restaurant ROI Calculator

    Score undiscounted return percentage for simpler investment screens.

Frequently asked questions

You may also need

Complementary calculators that often pair with this workflow.

Financebeginner4 min

Restaurant DSCR Calculator

Measure restaurant DSCR from annual, monthly, or projected operating income and debt payments. See coverage status, debt capacity, and recommendations.

Financebeginner4 min

Restaurant EBITDA Calculator

Calculate restaurant EBITDA from an income statement or net income add-backs. See EBIT, EBITDA margin, and recommendations.

Financeintermediate6 min

Restaurant Franchise Investment Calculator

Estimate restaurant franchise investment, ROI and payback after royalty and marketing fees, or test a loan scenario with monthly payment and DSCR.

Continue exploring

More tools to browse after you finish this calculation.

Food costbeginner2 min

Food Cost Percentage Calculator

Work out what share of your food sales is spent on ingredients. Enter total food cost and food sales to get your food cost percentage instantly, with the formula shown.

Laborbeginner2 min

Labor Cost Percentage Calculator

Calculate restaurant labor cost percentage from total labor and sales. Optionally include payroll taxes and benefits for a loaded labor figure.

Inventoryintermediate4 min

Restaurant Inventory Shrinkage Calculator

Compare expected versus actual restaurant inventory to calculate shrinkage quantity, shrinkage value, shrinkage percentage, inventory accuracy, and adjusted loss after recovery — with optional cause breakdown for waste, spoilage, damage, and theft.