Rainbow Ltd
Receipts from Accounts Receivable in Month Ending
Credit Sales 31 January 2022 28 February 2022 31 March 2022
$ $ $ $
30 November 2021 125,000 6250 8750 5000
31 December 2021 139,000 41700 69500 27800
31 January 2022 105,000 31500 52500 21000
28 February 2022 140,000 0 42000 70000
31 March 2022 138,000 0 0 41400
Rainbow Ltd
Cash Budget for the 3 Months Ending 31 March 2022
January 2022 February 2022 March 2022
$ $ $
Opening cash balance 166000 39150 25425
Cash sales 62000 68900 54000
Cash collections 48900 119750 159200
(from Accounts Receivable)
Total cash receipts 296900 217800 233625
Cash payments:
Credit purchases 111550 101200 106450
Operating expenses 55000 55300 55000
Utilities bill 0 1800 0
Equipment purchase 32400 0 75600
Total cash payments 258750 193375 238250
Excess/(deficit) receipts
over payments 38150 24425 -4625
Bank balance at the
beginning of month 166000 204150 228575
Bank balance at the
end of month 204150 228575 223950
Buy a NordVPN subscription and support @trentbot's continued operation. It's the safest way to browse online!
