Raleigh Medical Clinic is considering acquiring 2 new ultrasound machines for $300,000. The clinic estimates that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Raleigh Medical Clinic is considering acquiring 2 new ultrasound machines for $300,000. The clinic estimates that the machines will have an economic life of 4 years after which they will have zero salvage value. The machines expects the two machines to generate net revenue of $1,000,000 per year and to require $900,000 per year in fixed costs. The CCC of the clinic is 8 percent. Conduct a sensitivity analysis. Step 1 - Assemble the relevant data System cost $0 Revenue $0 $0 Fixed costs CCC 0% Step 2 -Calculate the net cash flows (000s of dollars) 0 1 System cost Net revenue Fixed costs Net income $0 Step 3 - Calculate net present value NPV $0.00 $0 $0 $0 2 $0 $0 $0 3 $0 $0 $0 4 $0 $0 $0 Step 4 - Calculate the NPV with system cost at -20, -10, 0, +10, and +20 percent of expected System cost: -10% -5% 0% 5% 10% Net revenue: -10% -5% 0% 5% 10% $0 $0 $0 $0 $0 Step 5 - Calculate the NPV with revenue at -20, -10, 0, +10, and +20 percent of expected -10% -5% 0% 5% 10% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0 $0 $0 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Step 6 - Construct a table of data for graph System cost Net revenue $0.00 $0.00 $0.00 $0.00 $0.00 In cell C32 insert "=B28" Select the range B32:C37 From the menu bar choose Data, What-if Analysis, Data Table. Row input cell: leave blank Column input cell: insert =B15 Click OK $0.00 $0.00 $0.00 $0.00 $0.00 In cell C41 insert "=B28" Select the range B41:C46 From the menu bar choose Data, What-if Analysis, Data Table. Row input cell: leave blank Column input cell: insert =B16 Click OK Step 7 - Create graph Step 7 - Interpret graph Raleigh Medical Clinic is considering acquiring 2 new ultrasound machines for $300,000. The clinic estimates that the machines will have an economic life of 4 years after which they will have zero salvage value. The machines expects the two machines to generate net revenue of $1,000,000 per year and to require $900,000 per year in fixed costs. The CCC of the clinic is 8 percent. Conduct a sensitivity analysis. Step 1 - Assemble the relevant data System cost $0 Revenue $0 $0 Fixed costs CCC 0% Step 2 -Calculate the net cash flows (000s of dollars) 0 1 System cost Net revenue Fixed costs Net income $0 Step 3 - Calculate net present value NPV $0.00 $0 $0 $0 2 $0 $0 $0 3 $0 $0 $0 4 $0 $0 $0 Step 4 - Calculate the NPV with system cost at -20, -10, 0, +10, and +20 percent of expected System cost: -10% -5% 0% 5% 10% Net revenue: -10% -5% 0% 5% 10% $0 $0 $0 $0 $0 Step 5 - Calculate the NPV with revenue at -20, -10, 0, +10, and +20 percent of expected -10% -5% 0% 5% 10% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0 $0 $0 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Step 6 - Construct a table of data for graph System cost Net revenue $0.00 $0.00 $0.00 $0.00 $0.00 In cell C32 insert "=B28" Select the range B32:C37 From the menu bar choose Data, What-if Analysis, Data Table. Row input cell: leave blank Column input cell: insert =B15 Click OK $0.00 $0.00 $0.00 $0.00 $0.00 In cell C41 insert "=B28" Select the range B41:C46 From the menu bar choose Data, What-if Analysis, Data Table. Row input cell: leave blank Column input cell: insert =B16 Click OK Step 7 - Create graph Step 7 - Interpret graph
Expert Answer:
Answer rating: 100% (QA)
It seems there is a sensitivity analysis exercise that you need to complete for the Raleigh Medical Clinic which is considering acquiring new ultrasou... View the full answer
Related Book For
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118155974
6th edition
Authors: Michael H. Granof, Saleha B. Khumawala
Posted Date:
Students also viewed these finance questions
-
a. Define "incremental cash flow." 1. Should you subtract interest expense or dividends when calculating project cash flow? 2. Suppose the firm had spent $100,000 last year to rehabilitate the...
-
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recently graduated MBA. The production line...
-
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recently graduated MBA. The production line...
-
In 1789, Henry Cavendish estimated the density of the earth by using a torsion balance. His 29 measurements follow, expressed as a multiple of the density of water. (a) Calculate the sample mean,...
-
Revenue recognition Fonterra Cooperative Group Limited (Fonterra), a New Zealand dairy cooperative, uses the accrual basis of accounting and recognizes revenue at the time it sells products or...
-
Use Apples financial statements in Appendix A to answer the following. 1. Identify the total amount of cash and cash equivalents for fiscal years ended (a) September 28, 2019, (b) September 29, 2018....
-
The U.S. total land area is almost \(9,307,800 \mathrm{~km}^{2}\). Thirty percent of the land is forestland. How much above-ground biomass is available in the U.S. forestland assuming a \(15,240...
-
Two tanks are connected together in the following unusual way in Figure. (a) Develop a model for this system that can be used to find h1, h2, w2, and w3 as functions of time for any given variations...
-
Topper Sports, Incorporated, produces high-quality sports equipment. The company's Racket Division manufactures three tennis rackets-Standard, Deluxe, and Pro-widely used in amateur play. Selected...
-
Last August, Malcolm (who is single) moved out of his rented apartment in Toronto, Ontario, to move to Vancouver, British Columbia, where he now lives and works. Malcolm has two T4s, one from Ontario...
-
let z denote the probability that a randomly selected respondent supports current laws legalizing abortion, predicted using gender of the respondent (G = 0, male; G = 1, female), religious...
-
The following scenario will be used for the next three questions. Thorin Corp. began operations in 2017. It is a merchandiser of a single item - Product Q and uses the Periodic Inventory method. The...
-
Table 17-4 Features of alternative security issues Common Stock Preferred Stock Bonds 1.Ownership and control of the firm Belongs to common stockholders through voting rights and residual claim to...
-
One of the biggest impacts of ___________ is the requirement for companies and their auditors to provide reports about the effectiveness of internal controls over the financial reporting process....
-
he accounts from the Adjusted Trial Balance are listed in alphabetical order. What is the total longminusterm liabilities? Baker Service Company Adjusted Trial Balance September 30, 2025 Balance...
-
There are 12 months on Earth and 4 different seasons. An alien asks us what the name of a month is based on a number. For example, 6 is June. So write a program that teaches the alien what month it...
-
In a case control study examining the relationship between development disorders and prenatal exposure to cocaine, the hospital records of 1000 infants diagnosed with a developmental disorder and...
-
d) For die casting processes: 1. What are the most common metals processed using die casting and discuss why other metals are not commonly die casted? 2. Which die casting machines usually have a...
-
What are the three main sections of the comprehensive annual nancial report? What are the main components of the nancial section?
-
Columbus City was awarded a state reimbursement grant of $150,000 to assist its adult literacy program. The following were signicant events relating to the grant: The city, which is on a calendar...
-
In 2015, the Bakersville Independent School District incurred $12 million in expenditures for teachers salary and benets. In that year, the legislature of the state in which the district is located...
-
What does it mean to say that the demand for resources is a derived demand? Is the demand for all goods and services a derived demand?
-
Using the data in exercise 2, determine how many units of resources the firm will want to acquire. Data from in exercise 2 Using the information in the following table, calculate the marginal revenue...
-
Using the information in the following table, calculate the marginal revenue product (MRP = MPP MR). Unit of Resources Total Resource Output Price Price 1 10 $5 $10 2 25 $5 $10 345 35 $5 $10 40 $5...
Study smarter with the SolutionInn App