Chapter 12 Sample Problem and Solution
xlsx
keyboard_arrow_up
School
University of Texas, Rio Grande Valley *
*We aren’t endorsed by this school
Course
6350.01V
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
3
Uploaded by PrivateMoonHyena43
UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT
Chapter 12 -- Project Risk Analysis
Sample Problem
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.
ANSWER
Step 1 - Assemble the relevant data
System cost
$0
Revenue
$0
Fixed costs
$0
CCC
0%
Step 2 - Calculate the net cash flows (000s of dollars)
0
1
2
3
4
System cost
Net revenue
$0
$0
$0
$0
Fixed costs
$0
$0
$0
$0
Net income
$0
$0
$0
$0
$0
Step 3 - Calculate net present value
NPV
$0.00
Step 4 - Calculate the NPV with system cost at -20, -10, 0, +10, and + 20 percent of expected
System cost:
$0.00
In cell C32 insert "=B28"
-10%
$0
$0.00
Select the range B32:C37
-5%
$0
$0.00
From the menu bar choose Data, What-if Analysis, Data Table.
0%
$0
$0.00
Row input cell: leave blank
5%
$0
$0.00
Column input cell: insert =B15
10%
$0
$0.00
Click OK
Step 5 - Calculate the NPV with revenue at -20, -10, 0, +10, and + 20 percent of expected
Net revenue:
$0.00
In cell C41 insert "=B28"
-10%
$0
$0.00
Select the range B41:C46
-5%
$0
$0.00
From the menu bar choose Data, What-if Analysis, Data Table.
0%
$0
$0.00
Row input cell: leave blank
5%
$0
$0.00
Column input cell: insert =B16
10%
$0
$0.00
Click OK
Step 6 - Construct a table of data for graph
System costNet revenue
-10%
$0.00
$0.00
-5%
$0.00
$0.00
0%
$0.00
$0.00
5%
$0.00
$0.00
10%
$0.00
$0.00
Step 7 - Create graph
Step 7 - Interpret graph
Copyright © 2020 Foundation of the American College of Healthcare Executives. Not for sale.
UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT
Chapter 12 -- Project Risk Analysis
Sample Problem
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.
ANSWER
Step 1 - Assemble the relevant data
System cost
-$300
Revenue
$1,000 Fixed costs
$900 CCC
8%
Step 2 - Calculate the net cash flows (000s of dollars)
0
1
2
3
4
System cost
Net revenue
$1,000
$1,000
$1,000
$1,000
Fixed costs
$900
$900
$900
$900
Net income
-$300
$100
$100
$100
$100
Step 3 - Calculate net present value
NPV
$31.21
A
B
C
D
E
F
G
H
I
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
SUBJECT = COST ACCOUNT
Seattle Grace Hospital plans to invest in a new piece of CT imaging
equipment. The hospital estimates that it can bill $1,500 per scan.
Preliminary market assessments indicate that demand will be fewer
than 5,000 scans per year. The hospital is considering a scanner
(scanner A) that will result in total fixed costs of $1 million per year and
would yield a profit of $500,000 if the hospital producedand billed for
5,000 scans. What is the implied variable cost rate (variable cost per
scan) for scanner A?
a. $1,500
b. $300
c. $1,200
d. $200
e. $100
arrow_forward
The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will completely satisfy the requirement, so no combinations need to be considered. The first costs, operating costs, and salvage values over a 5-year planning horizon are shown below. Using a future worth analysis with a MARR of 20%/year, determine the preferred gate.
arrow_forward
A distribution center wants to evaluate an alternative product tracking system. The system has an initial cost of $500,000 and a useful life of 7 years. The operating cost is estimated to be $550 per metric ton of product moved per day. The center can handle between 30 and 50 tons per day. Analyze the sensitivity of the PW to changes in a 10-metric-ton increment of product moved. Use an interest rate of 3% per year and 200 days of work per year.
Find the PW of 3 options.
arrow_forward
5
arrow_forward
9. Calculating Profitability Index Bill pians to open a self-serve grooming center in a storefront. The
grooming equipment will cost $187,000. Bill expects aftertax cash inflows of $62,000 annually for
seven years, after which he plans to scrap the equipment and retire to the beaches of Nevis, The first
cash inflow ocurs at the end of the first year. Assume the required return is 15 percent. What is the
project's PI? Should it be accepted?
arrow_forward
You have been asked to perform a sensitivity analysis on a company’s plan to modernize its facilities to determine the impact of possible errors in estimating the net annual savings. The initial investment in the modernization is $30,000. The expected net annual savings are $13,000. The salvage value is $7,000 after a planning horizon of 7 years. MARR is 12% per year. Solve, a. Determine if the modernization is economically attractive based on the initial estimates and an annual worth (AW) analysis. b. Determine the AW if the net annual savings change by the following percentages from the initial estimate: −80%, −60%, −40%, −20%, +20%, +40%. c. Determine the percentage change in net annual savings that causes a reversal in the decision regarding the attractiveness of the project.
arrow_forward
Accounting
arrow_forward
What is the implied variable cost rate for scanner A on these general accounting question?
arrow_forward
Can you please answer the general accounting question?
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Steel insulators is analyzing solution general accounting question
arrow_forward
Risk and probability Micro-Pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a 10-year period, and each requires an initial
investment of $2,000. Management has constructed the following table of estimates of rates of return and probabilities for pessimistic, most likely, and optimistic results:
a. Determine the range for the rate of return for each of the two cameras.
b. Determine the value of the expected return for each camera.
c. Which camera purchase is riskier? Why?
a. The range for the rate of return for camera R is %. (Round to the nearest whole number.)
Data table
(Click on the icon here in order to copy the contents of the data table below into
a spreadsheet.)
Initial investment
Annual rate of return
Pessimistic
Most likely
Optimistic
Camera R
Amount
$2,000
15%
29%
31%
C
0.29
0.51
0.20
Probability Amount
1.00
$2,000
Camera S
21%
26%
30%
Probability
1.00
0.18
0.54
0.28
- X
arrow_forward
Project Evaluation:
Kolby's Korndogs is looking at a new sausage system with an installed cost of $655,000. The cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage stystem can be scrapped for $85,000. The sausage system will save the firm $183,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $35,000. If the tax rate is 22 percent and the discount rate is 8 percent, what is the NPV of this project?
Can the calculator and excel solution be provided?
arrow_forward
please answer both requirements
arrow_forward
Solve the problem
arrow_forward
The management of Penfold Corporation is considering the purchase of a machine that would cost $310,000, would last for 6 years, and would have no salvage value. The machine would reduce labor and other costs by $60,000 per year. The company requires a minimum pretax return of 12% on all investment projects.
Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor(s) using the tables provided.
The net present value of the proposed project is closest to (Ignore income taxes.): (Round your intermediate calculations and final answer to the nearest whole dollar amount.)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Related Questions
- SUBJECT = COST ACCOUNT Seattle Grace Hospital plans to invest in a new piece of CT imaging equipment. The hospital estimates that it can bill $1,500 per scan. Preliminary market assessments indicate that demand will be fewer than 5,000 scans per year. The hospital is considering a scanner (scanner A) that will result in total fixed costs of $1 million per year and would yield a profit of $500,000 if the hospital producedand billed for 5,000 scans. What is the implied variable cost rate (variable cost per scan) for scanner A? a. $1,500 b. $300 c. $1,200 d. $200 e. $100arrow_forwardThe management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will completely satisfy the requirement, so no combinations need to be considered. The first costs, operating costs, and salvage values over a 5-year planning horizon are shown below. Using a future worth analysis with a MARR of 20%/year, determine the preferred gate.arrow_forwardA distribution center wants to evaluate an alternative product tracking system. The system has an initial cost of $500,000 and a useful life of 7 years. The operating cost is estimated to be $550 per metric ton of product moved per day. The center can handle between 30 and 50 tons per day. Analyze the sensitivity of the PW to changes in a 10-metric-ton increment of product moved. Use an interest rate of 3% per year and 200 days of work per year. Find the PW of 3 options.arrow_forward
- 5arrow_forward9. Calculating Profitability Index Bill pians to open a self-serve grooming center in a storefront. The grooming equipment will cost $187,000. Bill expects aftertax cash inflows of $62,000 annually for seven years, after which he plans to scrap the equipment and retire to the beaches of Nevis, The first cash inflow ocurs at the end of the first year. Assume the required return is 15 percent. What is the project's PI? Should it be accepted?arrow_forwardYou have been asked to perform a sensitivity analysis on a company’s plan to modernize its facilities to determine the impact of possible errors in estimating the net annual savings. The initial investment in the modernization is $30,000. The expected net annual savings are $13,000. The salvage value is $7,000 after a planning horizon of 7 years. MARR is 12% per year. Solve, a. Determine if the modernization is economically attractive based on the initial estimates and an annual worth (AW) analysis. b. Determine the AW if the net annual savings change by the following percentages from the initial estimate: −80%, −60%, −40%, −20%, +20%, +40%. c. Determine the percentage change in net annual savings that causes a reversal in the decision regarding the attractiveness of the project.arrow_forward
- Please do not give solution in image format thankuarrow_forwardSteel insulators is analyzing solution general accounting questionarrow_forwardRisk and probability Micro-Pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a 10-year period, and each requires an initial investment of $2,000. Management has constructed the following table of estimates of rates of return and probabilities for pessimistic, most likely, and optimistic results: a. Determine the range for the rate of return for each of the two cameras. b. Determine the value of the expected return for each camera. c. Which camera purchase is riskier? Why? a. The range for the rate of return for camera R is %. (Round to the nearest whole number.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment Annual rate of return Pessimistic Most likely Optimistic Camera R Amount $2,000 15% 29% 31% C 0.29 0.51 0.20 Probability Amount 1.00 $2,000 Camera S 21% 26% 30% Probability 1.00 0.18 0.54 0.28 - Xarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning