I need to know how to calculate a 5% discount for these tables to find the NPV.

Table 6.4 Cost-Benefit Analysis for Two Public Infrastructure Projects (S) Cost Year Personnel Operating Capital Benefit Project A 0 (the current year) 1 300,000 150,000 100,000 200,000 100,000 25,000 2,000 15,000 21,000 21,000 21,000 21,000 21,000 25,000 25,000 25,000 2 3 30,000 150,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 5 C 7 0 8 0 C 10 Project B 0 (the current year) 0 500,000 100,000 125,000 25,000 0 187,500 187,500 187,500 187,500 187,500 187,500 187,500 12,500 25,000 25,000 25,000 25,000 25,000 25,000 25,000 1 2 3 4 5 6 7 8 C C C 0 C 187,500 187,500 25,000 25,000 0 10 0 187,500 4. Ilustrate the concept of opportunity cost with examples in personal finance 5. Discuss the limitations of CBA in the public sector. Comment on the statement: "economical feasibility does not guarantee that a project will be funded." 3. CALCULATIONS Table 6.4 shows cost and benefit flows of two public infrastructure projects. 1. Use a 5 percent discount rate to compute the NPV for both projects 2. Recalculate the NPV for both projects with a 10 percent discount rate 3. Write a paragraph to discuss the economic feasibility of the two proje Ooo0 Oo00