February March Beginning cash balance Plus: Cash collections Plus: Cash from sale of plant assets Total cash available Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing Minimum cash balance desired Cash excess (deficiency) Financing 16,900 80,000 2,000 S 107,300 $ $ 41,400 47,700 98,400 S?S 25,100 21,000 21,000 Plus: New borrowings Less: Debt repayments Less: Interest payments (2) Total effects of financing s. Your first task was to help prepare the cash You recen y began ob as an accounting rter at Rock all Adventure budget fo Februar and March Un ortunate the computer with he budget crashed, and you did not have backup or even a hard copy You ran a pregram to salvage bits of data from the budgct e After cntering the following data in the budget, you may have just enough information to reconstruct the budget d not have a (Click the icon to view informiation on borrowing cash) Requirement Complete the tallowing cash budget (For amounts with a SO balance, make sure to enter "D in the appropriate cell Enter cash deticiencies with a minus sign or parentheses Enter the net total ettects ot financing with a minus sign when the amount is a net outflow. Round interest expense to the nearast whole dollar) interest e Rockwall Adventures Combined Cash Budget February and March February Beginning cash balance Plus: Cash collections Plus: Cash from sale of plant assets Total cash available Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing 16,900 107,300 47,700 98,400 (1) Ending cash balance before financing Minimum cash balance desired Cash excess (deficiency) Financing: 21,000 Plus: New borrowings Less: Debt repayments Less: Interest payments (2) Total effects of financing Ending cash balance (1) (2)