Question

Mike's Motors Corp. manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement, at a cost of 3% interest per month (paid at the end of each month). Any cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $41,000, and the company has no outstanding loans at that time. Forecasted cash receipts and forecasted cash payments (other than for loan activity) are as follows.

Cash Receipts Cash Payments
July $92,000 $120,000
August 118,000 106,900
September 157,000 134,400

Required:
Prepare a cash budget for July, August, and September.

Answer 1

Mike's Motors Corp.

Cash Budget

July August September

Beginning balance $41,000 $30,000 $30,000

Cash receipts 92,000 118,000 157,000

Total cash available $133,000 $148,000 $187,000

Cash payments 120,000 106,900 134,400

Interest/Loan repayment 11,100 6,602

Cash balance 13,000 30,000 45,998

Cash to borrow 17,000 0 0

Minimum cash balance $30,000 $30,000 $30,000

Step-by-step explanation:

a) Data and Calculations:

Minimum cash balance = $30,000

Interest rate on borrowings = 3% per month

Beginning cash balance = $41,000

Cash Budget

July August September

Beginning balance $41,000 $30,000 $30,000

Cash receipts 92,000 118,000 157,000

Total cash available $133,000 $148,000 $187,000

Cash payments 120,000 106,900 134,400

Interest/Loan repayment 11,100 6,602

Cash balance 13,000 30,000 45,998

Cash to borrow 17,000 0 0

Minimum cash balance 30,000 30,000 30,000

Loan repayment:

In August:

Interest is paid = $510 ($17,000 * 3%)

Loan is repaid = 10,590

Total paid = $11,100

Balance of loan unpaid = $6,410 ($17,000 - 10,590)

In September:

Interest on loan = $192 ($6,410 * 3%)

Loan repaid = 6,602 ($6,410 + 192)