Gabrielle just won$2.7million in the state lottery. She is given the option of receiving a of$1,200,000now, or she can elect to receive$90,000at the end of each of the next30years. If Gabrielle can earn5%annually on her investments, which option should she take?If Gabrielle takes the prize as an annuity, the present value of the30-yearordinary annuity is?Can you do it in an excel format?

Gabrielle just won $2.7 million in the state lottery. She is given the option of receiving a of $1,200,000 now, or she can elect to receive $90,000 at the end of each of the next 30 years. If...

Gabrielle just won

$2.7

million in the state lottery. She is given the option of receiving a of

$1,200,000

now, or she can elect to receive

$90,000

at the end of each of the next

years. If Gabrielle can earn

annually on her investments, which option should she take?

If Gabrielle takes the prize as an annuity, the present value of the

30-year

ordinary annuity is?

Can you do it in an excel format?

Jun 07, 2022