Prepare a cash budget for january through june

Assignment Help Financial Accounting
Reference no: EM131150632

Precision Machines

Read the following case study:

Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company's sales shows that the company's total sales are 30% cash sales and 70% credit sales. Further analysis of credit sales shows that the company receives 50% of the credit sales one month after the sale and the remaining 50% in the second month after the sale. This means the cash collections from sales are 30% in the first month of the sale, 35% in the second month, and 35% in the third month.

The materials purchased by the company amounts to 50% of the sales for the month. The company pays for the purchases one month after the initial purchase. The company likes to maintain a cash balance of $5,000. The cost of borrowing is 10%. The company plans to pay off the loan whenever there is a surplus and borrow when there is a deficit.

The attached spreadsheet shows revenues (sales), expenses, capital expenditures, and other expenses for Precision Machines' next six months. Using the information given on the spreadsheet, prepare a cash budget for January through June and determine the cash surplus, deficit, and the financing needs of the company. Write a 300-word essay recommending a cash management strategy for the company that will minimize the financing cost and increase the cash flows for the company.

Attachment:- Precision_Machines_Financial_Statements.xlsx

Reference no: EM131150632

Questions Cloud

The market for foreign exchange : Slides on "Globalisation and the multinational firm Host country relations" and "Globalisation and the multinational firm" are especially relevant.
Define legal limitation associated combating organized crime : Describe the legal limitations associated with combating organized crime, including a critique of major federal laws and strategies that support this effort.
Target market analysis : Target Market Analysis (Week 2) This section should contain one to two paragraphs with a description of the demographics of the target market and one to two paragraphs explaining the psychographic characteristics of the target market.
What acts did garcia do that amounted to a conspiracy : What acts did Garcia do that amounted to a conspiracy?-  What was the government's evidence that supports the conspiracy?
Prepare a cash budget for january through june : Using the information given on the spreadsheet, prepare a cash budget for January through June and determine the cash surplus, deficit, and the financing needs of the company.
Define legally enforceable : Define EACH of the following Terms: Legally enforceable, Bilateral Contract and Express Contract.
Dominant role in the transportation : Inland water carriers played a dominant role in the transportation of the United States in the 18th and 19th centuries. Why has their relative position declined during the 20th century? Are they still an important component of the total transportatio..
Exchange rate variation on financial management : Prepare a 2,500 word report responding to the concerns raised by the Board - assess the properties of various forms of exposure to international financial risks
Explain how each dimension will be used by the new company : Mobile Car Wash and Detailing Jim and Paul are best friends. They have talked about starting a business for several years. They have decided to start a mobile car wash and detailing service. To reduce operating expenses, they agree not to purchase a ..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Recording adjusting entries and preparing financial

recording adjusting entries and preparing financial statements.record adjusting entries and prepare financial

  What is goodwill and when may it be recorded

What is goodwill and when may it be recorded? Detailed answer please.

  Cost of goods sold

Presented below is the trial balance of Scott Butler Corporation at December 31, 2014. Debit Credit Cash $ 199,630 Sales $ 8,103,580 Debt Investments (trading) (cost, $145,000) 156,580 Cost of Goods Sold 4,803,580 Debt Investments (long-term) 301,630..

  Showed beginning inventory-cost of goods sold

The 2014 records of Thompson Company showed beginning inventory, $21,000; cost of goods sold, $29,000; and ending inventory, $23,000. The cost of purchases for 2014 was:

  What is the depreciation expense for year 1

The company uses the straight-line method of depreciation. Under IFRS, what is the depreciation expense for year 1?

  The following aging schedule for it accounts receivables

Smith Company prepared the following aging schedule for it accounts receivables

  Prepare sullivans journal entries to record of transactions

Sullivan Company sells industrial cleaning supplies and equipment to other businesses. Prepare Sullivan's journal entries to record each of these transactions.

  Aaa of amit, inc. an s corporation, has a balance

8. (TCOs 1 and 10) Beginning in 2010, the AAA of Amit, Inc. an S corporation, has a balance of $725,000. During the year, the following items occur:

  Increase net income reported in the financial statements

Can managers use accounting discretion in the accounting for accounts receivables to increase net income reported in the financial statements without changing the actual cash flows

  Equivalant units of production

how do I calculate the equivalant units of production for this problem? I cant seem to figure out how to line up the study answers to the questions im working on in class. is there a number for Chegg i can call?

  Transaction is disclosed on statement of cash flows

Zeus Manufacturing purchased plant assets that cost $50,000 by paying $20,000 in cash and financing the balance by issuing a note payable to the seller. This transaction is disclosed on a statement of cash flows as follows:

  Recorded revenues-expenses-paid dividends

Henson Company began the year with retained earnings of $330,000. During the year, the company recorded revenues of $500,000, expenses of $380,000, and paid dividends of $40,000. What was Henson’s retained earnings at the end of the year?

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