Cashflow Spreadsheets for Excel
Colorful enough for publication, this cash flow chart allows you to enter your business's beginning cash balance, and then operating and investment cash flow figures. Each category totals for you, and then automatically totals your ending cash position - perfect for a quick-but-polished snapshot. Excel 2003 or later.
This year-at-a-glance workbook allows you to compare your projected cash flow with your actual positions: enter your forecast cash balance and sales, and then your actual figures as they occur. Excel automatically calculates your totals and compares it to the forecast cash flow. Excel 2003 or later.
Figure out exactly where your cash is going with this one-year worksheet. Enter each month's income and outgo in the specific category cells for automatic monthly and yearly totals. Excel 2003 or later.
Perfect for tracking cash flow and getting a jump-start on your financial statements - simply enter your income and outgo for each reporting period. This worksheet automatically calculates and carries figures to a profit and loss statement, gain and loss statement, operating and liquidating cash flows, cash flow analysis and scenarios. Excel 2003 or later.
Especially for sole-proprietors, this year-at-a-glance sheet calculates total income and expenses for you. Additional cells for calculating inventory on hand and bad debts. Excel 2003 or later.
Evaluate a business's worth with hard financial data. This spreadsheet lists the figures you need for real analysis - enter each number for a numerical valuation. Worksheet 2 compares the betas of several business for side-by-side comparison. Excel 2003 or later.
Simple but powerful, this set of cash-flow statements was designed for analysts studying publicly-traded businesses. Excel 2003 or later.
This worksheet calculates your year-end cash flow figures in a format professional enough to publish. You can input figures directly or link to cells in another spreadsheet. Excel 2003 or later.