Answered

Welcome to Westonci.ca, the place where your questions are answered by a community of knowledgeable contributors. Get immediate and reliable solutions to your questions from a community of experienced experts on our Q&A platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.

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
Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.