Perform a cash flow analysis

Assignment Help Financial Management
Reference no: EM131324350

The industry of medical devices involves a number of monitoring and reconstructive devices. Some of those devices include cardiac and diabetic care as well as hip and knee replacements. The owners of a medical device manufacturing firm called “JointsOrtho” have recently reviewed information about the expected growth of the aging population in the United States. Every day 10,000 Americans are turning age 65 every the population of older adults is expected to reach 89 million people by the year 2050. This figure is more than double the number of older adults in the United States in 2010. Orthopedic medical devices are one of the fastest growing areas in medical device manufacturing.

The owners of JointsOrtho or JO, manufacture full hip and knee replacements and would like to have your firm set up a financial plan for opening a new manufacturing plant that makes medical devices often used for Orthopedics. Specifically you will set up a plant that manufactures Full Hip Replacements in Delaware.

Each Full Hip Replacement will be sold throughout the United States at a cost of $36,750 each, including shipping, etc. Sales are expected to be between 1,000 and 1,200 hips per month. This figure is above what they are already producing in their first plant. Depreciation for equipment should be set to 10 years.

You will need to provide information to the owners of JointsOrtho that includes what it will cost to open a facility and hire workers and determine if the facility will breakeven within the first 12 months.

You will be hiring a total of 3 shift supervisors and a total of 45 employees (including shift supervisors) to do various manufacturing of the hips, clean up, shipping, etc.

The 45 workers will be paid as follows:

15 of the workers will be paid at the rate of $18/hour for 40 hours per week (molding specialists)

10 of the workers will be paid at the rate of $16/hour for 40 hours per week (machining specialists)

5 of the workers will be paid at the rate of $13/hour for 40 hours per week (cleaning and maintenance)

10 of the workers will be paid at the rate of $17/hour for 40 hours per week (shipping and receiving)

3 shift supervisors will be paid at the rate of $20/hour for 40 hours per week

1 plant manager will be paid a salary of $6,000 per month

1 administrative/human resources person at the rate of $15/hour for 40 hours per week

Transaction 1: Borrow $6,000,000.00 for building with 10 year mortgage at 10% annum

Transaction 2: Pay your salary of $6,000/month

Transaction 3: Pay for building: Set up what will be office space, manufacturing space and warehouse space. Set a depreciation schedule

Transaction 4: Hire managers & Workers. Pay salaries and fringe benefits and taxes

Transaction 5: Pay employee health, life and disability premiums, plus FICA, un-employment and withholding taxes

Transaction 6: Order $3,000,000 worth of machinery/equipment for manufacturing. Pay ½ down.

Transaction 7: Receive machines and pay remaining amount due

Transaction 8: Hire employees- Expense 1st Months’ salary/wages, set up machinery depreciation, set-up standing costs

Transaction 9: Place order for raw materials at a cost of $1,000,000 which will include Machining, Casting, Grinding, Polishing and metal injection molding materials. *Note: These raw materials will need to be ordered every 3 months.

Transaction 10: Receive 3 month supply of raw materials

Transaction 11: Start up production. Pay workers for the month

Transaction 12: Book depreciation and other manufacturing overhead costs for the month

Transaction 13: Finish manufacturing 2,000 hips and move them into finished goods inventory

Transaction 14: Pay for the 3 month supply of raw materials received in Transaction 10

Transaction15: Manufacture and months’ supply of hip replacements

Transaction 16: Take an order for 1,200 hip replacements Transaction 17: Ship and invoice customer for 1,200 hip replacements

Transaction 18: Receive payment for 1,200 hip replacements Based on the above information:

Perform a Cash Flow Analysis.

Reference no: EM131324350

Questions Cloud

