USING EXCEL. PLEASE SUBMIT BEFORE DEADLINE

Your grandfather has offered you a choice of one of the three following alternatives: $13,000 now; $6,500 a year for eight years; or $92,000 at the end of eight years. (Use a Financial calculator to arrive at the answers. Round the final answers to the nearest whole dollar.) a-1. Assuming you could earn 11 percent annually, compute the present value for the following amounts. a-2. Which alternative should you choose? $92,000 received at the end of eight years $6,500 received each year for eight years $13,000 received now b-1. If you could earn 13 percent annually, compute the present value for the following amounts. b-2. Which alternative should you choose? $92,000 received at the end of eight years $6,500 received each year for eight years $13,000 received now