Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Join our platform to connect with experts ready to provide detailed answers to your questions in various areas. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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 hope this was helpful. Please come back whenever you need more information or answers to your queries. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Thank you for trusting Westonci.ca. Don't forget to revisit us for more accurate and insightful answers.