Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You recently began aob as an accounting intem at Randel Adventure. Your first task was to help prepare the cash budget for February and Merch.

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
You recently began aob as an accounting intem at Randel Adventure. Your first task was to help prepare the cash budget for February and Merch. Unfortunately, the computer with the budget le crashed and you did not have a backup or even hard copy. You ran a program to salvage bis of data from the budget fle Alterntering the following data in the budget, you may have just enough information to reconstruct the budget Ciek te onto w information on borrowing cath) Requirements Complete the following contest or amount with a balance, make sure to under grun the appropriate input and Enter canh cuficiencies with a minta sign or parentham. Inter the ret total efects of financing with one when outlow Round interest expense the ) Randel Adventures Combined Cash Budget February and March February 16.00 lleginning a balance Pu Colecione Chrome Towa Chew 5 07.000 300 Et nyambe in the one and then click Check More Info Ed Randell Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Street Bank, where the current interest rate is 7%. Randell Adventures pays interest on its outstanding debt at the end of each month. The company also repays all borrowed amounts at the end of the month as cash becomes available. Print Done i Incomplete budget X Randell Adventures Cash Budget February and March February March Beginning cash balance $ 16,800 $ ? Plus: Cash collections ? 79,900 2,300 0 Plus: Cash from sale of plant assets $ $? Total cash available 107,000 Less: Cash payments (purchase inventory) $ ? $ 47,200 41,300 ? Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing $ 98,000 $ ? $ ? $ 23,000 28,600 23,000 Minimum cash balance desired $? $? Cash excess (deficiency) Print Done i Incomplete budget rius. CasTFITONI Sare ur plant assets $ $ $? 107,000 Total cash available ? 41,300 Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) $?$ 47,200 ? $ $ 98,000 $? Total cash payments (1) Ending cash balance before financing $ ? $ 28,600 23,000 23,000 Minimum cash balance desired $ ? $ ? Cash excess (deficiency) Financing Plus: New borrowings Less: Debt repayments $ ? $? ? 2 ? ? Less: Interest payments $ ? $ $? (2) Total effects of financing $ $ ? $? Ending cash balance (1) + (2) Print Done

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

Current Issues In Auditing Fraternity Modern Auditing And Auditors Issues

Authors: Nancy Myle

1st Edition

B0BCSDPYMD, 979-8849756974

More Books

Students also viewed these Accounting questions

Question

In Problems 916, solve each triangle. 2 45 C 4 b A

Answered: 1 week ago