Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help? Trial NPV 1 49575 2 28569 3 26048 4 33091 5 35148 6 43320 7 22805 8 27075 9 41548 10 37637 11

Please help?

image text in transcribed
Trial NPV
1 49575
2 28569
3 26048
4 33091
5 35148
6 43320
7 22805
8 27075
9 41548
10 37637
11 36632
12 53416
13 21729
14 43221
15 47881
16 38289
17 34390
18 24814
19 26802
20 32148
21 30124
22 36282
23 39013
24 35052
25 51075
26 27907
27 47518
28 43379
29 36012
30 45136
31 31495
32 28874
33 24019
34 34393
35 41618
36 31287
37 23528
38 43025
39 39549
40 48406
41 23533
42 45957
43 39817
44 23011
45 21196
46 42814
47 38584
48 36264
49 42122
50 30290
A surgery center specializes in high-risk cardiovascular surgery. The center needs to forecast its profitability over the next three years to plan for capital growth projects. Find the distribution of the net present value of profit over the three-year horizon and analyze the summary statistics using 50 trials. Summarize your conclusions. Use a discount rate of 5%. Click here to view the descriptions of the model. Click here to view a sample of 50 simulation trial results. Set up a spreadsheet model and calculate the net present value for the profits in thousands of dollars using the minimum for uncertain values with uniform distributions, the mean for uncertain values with normal distributions, and the most likely values for uncertain values with triangular distributions. The net present value is $ thousand. (Round to the nearest thousand dollars as needed.) Model description For the first year, the anticipated number of patients served is uniform between 1,300 and 1,700 . The growth rate for subsequent years is triangular with parameters (5%,8%,9%), and the growth rate for year 2 is independent of the growth rate for year 3 . Average billing is normal with mean of $150,000 and standard deviation $10,000. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 11% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and the annual increase in fixed costs is uniform between 4% and 6% and independent of other years

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Controlling In SAP AFS Solution

Authors: David Jones

1st Edition

1521738092, 978-1521738092

More Books

Students also viewed these Accounting questions