Analyze financial data
pepper0513
CapitalProjectCaseStudyPart2.xlsxSheet1
| 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): |
1
2
3
4
5
6
7
8
9
A
B
Year 0
Nurse Triage Salaries
523,800
$
Forecasted ER Cost Reductions
400,000
$
New IT Specialist's Salary
150,000
$
Costs of Facility Renovations
30,000
$
Necessary Capital Equipment Purchases
117,000
$
Net Cash Flow:
Present Values of Net Cash Flows:
Net Present Value:
