Question

Georgia Health Center, a for profit hospital, is evaluating the purchase of a new diagnostic equipment. The equipment, which cost $600,000, has an expected life of five years and an estimated pretax salvage value of $200,000 at that time. The equipment is expected to be used 15 times a day for 250 days a year for each year of the project’s life. On average, each procedure is expected to generate $80 in collections, which is net of bad debt losses and contractual allowances, in its first year of use. Thus, net revenues for Year 1 are estimated at 15 x 250 x $80= $300,000

Labor and maintenance costs are expected to be $100,000 during the first year of operation, while utilities will cost another $10,000. The cost for expendable supplies is expected to average $5 per procedure during the first year. Cash overhead will increase by $5,000 in Year 1. All costs and revenues, except depreciation, are expected to increase at 5 percent inflation rate per year after the first year.

The equipment falls into the MACRS five-year class for tax depreciation and is subject to the following depreciation allowances:

Year	Allowance
1	0.20
2	0.32
3	0.19
4	0.12
5	0.11
6	0.06

The hospital’s tax rate is 40 percent, and its corporate cost of capital is 8%.

You can use Excel to complete this problem. If you do, please submit your homework document and the Excel file.

a. Estimate the project’s net cash flows over its five-year estimated life. Hint: complete the following table.

	0	1	2	3	4	5
Equipment cost
Net revenue
Less:
Labor & Maintenance
Utilities costs
Supplies
Incremental overhead
Depreciation
Income before taxes
Taxes (40%)
Project’s net income
Plus: Depreciation
Plus: Net salvage value

b. What’s the project’s NPV?

c. What’s the project’s IRR?

Answer 1

A.						( in $)
	0	1	2	3	4	5
Equipment cost	600000
Net revenue		300000	315000	330750	347288	364652
Less:
Labor & Maintenance		100000	105000	110250	115763	121551
Utilities costs		10000	10500	11025	11576	12155
Supplies		18750	19688	20672	21705	22791
Incremental overhead		5000	5250	5513	5788	6078
Depreciation		120000	192000	114000	72000	66000
Income before taxes		46250	-17438	69291	120455	136078
Taxes (40%)		18500	-6975	27716	48182	54431
Project’s net income		27750	-10463	41574	72273	81647
Plus: Depreciation		120000	192000	114000	72000	66000
Plus: Net salvage value						134400
Net Cash Flows (1)	-600000	147750	181538	155574	144273	282047
B.	Net Present Value
Present Value Factor (@ 8%)	1	0.9259	0.8573	0.7938	0.7350	0.6806
PV of Net Cash Flows	-600000	136806	155639	123500	106045	191956
PV of Net Cash inflows	713946
PV of Cash Out Flows	-600000
Net Present Value of Project	113946
C.	IRR
Since at Cost of Capital of 8%, Net Present Value is $113946, IRR is higher than 8%
Calculating NPV Using 12%
Present Value Factor (@ 12%)	1	0.8929	0.7972	0.7118	0.6355	0.5674
PV of Net Cash Flows	-600000	131920	144721	110735	91688	160041
NPV AT 12%	39104
Calculating NPV Using 15%
Present Value Factor (@ 15%)	1	0.8696	0.7561	0.6575	0.5718	0.4972
PV of Net Cash Flows	-600000	128478	137268	102293	82489	140227
NPV AT 15%	-9245
IRR                                  =	LOWER RATE   +   [ NPV AT LOWER RATE/ (NPV AT LOWER RATE - NPV AT HIGHER RATE) ] *   (HIGHER RATE - LOWER RATE)
=	0.12 + ( 39104 / (39104-(-9245) ))    * (0.15-0.12)
=	14.43%