verismall
File Download Portal

Whats NewMost popularterms and conditionsAbout UsContact Us

 
Home Page > Budgeting > Cash Flow Planning for Services
Cash Flow Planning for Service Companies
How much are you receiving and spending?

screenshot

File Size: 39 KB
Date Added: June 2003
Requirements: Microsoft Excel 97 and higher

screenshot

download

Description
This Excel spreadsheet has been developed following requests from customers who used our free Cash Flow Planner and wanted something similar for their business.  The user can update all text and values in blue.  Black text and values contain formulas and should not be changed.  As the user enter amounts the results are automatically calculated.

The spreadsheet contain a new section for cash and credit fees estimation.  Together with the debtor days figure it can calculate how much money you will receive in debtor account payments for each month.  Detail of how the debtor receipts and debtor balances are calculated are also shown at the bottom of the spreadsheet.

Cash receipts include money received for fees that are settled in cash, receipts from debtors, capital deposits, loans and interest received.  Cash payments include both normal service expense items as well as installments on financing and payments for capital assets.  We have tried to include a wide variety of service expense items under payments.  You may also change the description of the items in blue text.

The total receipts, total payments, net cash flow and expected bank balance for each month is automatically calculated.  The spreadsheet is preformatted to be printed.

Features:
  • Fee income estimation
  • Automatic debtor payment estimation
  • Capital and income receipts
  • Capital and expense payments
  • Net cash flow per month calculated
  • Expected bank balance calculated
Customer Reviews
none

Copyright 2014 Francois Andlau  -  all rights reserved