Answer:
Ending Cash Balance as are follows:
January = $40,000
February = $67,535
March = $40,000
Also, Loan Balance End of Month as follows:
January = $26,500
February = $0
March = $38,465
Explanation:
Note: See the attached excel file for the cash budget.
In the attached excel file, the following calculations are made:
January loan repayment = January Preliminary cash - January Interest expense - Minimum required cash balance = $94,300 - $800 - $40,000 = $53,500
February Loan repayment = January Loan Balance End of the Month = $26,500
March Additional Loan = Minimum required cash balance - March Preliminary cash balance = $40,000 - $1,535 = $38,465
From the attached excel file, we have Ending Cash Balance as follows:
January = $40,000
February = $67,535
March = $40,000
And also, Loan Balance End of Month as follows:
January = $26,500
February = $0
March = $38,465