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

Related Homework Solutions

Finance Questions: Risk, Inflation, Interest, Bonds
Homework Solution
$16.00
Accounting
Business
Finance
Financial Mathematics
Inflation
Interest
Bonds
Face Value
YTM
Maturity Risk Premium
Default Risk Premium
Treasury Securities
Percentage
Market Price
World Currencies
Homework Solution
$33.00
Business
Finance
Accounting
Economy
Currency
Money
US Dollar
Cash
Euro
New Zealand Dollar
Mexican Peso
Chilean Peso
Kuwait Dinar
Vietnam Dong
Cross Rates
Finance Questions
Homework Solution
$48.00
Business
Finance
Accounting
Payback
Cash Flow
Projects
Companies
Exchange Rates
Investors
Expansions
Bonds
Maturity
Tax Rate
Mortgage
Payments
Stock Prices
Investments
Capital
Supply
Demand
Regulations
Portfolio
Debt
Equity
Functio
Business Questions
Homework Solution
$35.00
Business
Accounting
Administration
Economy
Finance
Stock Splits
Stock Dividends
Taxes
Cash
Budget
Costs
Borrowing
Interest Rate
Credits
Balance Sheet
Finance Questions
Homework Solution
$35.00
Finance
Business
Accounting
Coupon
Payments
Costs
Bonds
Investments
Expansion Program
Growth
Risk Premium
Equity
Percentage
Data
Capital Structure
Functions
Equations
Get help from a qualified tutor
Live Chats