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

  Describe balance sheets income statements retained earnings

describe balance sheets income statements retained earnings statment statement cash

  Knowledge of the price-earnings ratio

For this assignment, you will use your newly acquired knowledge of the Price-earnings Ratio and the DuPont Model to perform an equity analysis for The ABC firm for the years 2012 and 2013.

  Would that affect the physical stock of assets

Assume the same depreciation method is used for stockholder reporting and for tax calculations and that the accounting change has no effect on assets’ physical lives.would that affect the physical stock of assets

  You expect the price of ge to not change very much in the

you expect the price of ge to not change very much in the next month so you go short on sell a straddle a put and a

  Expected rate of return from portfolio

What is the expected rate of return from this portfolio? If Security B is sold, what will be the expected rate of return on the remaining two-stock portfolio?

  What is the additional dollar amount

If Mr. Jim wishes to maintain his proportionate ownership in the company, what is the additional dollar amount he will be required to make assuming he can purchase the new shares from the company at a 5% discount?

  What are the advantages of click and brick retailers

Discuss the advantages of established click and mortar companies such as walmart over pure play e tailers. conversly, what are the advantages of click and brick retailers as compared with pure play e tailers?

  Compare and contrast the firm''s actions with your findings

Evaluate the firm's decision-making procedures, and explain why the acceptance of project 263 and rejection of project 264 may not be in the owners' best interest. If the firm maintains a capital structure containing 40% debt and 60% equity, find its..

  Chesteris planning to conduct exit interviews

Assume Chester Corp. is downsizing the size of their workforce by 20% (to the nearest person) next year from various strategic initiatives. Chesteris planning to conduct exit interviews to learn more about how they can improve in processes and inc..

  Calculate u d, and p for a two-step tree

Consider a European call option on a non-dividend-paying stock where the stock price is $40, the strike price is $40, the risk-free rate is 4% per annum, the volatility is 30% per annum, and the time to maturity is six months.

  Determine the core business

Describe, in brief, the histories of both of Amazon.com and Yahoo.com, and determine the core business of each.

  Can you make money via triangular arbitrage if you can show

you walk into an international bank with 1000 and observe the following exchange

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