Question
Biggs-Gridley Memorial Hospital, a non-taxpaying entity, is starting a new inpatient heart center on its third floor. The expected patient volume demands will generate $5,000,000
Biggs-Gridley Memorial Hospital, a non-taxpaying entity, is starting a new inpatient heart center on its third floor. The expected patient volume demands will generate $5,000,000 per year in revenues for the next five years. The new center will incur operating expenses, excluding depreciation, of $3,000,000 per year for the next five years. The initial cost of building and equipment is $7,000,000. Straight-line depreciation is used to estimate depreciation expense, and the building and equipment will be depreciated over a five-year life to their salvage value. The expected salvage value of the building and equipment at year five is $800,000. The cost of capital for this project is 10 percent. Compute the NPV and IRR to determine the financial feasibility of this project. Compute the NPV and IRR to determine the financial feasibility of this project if this were a tax-paying entity with a tax rate of 30 percent. (Hint: see Appendix E. Because the hospital is depreciating to the salvage value, there is no tax effect on the sale of the asset.)
I need in this format...
Givens | Years | 0 | 1 | 2 | 3 | 4 | 5 |
1 Initial Investment |
|
|
|
|
|
|
|
2 Net Revenue |
|
|
|
|
|
|
|
3 Cash Operation Expense |
|
|
|
|
|
|
|
4 Annual Depreciation |
|
|
|
|
|
|
|
5 Salvage Value |
|
|
|
|
|
|
|
6 Cost of Capital |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A Initial Investment |
|
|
|
|
|
|
|
B Net revenue |
|
|
|
|
|
|
|
C Less Cash operating expense |
|
|
|
|
|
|
|
D Less Depreciation Expense |
|
|
|
|
|
|
|
E Net Operating Income |
|
|
|
|
|
|
|
F Add Depreciation Expense |
|
|
|
|
|
|
|
G Net operating cash flows |
|
|
|
|
|
|
|
H Add Sale of salvage value |
|
|
|
|
|
|
|
I Project cash flows |
|
|
|
|
|
|
|
J Cost of Capital |
|
|
|
|
|
|
|
K Present value interest factors |
|
|
|
|
|
|
|
L Annual PV of cash flow |
|
|
|
|
|
|
|
M PV of cash flow |
|
|
|
|
|
|
|
N Net Present Value |
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started