Foyert Corp. requires a minimum $6,800 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $6,800 and the company has an outstanding loan of $2,800. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow.

October November December

Cash receipts $22,800 $16,800 $20,800

Cash payments 25,200 15, 800 15,200

Prepare a cash budget for October, November, and December.

Question

Business

Malik Payne

9 May, 05:20

Foyert Corp. requires a minimum $6,800 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $6,800 and the company has an outstanding loan of $2,800. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow.

October November December

Cash receipts $22,800 $16,800 $20,800

Cash payments 25,200 15, 800 15,200

Prepare a cash budget for October, November, and December.

+3

Answers (1)

Know the Answer?

Landen Newman · Answer 1

Answer&Explanation

october november december

beginning 6,800 6,800 6,800

receipts 2,800 16,800 20,800

payment - 25,200 - 15,800 - 15,200

interest - 28 - 252.28 - 244.8028 (beginning finance x 1%)

pre-finance - 15,628 7,548 12,155

minimun 6,800 6,800 6,800

Finance

beginning 2,800 25,228 24,480

payment/loan 22,428 - 748 - 5,355 (pre-finance - minimun)

ending 25,228 24,480 19,125

ending cash 6,800 6,800 6,800 (pre-finance + loan/repayment)