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. For the first year, the hospital anticipates serving 1,400 patients, which is expected to grow by 9% per year. Based on current reimbursement formulas, each patient provides an average billing of $120,000, which will grow by 3% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4%.

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. For the first year, the hospital anticipates serving 1,400 patients, which is expected to grow by 9% per year. Based on current reimbursement formulas, each patient provides an average billing of $120,000, which will grow by 3% each year. However, because of managed care, the center collects only 25% of billings. Variable costs for supplies and drugs are calculated to be 10% of billings. Fixed costs for salaries, utilities, and so on will amount to $20,000,000 in the first year and are assumed to increase by 6% per year. Develop a spreadsheet model to predict the net present value of profit over the next three years. Use a discount rate of 4%.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Please answer with a complete step
How do I solve this by hand and what is the equation?
Calculate the NPV based upon the following facts: Bob has just completed the development of a better face shield for health workers. The new product is expected to produce annual revenues of $230,000. Bob requires an investment in an advanced 3D Printer costing $30,000. The project has an expected life of 5 years. The 3D printer will have a $20,000 salvage value at the end of 5 years. Working capital is expected to increase by $80,000 which Bob will recover at the end of the products life cycle. Annual operating expenses are estimated at $200,000. The required rate of return is 4%.
Cohen Brothers Fixers R Us is a small company specializing in emergency home repairs. They are considering expanding into a domestic emergency consultation business. Doing so will involve investing $1 million in licensing, recruiting, training, advertising, and a phone call answering center. A staff of 20 licensed clinical social workers will be hired to perform emergency counseling. If the service is well-received (probability 60%) then cash flows will be $500,000 per year for 3 years. If the service is not well-received (probability 40%) then the cash flows will be $210,000 per year for 3 years. Calculate the expected NPV of the project. Cohen's discount rate is 10% -$40,953 -$45,049 -$49,554 -$54,509…
Terra Landscape is evaluating a capital budgeting project that is expected to generate $80, 100 per year during its eight-year life. If its required rate of return is 14 percent, what is the value of the project to Terra Landscape?
Subject: acounting
The hospital is considering the purchase of imaging equipment worth $25,000 to improve its visual capture results, and improve outcomes. The operating costs will be reduced by $7,000 per year. The computer has an estimated life expectancy of 5 years, and an estimated salvage value of $5,000. What is the profitability index if the discount rate is 8%. Ignore reimbursement considerations.
Please explain and answer ALL questions. A,B, and C. Thank you.
First National Bank of Conway is considering installing two ATMs in its Southside branch. The new machines are expected to cost $37000 apiece. Installation costs will amount to about $15000 per machine. Each machine has a projected useful life of 10 years. Due to rapid growth in the Southside district, these two machines (combined) are expected to handle 50000 cash transactions per year. On average, each cash transaction is expected to save $0.30 in teller expenses. If First National has a 0.10 cost of capital, what is the NPV of this project?
A small company wishes to set up a fund that can be used for technology purchases over the next 6 years. Their forecast is for $9,000 to be needed at the end of year 1, increasing by 5% each year thereafter. The fund earns 10% per year. How much money must be deposited to the fund at the end of year 0 to just deplete the fund after the last withdrawal?
great lakes clinic has been asked to provide exclusive healthcare services for next year's world exposition. although flattered by the request, the clinic's managers want to conduct a financial analysis of the project. there will be an up front cost of $160,000 to get the clinic in operation. then, a net cash inflow of $1 million is expected from operations in each of the two years of the exposition. however, the clinic has to py the organizers of the exposition a fee for the marketing value of the opportunity. this fee, which must be paid at th end of the second year, is $2 million.a. what are the cash flows associated with the project?b. what is the project's IRR?c. assuming a project cost of capital of 10 percent, what is the project's NPV?
The Hangover Diner is considering a project to build a new diner next to Saint Joseph's University with an initial cost of $555,000. Construction will take 2 years. The diner will open in year 3, so no cash will be received in the first 2 years. At the end of the third year, the diner expected to produce a cash inflow of $100,000. Starting in the fourth year the cash flows are expected to grow by 2.50% per year forever. What is the project's net present value today at a 15% discount rate? O -$22,711 $44,274 O $49,915 $58,552

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS