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

  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