Please post answer with excel functions for work. Thank you!

2. As Chief Financial Officer for a medium-sized business you have been engaged in negotiations with a provider of mobile telephone services. Naturally, they have offered you a wide array of (bewildering!) tariffs from which you can choose. If the prevailing rate of interest is 8%, which of the following will you recommend to your Board of Directors: (a) A single payment of 120,000 now (b) 200,000 payable at the end of 5 years (c) 12,500 a year forever (d) 20,000 for each of the next 10 years (e) 7,500 next year, increasing thereafter by 5% a year forever