Question

Foyert Corp. requires a minimum $30,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $30,000, and the company has an outstanding loan of $10,000. 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 $ 110,000 $ 80,000 $ 100,000
Cash payments 120,000 75,000 80,000
Prepare a cash budget for October, November, and December. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)

Answer 1

Answer:

From the attached excel file, we have:

a. Ending Cash Balance:

October = $30,000

November = $30,000

December = $34,546

b. Loan Balance End of Month:

October = $20,100

November = $15,301

December = $0

Explanation:

Note: See the attached excel file for the cash budget for October, November, and December.

In the attached excel file, the following calculations are made:

October additional loan = Minimum required cash balance - October Preliminary cash balance = $30,000 - $19,900 = $10,100

November Loan Repayment = November Preliminary cash balance - Minimum required cash balance = $34,799 = $30,000 = $4,799

Download xlsx