If someone could help me solve for February and March cash budget sheet that would be amazing! I am a little confused. Thank you so much in advanced!
You recently began a job as an accounting intern at Rocky Avventures. Your first task was to help prepare the cash budget for February and March. Unfortunately, the corrputer with the budget file crashed, and you did not have a backup or even a hard copy. You ran a program la salvage bils of cala from the buuget lie. After entering the folosing dala in the budgel, you may have just enough information to reconstruct the budgel. Click the icon to view infomation on borrowing cash.) Requirements Incomplete budget Corrplele lhe folosing cast budge. (For armounts with a $0 balance, inake sure to eriler "O' in the appropriale inpul field. Enter cash deficiencies with a minus sign or parentheses. Enter the ne expense to the nearest whole dollar) More info Rocky Adventures Cash Budget February and March February and March February February March Rocky Adventures eliminates any cash deficiency by botuwing the exact amount needed from Stale Street Bark, where the current interest rate is 6%. Rocky Adventures pays interest an its outstanding debt at the end of each month. The company also repays al borrowed amounts al the end of the month as casti becomes available. $ S 18.700 S? 16,700 90400 0 Beginning cash balance Plus: Cash collections 2 79,700 2.400 0 $ 107 100 S $ 107.100 Print Beginning cash balance Plus. Cash collections Plus: Cash for sale of plant assets Total cash available Less: Cash peyments (purchase inventory Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing Minimum cash balance desired 59200 Done 41,500 ? 47,900 99 200 Plus: Cash from sale of plant assets Total cash available Lees: Cash payments (purchase Inventory) Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing Minimum cash balance desired 32S 47.900 s $ 99,200 S? 26.000 23,000 $? S 23.000 22.000 3 S? Cash excess (deficiency) Financing: Plus: New borrowings Less: Debt repayments $? Cash excese (uliclunay) Finanang: Plus: New borrowinge Less: Debl repayments Lass: Interest payments 12) Total effects of financing Ending cash balance (1) (2) (1+ S? ? 2 7 Less: Interest payments S? 12] Total effects of financing S2 Help me solve this Video Get more help Print Done
