$($Preparation of a cash budget$)$ Harrison Printing has projected its sales for the first eight months of $2014$ ss follows: $,$

b$.$ Harrison has a $$199,100$ note due in June. Will the firm have sufficient cash to repay the loan?

Complete $($month by month$)$ the cash budget for the most likely case scenario below: $($Round to the nearest dollar.$)$

Ssles

Cash Receipts

Sales for cash $(20\%)$

First month after sales $(50\%)$

Second month after sales $(30\%)$

Total Cash Receipts

Cash disbursements

Raw materials

Rent

Other expenditures

Tsx prepsyments

Total Cash Disbursements

Net Change in Cash

Net change in cash for period

$(+)$ Beginning cash balance

$(-)$ Interest on short$-$term borrowing

$(-)$ Short$-$term borrowing repsyments

$(=)$ Ending cash balance b$/$

borrowing

New Financing Needed

Financing needed for period

Ending cash balance

Cumulative borrowing

Data table

$

$

$$r$

$

$ $21,000s$