Calculating free cash flow is useful for investors and lenders to evaluate the success of a company. To create an Excel spreadsheet to calculate operating cash flow, first merge the first row of cells together (between columns A to N). This row will serve to title this document, such as "Cash Flow 2014-2015." Repeat the same step for the second row; this row serves to write the name of business.

In cells B4 through M4, put one month of the year within each starting with the beginning of the tax year. In A5, type "Opening Balance." In A7 through A12, type the following: "Money In" (A7), "Owner's Capital" (A8), "Bank Loans" (A9), "Sales" (A10), "Other" (A11), and "Total Money In" (A12). In A12 through M12 put a border at the top. These cells will represent the money coming in to the business.

Modify the margins of column A to comfortably fit all of the words in these cells. In A14 type in "Money Out," which will account for all of the business' costs. Type the following in the designated cells: "Loan Repayments" (A16), "Goods for Resale" (A18), "Equipment" ( A19), "Advertising" (A21), "Website" (A22), "Merchant" (A23), "Postage" (A24) "Stationary" (A25), and "Total Money Out" (A27). Add necessary expenses in columns B through M.

For A27 through M27, put a border at the top. Highlight all of the cells between B5 to M27, click format cells, go to Numbers, and then Accounting. Format it so that the cells' values have two decimal places. In B12, put in "=SUM(B8:B11)" and press enter. Drag this formula across for each month. In B27, input "=SUM(B16:B26)" and press enter. Drag this formula across the Excel sheet for each month. In A29, type in "Closing Balance." In cell B29, type in the following formula: "=B5+B12-B27." Drag this formula across for each month (to cell M27).

Lastly, type in all of the values that are specific to your business for each month. The closing balance row represents the operating cash flow and will also indicate a company's budget.

  1. What is the formula for calculating return on equity (ROE) in Excel?

    Find out more about return on equity, the formula to calculate it and how to calculate return on equity in Microsoft Excel. Read Answer >>
  2. What is the formula for calculating the price-to-earnings (P/E) ratio in Excel?

    Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft ... Read Answer >>
  3. How do I calculate the expected return of my portfolio in Excel?

    Find out how to calculate the total expected annual return of your portfolio in Microsoft Excel using the value and return ... Read Answer >>
  4. How do you calculate present value in Excel?

    Learn what present value and future value are and how to use Microsoft Excel to calculate present value, given the future ... Read Answer >>
  5. How do I calculate the equity risk premium in Excel?

    Find out how to calculate the equity risk premium for an individual security using Microsoft Excel, including how to estimate ... Read Answer >>
  6. How do you calculate net current assets in Excel?

    Learn how to calculate net current assets, or working capital, in Microsoft Excel and how to evaluate the financial health ... Read Answer >>
Related Articles
  1. Trading

    Improve your investing with Excel

    Find out how to use Excel, a useful tool for assisting with investment organizations and evaluations.
  2. Insights

    Cell Phone Evolution

    Follow the evolution of cell phones from 20 pound bricks to the sleek smart phones of today.
  3. Personal Finance

    Schedule Loan Repayments With Excel Formulas

    Learn how to calculate all the particulars of a loan using Excel, and find out how to set up a schedule of repayment for a mortgage or any other loan.
  4. Personal Finance

    How Cell Phones Have Changed Your Budget

    The cost of owning a cell phone wasn't a factor for people less than two decades ago. Today, there seems to be no end to the additional charges that come from owning a smartphone.
  5. Investing

    Verizon Selling Bonds Backed by Cell Phone Bills

    Verizon became the first cell phone carrier to issue a bond that is backed directly by its outstanding bills to its cell phone customers.
  6. Small Business

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  7. Investing

    Evaluating A Statement Of Cash Flows

    The metrics for the Statement of Cash Flows is best viewed over time.
  8. Investing

    Global Blood Sickle Cell Trial Moves Forward (GBT)

    Global Blood Therapeutics secured FDA approval to proceed with a Phase 3 trial for its GBT440 drug to treat sickle cell disease.
  9. Investing

    Corporate Cash Flow: Understanding the Essentials

    Tune out the accounting noise and see whether a company is generating the stuff it needs to sustain itself. Learn how to read the cash flow statement.
  1. Financial Modeling

    The process by which a firm constructs a financial representation ...
  2. Price to Free Cash Flow

    Price to free cash flow is an equity valuation metric used to ...
  3. Operating Cash Flow Margin

    Operating cash flow margin measures cash from operating activities as ...
  4. Cash Flow From Investing Activities

    Cash flow from investing activities reports the total change ...
  5. Cash Flow

    Cash flow is the net amount of cash and cash-equivalents being ...
  6. Free Cash Flow Per Share

    On a per share basis, free cash flow per share is cash available ...
Hot Definitions
  1. Futures Contract

    An agreement to buy or sell the underlying commodity or asset at a specific price at a future date.
  2. Yield Curve

    A yield curve is a line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but ...
  3. Portfolio

    A portfolio is a grouping of financial assets such as stocks, bonds and cash equivalents, also their mutual, exchange-traded ...
  4. Gross Profit

    Gross profit is the profit a company makes after deducting the costs of making and selling its products, or the costs of ...
  5. Diversification

    Diversification is the strategy of investing in a variety of securities in order to lower the risk involved with putting ...
  6. Intrinsic Value

    Intrinsic value is the perceived or calculated value of a company, including tangible and intangible factors, and may differ ...
Trading Center