-
Nama : Rio Irzan AlviardiNoreg : 5235131585Prodi : PTIK 2013Mata Kuliah : Analisa Perancangan Sistem (kosek 9573)Tugas : Tuliskan perhitungan ROI dengan menggunakan Ms. EXCEL
-
Page 1-34
Year 0 Year 1 Year 2 Year 3 TotalTotal Benefits 45,000 50,000 57,000 152,000
Total Costs 100,000 11,000 12,000 16,000 138,000ROI -1 3.09090909 3.166667 2.5625 0.101449275
Page 1-37
Year 0 Year 1 Year 2 Year 3 TotalTotal Benefits 45,000 50,000 55,000 150,000
Total Costs 100,000 10,000 12,000 16,000 138,000ROI -1 3.5 3.166667 2.4375 0.086956522
Page 1-402012 2013 2014 2015 2016
Total Benefits 638,000 668,000 699,800 733,508Total Costs 1,632,295 185,000 189,600 194,384 199,359
ROI -1 2.44864865 2.523207 2.600091 2.67933226
-
Page 1-40Total
2,739,3082,400,638
0.1410749976
Sheet1