Sales Budget - Part 6

Part 6  -  Determine Your Forecasted Accounts Receivable

An account receivable is a "promise" made by a customer to pay for products or services at a later point in time. Many of us have purchased items on credit, promising to pay for them in the future. Companies offer credit terms as an added service to customers, in an attempt to increase sales. When you, as a consumer, purchase something on credit, the company you purchase the product or service from will consider you an account receivable. If you, as a business owner, allow customers to buy your products on credit, then those customers are considered accounts receivable.

Your task is to forecast the amount of money customers will owe you at the END of each forecasted business year. In our example, Murray's task is to forecast the amount of money customers will owe him on December 31, 200X, and on December 31, 200Y (IE the end of each forecasted business year).

As you might suspect, customers will not owe Murray any money in any month or in any year, since he requires customers to pay him in advance (IE he offers no credit terms to his customers). As a result, Murray's Accounts Receivable on December 31, 200X and on December 31, 200Y will be ZERO. Therefore, his 200X and 200Y Forecasted Balance Sheet will show a ZERO amount in his Accounts Receivable. (Please Note: Accounts Receivable are considered Assets and appear under the Current Assets section of the Balance Sheet).

If your company plans to offer credit to customers, you will need to use the following formula to determine your Forecasted Ending Accounts Receivable.

CALCULATION OF ENDING ACCOUNTS RECEIVABLE:
Forecasted Sales expected during the current year $XXX
Less: Forecasted Cash collected from customers during the current year $(XXX)
Add: Forecasted Accounts Receivable prior to current year $ XXX
Amount Owed to You by Customers ( IE accounts receivable) $ XXX

 

Lets use the above formula to prove that Murray's accounts receivable for December 31, 200X is ZERO. As the formula implies, we need three pieces of information - Murray's total forecasted sales for 200X, the total cash he expects to collect during 200X from customers, and the amount customers owed him at the end of the previous year, namely 200W (IE year 200W).  The first two pieces of information have already been calculated in Part 5 of this budget entitled, "Determining When Customers Will Pay You". Below summarizes these calculations.

MONTH/YEAR Forecasted Sales
each Month
Forecasted Cash Collections
from Customers each Month
July $18,720 $18,720
August $23,920 $23,920
September $24,960 $24,960
October $13,520 $13,520
November $10,400 $10,400
December $12,480 $12,480
TOTALS $104,000 $104,000

 

As you can see, Murray's total forecasted sales for 200X are expected to be $104,000. In addition, Murray's total forecasted cash collections from customers during 200X is expected to be $104,000. Once again, these numbers were taking from Part 5 of this Budget entitled, "Determining When Customers Will Pay You".

The final piece of information needed in order to determine Murray's Forecasted Ending Accounts Receivable is the amount his customers owed him at the end of  200W. Since Murray's first month of operation is scheduled for July of 200X, he would not have had any customers in 200W and therefore, customers would not have owed him any money at the end of 200W.

Now Murray can use the formula to calculate his forecasted accounts receivable for December 31, 200X (IE Ending Accounts Receivable).

FORECASTED ACCOUNTS RECEIVABLE
AS OF DEC. 31, 200X:
Forecasted Sales made during the current year $104,000
Less: Cash collected from customers during the current year $104,000
Add: Accounts Receivable prior to current year $ 0.00
Accounts Receivable as of Dec. 31, 200X $ 0.00

 

A1s stated earlier and as indicated above, customers will not owe Murray any money on December 31, 200X, or at any other time during the year, due to his credit granting policy of 0 days. Now lets use the formula to calculate his Forecasted Accounts Receivable for December 31, 200Y.

Once again, Murray will need three pieces of information before he can calculate his forecasted accounts receivable on December 31, 200Y - 1) his total forecasted sales for 200Y, 2 )his total forecasted cash to be collected during 200Y, and the amount customers owed him at the end of 200X. The first two pieces of information have already been calculated in Part 5 of this Budget entitled, "Determining When Customers Will Pay You". Below summarizes these calculations:

MONTH/YEAR Dollar Sales
each Month
Forecasted Cash Collections
from Customers each Month
January $23,040 $23,040
February $21,120 $21,120
March $17,280 $17,280
April $17,280 $17,280
May $13,440 $13,440
June $9,600 $9,600
July $7,680 $7,680
August $17,280 $17,280
September $15,360 $15,360
October $9,600 $9,600
November $21,120 $21,120
December $19,200 $19,200
TOTALS $192,000 $192,000


As you can see, Murray's total forecasted sales for 200Y are expected to be $192,000. In addition, Murray's total forecasted cash collection from customer during 200Y is expected to be $192,000. Once again, these numbers were taking from Part 5 of this Budget entitled, "Determining When Customers Will Pay You".

The final piece of information needed in order to determine Murray's Forecasted Ending Accounts Receivable is the amount his customers owed him at the end of 200X. Recall from above, Murray forecasted his Accounts Receivable on December 31, 200X will be ZERO ($0.00).

Now Murray can use the formula to calculate his Forecasted Accounts Receivable for December 31, 200Y.

ACCOUNTS RECEIVABLE
AS OF DECEMBER 31, 200Y:
Forecasted Sales made during the current year $192,000
Less: Cash collected from customers during the current year $192,000
Add: Accounts Receivable prior to current year (Dec 31, 200X) $ 0.00
Accounts Receivable as of Dec. 31, 200Y $ 0.00

 

As you can see, Murray's Accounts Receivable on December 31, 200Y is forecasted to be Zero. In other words, Murray's customers will not owe him any money on December 31, 200Y. Therefore, NO Accounts Receivable ($0.00) will appear on his December 31, 200Y Forecasted Balance Sheet under the "Current Assets" section.

Categories: Forecasting