Answer:
Option (c) is correct.
Explanation:
January:
Total cash available:
= cash balance at beginning - Budgeted cash collections
= $50,000 + $100,000
= $150,000
Total cash payments(budgeted cash payments) = $127,000
Closing cash balance:
= Total cash available - Total cash payments + Borrowings
= $150,000 - $127,000 + $0
= $23,000
February:
Total cash available:
= cash balance at beginning - Budgeted cash collections
= $23,000 + $80,000
= $103,000
Total cash payments (budgeted cash payments) = $165,000
Closing cash balance = Total cash available - Total cash payments + Borrowings
$10,000 = $103,000 - $165,000 + Borrowings
Borrowings = $175,000 - $103,000
= $72,000
March:
Total cash available:
= cash balance at beginning - Budgeted cash collections
= $10,000 + $75,000
= $85,000
Total cash payments (budgeted cash payments) = $92,000
Closing cash balance = Total cash available - Total cash payments + Borrowings
$10,000 = $85,000 - $92,000 + Borrowings
Borrowings = $102,000 - $85,000
= $17,000