Question: 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 depositPlease 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 percent

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!