HCM301 CSU Understanding Healthcare Financial Management Analysis

User Generated

QTerra23

Computer Science

HCM301

Colorado State University Global Campus

Bradley Beauvais

Description

Please complete the two problems below, using excel and excel formulas.

UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT

Chapter 12 -- Project Risk Analysis

PROBLEM 3

Consider the project contained in Problem 7 in Chapter 11 (California Health Center).

a. Perform a sensitivity analysis to see how NPV is affected by changes in the number of procedures per

day, average collection amount, and salvage value. Remember supplies vary with number of procedures.

b. Conduct a scenario analysis. Suppose that the hospital's staff concluded that the three most uncertain

variables were number of procedures per day, average collection amount, and the equipment's salvage

value. Furthermore, the following data were developed:

Equipment

Number of

Average

Salvage

Scenario

Probability

Procedures

Collection

Value

Worst

0.25

10

$60

$100,000

Most likely

0.50

15

$80

$200,000

Best

0.25

20

$100

$300,000

c. Finally, assume that California Health Center's average project has a coefficient of variation of NPV in

the range of 1.0 - 2.0. (Hint: Coefficient of variation is defined as the standard deviation of NPV divided

by the expected NPV.) The hospital adjusts for risk by adding or subtracting 3 percentage points to its

10 percent corporate cost of capital. After adjusting for differential risk, is the project still profitable?

d. What type of risk was measured and accounted for in Parts b. and c.? Should this be of concern to the

hospital's managers?

ANSWER

9/1/14

UNDERSTANDING HEALTHCARE FINANCIAL MANAGEMENT

Chapter 14 -- Financial Forecasting

PROBLEM 1

Florida Home Health is a small home care agency owned by a group practice of nurses and physical

therapists in Tampa, Florida. During the past few years, the company reported the following revenues:

Year

Revenues (thousands)

1

$2,058

2

$2,534

3

$2,472

4

$2,850

5

$3,000

6

?

Predict Florida Home Health's Year 6 revenue.

ANSWER

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, your assignment is complete. Thank you

1
2
3
4
5
6

Revenues (thousands)
$2,058
$2,534
$2,472
$2,850
$3,000
?

Financial Fore
$3,500

Revenues (thousands)

Year

$3,000
$2,500
$2,000
$1,500
$1,000
$500
$0
0

Y=220x + 1922.8
when x=6 years,
Y=220 * 6 + 1922.8
Y= $3,242

1

Financial Forecasting
y = 220x + 1922.8

2

3

4
Years

5

6

7

Problem 2
a
Procedures per day
Collection amount
Salvage value

Value Changes
-0.3
10.5
56
140000

-0.2
12
64
160000

-0.1
13.5
72
180000

0
15
80
200000

0.1
16.5
88
220000

0.2
18
96
240000

0.3...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4