# How to Create a Restaurant Cash Flow Statement in Excel – 3 Steps

The sample dataset contains values in Accounting format.

Below is the initial view of the operations section of the cash flow statement.

### Step 1 – Creating an Operations Cash Flow Section

• Enter the title and other parameters.
• Create the Net Cash Flow in B10.

• Enter monetary values in C5:C9 (negative amounts inside parentheses).

• In C10, enter the following formula:
`=SUM(C5:C9)`

• Press Enter.

The Net Cash Flow is displayed in C10.

### Step 2 – Adding Cash Flow from Investing Activities

• Create a new table: Investing Activities and format it.
• Enter the investment-related parameters.
• Create the Net Cash Flow from Investing Activities parameter in B10.

• Enter dollar values.

• In C10, use this formula:
`=SUM(C5:C9)`

• Press Enter or click an empty cell to see the Net Cash Flow from Investing Activities in C10.

### Step 3 – Inserting a Financing Activities Section

• Create a new table: Financing Activities.
• Enter the parameters.
• Double-click B10 and enter the Net Cash Flow from Financing Activities.
• Create the Net Cash Flow parameter.

• Enter monetary values in C5:C9.

• In C10, enter the following formula:
`=SUM(C5:C9)`

• Press Enter to see the Net Cash Flow from Financing Activities in C10.

• Use the formula below in C11:
`=SUM(C10+Operations!C10+Investing!C10)`

• Press Enter.

The final Net Cash Flow value is displayed.

## Related Articles

<< Go Back to Cash Flow TemplateFinance TemplateExcel Templates

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF