Cash Operating Expense Payments Worksheet

Instructions

This worksheet is where you enter your other cash payments.

The worksheet provides you with two methods for entering your estimates.

(1) The first method allows you to enter estimate amounts for 4 week and 5 week periods OR

enter a percentage of sales to use to calculate the expense. This information is then transferred

to the Cash Projection Worksheet and entered in each of the monthly columns based on the

percentage entered or whether the amounts entered represent a 4 week or 5 week period.

If entering amounts, both the 4 Week and 5 Week amounts need to be entered.

The percentage of sales figures or the monthly estimated amounts are entered in

the Estimated Monthly Totals Table.

(2) The second method allows you to enter amounts for each of the months that you are estimating.

This information is entered in the Estimate Each Month Table.

You can combine the two methods and enter some disbursements as a percentage or monthly

four (4) and five (5) week periods in the Estimated Monthly Totals Table and enter other data individually

for each month in the Each Month Table or you can enter all your data in either table.

Do not enter data for the same type of payment in both tables. In other words if you use the Estimated Monthly Totals Table to enter your Salaries and Wages

Estimate don't also enter Salaries and Wages in the Estimate Each Month Table.

Enter Your Estimates in the Yellow Highlighted Areas of the tables.

Additional space has been provided in the table below for you to add up to 25 additional expenses that you want to include..

Add your new categories to the yellow highlighted portion of the Estimated Monthly Totals Table. These same categories

are automatically added to your Estimate Each Month Table. The added categories will then be displayed and available to use

to enter data for the new categories in both tables.

Introduction

CashProjection Worksheet

Sales Forecast Worksheet

Weekly Forecast Worksheet

Charts Worksheet

Cash Operating ExpensePayments

Estimated Monthly Totals Table

This is a quick method for entering your estimated cash operating payments (expenses).

Enter an amount for both a 4 week and 5 week period OR a percentage of sales amount

for any or all of the listed payment types. Items not entered in this table should be entered in the

Estimate Each Month Table. If you enter amounts or a percentage for a category in this sheet

don't also enter an amount for the same category in the Estimate Each Month Table.

If you want to add some additional payment categories, add the new categories in the

yellow highlighted portion of the table below.

Note: Categories added in this table are also automatically added to the Estimate Each Month Table.

4-Week

5-Week

Percentage

Period

of Sales

Cash Operating Expense Payments

Salaries and Wages

Employee Benefits

Worker's Compensation

Rent-Property

Rent-Equipment

Utilities

Repairs and Maintenance

Insurance

Car & Truck Expenses

Travel

Entertainment

Telephone

Postage

Office Supplies

Advertising

Marketing/Promotion

Professional Fees

Training and Development

Bank Charges

Credit Card Fees

Miscellaneous

Total Monthly Cash Operating Expense Disbursements

Estimate Each Month Table

This method requires the user to enter the estimated amounts for the number.

of periods that the user wants to prepare an estimate for. The number of periods

that need to be entered is the number of periods that you entered in the

Cash Projection Worksheet and appears at the top of the worksheet.

If you enter amounts for a category in this sheet don't also enter an amount

for the same category in the Estimated Monthly Totals Table.

Estimate Each Month Table

Number Of Periods Needing To Be Entered:

Cash Operating Expen

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12

Total