Free tools Windows power users keep installed
One-click scans. No signup required.
The basic cash-flow formula is =Cash Inflows-Cash Outflows. If you enter outflows as negative numbers, the safer worksheet formula is =SUM(all_cash_flow_entries). Net cash flow measures movement during a period; ending cash adds the opening balance. The examples below show how to build a transaction-based workbook, forecast balances, and evaluate projects with NPV and IRR.
What cash flow means in Excel
A cash inflow is money actually received. A cash outflow is money actually paid. Net cash flow is inflows minus outflows for a defined period, while cash balance is the amount available after adding that period’s net flow to the opening balance.
Cash flow is not profit. Profit can include unpaid invoices, depreciation, accruals and other noncash items. A profitable business can have negative cash flow when customers pay late or inventory and other working-capital requirements absorb cash. For a cash tracker, record receipts and payments when money moves, not when an invoice is issued; see Microsoft’s guidance on recording actual business receipts and payments at Microsoft’s cash-flow tracker guide.
Set up the workbook before adding formulas
Use a transaction-level table
| Date | Description | Category | Type | Amount |
|---|---|---|---|---|
| 1/5/2026 | Customer payment | Sales | Operating inflow | 4,500 |
| 1/7/2026 | Rent | Occupancy | Operating outflow | -1,200 |
| 1/10/2026 | Equipment purchase | Equipment | Investing outflow | -3,000 |
| 1/15/2026 | Loan proceeds | Debt | Financing inflow | 10,000 |
- Enter inflows as positive and outflows as negative values.
- Store dates as real Excel dates and use one period convention, such as daily, weekly, monthly or annual.
- Select the range and press Ctrl+T to create an Excel Table; structured references then expand as rows are added.
- Keep assumptions, such as tax rates and discount rates, separate from calculated cells.
- Do not mix accrual revenue with cash receipts.
For a formal statement, classify cash as operating, investing or financing activity. The SEC explains these three principal sections and the operating-cash-flow reconciliation context in its financial-statement guide.
#1 Best Overall
- PROFESSIONAL FINANCIAL CALCULATOR : Built-in TVM, IRR, NPV. Engineered for business analysts, real estate investors, accountants, and finance students.
- ADVANCED CASH FLOW & AMORTIZATION : Execute time value of money, break-even analysis, depreciation schedules, and bond pricing. Trusted for professional exam prep", MBA coursework, and banking certifications.
- CATIGA CF-300 : Flip-open hard case with a snap-close design for a secure fit. Compact and portable: designed for daily professional use in office, classroom, or on-site.
- ALL-IN-ONE FOR PROFESSIONALS : From NPV/IRR for real estate analysis to statistical calculations for business analysts. Handles probability, linear regression, and complex financial formulas.
- MORTGAGE, LOAN & INVESTMENT CALCULATOR : Covers bond pricing, loan amortization, investment analysis, and exam-level computations. Your go-to accounting calculator, business calculator, and real estate calculator in one device.
Summarize transactions by period
If your table is named Table1, this formula totals all cash entries from the date in H1 through the day before I1:
=SUMIFS(Table1[Amount],Table1[Date],">="&H$1,Table1[Date],"<"&I$1)To total only inflows, add a type criterion:
=SUMIFS(Table1[Amount],Table1[Type],"Inflow",Table1[Date],">="&H$1,Table1[Date],"<"&I$1)Excel formulas begin with =; Microsoft’s formula overview covers cell references and functions such as SUM.
Example 1: Calculate net cash flow
| Item | Amount |
|---|---|
| Sales collected | 12,000 |
| Loan proceeds | 5,000 |
| Payroll | -4,000 |
| Rent | -2,000 |
| Equipment | -3,500 |
With these values in B2:B6, use:
=SUM(B2:B6)The result is $7,500. If inflows and outflows are stored in separate positive ranges instead, use =SUM(inflows)-SUM(outflows). Never subtract a range that already contains negative outflows.
Example 2: Calculate cumulative and ending cash
Suppose monthly net cash flow is in row 10. If January is in B10 and February in C10, set the first cumulative value to =B10, then use =B11+C10 in the next column and copy across.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →If beginning cash is in B2, January ending cash is:
Rank #2
- HP 12C: INDUSTRY STANDARD SINCE 1981 – Trusted by professionals in real estate, banking, and finance for over 40 years. The HP 12C finance calculator remains the go-to tool for fast and accurate calculations in high-stakes business environments.
- 120+ FUNCTIONS FOR FINANCIAL ANALYSIS – Calculate loan amortization, bond pricing, mortgage payments, NPV, IRR, depreciation, and more with this large calculator. Built-in business and statistical functions allow you to perform complex calculations in just a few keystrokes.
- RPN ENTRY FOR FASTER WORKFLOWS – Reverse Polish Notation (RPN) allows for efficient data entry with fewer keystrokes and no formulas. This RPN calculator is perfect for a mortgage payment calculator, accounting calculator, business calculator, or real estate calculator for desktop.
- PROGRAMMABLE FOR REPEAT TASKS – The HP12C desk calculator stores custom keystroke sequences for repeated use. This large calculator supports up to 20 cash flows for IRR/NPV analysis, modeling investment scenarios, projecting returns, and automating routine calculations.
- INCLUDES CLEANING CLOTH, CASE & BATTERIES – Compact design fits easily on a desk or crowded table area. Includes a protective carrying case, cleaning cloth, and comes with pre-installed batteries so it's ready to use out of the box. A great choice for home finances, business professionals, and accountants.
=B2+B10For a rolling schedule, link each month’s beginning cash to the previous month’s ending cash. Cumulative cash flow reveals recovery of an initial investment, temporary deficits and the lowest cash point that may require funding. It is undiscounted, so a positive cumulative total does not by itself prove that a project creates value.
Example 3: Calculate operating cash flow
A simplified indirect-style model is:
=Operating_Income+Depreciation_And_Amortization-Change_In_Working_Capital-Cash_Taxes| Item | Amount |
|---|---|
| Operating income | 40,000 |
| Depreciation | 6,000 |
| Increase in working capital | 8,000 |
| Cash taxes | 7,000 |
=40000+6000-8000-7000 returns $31,000. An increase in receivables, inventory or other operating current assets generally uses cash; an increase in payables or accrued operating liabilities generally supplies cash. Subtract the change, not the entire working-capital balance.
Operating cash flow can be presented by direct or indirect methods, and classifications differ by accounting framework. State the definition used in your model rather than treating this simplified formula as universal.
Example 4: Calculate free cash flow
This example uses unlevered free cash flow (also called free cash flow to the firm):
=NOPAT+Depreciation_And_Amortization-Capital_Expenditures-Change_In_Net_Working_CapitalCalculate NOPAT as EBIT*(1-Tax_Rate).
| Item | Amount |
|---|---|
| EBIT | 80,000 |
| Tax rate | 25% |
| Depreciation | 10,000 |
| Capital expenditures | 30,000 |
| Increase in net working capital | 8,000 |
=80000*(1-25%)+10000-30000-8000 returns $32,000.
Define the term in your workbook. Unlevered FCF is available to debt and equity providers before financing flows; levered FCF is what remains for equity after interest, borrowing and principal repayment. FCFF generally means unlevered FCF, while FCFE means free cash flow to equity. Do not add back depreciation and subtract capital expenditure to an operating-cash-flow figure that already contains those components, or you may double-count.
Rank #3
- HP 10BII+ FOR STUDENTS & PROFESSIONALS – Designed for business, finance, accounting, and statistics courses, this HP calculator helps learners and professionals solve common financial problems quickly—no need to memorize formulas or rely on spreadsheets.
- 100+ FUNCTIONS FOR REAL-WORLD MATH – Easily calculate time value of money, interest rates, loan payments, NPV, IRR, cash flows, and more. The 10bII+ also offers probability distributions for statistics courses, a feature rarely found in financial calculators.
- ALGORITHMIC INPUT WITH DEDICATED KEYS – Uses algebraic and chain logic for efficient calculations with minimal keystrokes. Familiar layout mirrors standard calculators for easy learning, while dedicated keys provide quick access to essential financial and statistical functions.
- APPROVED FOR MAJOR EXAMS – The HP 10bII+ algebra calculator is allowed on SAT, PSAT/NMSQT, and AP tests. Perfect for finance, accounting, and statistics students, it’s an essential tool for classwork, coursework, and standardized exam preparation.
- INCLUDES TRAVEL CASE, CLEANING CLOTH & BATTERIES – Slim and durable, perfect for carrying in a backpack or storing in a locker. Comes with a protective case, cleaning cloth, and batteries, ready to use right out of the box. Large, high-contrast screen (non-backlit) ensures easy readability during exams or lectures.
Example 5: Build a cash-flow forecast
A one-period forecast is:
=Beginning_Cash+Projected_Inflows+Projected_OutflowsWith negative outflows, a forecast containing beginning cash of $20,000, receipts of $35,000, payroll of -$18,000, rent and utilities of -$7,000, and equipment of -$12,000 gives:
=20000+35000-18000-7000-12000Ending cash is $18,000. In a monthly model, use Ending Cash = Beginning Cash + Net Cash Flow and link the next month’s beginning cash to the prior month’s ending cash.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →- Model base, optimistic and pessimistic scenarios.
- Use expected collection dates, not invoice dates.
- Include tax, debt-service and major supplier payment dates.
- Set a minimum-cash threshold and conditional formatting for projected shortfalls.
Microsoft provides business-finance templates and cash-flow projection guidance in Manage business finances and free web templates at Excel templates.
Example 6: Calculate incremental cash flow
Incremental cash flow is the difference between the decision case and the relevant base case:
=Cash_Flow_With_Project-Cash_Flow_Without_ProjectFor additional revenue of $100,000, additional costs of $55,000, taxes of $9,000 and an initial investment of $25,000:
Rank #4
- The spreadsheet design is for accountants or calculator Lover who love to use a software for their budget or bills or need in business for projects. You love Accounting programs and Funny bookkeeping templates? Then you'll love this too!
- Addicted To Spreadsheets
- Two-part protective case made from a premium scratch-resistant polycarbonate shell and shock absorbent TPU liner protects against drops
- Printed in the USA
- Easy installation
=100000-55000-9000-25000The incremental cash flow is $11,000.
Include new or lost revenue, avoided and additional costs, tax effects, working-capital needs, opportunity costs and salvage value. Exclude sunk costs, unchanged costs and allocated overhead that will not change. Include financing effects only when the analysis is explicitly equity-based. A timing change can alter NPV and IRR even when total undiscounted cash is unchanged.
PC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteExample 7: Calculate NPV and discounted cash flow
Regular periods with NPV
| Period | Cash flow |
|---|---|
| Year 0 | -50,000 |
| Year 1 | 15,000 |
| Year 2 | 20,000 |
| Year 3 | 25,000 |
At an 8% rate, if Year 0 is in B3 and Years 1–3 are in C3:E3, use:
=NPV(8%,C3:E3)+B3Excel treats each value supplied to NPV as an end-of-period cash flow. Therefore, add a time-zero investment separately. The usual error is =NPV(8%,B3:E3), which discounts the initial investment by one period. Microsoft’s explanation is available in Calculate NPV and IRR in Excel.
Manual present-value calculation
If a cash flow is in B3, its period number in A3, and the discount rate in $B$1, use:
=B3/(1+$B$1)^A3Sum future present values and add the undiscounted time-zero cash flow. A positive NPV exceeds the selected hurdle rate under the stated assumptions; it is not a guaranteed profit.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitchesBest Value
- DEDICATED FUNCTION KEYS for Quick Financial Solutions: Clearly labeled function keys enable you to quickly and confidently provide financial answers and options for your clients, whether in the office, in the car or at an open house. Compare loan options and provide payment solutions to give your client choices
- INSTANT FINANCIAL PROBLEM SOLVING: Solve the financial questions your clients have whether they are buyers, investors or renters; increase your perceived professionalism and close more home sales by quickly answering real estate finance problems including remaining balances
- RESIDENTIAL REAL ESTATE FINANCE TERMS: Keys labeled in residential real estate finance terms like Loan AMT, Int, Term, PMT; Calculator is super easy to use to determine a mortgage loan that works for your client
- VERSATILE LOAN CALCULATION OPTIONS: Calculate 80:10:10 or 80:15:5 combo loans at the press of a button; check to see if ARMs or bi-weekly loans, quarterly payments or if interest-only payments are the answer; giving your client more choices
- COMES COMPLETE: Comes with a protective slide cover, quick reference guide, pocket user's guide, two long-life batteries, and 1-year warranty
Irregular dates with XNPV
Use XNPV when dates are actual and unevenly spaced. Keep the values and dates ranges aligned and include the initial cash flow in both ranges. For example:
=XNPV(8%,B3:B6,A3:A6)Example 8: Calculate IRR and XIRR
Evenly spaced periods
For the Year 0–Year 3 range above, use:
=IRR(B3:E3)IRR requires at least one negative and one positive value. It is iterative and uses a default 10% guess when no guess is supplied. If necessary, try =IRR(B3:E3,20%). Microsoft documents these behaviors and the possible #NUM! result in its IRR function reference.
Uneven dates
| Date | Cash flow |
|---|---|
| 1/1/2026 | -50,000 |
| 8/15/2026 | 12,000 |
| 3/1/2027 | 20,000 |
| 12/31/2027 | 25,000 |
=XIRR(B3:B6,A3:A6)Use XIRR for irregular dates and IRR only when intervals are regular. Multiple sign changes can create multiple IRRs, and some patterns have no meaningful IRR. When projects differ in size or timing, compare NPV at a common hurdle rate rather than relying on IRR ranking.
Choose the method that answers your question
| Question | Approach |
|---|---|
| How much moved this month? | SUM or SUMIFS |
| What is the ending balance? | Beginning cash plus net cash flow |
| How much do operations generate? | Operating-cash-flow model |
| What remains after reinvestment? | Defined free-cash-flow model |
| What will be available next month? | Cash-flow forecast |
| What changes if a project is approved? | Incremental cash flow |
| Does a project beat the hurdle rate? | NPV or XNPV |
| What return does the cash-flow pattern imply? | IRR or XIRR |
Timing, sign and data-quality checks
- Match rates to periods. A monthly series needs a stated monthly discount convention. For an effective annual rate, an equivalent monthly rate is
=(1+Annual_Rate)^(1/12)-1; a nominal rate compounded monthly is commonly divided by 12. - Keep transfers out of business cash flow. Moving money between two included bank accounts is neither revenue nor an expense.
- Separate debt components. Loan principal received is financing inflow; principal repaid is financing outflow; interest classification depends on the applicable accounting framework and policy.
- Use cash taxes in forecasts. Valuation models may calculate taxes from taxable operating income, which is not always the same timing as cash tax payments.
- Exclude noncash items from a transaction ledger. Depreciation, amortization, impairment and stock compensation may reconcile accounting profit to operating cash flow but are not payments in that period.
- Audit completeness. Check duplicate or missing bank transactions, credit-card purchase date versus payment date, owner contributions versus revenue, restricted cash, foreign-currency conversion and overdrafts.
- Avoid hard-coding. Link formulas to labeled assumptions and source transactions so changes flow through the model.
Fix common formula failures
#NUM! from IRR or XIRR
- Confirm at least one negative and one positive cash flow.
- Put cash flows in chronological order.
- Convert date text into real Excel dates.
- Make the date and value ranges the same size.
- Check that values are not all zero.
- Try a different guess, such as
=XIRR(B3:B8,A3:A8,20%).
Unexpected NPV
- Verify that the time-zero cash flow is outside the regular-period
NPVrange. - Check the rate’s frequency against the cash-flow frequency.
- Check signs, blanks and text values.
- Confirm that the first future flow occurs at the end of the first period.
- Use
XNPVwhen actual dates are irregular.
Unexpected ending cash
- Link each beginning balance to the previous ending balance.
- Exclude internal transfers.
- Include bank fees, taxes, refunds and chargebacks.
- Do not count an invoice before its collection date.
- Check that date criteria include the intended start and end dates.
When Excel is no longer enough
Excel is well suited to a transparent forecast, classroom exercise, one-off project model or small manually maintained dataset. Dedicated accounting software becomes more appropriate when you need automated bank feeds, reconciliations, audit trails, permissions, recurring transactions, tax workflows or formal reports.
Recommended Free Tools
QuickBooks’ cash-flow resources describe accounting reports and provide an Excel template; current plan promotions and prices are date-sensitive, so check its official product finder before buying. For connected reporting inside Excel, LiveFlow’s Microsoft AppSource listing describes integrations with QuickBooks Online and Xero, templates and custom subscription pricing. These tools automate data and reporting; they do not remove the need to define signs, timing and classifications correctly.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
