DCF Valuation Model Restaurant

DCF_Valuation_Model_for_Restaurants

The DCF Valuation Model for Restaurants provides a business plan in the form of an Excel Template to value a restaurant based on the Discounted Cash Flow Method.

The model allows the user to derive a monthly budget over the next 5 years with detailed revenues and cost assumptions. The budget then is used to project the next years’ financial statements such as the Income Statement, Balance Sheet and Cash Flow Statement for the restaurant (which corresponds to a 5 year business plan). Having that allows to calculate the discounted free cash flow which then is used for the DCF Valuation. The DCF Valuation also compares the results for the implied EV/EBITDA multiple.

The highlights of the model are:

  • Revenues from 3 products such as breakfast, lunch and dinner
  • Detailed sales forecast such as number of tables, number of guests, average revenues per guest and day, etc.
  • Detailed cost assumptions with staff costs, rent, etc.
  • Monthly budget for 5 years
  • 3 Statement Model: Projected Income Statement, Balance Sheet, Cash flow Statement
  • Free Cash Flow Calculation
  • Fixed Asset Schedule and calculation of foreseeable depreciation
  • Debt Schedule
  • Calculation of relevant financial ratios
  • Calculation of Net Present Value (NPV) which is the same as the DCF Value or Enterprise Value. After adjusting for the net debt, one can derive the Equity Value

The financial model is available in two versions, one with only the input cells editable (Free) and all cells editable (FULL Version).

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

DCF Valuation Model Restaurant - Executive Summary
DCF Valuation Model Restaurant – Executive Summary

 

Restaurant Budget - Monthly Financial Projections
Restaurant Budget – Monthly Financial Projections
Restaurant Financial Statements - Balance Sheet, Income Statement and Cash Flow Statement
Restaurant Financial Statements – Balance Sheet, Income Statement and Cash Flow Statement

 

 

 

Users who purchased DCF Valuation Model Restaurant, also purchased:
Apartment Complex Cash Flow and Valuation
ap6
  •  x 
  •  x 
Add to wish list
Purchase Excluding 8% tax
Commercial Real Estate Valuation Model
Commercial_Real_Estate_Valuation
Add to wish list
Purchase Excluding 8% tax
Hotel Valuation Financial Model
Hotel Valuation Financial Model
Add to wish list
Purchase Excluding 8% tax
Industry , ,
Summary The DCF Valuation Model for Restaurants provides a business plan in the form of an Excel Template to value a restaurant based on the Discounted Cash Flow Method.
Screenshots / Pictures
Use Cases , , , , , , ,

Write a Review