Cash Flow Calculator - For Forecasting and Analysis

Cash Flow Calculator

Cash flow analysis can be difficult because income and expenses occur at irregular intervals making it hard to get a true statement of net cash flow.

This calculator works for both business and personal finances to project your monthly and annual net cash flows. It converts all the irregular payments into monthly equivalents so you can budget and know your free cash flow position with confidence.

Simply complete each of the six sections and the calculator will automatically forecast the cash flow analysis. To figure a budget you can just go back and edit your entries until your projections look acceptable then click on the "Create Report" button at the bottom of the worksheet for a printable report.


Cash Inflows
Example Accounts	Inflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Your Primary Job Spouse's Primary Job Your Second Job Spouse's Second Job Your Business Revenues Spouse's Business Revenues Interest & Dividend Income Rental Income Cash Gifts Gambling Winnings Rummage Sale Receipts Tax Refund







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Inflow:
Administrative Outflows		Balance Forward:
Example Accounts	Outflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Savings Deposits Investment Deposits Office Supplies Postage Basic Phone Tax Preparation Computer Supplies Legal Expenses Misc. Payments Brokerage Fees Income Tax Payments Health Insurance Life Insurance Charitable Gifts Tools Reference Materials Classified Ads







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Adminsitrative Outflow:
Personnel Outflows		Balance Forward
Example Accounts	Outflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Groceries Vegetable Gardening School Lunches Toiletries & Grooming Hair & Make-up Medical, Dental, & Optical Medication & Prescriptions Clothing & Laundry Dry Cleaning Education Daycare Child Support Health Club Memberships Therapy







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Personnel Outflow:
Transportation Outflows		Balance Forward
Example Accounts	Outflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Gasoline Car Repairs & Maintenance Car Insurance Car Payments Lease Payments Fares and tolls Parking Licenses & Permits Fines & Tickets







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Transportation Outflow:
Residential Outflows		Balance Forward
Example Accounts	Outflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Grounds Maintenance Building Repairs & Maint. Cleaning Supplies Furniture & Fixtures Appliances Pest Control Interior Decorating Rent or Lease Payments Mortgage Payments Property Taxes Propane, Fuel Oil, & Wood Electricty Property Insurance Snow Removal Alarm Systems







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Residential Outflow:
Entertainment Outflows		Balance Forward
Example Accounts	Outflow Description	# of Pmts Per Year	Amt of Each Pmt	Monthly Amount
Movies & Theatrical Long Distance Calls Vidio & Movie Rental Cable & Satelite Sporting Events & Activities Hobbies & Crafts Games, Arcade, and Amusement Parties & Entertaining Gifts Dining Out Nightclubs Gambling Pets & Pet Supplies Music Vacation Propery Payments Vacation & Travel







Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals


	Total Monthly Entertainment Outflow:
Summary of Cash Flows
Links	Category		Outflows	Inflows
Instructions Inflows Administrative Personnel Transportation Residential Entertainment Totals	Monthly Inflow
	Monthly Administrative Outflow
	Monthly Personnel Outflow
	Monthly Transportation Outflow
	Monthly Residential Outflow
	Monthly Entertainment Outflow

	Total Monthly Outflows
	Net Cash Flow