Prepare Cash Budgets for November and December

Assignment Help Accounting Basics
Reference no: EM132825023

Question - Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $350,000 for November, $370,000 for December, and $360,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 74% of sales.

The company desires an ending merchandise inventory equal to 70% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase.

Other monthly expenses to be paid in cash are $20,800. Monthly depreciation is $20,600. Ignore taxes.

Assets

Cash 21,600

Accounts receivable 82,600

Merchandise inventory 181,300

Property, plant and equipment (net of accumulated depreciation) 1,002,000

Total assets $1,287,500

Liabilities and Stockholders' Equity

Accounts payable 195,600

Common stock 570,000

Retained earnings 521,000

Total liabilities and stockholders' equity 1,287,500

Required -

a. Prepare a Schedule of Expected Cash Collections for November and December.

b. Prepare a Merchandise Purchases Budget for November and December.

c. Prepare Cash Budgets for November and December.

d. Prepare Budgeted Income Statements for November and December.

e. Prepare a Budgeted Balance Sheet for the end of December.

Reference no: EM132825023

Questions Cloud

Prepare machinery account and depreciation account : Berlia Ltd. purchased a second hand machine for 56,000 on October 01, 2018. Prepare machinery account and depreciation account
Difference in inferential and descriptive statistics : How are inferential and descriptive statistics used to make health care business decisions on a daily basis?
What additional steps need to be taken to continue advocacy : Research legislation that has occurred within the last 5 years at the state or federal level as a result of nurse advocacy. Describe the legislation.
Identify opportunities to better allocate human resources : -How can metrics be used to identify opportunities to better allocate human resources and financial resources and support the company in its strategic initiativ
Prepare Cash Budgets for November and December : Other monthly expenses to be paid in cash are $20,800. Monthly depreciation is $20,600. Ignore taxes. Prepare Cash Budgets for November and December
Identify a problem or concern in your state or organization : For this assignment, identify a problem or concern in your state, community, or organization that has the capacity for advocacy through legislation.
Strong conflict management skills : Why is it important for health care managers to have strong conflict management skills? Provide examples.
Explain the control business risk so the it group : Vendors in the computer system. Explain the control concern/business risk so the IT group, responsible to correct the issue, will understand the business need.
Identify the structural components of the selected theory : Identify the structural components of the selected theory: Describe the purpose of the theory (descriptive, explain, predictive etc.).

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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