Capital Project Case Study

profileLeeTampa
CapitalProjectCaseStudyPart2.xlsx

Sheet1

Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Nurse Triage Salaries $ 523,800 $ 549,990 $ 577,490 $ 606,364 $ 636,682 $ 668,516
Forecasted ER Cost Reductions $ 400,000 $ 800,000 $ 848,000 $ 900,577 $ 955,512 $ 1,013,798
New IT Specialist's Salary $ 150,000 $ 154,500 $ 159,135 $ 163,909 $ 168,826 $ 173,891
Costs of Facility Renovations $ 30,000 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Necessary Capital Equipment Purchases $ 117,000 $ 3,510 $ 3,510 $ 3,510 $ 3,510 $ 3,510
Net Cash Flow:
Present Values of Net Cash Flows:
Net Present Value:
Internal Rate of Return (IRR):
Modified Internal Rate of Return (MIRR):
Payback Period (# years):
Discounted Payback Period (# years):