Question

Assume that you are the CFO of a non-tax paying hospital that is considering opening a pediatric unit. Based on your research, you expected the following:
The cost of new equipment for the unit is $4 million. The equipment has a 10 year useful life and can be sold for $500K at the end of 10 years. (Assume straight line depreciation)
• The staffing cost for the unit is as follows:
• 3 doctors @ an average annual salary of $250K each
• 6 nurses @ an average annual salary of $70K each
• 1 administrative assistant with an annual salary of $40K
• A salary increase of 4% is given each year.
• Employee benefits are 35% of salaries
• Other operating expenses are projected at $2.75 million per year and are expected to increase by 5% each year.
• The average revenue collected from each patient encounter is $650.
• In the first year, this unit is expected to have 8,000 patient encounters.
Patient encounters are expected to grow by 2% each year in years 2-4 and 4%
each year in years 5-7 and 5% each year in years 8-10.
• The required rate of return is 10%.
• The required payback period is 7 years.

You are required to:
Prepare an Excel document that shows the projected cash flows and the NPV, IRR, and payback period calculations.
Prepare a single spaced report to the hospital’s board explaining whether they should proceed with opening this unit. Use NPV, IRR and payback period as the basis for your recommendation. Be sure to explain all of your assumptions. In a practical sense, there are many factors that are missing that should be considered in this decision. Devote a third of your report to highlight any factors that may affect the cash flow calculations.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Business and Finance: Hospital Management

This is only a preview of the solution. Please use the purchase button to see the entire solution

$90.00

or $1 if you
register a new account!

Related Homework Solutions

Future Contract and Stock Option Explanation
Homework Solution
$33.00
Business
Finance
Economics
Contracts
Stocks
Cash
Strike Prices
Profit
Loss
Risk
Textile Importers
Companies
Call Option
Put Option
Finance Questions
Homework Solution
$13.00
Business
Finance
ER
Remnimbi
Yen
Interest
China
Japan
Thailand
US
Sales
Production
Income Statement & Net Cash Flow
Homework Solution
$9.00
Accounting
Business
Financial Management
Economy
Income Statement
Net Cash Flow
EBIT
Tax
Amortization Expenses
Interest
Expenses
Depreciation
Business Questions
Homework Solution
$44.00
Accounting
Business
Financial Management
Economy
International Monetary Fund
Financial Crisis
Loans
Deposits
Banks
Federal Reserve
Basis Points
Inflation
Money Supply
Business Questions
Homework Solution
$83.00
Accounting
Business
Financial Management
Economy
Government Securities
Prices
Profit
Liabilities
Bonds
Cash Flow
Discount Factors
Face Value
Interest Rate
Coupon Reinvestment Rate
Get help from a qualified tutor
Live Chats