Prepare a cash budget for the first quarter

Assignment Help Financial Accounting
Reference no: EM131288505

Lewis is a merchandising company. Each month they buy the inventory that they expect to sell the next month. Then they pay for it 50% in the month of purchase and 50% the next month. The purchase price is $50.

The sales commission is 6% and is paid in the month following the sales. Variable costs are 20% of sales and is paid 80% in the month incurred and 20% the following month.

Fixed costs are: Depreciation = $3,000 per month

Insurance = $1,200 per month paid on 1-1 and 7-1

Taxes = $800 per month and paid on 1-1.

Salaries = $12,000 per month paid when incurred

They plan on buying equipment for $10,000 in January and pay for it then.

The beginning cash balance is $10,000

Sales Price is $80 per unit. 10% of sales are cash and the rest credit. The collection pattern is: 30% in month of sale, 50% the next month and 20% two months later.

Sales

October, 2015= 8,000

November, 2015 = 9,000

December, 2015 = 10,000

January, 2016 = 9,000

February, 2016 = 8,000

March, 2016 = 8,500

April ,2016 = 10,000

Prepare a cash budget for the first quarter of 2016. If a loan is needed, a line of credit has been established at the bank. The loan would be taken out on the first of the month and repaid at the end of the month when all can be paid. The rate is 6%.

Reference no: EM131288505

Questions Cloud

Fringe benefits become tax deductible : At TechCorp Systems, they pay their employees $20 ofwages plus 5 units of fringe benefits (currently not tax deductible) while making zero profit. If their fringe benefits become tax deductible, how many units of fringe benefits can they give to t..
Should expatriate personnel be used : Should expatriate personnel be used? What are some of the difficulties they may encounter overseas? What can be done to minimize these problems?
Balance of payments issued by the country : Identify a host country which has a high repatriation risk for companies which engage in foreign direct investment. Once you have identified the country, observe the last balance of payments issued by the country.
Discuss two views of organizing mars european activities : Merger of the European food, pet care and confectionery divisions- Discuss the two views of organizing Mars' European activities.- Did Mars Inc. do the right thing in your opinion?
Prepare a cash budget for the first quarter : Lewis is a merchandising company. Each month they buy the inventory that they expect to sell the next month. Then they pay for it 50% in the month of purchase and 50% the next month. The purchase price is $50. Prepare a cash budget for the first quar..
What happens if a g protein is unable to hydrolyze gtp : What happens if a G protein is unable to hydrolyze GTP? How will this affect the pathway in which the G protein functions? Would activities both upstream and downstream of the G protein be affected?
Identify an organization that could use a pmo : Identify an organization that has a PMO (which may be based on your work experience). Characterize the organization's PMO structure type.
How will you apply these insights in your doctoral research : What similarities and differences do you find when comparing the two sources' research value to your doctoral journey?
Law of diminishing returns sets in from marginal costs : "You can determine when the law of diminishing returns sets in from your marginal costs." The manufacturer wants you to tell him which of the above statements are right and which wrong.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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