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. 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 >>
  2. 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 >>
  3. 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 >>
  4. Can you calculate the marginal tax rate in Excel?

    Learn how to approximate taxes owed and if Excel and marginal tax rate data provide an accurate number for personal tax calculation. Read Answer >>
  5. 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 >>
Related Articles
  1. Trading

    Improve your investing with Excel

    Excel is a useful tool to assist with investment organization and evaluation. Find out how to use it.
  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

    6 Tips For Getting A Good Cell Phone Plan

    Avoid overspending on cell service with this expert advice.
  4. Investing

    Bellicum’s Technology May Pay Off Big (BLCM)

    Bellicum’s approach augurs well with the successful cancer therapies and offers long-term potential for the company
  5. Small Business

    The Importance of Excel in Business

    Microsoft Excel is an indispensable tool for any business.
  6. Small Business

    Understanding Cash Flow

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

    Cellular Biomedicine and GE Healthcare Ink Pact

    Cellular Biomedicine announced a research pact with GE Healthcare China.
  8. Investing

    Evaluating A Statement Of Cash Flows

    The metrics for the Statement of Cash Flows is best viewed over time.
  9. 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.
  10. 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.
RELATED TERMS
  1. Financial Modeling

    The process by which a firm constructs a financial representation ...
  2. Stated Annual Interest Rate

    A stated annual interest rate is the return on an investment ...
  3. Free Cash Flow Yield

    An overall return evaluation ratio of a stock, which standardizes ...
  4. Operating Cash Flow (OCF)

    Operating Cash Flow (or OCF) is a measure of the amount of cash ...
  5. Cash Flow Statement

    A cash flow statement is a financial statement that provides ...
  6. Cash Flow Loan

    A cash flow loan is a type of unsecured borrowing that is used ...
Hot Definitions
  1. Gross Margin

    A company's total sales revenue minus its cost of goods sold, divided by the total sales revenue, expressed as a percentage. ...
  2. Inflation

    Inflation is the rate at which prices for goods and services is rising and the worth of currency is dropping.
  3. Discount Rate

    Discount rate is the interest rate charged to commercial banks and other depository institutions for loans received from ...
  4. Economies of Scale

    Economies of scale refer to reduced costs per unit that arise from increased total output of a product. For example, a larger ...
  5. Quick Ratio

    The quick ratio measures a company’s ability to meet its short-term obligations with its most liquid assets.
  6. Leverage

    Leverage results from using borrowed capital as a source of funding when investing to expand the firm's asset base and generate ...
Trading Center