Use Excel

For example.. I want it looks like that

7.21 From the following data, calculate the (a) conven tional and (b) modified benefit/cost ratios using a discount rate of 6% per year and a very long (in nite) project life. To the People To the Government Benefits:$300,000 now Costs: $1.5 million novw and $100,000 per year thereafter $40,000 per year and $200,000 three years from now Disbenefits: Savings: $70,000 per year 0 1 2 3 4 cf 150000 -1000 -1000 -1000 -1000 4000 cf -200000 1500 -1500 1500 1500 5500 ($535.27) ($1,159.39) ($150,535.27) ($201,159.39) npv -pv 1