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

Answer:

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

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)