finance management

su_mhc6305_w4_a4.xls

Capital Project Analysis

Project Analysis Case Study					© 2007 South University
Boca Grande Hospital
Enter appropriate input values in the cells colored red.
INPUT DATA:				KEY OUTPUT:
Land initial cost			$0	NPV	$0
Land opportunity cost (and salvage value)			$0	IRR	0.0%
Building/equipment cost			$0	MIRR	0.0%
Build/equipment salvage value			$0	Payback	999.0
Procedures per day			0
Average net revenue per procedure			$0
Labor costs			$0
Utilities costs			$0
Incremental overhead			$0
Supply cost ($/procedure)			$0
Inflation rate on charges			0.0%
Inflation rate on costs			0.0%
Tax rate			0.0%
Revenues lost from inpatient surgeries			$0
Reduction in inpatient surgery costs			$0
Cost of capital			0.0%
MODEL-GENERATED DATA:
Depreciation Schedule:
		MACRS	Deprec.	End of Year
	Year	Factor	Expense	Book value
	1	0.20	$0	$0
	2	0.32	0	0
	3	0.19	0	0
	4	0.12	0	0
	5	0.11	0	0
	6	0.06	0	0
Net Cash Flows:
			Project Cash Flows
			0	1	2	3	4	5
Land opportunity cost			$0
Building/equipment cost			0
Net revenues (including inpatient loss)				$0	$0	$0	$0	$0
Less: Labor costs				0	0	0	0	0
Cost savings on inpatients				0	0	0	0	0
Utilities costs				0	0	0	0	0
Supplies				0	0	0	0	0
Incremental overhead				0	0	0	0	0
Depreciation				0	0	0	0	0
Income before taxes				$0	$0	$0	$0	$0
Taxes				0	0	0	0	0
Project net income				$0	$0	$0	$0	$0
Plus: Depreciation				0	0	0	0	0
Plus: Net land salvage value								0
Plus: Net building/equipment salvage value								0
Net cash flow			$0	$0	$0	$0	$0	$0
Cumulative net cash flow			$0	$0	$0	$0	$0	$0
(For payback calculation)
Profitability and Breakeven Measures:
Net present value (NPV)				$0
Internal rate of return (IRR)				0.0%
Modified IRR (MIRR)				0.0%
Payback				999.0

Page &P