In this tutorial, I am going to show you step-by-step procedures to make a restaurant cash flow statement in excel. You can use these steps even in large datasets to create simple cash flow statements for any other businesses. Throughout this tutorial, you will also learn some important excel tools and techniques which will be very useful in any excel related task.
Download Practice Workbook
You can download the practice workbook from here.
What Is a Cash Flow Statement?
A cash flow statement is basically a tabular record that shows the cash coming and going out of the company for a certain period of time. This document is very crucial in determining how a business is doing in terms of managing its cash position like paying debt obligations, funding operating expenses, etc. The cash flow statement is also a complementary document to the balance sheet and income statement.
Step-by-Step Procedures to Make a Restaurant Cash Flow Statement in Excel
We have taken a concise dataset to explain the steps clearly. The dataset has approximately 7 rows and 2 columns. Initially, we formatted all the cells containing dollar values in Accounting format. Below is the initial view of the operations section of our cash flow statement. All of the other sections also have the same format except for different parameters.
Step 1: Creating Operations Cash Flow Section
This parameter in a cash flow statement is a measure of the restaurant’s regular business operations. This also indicates whether a restaurant can generate enough positive flow of cash to sustain its business. Let us see how to set this up in excel.
- First, type the title Operations and also all the other parameters.
- Now, create the Net Cash Flow from Operations parameter inside cell B10.
- Next, type in all the monetary values inside cells C5 to C9. Note that the negative amounts are inside parentheses.
- Then, navigate to cell C10 and insert the following formula:
=SUM(C5:C9)
- Finally, press the Enter key and this will give the Net Cash Flow from Operations value inside cell C10.
Read More: How to Calculate Operating Cash Flow in Excel (2 Easy Ways)
Similar Readings
- Calculate Incremental Cash Flow in Excel (2 Examples)
- How to Create Cash Flow Projection Format in Excel
- Create Cash Flow Statement Format with Indirect Method in Excel
- Cash Flow Statement Format in Excel for Construction Company
- How to Create Monthly Cash Flow Statement Format in Excel
Step 2: Adding Cash Flow from Investing Activities
Investing activities make an important portion of a restaurant cash flow statement. These activities include purchasing cooking equipment, decorating the shop, etc. Follow the steps below to create this in excel.
- To begin with, insert the table title as Investing Activities and give it some formatting like making it bold, filling color, etc.
- Then, insert all the investment-related parameters.
- Here, create the Net Cash Flow from Investing Activities parameter in cell B10 and format it a little differently.
- Now, insert the dollar values besides the respecting parameters.
- Then, go to cell C10 and type in this formula below:
=SUM(C5:C9)
- After that press the Enter key or click on any empty cell and this will give you the Net Cash Flow from Investing Activities inside cell C10.
Read More: How to Calculate Cash Flow in Excel (7 Suitable Examples)
Step 3: Inserting Financing Activities Section
Cash Flow from Finance Activities or CFF is a set of cash flow statement parameters that denotes the flow of cash assets which funds the restaurant business. Let us see how to include this inside our excel cash flow statement.
- To start with this last step, begin by creating the table title as Financing Activities as we did previously. Note that here we have merged multiple cells for the title.
- Again, make sure to input all the necessary parameters as in the image below.
- Then, double-click on cell B10 and insert the Net Cash Flow from Financing Activities parameters, and also format it.
- After that, make the Net Cash Flow parameter which will show the overall financial condition of the restaurant.
- As previously, type in the monetary values inside cells C5 to C9.
- Next, go to cell C10 and type the following formula:
=SUM(C5:C9)
- Now press Enter and this will calculate the Net Cash Flow from Financing Activities value inside cell C10.
- Then, for the last time type in the formula below in cell C11:
=SUM(C10+Operations!C10+Investing!C10)
- Lastly, press the Enter key to confirm the formula and this will give the final Net Cash Flow value for the restaurant.
Read More: Create Cash Flow Statement Format Using Direct Method in Excel
Conclusion
I hope that you were able to apply the methods that I showed in this tutorial on how to make a restaurant cash flow statement in excel. As you can see, there are quite a few steps to achieve this. So carefully follow them to achieve the same result as we have produced here. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.
Related Articles
- Create a Retirement Cash Flow Calculator in Excel
- How to Create a Cash Flow Waterfall Chart in Excel
- Create a Real Estate Cash Flow Model in Excel
- How to Calculate Annual Cash Flow in Excel (with Easy Steps)
- Calculate Discounted Cash Flow in Excel (with Easy Steps)
- How to Forecast Cash Flow in Excel (with Detailed Steps)
- Create Investment Property Cash Flow Calculator in Excel