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

### 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

### The Importance of Excel in Business

Microsoft Excel is an indispensable tool for any 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 ...