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 2% 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 $32,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 $ 83,000 $ 111,000
August 109,000 97,900
September 148,000 125,400

Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)

Answer 1

Answer:

Mike's Motors Corp.

Cash Budget for July, August, and September:

                                          July           August        September       Total

Beginning balance        $32,000     $30,000         $30,000       $32,000

Cash receipts                  83,000      109,000          148,000       340,000

Bank borrowings            26,000           0                   0                  26,000

Total receipts                 141,000       139,000         178,000      $398,000

Cash Payments              111,000        97,900          125,400        334,300.00

Interest                                                    520                 308.40          828.40

Loan repayment                                 10,580            15,420          26,000.00

Total payments              111,000      109,000            141,128.40    361,128.40

Minimum cash balance 30,000       30,000             36,871.60     36,871.60

Explanation:

a) Data and Calculations:

            Cash  Receipts   Cash  Payments

July            $ 83,000        $ 111,000

August        109,000           97,900

September 148,000          125,400

Minimum cash balance = $30,000

Interest on borrowings = 2% per month

July ending:

Borrowing to maintain minimum cash balance = $26,000

Interest for August = $520 ($26,000 * 2%)

August ending:

Loan balance = $15,420 ($26,000 - $10,580)

Interest for September = $308.40 ($15,420 * 2%)