Answered

Welcome to Westonci.ca, your go-to destination for finding answers to all your questions. Join our expert community today! Discover the answers you need from a community of experts ready to help you with their knowledge and experience in various fields. Get immediate and reliable solutions to your questions from a community of experienced professionals on our platform.

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)

Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. We're glad you chose Westonci.ca. Revisit us for updated answers from our knowledgeable team.