Answered

Get reliable answers to your questions at Westonci.ca, where our knowledgeable community is always ready to help. Ask your questions and receive detailed answers from professionals with extensive experience in various fields. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals.

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.

Sagot :

anthougo

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)

We appreciate your time on our site. Don't hesitate to return whenever you have more questions or need further clarification. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Get the answers you need at Westonci.ca. Stay informed by returning for our latest expert advice.