NURS 6211

Vincy
ExpenseandrevenueforEMR.xlsx

Sheet1

Expenses/Cost Initial cost FY1 FY2 FY3 FY4 FY5 Total (5Years) XCD
Startup Expenses
Software Licenses $160,000 $180,000 $200,000.00
Training (staff) $217,000 0 0 0 0 0
Hardware & Software setup $294,117 0 0 0 0
Other hardware (including peripherals) $30,000 0 $60,000
Server $115,000 $55,000.00 $55,000.00
3rd party interface $30,000
Cost/procedure at $25/procedure x 150 $3,750
Contingency, 20% $110,000
Total Expenses $959,867 $235,000 $315,000.00 $1,509,867
Revenue /Benefits
New medical record creation $111,664 $204,093 $204,093 $204,093 $204,093
Software support $45,000 $50,000 $50,000.00
Improved coding $20,000 $22,000.00 $22,000.00 $22,000.00 $22,000.00
Charge capture $32,880 $32,880 $32,880 $32,880 $32,880
Chart management $45,000 $50,000.00 $50,000 $50,000.00 $50,000.00
Contingency, 20% $11,000 $15,000 $15,000.00
Total Expenses $265,544 $308,973 $373,973 $308,973 $373,973 $1,631,436
ROI
Invested Amount $1,509,867.00
Returned Amount $1,631,436
Gain/Loss $121,569.00
ROI 8.05%
Annual Return 1.56%

Sheet2

Sheet3