In: Computer Science
The given table contains values of Total Benefits and Total Costs for a period of five years. Calculate all other values and fill the table. Use the provided excel file.
Year | 1 | 2 | 3 | 4 | 5 | Total | ||
Total Benefits | 52587 | 84364 | 96870 | 103574 | 112851 | 450246 | ||
PV of Benefits | ₹ 50,564.42 | ₹ 77,999.26 | ₹ 86,117.08 | ₹ 88,535.49 | ₹ 92,755.30 | |||
PV of All Benefits | ₹ 3,70,069.39 | |||||||
Total Costs | 148502 | 48084 | 39870 | 35584 | 33582 | 305622 | ||
PV of Costs | ₹ 1,42,790.38 | ₹ 44,456.36 | ₹ 35,444.28 | ₹ 30,417.35 | ₹ 27,601.96 | |||
PV of All Costs | ₹ 2,51,199.01 | |||||||
Total Projects Benefits-Costs | ₹ -97,937.58 | ₹ 29,915.26 | ₹ 46,247.08 | ₹ 52,951.49 | ₹ 59,173.30 | ₹ 90,349.55 | ||
Yearly NPV | ₹ -94,170.75 | ₹ 27,658.34 | ₹ 41,113.48 | ₹ 45,263.15 | ₹ 48,636.14 | |||
Cumulative NPV | ₹ 74,260.74 | |||||||