Question: Please explain the annuity payment on excel. Formulas provided but answer is wrong. 32. You are going to pay $100 into an account at the

Please explain the annuity payment on excel. Formulas provided but answer isPlease explain the annuity payment on excel.

Formulas provided but answer is wrong.

32. You are going to pay $100 into an account at the beginning of each of the next 40 years. At the beginning of the 41st year you buy a 30 year annuity whose first payment comes at the end of the 41st year (the account pays 12%). How much will you receive at the end of the 41st year (i.e. the first annuity payment). Round to nearest $100. a. $93,000 b. $7,800 c. $11,400 d. $10,700 PMT 100 nper 40 r 0.12 $85,914.24 =FV(C13,012,-C11,,1) ($10,419.98) =PMT(C13,41,86000,0,0)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!