Question

The Arkansas Company makes and sells a product called Product K. Each unit of Product K sells for $39 dollars and has a unit variable cost of $24. The company has budgeted the following data for November:
Sales of $1,302,200, all in cash.

A cash balance on November 1 of $64,500.

Cash disbursements (other than interest) during November of $1,310,000.

A minimum cash balance on November 30 of $92,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 2% 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

Answer:

$36,020.40

Explanation:

The computation of cash balance is shown below:-

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

= $64,500 + $1,302,200 - $1,310,000

= $1,366,700 - $1,310,000

= $56,700

Interest = X × 0.02

Cash balance at end = Excess of cash receipts over disbursement + Borrowing - Interest

$92,000 = $56,700 + X - 0.02x

$92,000 - $56,700 = 0.98x

X = $35,300 ÷ 0.98

= $36,020.40