Bean Counter Cash Forecast

Enter a number between 1 and 12.

Enter Beginning Cash Balance

Enter your estimated percentage of your sales that you receive payment at the time of the sale.

Enter your net balance for the amounts that your customers owe you for and haven't paid. Reduce this amount for any accounts that you have estimated as non collectible. Normally you would calculate this amount by taking your Accounts Receivable Balance and subtracting your Allwance For Uncollectibles Account.

[5]

This table must be filled in if you have entered any Beginning Accounts Receivable in the Cell I73.

[6]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are Current. In other words. amounts that are not yet due to be paid by your customers. Normally this information is obtained from your Accounts Receivable Ageing Report as of the end of your prior year.

[7]

Enter the amount you expect to collect from your current balance
in Month 1.

[8]

Enter the amount you expect to collect from your current balance
in Month 2
.

[9]

Enter the amount you expect to collect from your current balance
in Month 3.

[10]

Enter the amount you expect to collect from your current balance
in Month 4.

[11]

Enter your estimated percentage of your sales on credit that
you collect in the same month of the sale.

[12]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are 1-30 days late. Normally this information is obtained from your Accounts Receivable
Ageing Report as of the end of your prior year.

[13]

Enter the amount you expect to collect from your current balance
in Month 1.

[14]

Enter the amount you expect to collect from your current balance
in Month 2.

[15]

Enter the amount you expect to collect from your current balance
in Month 3.

[16]

Enter the amount you expect to collect from your current balance
in Month 4.

[17]

Enter your estimated percentage of your sales on credit that
you collect one month after the sale.

[18]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are over-30 days late. Normally this information is obtained from your Accounts Receivable
Ageing Report as of the end of your prior year.

[19]

Enter the amount you expect to collect from your current balance
in Month 1.

[20]

Enter the amount you expect to collect from your current balance
in Month 2.

[21]

Enter the amount you expect to collect from your current balance
in Month 3.

[22]

Enter the amount you expect to collect from your current balance
in Month 4.

[23]

Enter your estimated percentage of your sales on credit that
you collecttwo months
after the sale.

[24]

Enter your estimated percentage of your sales on credit that
you collect three months after the sale.

[25]

This total should be
be equal to the check
total to the left in Column I.

[26]

Enter your estimated percentage of your sales on credit that will not be
collected.

[27]

This total should be
100 %

[28]

Enter your Actual Ending Inventory from Prior Year Balance Sheet.

[29]

Enter Actual Sales from Prior Year Income Statement.

[30]

Enter Cost Of Goods Sold from Prior Year Income Statement.

[31]

Enter the beginnin balance for the amounts that you owe your suppliers and haven't paid.

[32]

This table must be filled in if you have entered any Beginning Accounts Payable in the Cell I93.

[33]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable that are Current. In other words. amounts that are not yet due to be paid. Normally this information is obtained from your Accounts Payable Ageing Report as of the end of your prior year.

[34]

Enter the amount you expect to pay on your current balance amount
in Month 1.

[35]

Enter the amount you expect to pay on your current balance amount
in Month 2.

[36]

Enter the amount you expect to pay on your current balance amount
in Month 3.

[37]

Enter the amount you expect to pay on your current balance amount
in Month 4.

[38]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable) that are 1-30 days late. Normally this information is obtained from your Accounts Payable
Ageing Report as of the end of your prior year.

[39]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 1.

[40]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 2.

[41]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 3.

[42]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 4.

[43]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable) that are over-30 days late. Normally this information is obtained from your Accounts Payable
Ageing Report as of the end of your prior year.

[44]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 1.

[45]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 2.

[46]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 3.

[47]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 4.

[48]

This total should be
be equal to the check
total to the left in Column I.

[49]

Enter an Estimated Cost Of Goods Sold as a percentage of Sales if
actual financial data is not available.

[50]

Enter an Estimated Inventory Turnover Rate if actual financial data is not available.
Example: Enter a 12 if your inventory turns over 12 times a year.

[51]

Enter Beginning Inventory Balance as of the begiining month of your projrction.

[52]

Enter your estimated percentage of your purchases that you pay at the time of the purchase.

[53]

Enter the beginning amount of sales tax that is owed.

[54]

Enter your Sales Tax Rate as a percentage.

[55]

Enter your estimated percentage of your purchases on credit that
you pay in the same month of the purchase.

[56]

Enter the percentage of your Sales that are exempt from Sales Tax.

[57]

Enter your estimated percentage of your purchases on credit that
you pay one month after the purchase.

[58]

Enter your estimated percentage of your purchases on credit that
you pay two months after the purchase.

[59]

Enter your estimated percentage of your purchases on credit that you pay three months after the purchase.

[60]

This table must be filled in if you have entered any Beginning Accounts Payable in the Cell I58.

[61]

Enter the beginning amount of other amounts owed.

[62]

This total should be
be equal to the check
total to the left in Column I.

[63]

Enter Current Social Security and Mediacre Tax Rate a a percentage.

[64]

Enter Current Federal Unemployment Tax Rate as a percentage.

[65]

Enter Your Current State Unemployment Tax Rate as a percentage.

[66]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area to the right below each month to identify whether a month has 4 or 5 weeks. This is required information.

[67]