Can someone please tell me if I am on the right path with calculating ROI? I have 120% for annual ROI and total 86%. When i broke up direct i got 40% annual and overall total of 29%.

Scenario 1 Annual Benefits	Initial	Yr1	Yr2	Yr3
Direct	-	100	100	100
Indirect	-	200	200	200
Total Benefits per period	-	300	300	300
Depreciation Schedule	Acquisition	Yr1	Yr2	Yr3
Software	100	-	-	-
Hardware	50	-	-	-
Total Depreciation per period	150	-	-	-
Expensed Costs	Initial	Yr1	Yr2	Yr3
Software	-	100	100	100
Hardware	-	50	50	50
Consulting	100	-	-	-
Personnel	100	100	100	100
Training	100	-	-	-
Other	-	-	-	-
Total Costs per period	300	250	250	250

Expensed Costs	Initial	Yr1	Yr2	Yr3
Software	-	100	100	100
Hardware	-	50	50	50
Consulting	100	-	-	-
Personnel	100	100	100	100
Training	100	-	-	-
Other	-	-	-	-
Total Costs per period	300	250	250	250

Scenario 1 Annual Benefits	Initial	Yr1	Yr2	Yr3
Direct	-	100	100	100
Indirect	-	200	200	200
Total Benefits per period	-	300	300	300

Scenario 1 Annual Bene Initial Direct Indirect - Yr1 100 200 Yr2 100 200 Yr3 100 200 Total Benefits per perio - 300 300 300 Depreciation ScheduleAcquisition Yr1 Software 100 Hardware 50 - ### ### - Total Depreciation per p - - - Expensed Costs Software Hardware Consulting Personnel Training Other 150 Initial Yr2 Yr1 Yr3 Yr2 Yr3 100 100 100 - 100 50 100 ### 100 50 ### 100 ### - Total Costs per period 300 250 250 Discount rate 15% Annual ROI Total 120% 120% 120% 86% 40% 40% 40% 80% 80% 80% Direct ROI total Direct ROI Indirect ROI Total Indirect ROI 100 50 100 ### TCO checksum 1,200 250 29% 57% Scenario 2AnnInitial Direct Indirect - 100 200 100 200 100 200 Total Benefits - 300 300 300 CO checksum Yr1 Yr2 Yr3