3)In this exercise you will calculate the Present Value based on the following parameters: a.X = $14,000 b.N = 5 years c.r = 7.5%

Part 2:

1)Create a new worksheet in the file and name it Part 2.

2)Using the same parameters as in #3 above create the following:

a.Create a table with a column of discount rates from 2% to 25% in increments of a half percentage. For example, 2%, 2.5% 3% and so on.

b.In the table create a column to calculate the present value at each discount rate.

c.Create a line chart showing the present value for each discount rate.