Question

Calculate the additional cash needed for the six months. When there is a cash shortfall (the shortfall/surplus cash calculation is less than zero), additional cash must be obtained from a loan to cover all of the monthly expenses. Therefore, additional cash needed is equal to any cash shortfall. It is zero if there is a cash surplus. The additional cash needed should be a positive number even though a shortfall will be a negative number in the model (row 26). [6 points]

Answer 1

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.