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

  Prepare the company cash budget for april in good form

Prepare the company's cash budget for April in good form. Make sure to indicate what borrowing, if any, would be needed to attain the desired ending cash balance.

  Berkshire inc. uses a periodic inventory system

Berkshire Inc. uses a periodic inventory system. At the end of 2012, it missed counting some inventory items, resulting in an inventory understatement by $600,000. Assume that Berkshire has a 30% income tax rate and that this was the only erro..

  Describe statement of cash flows

Given the above information, prepare a statement of cash flows for Doug Corporation for the year 2009 on a separate Excel spreadsheet as directed on the Problem Set 1 directions.

  Prepare a single journal entry to record the incurred costs

Asset cost allocation - Prepare a single journal entry to record all the incurred costs assuming they are paid in cash on January 1, 2013 and use straight line method, prepare the December 31 adjusting entries to record depreciation for the 12 month..

  Financial performance

"Financial Performance" Identify at least (3) ratios that could be manipulated to mislead investors and creditors regarding the company’s financial condition. Examine the motivation of management to manipulate the ratios identified.

  Reported as current liabilities on balance sheet

The accounts and balances shown below were gathered from Pastel Corporation’s trial balance on December 31, 2014. All adjusting entries have been made. See information for Pastel Corporation above. The amount that should be reported as current liabil..

  Unique situations or transactions that you may encounter

What if you worked in the accounting department of a university and your boss has asked you to explain and discuss components of revenue or expense that are reported on the university’s statement of revenues, expenses, and changes in net asset. Name ..

  Show the machinery account for three years

You are required to show the Machinery Account for three years from 2006 to 2009 in the books of SUN Limited, which closes its books on Dec 31st.

  Calculate the current and quick ratio at end of each year

Calculate the current and quick ratio at the end of each year. How has the company's short-term liquidity changed over this period? What do these calculations suggest about the company's performance?

  Balance of the investment in the straw corporation account

On January 1, Evanston Corporation purchased 40% of the outstanding common stock of the Straw Corporation for $275,000. During the year, Straw Corporation reported net income of $100,000 and paid cash dividends of $50,000. The balance of the Investme..

  Fraud detection and deterrence

Write a case describing a fraud of a type consistent with one of the many types of fraud we discussed during the class (such as larceny, asset misappropriation, cash skimming, among others). The case discussion in your paper should include at a minim..

  Market a one year futures price is currently traded

A one year European put option and a one year European call option with a strike price of $59 are both priced at $5 in the market a one year futures price is currently traded at $58. The risk free rate is 7% per annum. Is there an arbitrage opportuni..

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