Question

From the information given below construct a cash budget for five months period starting form May 20X1 till September. MONTH AND YEAR PROJECTED SALES April 20X1 $ 140,000 May 20X1 130,000 June 20X1 90,000 July 20X1 65,000 August 20X1 84,000 September 20X1 95,000 October 20X1 160,000 November 20X1 200,000 December 20X1 240,000 January 20X2 190,000 Total payments 34,700 30,400 41,500 59,000 88,500 110,000 Additional information: a) Assume that minimum cash balance as $ 10,000 and same balance has to be maintained throughout the planning period. b) 100 % percent of sales are credit basis. 80 percent of the accounts receivables are collected in one month, 10 percent during the second month of sale, 5 percent during the second month of sale and remaining during the fourth month of sale.

Answer 1

Cash Surplus May $83,300 June $ 61,600 July $33,000

Aug $25,500 Sept $ 3650

Step-by-step explanation:

MONTH AND YEAR PROJECTED SALES FIRST MONTH

COLLECTIONS (80%)

April 20X1 $ 140,000 112,000

May 20X1 130,000 104,000

June 20X1 90,000 72,000

July 20X1 65,000 52,000

August 20X1 84,000 67,200

September 20X1 95,000 76,000

October 20X1 160,000 128,000

November 20X1 200,000 160,000

December 20X1 240,000 192,000

January 20X2 190,000 152,000

First we find the monthly cash collections 80 % in the month of sales , 10% in the second month , 5% in the third and 5 % in the fourth . We have summed them up in the following table.

Sales Collections

MAY JUNE JULY AUGUST SEPT

Particulars

1st Month 104,000 72,000 52,000 67,000 76,000

Collections

2nd Month 14,000 13,000 9000 6500 8400

3rd Month 7000 6500 4500 3250

4th Month 7000 6500 4500

Total

Collections 118,000 92,000 74,500 84,500 92,150

Now we prepare the cash budget deducting payments from collections and maintaining beginning and ending balance.

Cash Budget

MAY JUNE JULY AUGUST SEPT

Particulars

Opening 10,000 10,000 10,000 10,000 10,000

Add Total

Collections 118,000 92,000 74,500 84,500 92,150

Less Closing 10,000 10,000 10,000 10,000 10,000

Less Payments34,700 30,400 41,500 59,000 88,500

Cash Surplus 83,300 61,600 33,000 25,500 3650