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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
