Question: Use Excel to answer this question: Assume that you are going to make 42 annual contributions into your retirement plan, staring today. The first annual

Use Excel to answer this question: Assume that you are going

Use Excel to answer this question: Assume that you are going to make 42 annual contributions into your retirement plan, staring today. The first annual contribution is $12,000, but your contributions then grow at 5% each year. What is the future value of these 42 contributions (note: at the end of year 41 ), if the discount rate is 6% ? $4,827,806.19 $4,554,534.14 $4,257,213.01 $3,699,863.18

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!

H, age 45, and W, age 43, are married with a 5-month-old son. H and W always file jointly. H is the vice president of a local bank and is paid a salary of $95,000. W is registered nurse at a large...

Use Excel to answer this question: Assume that you are going to make 4 2 annual contributions into your retirement plan, staring today. The first annual contribution is $ 1 0 , 0 0 0 , but your...

N QUESTION 20 Which of the following is true about financial statements? a. Since financial statements are prepared following GAAP, they can be directly compared across companies. b. Audited...

You need $76,000 in 11 years. If you can earn .43 percent per month, how much will you have to deposit today? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,...

Pretty simple just answer the questions below its only 2 of them attached are the reference materials you'll need to site apa style format from Chapter 11: 11.2 #2 (p. 276) Also answer this question...

1 . You invest $ 1 0 4 into an account in 3 years from today that is expected to earn 6 . 9 % per year. Then, you invest $ 2 3 9 into the same account in 9 years from today. What will the account...

Dears, Kindly we need your help to read the below Case Study and Answer the question : 1) What should Gassner and the Executive Committee doing about modifying the business plan and bonus targets of...

I need a step by step solution on how to solve this problem please. UNIS Data Review View Help O Search X LE Paste Calibri 29 Wrap Text General . 12 -A A - A- LL BIU + Merge & Center - $ % 9 Insert...

If the current rate of interest is 7.5%, then the present value (PV) of an investment that pays 51000 per year and lasts 8 years is iclasest to Note. Express youranswers in strictly numerical terms....

QUESTION 1 7 "A perpetuity has a PV of $ 1 0 0 0 . If the interest rate is 6 % , how much will the perpetuity pay every year? Note: Express your answers in strictly numerical terms. For example, if...

What are the problems with the proto-orthodox claims about the apostolic authorship of the texts in their canon? To which books does each "problem" apply? [Notes; "Introduction to the New Testament...

Calculate the future sum of $1,000, given that it will be held in the bank for 5 years and earn 10 percent compounded semiannually.

Rockwell owns sixty - five percent ( 6 5 % ) of the capital and profits interest of the RW Partnership. Rockwell sells Land ( Adjusted Basis of $ 4 0 , 0 0 0 and Fair Market Value of $ 6 0 , 0 0 0 )...

North Division has the following information: Sales $1240000 Variable expenses 652000 Fixed expenses 620000 If this division is eliminated, the fixed expenses can be allocated to the companys other...