Question

Parker, Inc. has a cash balance of $20,000 on April 1. The company is now preparing the cash budget for the second quarter. Budgeted cash collections and payments are as follows:

April May June
Cash collections 25000 24000 24000
Cash payments:
Purchases of direct materials 4000 5300 6200
Operating expenses 5300 6000 5300
There are no budgeted capital expenditures during the quarter. Based on the above data, calculate the projected cash balance at the end of April.
a. $41,000
b. $35,000
c. $45,000
d. $25,000

Answer 1

$35,700

Step-by-step explanation:

Projected cash balance at the end of April = Cash Balance at the beginning of the month + Total cash collection in the month - Total cash payments during the month

Projected cash balance at the end of April = $20,000 + $25,000 - ($4,000 + $5,300)

Projected cash balance at the end of April = $35,700.