A:

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.

RELATED FAQS
  1. What is the formula for calculating free cash flow in Excel?

    Find out more about free cash flow, the formula for calculating free cash flow and how to calculate a company's free cash ... Read Answer >>
  2. How do I calculate how long it takes an investment to double (AKA 'The Rule of 72') ...

    Find out more about the rule of 72, what the rule of 72 measures and how to calculate the rule of 72 for investments using ... Read Answer >>
  3. What is the formula for calculating return on assets (ROA) in Excel?

    Find out more about the return on assets (ROA) ratio and the formula for calculating a company's return on assets in Excel. Read Answer >>
  4. What is the formula for calculating the capital asset pricing model (CAPM) in Excel?

    Find out more about the capital asset pricing model (CAPM) and the formula for calculating it in Microsoft Excel. Read Answer >>
  5. How do you calculate return on equity (ROE) in Excel?

    Find out more about return on equity, the formula to calculate ROE and how to calculate this measure of a company's profitability ... Read Answer >>
  6. What is the difference between Macaulay duration and modified duration?

    Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies ... Read Answer >>
Related Articles
  1. Insights

    Simulating stock prices using excel

    Here, we'll use the average of the change in log prices, volatility, normal distribution and Excel to formulate the future prices of an asset. This can amount to a very valuable tool for investors ...
  2. Small Business

    Understanding Cash Flow

    Learn about the different types of cash flows and the importance for businesses to properly manage their cash flows.
  3. Investing

    Evaluating A Statement Of Cash Flows

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

    Fundamental Case Study: Is Amazon's Cash Flow Actually Solid? (AMZN)

    Review Amazon's cash flow situation, including its free cash flow yield, operating cash flow from organic growth and cash flow from debt financing.
  5. Personal Finance

    What Kind of Solar Panels Provide the Best Savings?

    Before you make any decisions about incorporating solar energy into your home, it's first helpful to better understand the prospective ROI of doing so.
  6. Investing

    What’s FuelCell Energy Strategy To Stand Out?

    FuelCell Energy stands out from most companies in the fuel cell industry by concentrating on a different niche that involves a different type of technology
  7. Investing

    Cash flow statements: Reviewing cash flow from operations

    Discover why cash flow from operating activities is significant to businesses, and learn the direct and indirect methods for calculating it.
  8. Investing

    Cash Flow on Steroids: Why Companies Cheat

    Pressure to be the best can sometimes push corporations to cheat. Learn how they do it and how to spot it.
  9. Investing

    Why Quants are Tracking You Through Your Phone

    We asked three quantitative analysts to name the most interesting data sets they've heard of, from cell phones tracking their owners for third parties, to investing on the outcome of court cases. ...
RELATED TERMS
  1. Protected Cell Company (PCC)

    A protected cell company (PCC) is a corporate structure, a single ...
  2. Free Cash Flow Yield

    Free cash flow yield is a financial ratio that standardizes the ...
  3. Operating Cash Flow Margin

    Operating cash flow margin measures cash from operating activities as ...
  4. Compound Interest

    Compound interest is interest calculated on the initial principal ...
  5. Cash Flow From Operating Activities (CFO)

    Cash Flow From Operating Activities (CFO) is an accounting item ...
  6. Cash Flow From Investing Activities

    Cash flow from investing activities reports the total change ...
Trading Center