Silly Cat Training (SCT), a cat training school, is being sued by the parents of a child who was bitten by a cat in the custody of SCT. Two out-of-court settlements are under consideration. Under the first, SCT would pay the injured party $100,000 per year for 10 years, with the first payment one year from today. Under the second alternative, SCT would pay the injured party $100,000 today and $1,000,000 ten years from today. In your report, describe which of these offers is best from SCTs perspective, assuming a 2.5 percent interest rate? PLEASE SHOW WORK IN EXCEL

1. Present value of 1^st settlement: $100,000 per year for ten years
2. Present value of 2^nd settlement: $100,000 today and $1,000,000 ten years from today

23 24 D) 25 Rate Number of Periods Payments Future Value Present value of 1st Settlement $0.00 26 27 E) Rate Number of Periods Payments Future Value Present value of 2nd Settlement 28 29 20