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,...
-
Calculate the maximum non-expansion work per mole that may be obtained from a fuel cell in which the chemical reaction is the combustion of propane at 298 K.
-
Greenock Limited has the following information available for accruals for the year ended December 31, 2022. The company adjusts its accounts annually. 1. The December utility bill for $425 was...
-
Venezuelan Bolivar (A). The Venezuelan government officially floated the Venezuelan bolivar (Bs) in February 2002. Within weeks, its value had moved from the pre-float fix of Bs778/$ to Bs1025/$. a....
-
Shortys Convenience Stores income statement for the year ended December 31, 2013, and its balance sheet as of December 31, 2013, reported the following: The business is organized as a proprietorship,...
-
Which rule explains why these triangles are congruent? S P SAS ASA Q U T AAS These triangles cannot be S
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
On August 1, 2016, Stephanie Ram, a sole proprietor, started a new business, Ram Wholesale Company. The company sells refrigerators (merchandise) to various retail stores and uses the periodic...
-
Neeley Grocery has a monthly target operating income of $20,700. Variable expenses are 10% of sales and monthly feed expenses are $15,300. What is the monthly margin of safety as a percentage of...
-
Given the following information: Average return Standard Deviation Stock X (w-40%) Stock Y (w-60%) 8% 20% 25% 22% Assume the correlation between the two stocks is 0.5. What's the portfolio's risk?
-
K To borrow money, you pawn your guitar. Based on the value of the guitar, the pawnbroker loans you $720. One month later, you get the guitar back by paying the pawnbroker $1170. What annual interest...
-
There are several different methods that can be used to allocate our scarce resources. There is no absolutely correct way of allocating scarce resources. A particular method might prove to be ideal...
-
Consider two hypothetical professional leagues, both of which have revenue sharing across teams. League A has much larger national revenue from TV broadcasting rights. It provides a large amount of...
-
5 14.28 points eBook Grady and Associates performs a variety of activities related to information systems and e-commerce consulting in Toronto, Canada. The firm, which bills $176 per hour for...
-
l ask this second time correnct answer is 38,01 can we look pls Consider a non-conducting rod of length 8.8 m having a uniform charge density 4.5 nC/m. Find the electric potential at P, 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...
-
How many months does it take to save $200,000.00 based on the information provided in this problem?---
-
What is the amount oi the credit to employee city income tax payable?
-
Milat is the total yearly gross pay for all employees?
Study smarter with the SolutionInn App