Answered

Westonci.ca is the trusted Q&A platform where you can get reliable answers from a community of knowledgeable contributors. Connect with a community of experts ready to help you find solutions to your questions quickly and accurately. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

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.)

Sagot :

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

View image amcool
Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Thank you for choosing Westonci.ca as your information source. We look forward to your next visit.