How to Prepare a Cash Flow Statement | Accion Opportunity Fund (2024)

One of the most important aspects of running your business is managing the amount of money that comes in and goes out. Ideally, more will always be flowing in than flowing out, but it doesn’t always happen that way. You may have to pay your staff and suppliers while waiting to pay yourself. No matter what your situation, it’s helpful to have a picture of where you stand at any given time, and learning how to prepare a cash flow statement is the key. It gives you an overview of how money flows in and out of the business so you can spot trends and manage them.

As with other financial statements, if you use accounting software like QuickBooks or Peachtree, the program will prepare a cash flow statement for you after you enter the pertinent information. However, you can easily prepare a cash flow statement on your own with some simple calculations.

Four Steps to Prepare a Cash Flow Statement

Here are four steps to help you prepare a cash flow statement.

Cash flow statements can be prepared monthly, quarterly, yearly, or for any period you determine to be most helpful. Most businesses find keeping track each month is beneficial.

1. Start with the Opening Balance

For the first month, start with the total amount of cash your business has in its bank accounts.

2. Calculate the Cash Coming in (Sources of Cash)

Figure out all the money you expect to take in during the month. Only include actual money you will be receiving, not the sales you have made. For example, if you signed a contract for $100,000 over the next six months but are only receiving $15,000 of it this month, you would only count $15,000 for now because that would be the cash you have on hand.

Count everything coming in, including all collections of previous sales you made on credit, any transfers of your own personal money into the business, and any loans you might have taken during the period. Basically, you will include every single dollar coming into your business, whether from operations (sales of your goods or services), investments (sales of assets such as business equipment or land), or financing activities (equity you and/or shareholders are providing, or loans).

Add the figure you’ve arrived at in Step 2 to your opening balance from Step 1 to get your total cash balance for the period.

3. Determine the Cash Going Out (Uses of Cash)

Now, count up and enter all of the payments you expect to make for the month. Include items such as inventory, rent, salaries, taxes, loan payments, etc. Take into account everything you’ll spend money on this month.

If you have an annual bill for something like insurance, but have to pay for it all at one time or twice a year, you would count the payment as an expenditure during the month(s) in which you pay it. (You should still budget for it monthly, but you’ll have to come up with the cash during the month it’s actually due.)

4. Subtract Uses of Cash (Step 3) from your Cash Balance (sum of Steps 1 and 2)

The number you’re left with will be how much cash you have left at the end of the month. It will also be your Opening Balance at the start of the next month. If the number is negative, it means you will have a shortfall-not enough cash to cover your expenses.

An Alternative Method

Instead of lumping together all of the sources of cash and all of the uses of cash, you can figure out your cash flow for each category separately. You would have one category for operating activities, one for investing activities, and one for financing activities. For each, you would total up the cash coming in and subtract the payments going out.

How to Use a Cash Flow Statement

The biggest benefit to analyzing your cash flow is the information it provides about how to handle your expenses. While your business may be profitable in the long run, you may still have periods where you don’t have the money to pay your bills. This is especially true for companies that do a lot of invoicing.

Not all customers pay on time, and sometimes, they don’t pay at all. Because cash flow ONLY counts the money you’ve actually received, it can be more realistic than your profit and loss statement when it comes to figuring out the financials of your operation.

When you see the figures in black and white, you’ll realize the periods in which you either have to cut the amount of money you’re spending or increase the money coming in-whether it’s by booking more business, getting paid faster, or getting a loan or a line of credit.

Next Article: Fundamentals of Financial Documents

How to Prepare a Cash Flow Statement | Accion Opportunity Fund (2024)

FAQs

How to Prepare a Cash Flow Statement | Accion Opportunity Fund? ›

While not specifically included in the definition of a relevant cash flow (as noted above) opportunity costs are also relevant cash flows.

How do we calculate cash flow opportunity? ›

How to calculate net cash flow
  1. Net Cash Flow = Total Cash Inflows – Total Cash Outflows.
  2. Net Cash Flow = Operating Cash Flow + Cash Flow from Financial Activities (Net) + Cash Flow from Investing Activities (Net)
  3. Operating Cash Flow = Net Income + Non-Cash Expenses – Change in Working Capital.
Jun 9, 2023

Does cash flow include opportunity cost? ›

While not specifically included in the definition of a relevant cash flow (as noted above) opportunity costs are also relevant cash flows.

How do you lay out a cash flow statement? ›

Four Steps to Prepare a Cash Flow Statement
  1. Start with the Opening Balance. ...
  2. Calculate the Cash Coming in (Sources of Cash) ...
  3. Determine the Cash Going Out (Uses of Cash) ...
  4. Subtract Uses of Cash (Step 3) from your Cash Balance (sum of Steps 1 and 2)

