Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You recently begajob in accounting internat Raymond Adventures. Your first task was to help prepare the comh budget for February and March Unfortunately, the computer

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
You recently begajob in accounting internat Raymond Adventures. Your first task was to help prepare the comh budget for February and March Unfortunately, the computer with the budget fle crushed, and you did not have a backup or even a hard copy. You on a program to salvage bis of data from the budget fleAher antering the following data in the budget, you may have just enough information to reconstruct the budget (Click the icon to view Womation on borrowing cash) Requirements Complete the following cash budget. (For amounts with a balance, make sure to or in the appropriate cel Intercanh deficiencies with a minus signer parentheses. Enter the net total effects of financing with a minus sign when the amount is a netoutfow. Found interest expense to the nearest whole dollar) Raymond Adventures Combined Cash Budget February and March February 16.400 5 Beginning cash bence Pas lections Por Cushrome of plants Total cash valle 106.400 47 50 98.00 5 Total cash payments (1) Ending chance before financing Minimum cash balance desired Cathetes ceny Francing 2000 47,500 Less: Cash payments (operating expenses) Total cash payments (1) Ending cash balance before financing $ 98,300 Minimum cash balance desired 21,000 Cash excess (deficiency) Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments (2) Total effects of financing Ending cash balance (1) + (2) Enter any number in the edit fields and then click Check Answer. part More Info Raymond Adventures eliminates any cash deficiency by borrowing the exact amount needed from State Street Bank, where the current interest rate is 7%. Raymond 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. Incomplete budget February and March March February 16,400 Beginning cash balance $ $? Plus: Cash collections ? 0 80,000 1,800 Plus: Cash from sale of plant assets Total cash available $ 106,400 $? Less: Cash payments (purchase inventory) Less: Cash payments (operating expenses) $?$ 47,500 41,200 ? $ 98,300 $? Total cash payments (1) Ending cash balance before financing Minimum cash balance desired $ ? $ 23,500 21,000 21,000 $ ? $? 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

Auditing And GRC Automation In SAP

Authors: Maxim Chuprunov

2013 Edition

3642434525, 978-3642434525

More Books

Students also viewed these Accounting questions

Question

How did you feel about taking piano lessons as a child? (general)

Answered: 1 week ago