Prepare a cash budget for the months of january and february

Assignment Help Financial Accounting
Reference no: EM13897935

At December 31, the balance sheet of Rodriguez Malting Company was the following (in thousands):

Cash

$ 50

Accounts payable

$ 360

Accounts receivable

530

Accrued expenses

212

Inventories

545

Bank loan

400

Current assets

$1,125

Current liabilities

$ 972

Net fixed assets

1,836

Long-term debt

450



Common stock

100


 

Retained earnings Total liabilities and

1,439

Total assets

$2,961

shareholders' equity

$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 $500

February $1,000

December 600

March 650

January 600

April 750

On 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.

c. Prepare a projected Income Statement for the months of January, February and March

d. Prepare a forecast balance sheet for March 31.

Reference no: EM13897935

Questions Cloud

Determine impeller diameter : A lime-soda softening plant treats a flow of 150 MGD, and the water has 86 mg/l CO2. The commercial grade of quicklime has a purity of 85% and the soda ash has a purity of 95%. Determine: The pounds of quicklime and soda ash required per million ga..
What is the probability that the option will be exercised? : What is the probability that the option will be exercised?
What is the present worth the given investment : Uncle Wilbur's trout ranch is now for sale for $30,000. Annual property taxes, maintenance, supplies, and so on are estimated to continue to be $3,000/year. What is the present worth the investment?
What sort of transactions should mary undertake in order : What sort of transactions should Mary undertake in order to hedge
Prepare a cash budget for the months of january and february : Prepare a cash budget for the months of January, February, and March. Determine the amount of additional bank borrowings necessary to maintain a cash balance of $50,000 at all times.
What is the npv of the given investment : Rocky Mountain's tax rate is 34 percent, and its opportunity cost of capital is 10 percent. What is the NPV of this investment?
Describe the image receptor response curve for cr : General information about the use of intensifying screens in radiology, and how films intended for use with intensifying screens differ from non-screen films. Describe the image receptor response curve for CR
What effects switching the solvents t water : Clearly and unambiguously show what effects switching the solvents t water would have on the reaction coordinate diagram.
When hbr is neutralized with koh, what salt is produced : How many milliliters of 1.00 M NaOH are required to completely neutralize 100.0mL of 0.500 M H3PO4 and What is the molarity of a solution that contains 32.0 g of HCl in 2.50 L of solution?

Reviews

Write a Review

 

Financial Accounting Questions & Answers

  Calculate the cost of goods transferred to the finished good

From this information, calculate the cost of goods transferred to the Finished Goods Inventory account, the cost remaining in the Work in Process Inventory account, and the total costs to be accounted for. Use the FIFO costing method.

  What is operating income of both divisions together

Assume 200 barrels are transferred from the Production Division to the Refining Division for a transfer price of $6 per barrel. The Refining Division sells the 200 barrels at a price of $40 each to customers. What is operating income of both divis..

  Difference between an associate and a subsidiary

What is the difference between an "Associate" and a "Subsidiary"? Give an example in your answer. And what is Goodwill and when is that applie

  Choosing the method of depreciation with 30 tax rate

choosing the method of depreciation with 30 tax rate straight line or double declining depreciation.the capital company

  Why does an intra-entity sale of a depreciable asset

Why does an intra-entity sale of a depreciable asset (such as equipment or a building) require subsequent adjustments to depreciation expense within the consolidation process?

  Inventory item class used to add comments to invoices

The inventory item class used to add comments to invoices is called the:

  Q1 on 28th june 2011 a corporation sold an apartment

q1. on 28th june 2011 a corporation sold an apartment building for 150000 exclusive of the land. the building

  Is the company too reliant on long-term debt financing

All questions pertain to Home Depot 1. Does the company's management appear to be managing debt properly? Is the company too reliant on long-term debt financing?

  Act similar to the sarbanes-oxley act

Do you think that other types of organizations should have an act similar to the Sarbanes-Oxley Act? Why or why not? Should the government, nonprofits, and private companies be held to the same or similar standards? Or is it too costly and time-consu..

  Constitute unethical behaviour

Mr Phillips accepted the quote from Mr Hudson after he and Mr Dwight spent a delightful week with Mr Hudson on the latter's private island off the coast of Mozambique.

  Consider a 125 mile stretch of a roadway of homogeneous

consider a 1.25 mile stretch of a roadway of homogeneous geometric features. assume all incoming flow is coming from

  Prepare journal entries to record the purchase on november

Prepare journal entries to record the purchase on November 1; the adjustment to accrue interest on December 31, which is the end of the fiscal year; and the receipt of cash at the maturity date of April 30, 2015.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd