How to do on Excel

A privately run, for-profit, prison is considering ways in which it can cut its monthly costs and therefore increase profit. One idea it is considering is to pay a judge to guarantee convicted prisoners in poor health win their appeals and are set free. The prison believes it can realize the monthly cost savings below over the initial year of the plan. What is the present value of the first year's monthly cost savings? Assume a discount rate of 8%. Month Savings ($) 3,500 6,000 6,500 9,000 9,000 9,000 9,400 9,800 4,800 5,000 2,000 3,500 77,500 10 11 12 31 Total