Answer and Explanation:
The presentation of the cash budget for the three months is shown below:
Particulars April May June
Beginning
cash balance $182,000 $264,650 $434,150
Add:
Cash receipts :
Credit sales
collections $577,750 $622,700 $621,650
Total cash
available $759,750 $887,350 $1,055,800
Less:
Cash disbursements
Purchases -$289,000 -$302,000 -$282,000
Wages, Taxes
and expenses -$137,000 -$129,000 -$179,000
Interest -$15,600 -$15,600 -$15,600
Equipment
purchases -$53,500 -$6,600 -$248,000
Total
cash disbursements -$495,100 -$453,200 -$724,600
Ending
cash balance $264,650 $434,150 $331,200
Working Notes:
Cash collection from credit sales
Particulars March April May June
Credit sales $561,000 $689,000 $598,000 $751,000
Cash collected :
35% cash collected
in month of sales $196,350 $241,150 $209,300 $262,850
60% cash collected
in following month
of sales $0 $336,600 $413,400 $358,800
Total cash
collected from sales $577,750 $622,700 $621,650
