Outdoor Dining Cost Calculator & Forecasted Income Statement Model

August 2020
Outdoor Dining

 

The Outdoor Dining Cost Calculator and Forecasted Income Statement Model will help you: 

  1. Build & Improve: Find out how much it would cost you to build an outdoor dining space from scratch, or read our tips on how to improve on your current outdoor space.

  2. Input: Input your restaurant’s total monthly sales, expenses & taxes to find your current net income.

  3. Predict: Learn how COVID has affected your business in the past, and predict how it will affect you in the coming months by viewing your projected net income over the next six months.
Outdoor Dining Cost Calculator and Forecasted Income Statement Excel Spreadsheet Screenshot

How to Download the Model: 

  1. Access the interactive Excel spreadsheet here.
  2. Go to File > Save As > Download a Copy to download your own copy of the Excel spreadsheet
  3. Follow along with the instructional videos below and start inputting your data. 

 

Follow Along with our Instructional Videos

Outdoor Dining Cost Calculator Video

Video Overview

  • Follow a set of questions to determine the costs of setting up an outdoor dining space. 
  • Preview and enter purchasing options. The model will estimate the fixed cost of creating an outdoor space.
  • Review our checklist to improve outdoor dining and learn some helpful tips for success.
Forecasted Income Statement Model Video

Video Overview

  • Preview the process of inputting your business’s financial numbers in all of the blue boxes
    • View notes in the top right corner of the excel boxes if an income statement is not available
  • Identify how COVID has affected your business in the past by inputting information into a “base month” and a “month before base month”
  • Predict expected income for the next six months by proceeding to the forecasted income statement tab