Answer :
Answer:
Ending cash balance for November = $52,869
Explanation:
Crane Company
Cash Budget
October
November
beginning cash balance
$16,000
$40,539
expected cash receipts
$63,000
$95,000
Total available cash
$79,000
$135,539
expected cash payments
$45,000
$76,000
excess of available cash over payments
$34,000
$59,539
financing:
Borrowings
$6,539
$0
Repayments
$0
($6,539)
Interest
$0
($131.00)
Ending cash balance
$40,539
$52,869
The ending cash balance shortfall in October $40,539 - $34,000 = $6,539
Hence, the amount to be borrowed = $6,539
In November, the company has enough funds to meet its ending cash balance as well as pay-off the borrowed amount with interest.
Interest for 2 month = 6,539 x 12% x 2/12 = $130.78 or $131 (rounded off)
Note: cash is borrowed in the first day of the month, assuming the company borrows cash on October 1, and repays on November 30, interest is payable for two months.
The ending cash balance for Crane Company in the month of November, after the repayment of loans is $52,936.
Data and Calculations:
October November
Beginning Cash Balance $16,000 $40,438
Expected Cash Receipts $63,000 $95,000
Overdraft 6,438 0
Total Receipts $85,438 $135,438
Expected Cash Payments $45,000 $76,000
Repayment of overdraft 6,438
Interest on overdraft 64.40
Total Payments $45,000 $82,502.40
Minimum cash balance $40,438 $52,935.60
Interest on overdraft = $64.40 ($6,438 x 12% x 1/12)
Thus, the ending cash balance for November is $52,936.
Learn more: https://brainly.com/question/8707644