Question

Required: Siegfried Basset is 65 years of age and has a life expectancy of 12 more years. He wishes to invest $20,000 in an annuity that will make a level payment at the end of each year until his death. If the interest rate is 8%, what income can Mr. Basset expect to receive each year? Note: Use cells A8 to B10 from the given information to complete this question. You must use the built-in Excel function to answer this question. All answers should be displayed as positive numbers. Round your answer to 2 decimal places. Input area: Interest rate Investment Years of life expectancy Output area: Yearly income 8% $ 20,000 12 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work

          Required:
Siegfried Basset is 65 years of age and has a life expectancy of 12 more years. He wishes to invest $20,000 in an annuity that
will make a level payment at the end of each year until his death. If the interest rate is 8%, what income can Mr. Basset expect
to receive each year?
Note: Use cells A8 to B10 from the given information to complete this question. You must use the built-in Excel function to
answer this question. All answers should be displayed as positive numbers. Round your answer to 2 decimal places.
Input area:
Interest rate
Investment
Years of life expectancy
Output area:
Yearly income
8%
$ 20,000
12
Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work

Required:
Siegfried Basset is 65 years of age and has a life expectancy of 12 more years. He wishes to invest 20,000 in an annuity that
will make a level payment at the end of each year until his death. If the interest rate is 8%, what income can Mr. Basset expect
to receive each year?
Note: Use cells A8 to B10 from the given information to complete this question. You must use the built-in Excel function to
answer this question. All answers should be displayed as positive numbers. Round your answer to 2 decimal places.
Input area:
Interest rate
Investment
Years of life expectancy
Output area:
Yearly income
8% 20,000
12
Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work

Added by Valerie U.

Question

Please give Ace some feedback