Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedPlease 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

3. Resolving differences.

Answered: 1 week ago

Question

7. Highlight warnings and precautions.

Answered: 1 week ago

Question

8. Use headings and subheadings for longer procedures.

Answered: 1 week ago