+1 4853618276 support@regentessays.com

5-10A. (Solving for i in annuities) Nicki Johnson, a sophomore mechanical engineering student,,receives a call from an insurance agent who believes that Nicki is an older woman ready to retire,from teaching. He talks to her about several annuities that she could buy that would guarantee,her an annual fixed income. The annuities are as follows:,annuity A Initial Payment into Annuity A \$50,000, annuity B Initial payment into Annuity B \$60,000, annuity c Initial payment into Annuity C \$70,000. AT t = 0. annuity A amount of money received per year Annuity A \$8,500. annuity B amount of money received per year Annuity B \$7,000. annuity C amount of money received per year Annuity C \$8,000. Duration of annuity (years) for annuity A 12 years, annuity B 25 years, annuity C 20 years. If Nicki could earn 11 percent on her money by placing it in a savings account, should she place,it instead in any of the annuities? Which ones, if any? Why?,if possible need in excel format