PLEASE EXPLAIN THIS TABLE TO ME!

TELL ME HOW THE CALCULATIONS ARE MADE!!!

Analysis of financial viability in the selection of projects Discount rate 8% Time to completion = 6 months 0 1 2 3 Total Costs 140,000 40,000 40,000 40,000 Discount factor 1 0.93 0.86 0.79 Discounted costs 140,000 37,037 34,294 31,753 243,084 Benefits 0 200,000 200,000 200,000 Discount factor 0.93 0.86 0.79 Discounted benefits 186,185 171,468 158,766 515,419 Discounted benefits - costs 140,000 148,148 137,174 127,013 Cumulative benefits - costs 140,000 8,148 145,322 272,366 * NPV Payback in year 1 Discounted life cycle ROI > 112% Assumptions Costs # hours PM (500 hours, $50/hour) 25,000 Staff (1,500 hours, $70/hour) 105,000 Outsourced software and services 10,000 Total project costs (all applied in year 0) 140,000 Integrate the formulas of: Discount Factor = 1 / (1 * (1 + Discount Rate)Period Number) Discounted ROI = (total discounted benefits - total discounted costs) / total discounted costs *100