Answer:
the numbers are missing, so I looked for a similar question:
Vince's Blinds will have cash receipts of $97,000 and cash disbursements of $108,000. If its beginning cash is $5,000 and its desired reserve is $2,000, what will be its shortfall in cash for the month?
You have to repeat the same procedure for the following months. The ending balance of month 1 becomes the beginning balance of month 2, and so on. For month 2 we can flip the cash receipts and disbursements:
Month 1 Month 2 Month 3
Beginning cash balance $5,000 $2,000 $5,000
Cash receipts $97,000 $108,000 ....
Cash disbursements ($108,000) ($97,000)
Net balance ($6,000) $13,000
Cash from loan $8,000 ($8,000)
Ending cash balance $2,000 $5,000
Depending on the numbers that you have, you should be able to complete the 6 months and then just add the cash from loans.
