Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

At December 31, the balance sheet of Rodriguez Malting Company was the following (in thousands):Cash $ 50 Accounts receivable 530 Inventories 545Current assets Net fixed

At December 31, the balance sheet of Rodriguez Malting Company was the following (in thousands):Cash $ 50 Accounts receivable 530 Inventories 545Current assets Net fixed assets Total assets$1,125 1,836$2,961 The company has received a large order and anticipates the need to go to its bank to increase its borrowings. As a result, it needs to forecast its cash requirements for January, February, and March. Typically, the company collects 20 percent of its sales in the month of sale, 70 percent in the subsequent month, and 10 percent in the second month after the sale. All sales are credit sales. Purchases of raw materials to produce malt are made in the month prior to the sale and amount to 60 percent of sales in the subsequent month. Payments for these purchases occur in the month after the purchase. Labor costs, including overtime, are expected to be $150,000 in January, $200,000 in February, and $160,000 in March. Selling, administrative, tax, and other cash expenses are expected to be $100,000 per month for January through March. Actual sales in November and December and projected sales for January through April are as follows (in thousands): November December January$500 February $1,000 600 March 650 600 April 750On the basis of this information:

a. Prepare a cash budget for the months of January, February, and March.

b. Determine the amount of additional bank borrowings necessary to maintain a cash balance of $50,000 at all times. (Ignore interest on such borrowings.)

c. Prepare a forecast balance sheet for March 31. (It should be noted that the company maintains a safety stock of inventory and that depreciation for the three-month periodis expected to be $24,000.)

Step by Step Solution

3.43 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

Quiz a Cash budget January Cash receipts 20 of January sales 500000 100000 70 of December sales 600000 420000 10 of November sales 1000000 100000 Tota... 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

Modern Advanced Accounting In Canada

Authors: Hilton Murray, Herauf Darrell

7th Edition

1259066487, 978-1259066481

More Books

Students also viewed these Accounting questions