How many neutrons does element : How many neutrons does element x have if it's atomic number is 42 and it's mass number is 154?
How englehardt concept of victory culture reflected in war : How has Englehardt's concept of "victory culture" been reflected in war toys, films & TV series since WWII?  (Be sure to cite specific examples from the 3 periods discussed in the book:  the peak, fall and potential revival of the "victory culture..
Differences between a recombining and non recombining tree : Discuss how a binomial model accommodates the possibility of early exercise of an option. Explain the differences between a recombining and non-recombining tree. Why is the former more desirable?
Make sure to identify all the entities and their attributes : Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes).
Perform a cash flow analysis : The industry of medical devices involves a number of monitoring and reconstructive devices. Some of those devices include cardiac and diabetic care as well as hip and knee replacements. The owners of a medical device manufacturing firm called “Joints..
Brief history of the social origin of the product : For this assignment, you will select 4 fermented foods to include in a full course dinner menu. Not every dish in the menu needs to be fermented, but 4 fermented products have to be included. The menu should have an appealing design, and foods sel..
Create a windows application and add a database : Statement Create a C# Windows application (named EmployeeManagement) and add a database named EmployeeData.mdf. A button that, when clicked, sorts the data in ascending order by hourly pay rate.
Define the problem in the scenario that you have chosen : When faced with a problem, what do you do to solve it? This assignment asks you to apply a six-step to problem solving process to a specific problem scenario. You will write a paper that presents a synthesis of your ideas about solving the problem..
Book review - citizen coke : Book review in history book is "Citizen Coke" by Bartow J. Elmore. The purpose of the book review paper is to demonstrate your mastery of its material and offer the class background on the subject of your choice

Reviews

Write a Review

Financial Management Questions & Answers

  What are capital structure weights on book value basis

Vedder, Inc., has 7.2 million shares of common stock outstanding. The current share price is $62.20, and the book value per share is $5.20. Vedder also has two bond issues outstanding. The first bond issue has a face value of $71.2 million, a coupon ..

  What is the price of the bonds as percentage of pars

Ramstucky Corp bonds just paid their annual coupon of 4%. They mature in 6 years. The required rate of return on the bonds is 5%. So it’s a $10,000 bond selling for $9,000. The call price of the bonds is 102, but they are not callable until after the..

  Analyzing and explaining the effects of a stock split

On March 1 of the current year, Zhang Company has 500,000 shares of $20 par value common stock that are issued and outstanding. Its balance sheet shows the following account balances relating to common stock. How many shares of common stock are issue..

  Calculate the weights for debt-common equity

The Imaginary Products Co. currently has debt with a market value of $275 million outstanding. The debt consists of 9 percent coupon bonds (semi annual coupon payments) which have a maturity of 15 years and are currently priced at $1,054.14 per bond...

  Economy probability of state of economy stock

A portfolio consists of 20 percent Stock A, 50 percent Stock B, and 30 percent Stock C. What is the portfolio expected return given the following: State of Economy Probability of State of Economy Stock A Returns Stock B Returns Stock C Returns

  Risk for high medical expenditures

The law now gives a worker who becomes unemployed the right to buy continuing health insurance coverage after leaving the company. Why might it be rational for a factory worker who loses his or her job to give up this legal right to purchase coverage..

  Treasurer effectively hedge away

The treasurer for Pittsburgh Iron Works wishes to use financial futures to hedge her interest rate exposure. She will sell five Treasury futures contracts at $143,000 per contract. It is July and the contracts must be closed out in December of this y..

  Cash flows for three mutually exclusive projects

Consider the following cash flows for three mutually exclusive projects. What is the IRR of the project you should accept? Assume an interest rate of 12% Year A B C 0 −$950,000 −$1,790,000 -$1,000,000 1 370,000 800,000 660,000 2 510,000 800,000 550,0..

  Cost of retained earnings using the gordon model approach

Heavy Rain Corporation just paid a dividend of $3.96 per share, and the firm is expected to experience constant growth of 2.17% over the foreseeable future. The common stock is currently selling for $74.35 per share. What is Heavy Rain’s cost of reta..

  What is the total risk of this portfolio

A portfolio consists of 4 securities. Security 1: Beta= 1.2 Standard deviation of random error term=5% Proportion=.10. Security 2: Beta=1.03 Standard deviation of random error term= 7% Proportion = .10 The standard deviation of the market index is 15..

  What is the after-tax of capital to walgreen for the bonds

The Walgreen Corporation is contemplating a new investment that it plans to finance using one-third debt. The firm can sell new $1000 par value with a 15-year maturity at a price of $948 that carry a coupon interest rate of 12.3 percent that is paid ..

  About the sell certain land

Roberta offers to sell certain land to Emily for $10,000. This offer is made by a letter, signed by Roberta and mailed on March 1, 1990. The letter also stated that the offer would be kept open until July 1, 1990. Discuss in detail whether there is a..

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