Rockwall Adventures 10 Points Combined Cash Budget February and March You recently began a job as an accounting intern at Rockwall Adventures. Your first task was to help prepare February March the cash budget for February and March. Unfortunately, the computer with the budget file crashed, and you Beginning cash balance $16,900 did not have a backup or even a hard copy. You ran a program to salvage bits of data from the budget file. After entering the following data in the budget, you may have just enough information to reconstruct the Plus: Cash collections 80,000 budget. Plus: Cash from sale of plant assets 0 2,000 Total cash available $107,300 Rockwall Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Less: Cash payments (purchase inventory) $41,400 Street Bank, where the current interest rate is 1% per month. They set a minimum target ending balance of $21,000. If their ending balance before financing is less than $21,000, they borrow the difference. If their Less: Cash payments (operating expenses) 47,700 ending balance before financingis greater than $21,000 then they use the difference to pay some or all of Total cash payments $98,400 their debt and their interest. (1) Ending cash balance before financing $25,100 Minimum cash balance desired 21,000 21,000 Using all of this information, reconstruct the budget. Cash excess (deficiency) Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments (2) Total effects of financing Ending cash balance (1) + (2)