Forecasting Cash Flow

Forecasting Cash Flow

How to Download a Worksheet
No information you provide on this form is stored by this or any other website. You may enter information directly into this form, but....IF YOU WISH TO RETAIN THE INFORMATION, DOWNLOAD THE FORM TO AN APPROPRIATE FILE ON YOUR SYSTEM. Use the download button at the bottom right of the form.

Two models -- 6-week and 6-month

If projected Ending Cash is negative, do something about it NOW!!

Instructions (Period = week or month)

  1. Enter the first day of the first period using the format MO/DY/YR   (08/01/XX)
  1. Go to the “Cash In from Projects” page.
  2. Enter at “Project Name” the names of Projects currently under construction and at “Prospect Name” the Projects projected to start in the next six periods.
  3. At “$ Remain”, enter the amount remaining on the construction contract. At “Estimate $”, enter the estimate amount.
  4. Enter the cash flows expected from those projects in the appropriate period.
  5. Totals are automatically entered in the summary sheet.
  1. Add up all sources of cash in the Company  (checking, savings, petty cash, etc.) and enter in the first period.  Other periods will be computed automatically.
  1. Enter the amount of current Accounts Receivable you expect to receive in this and in the coming periods.
  1. Enter any anticipated proceeds from the sale of an asset.
  2. Enter any capital to be contributed by the Owner.
  3. Enter any anticipated proceeds from loans or lines of credit.
  1. Enter Current Accounts Payable.
  2. Enter Cost Of Goods Sold (COGS) as a percentage of revenue.  This number should be available on P&L statement or can be calculated by dividing COGS by Revenue. Default is 78%.
  3. Enter the percent of invoiced COGS that will be paid this period.  Default is 20% for the weekly analysis and 50% for the monthly analysis.
  1. The total of the Accounts Payable will be entered in the current period by default.
  2.  Enter the amount of Accounts Payable you expect to pay in the next periods in the out-period spaces.
  3. The amounts you enter will be deducted from the initial period Accounts Payable total.
  1. Enter Payroll for each period.
  2. Enter all Other Expenses. Use the General and Administrative (G&A) section of the P&L statement. Back out Payroll and Loan Payments, which have their own entries.  This number should be relatively static, so extend to all six periods.  Add or subtract if you know any period is going to be unusual.
  3. Enter the cash required for any anticipated asset purchases. If you are financing a purchase (like a truck), only enter the down payment.
  4. Enter any anticipated withdrawals by the Owner.
  5. Enter the total of all periodic payments to Lenders.
Scroll to Top