50.1K

Verified Solution

Link Copied!

ou recently began a job as an accounting internat Regis Adventures. Your first task was to help prepare the cash budget for February and March Unfortunately, the computer with the budget crashed, and you did not have a backup or even a hard copy. You an a program to savage bes of data from the budget te Ahorntoring the following data in the budget, you may have just enough formation to reconoce budget Requirements Complete the following cash dot For mounts with a starcs, make sure to enter in the propriate noted. Enter can deficiencies with a sign or parentheses Enter the root offects of financing with a minus when the amount is a net how Round not expense to eat wholedo) Regis Adventures Cash Budget February and March February $ 16,300 March $ ? Beginning cash balance Plus: Cash collections ? 80,000 2,400 0 Plus: Cash from sale of plant assets $ 106,300 $? $ ? $ 47,600 41,400 ? 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 $ 98,100 $? $? $ 23,000 28,700 23,000 $ ? $? Cash excess (deficiency) Financing Plus: New borrowings $? $ $? $ 16,300 $ ? Beginning cash balance Plus: Cash collections ? 80,000 0 2,400 Plus: Cash from sale of plant assets $ 106,300 $? Total cash available 41,400 $?$ 47,600 ? Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing $ 98,100 $? $ ? $ 28,700 23,000 23,000 Minimum cash balance desired $? $? Cash excess (deficiency) Financing: Plus: New borrowings Less: Debt repayments $? $? ? ? ? ? Less: Interest payments (2) Total effects of financing $? $ ? $? $? Ending cash balance (1) + (2)

Answer & Explanation Solved by verified expert

See Answer