What are examples of fund flow statements? ›

Fund Flow = Total Sources of Funds – Total Uses of Funds. For example, if a company in India issues INR 10,00,000 in new equity shares (source) and invests INR 6,00,000 in fixed assets (use), the fund flow would be INR 10,00,000 – INR 6,00,000 = INR 4,00,000.

What is the formula for the opportunity cost of funds? ›

The formula for opportunity cost is OC = FO – CO, where OC signifies opportunity cost, FO is the return on the foregone option and CO is the return on the chosen option. By employing this calculation, you can concretely assess the benefits that might have been accrued had a different decision been made.

What is the cash flow from investing opportunities? ›

Key Takeaways. Cash flow from investing activities is a section of the cash flow statement that shows the cash generated or spent relating to investment activities. Investing activities include purchases of physical assets, investments in securities, or the sale of securities or assets.

What are the three types of cash flow statements? ›

The main components of the CFS are cash from three areas: Operating activities, investing activities, and financing activities.

What are the three major steps in preparing a cash flow statement? ›

  • Step 1: Calculate the New Cash Balance. A business will start and end the year with a cash surplus or deficit. ...
  • Step 2: Calculate Operating Activities. ...
  • Step 3: Calculate Investing Activities. ...
  • Step 4: Calculate Financing Activities. ...
  • Step 5: Calculate Net Cash. ...
  • Step 6: Notate Disclosures.
Feb 18, 2023

How do you prepare a project for a cash flow statement? ›

There are several steps you can take to create a cash flow projection statement:
  1. Calculate the current cash amount. ...
  2. Estimate projected cash. ...
  3. Estimate potential expenses. ...
  4. Calculate predicted income minus predicted expenses. ...
  5. Add the projected cash flow figure to the current cash amount.
Feb 3, 2023

What are the four rules for creating cash flow statement? ›

Four simple rules to remember as you create your cash flow statement:
  • Transactions that show an increase in assets result in a decrease in cash flow.
  • Transactions that show a decrease in assets result in an increase in cash flow.
  • Transactions that show an increase in liabilities result in an increase in cash flow.
Feb 28, 2024

What is the formula for calculating opportunity cost? ›

In business, opportunity cost is calculated mathematically using the following formula: Opportunity cost = FO – CO, where FO is the potential return on the option not chosen while CO is the return on the option chosen.

What is opportunity free cash flow? ›

Free cash flow (FCF) is the money a company has left over after paying its operating expenses (OpEx) and capital expenditures (CapEx). The more free cash flow a company has, the more it can allocate to dividends, paying down debt, and growth opportunities.

What does the opportunity cost include? ›

The opportunity cost includes both explicit and implicit costs. Explicit costs are costs that require a money payment. Implicit costs are costs that do not require a money payment. Opportunity cost includes both explicit and implicit costs.

How does a fund flow statement differ from a cash flow statement? ›

Cash flow statement of a company is an indicator of its financial health in terms of management, revenue generation and turnover. Conversely, funds flow statements are created to measure the profitability of a stock market tool through its market demand, as it portrays investor confidence in a particular instrument.

What is the format of fund flow? ›

The Fund Flow Statement Format includes information about the inflows and outflows of cash and other assets. It also provides information on the sources of finances, such as proceeds from asset sales or debt issuance, as well as the uses of cash, such as acquiring new equipment or debt repayment.

How do you prepare a cash flow statement for mutual funds? ›

Direct Method:
  1. List cash receipts: Include cash collected from customers.
  2. List cash payments: Include cash paid to suppliers, employees, interest paid, and income taxes paid.
  3. Calculate net cash flow from operating activities: Subtract total cash payments from total cash receipts.

How to calculate funds from operations in a fund flow statement? ›

FFO is calculated by adding depreciation, amortization, and losses on sales of assets to earnings and then subtracting any gains on sales of assets and any interest income. It is sometimes quoted on a per-share basis.

Top Articles
Latest Posts
Article information

Author: Fredrick Kertzmann

Last Updated:

Views: 5447

Rating: 4.6 / 5 (46 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Fredrick Kertzmann

Birthday: 2000-04-29

Address: Apt. 203 613 Huels Gateway, Ralphtown, LA 40204

Phone: +2135150832870

Job: Regional Design Producer

Hobby: Nordic skating, Lacemaking, Mountain biking, Rowing, Gardening, Water sports, role-playing games

Introduction: My name is Fredrick Kertzmann, I am a gleaming, encouraging, inexpensive, thankful, tender, quaint, precious person who loves writing and wants to share my knowledge and understanding with you.