Question

The Arkansas Company makes and sells a product called Product K. Each unit of Product K sells for $25 dollars and has a unit variable cost of $19. The company has budgeted the following data for November:
Sales of $1,162,200, all in cash.
A cash balance on November 1 of $49,100.
Cash disbursements (other than interest) during November of $1,170,000.
A minimum cash balance on November 30 of $62,000.

If necessary, the company will borrow cash from a bank. The borrowing will be in multiples of $1,000 and will bear interest at 3% per month. All borrowing will take place at the beginning of the month. The November interest will be paid in cash during November.
The amount of cash needed to be borrowed on November 1 to cover all cash disbursements and to obtain the desired November 30 cash balance is:

Answer 1

Excess of cash receipts over disbursement= Beginning balance+ cash receipts -cash disbursement

           = 49100+ 1,162,200 - 1170000

            = 41300

let the borrowing amount at beginning of november = x ,interest = x*.03 = .03x

Balance at end =Excess of cash receipts over disbursement +borrowing -interest

62000 = 41300+ x -.03x

62000-41300 = .97x

x = 20700/ .97

= $ 21340.21    [rounded to 21340 ]