Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete A, B, And C with excel formulas shown You deposit $14,000 annually into a life insurance fund for the next 10 years, after
Please complete A, B, And C with excel formulas shown
You deposit $14,000 annually into a life insurance fund for the next 10 years, after which time you plan to retire. a. If the deposits are made at the beginning of the year and earn an interest rate of 7 percent, what will be the amount in the retirement fund at the end of year 10? b. Instead of a lump sum, you wish to receive annuities for the next 20 years (years 11 through 30). What is the constant annual payment you expect to receive at the beginning of each year if you assume an interest rate of 7 percent during the distribution period? c. Repeat parts (a) and (b) above assuming earning rates of 6 percent and 8 percent during the deposit period and earning rates of 6 percent and 8 percent during the distribution period. Answer is not complete. Complete this question by entering your answers in the tabs below. Req A and B Reqc Repeat parts (a) and (b) above assuming earning rates of 6 percent and 8 percent during the deposit period and earning rates of 6 percent and 8 percent during the distribution period. (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Value at 10 Years Distribution Period Deposit Period 6 percent Annual payment $ 184,531.13 X 6 percent 8 percent 8 percent 6 percent 8 percentStep 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