Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started