Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Accounting And Control A Managerial Emphasis

Authors: Sidney J. Gray, Stephen B. Salter, Lee H. Radebaugh

1st Edition

0471128082, 978-0471128083

More Books

Students also viewed these Accounting questions

Question

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago

Question

1. Discuss the main incentives for individual employees.pg 87

Answered: 1 week ago