Prepare a cash budget for precision machines

Assignment Help Finance Basics
Reference no: EM131300483

Create an outline for the essay.

Develop a 700-word annotated bibliography using at least 3 resources.

Review the "Precision Machines" document and spreadsheet.

Prepare a cash budget for Precision Machines in Microsoft Excel.

Create a 1,225-word strategic analysis and include the following:

  • Recommend a cash management strategy for the company that will minimize the financing cost and increase the cash flows for the company.
  • Explain two economic and market forces that will impact the financial plan of this company.

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.

Attachment:- Assignment.rar

Reference no: EM131300483

Questions Cloud

Supply chain for a middle eastern company : Write a paper, not including the cover and reference pages, describe some of the considerations in creating an effective supply chain for a Middle Eastern company.
The right to purchase shares of wan stock : George owns an option which gives him the right to purchase shares of WAN stock at a price of $22 a share. Currently, WAN stock is selling for $25. He would like to profit on this option but is not permitted to exercise it for another two weeks.
Should china continue to ignore the criticism from abroad : Should China continue to ignore the criticism from abroad? Or, should China make changes to its authoritarian rule and human rights policies? which includes brutal crackdowns on dissent?
Representative investors average degree of risk aversion : The expected rate of return on the market portfolio is 9.25% and the risk–free rate of return is 0.75%. The standard deviation of the market portfolio is 18.50%. What is the representative investor’s average degree of risk aversion?
Prepare a cash budget for precision machines : Develop a 700-word annotated bibliography using at least 3 resources. Review the "Precision Machines" document and spreadsheet. Prepare a cash budget for Precision Machines in Microsoft Excel
Were the futures priced fairly : In May of 201X, six-month futures on the Imaginary Country stock index traded at 15,330. Spot was 13,743. The interest rate was 15 percent and the dividend yield was 7 percent. Were the futures priced fairly?
How many common shares are currently outstanding : Henderson Industries has $100 million of common equity; its stock price is $40 per share; and its Market Value Added (MVA) is $120 million. How many common shares are currently outstanding? Write out your answer completely. For example, 5 million sha..
What rms current is delivered by the source : An 80.0-O resistor, a 200-mH inductor, and a 0.150-µF capacitor are connected in parallel across a 120-V (rms) source operating at 374 rad/s.
Examine role of technology in the evolution of cryptography : Examine role of technology in evolution of cryptography. Evaluate symmetric key cryptography, including implementation of at least one symmetrical algorithm.Explain role symmetric algorithms play in securing network protocols.

Reviews

Write a Review

Finance Basics Questions & Answers

  Why did the price change so fast on a book rental

Why did the price change so fast on a book rental? On April 16,2013 the price was 36.99 and not it 102.99?

  Write down the major components of the bond briefly

what are the major components of a bond? briefly explain each one. suppose you are contemplating purchasing rmi common

  Income statement reports on operations

Explain the following statement: While the balance sheet can be thought of as a snapshot of a firm's financial position at a point in time, the income statement reports on operations over a period of time

  The standard deviation of the returns on the index

Which is the standard deviation of the returns on the index from 2000 to 2009 closest to?

  Explain what happens to the standard error of the mean if

answer the following questions in one or two well-constructed sentences.a. what happens to the standard error of the

  Evaluate the financial strengths and weaknesses jaedan

Complete the Mini Case in Chapter 2 of your text. Use formulas to calculate the ratios, clearly label the analysis, and round to one decimal place. You must complete all requirements of the case study.

  Ford is considering moving its taurus plant from edison nj

1.which of the following is an example of the resource-based view of the firm?a.philip morris diversified by purchasing

  Discuss the advantages and disadvantages relative to a

as the world economy becomes more globalized it is expected that economic integration will continue. there are 6 stages

  What are the differences between financial and managerial

what are the differences between financial and managerial accounting? why does financial accounting have to comply with

  How will this change in policy affect accounts receivable

Essence of Skunk is considering a change in its credit policy to terms of 3/10, net 30 to preserve its market share. How will this change in policy affect accounts receivable?

  Bruner breakfast foodsrsquo balance sheet shows a total of

bruner breakfast foodsrsquo balance sheet shows a total of 20 million long-term debt with a coupon rate of 8.00.the

  What is the required rate of return on zoro stock

Zoro Corporation has a beta of 2.0. The risk-free rate of interest is 5%, and the return on the stock market overall is expected to be 13%. What is the required rate of return on Zoro stock?

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