If projected Ending Cash is negative at any point in the future, do something about it NOW!!
Look six weeks into the future to anticipate cash flow problems.
At the “CASH BALANCES” window, enter the first day of the current period at the “As of” cell using the format MO/DAY/YR (08/01/XX)
Enter names and balances for all Checking and Savings accounts. If applicable, also identify Other Cash available.
Totals will be calculated automatically and transferred to other sections of the worksheet.
Go to the “Project/Prospect Info” section.
Current Projects:
Enter at “Project Name” the names of Projects currently under construction.
At “$ Est + COs”, enter the current amount of the construction contract plus any executed Change Orders.
At the “Paid-to-Date” section, enter the total amount the customer has paid on the project.
Prospects:
Enter at “Prospect Name” the Projects projected to start in the next six periods.
Select the status of the prospect.
Enter the anticipated Start Date.
Enter the projected $ of the budget.
Totals are automatically entered in the summary sheet.
The “Revenue Funnel” sums the potential revenue available from contracted jobs and strong prospects.
Go to the “Six-Week Production Projections” section.
Current Projects:
Enter at anticipated weekly production for each project.
Prospects:
If the Prospect will become a customer in the next six weeks, enter the anticipated weekly production for that Prospect.
At “A/R Receipts”, enter the amount of current Accounts Receivable you expect to receive in this and in the coming weeks.
At “Milestone Billings”, enter the anticipated contract billing you will receive per the outstanding contracts.
Enter any anticipated proceeds from the sale of an asset.
Enter any capital to be contributed by the Owner.
Enter any anticipated proceeds from loans or lines of credit.
Enter Current Accounts Payable.
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.
Enter the percent of invoiced COGS that will be paid this period.
The total of the Accounts Payable will be entered in the current period by default.
Enter the amount of Accounts Payable you expect to pay in the next periods in the out-period spaces.
The amounts you enter will be deducted from the initial period Accounts Payable total.
Enter Payroll for each period.
Enter all Other Expenses. Use the General and Administrative (G&A) section of the P&L statement. Do not include 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.
Enter the cash required for any anticipated asset purchases. If you are financing a purchase (like a truck), only enter the down payment.
Enter any anticipated withdrawals by the Owner.
Enter the total of all periodic payments to Lenders.
This line shows the weekly performance of the cash accounts.
It measures the net cash flow for the period.
This line shows a projection of the balance of the cash accounts at the end of the weekly period.
You are watching for negative balances and should act when a negative balance is projected.
You can:
Slow down the payment of Accounts Payable;
Delay regularly scheduled payments;
Accelerate Accounts Receivable;
Increase Owner’s Contribution, or Additional Paid-In Capital, if resources are available;
Increase borrowings on established lines of credit;