Question: (Needs to be shown on excel) You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30

(Needs to be shown on excel)

You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the next 20 years. Calculate how much you would have to save between now and age 65 in order to finance your retirement income.

Make the following assumptions:

All savings receive compound interest of 10% per year.

You make the first payment today and the last payment on the day you turn 64 (30 payments).

You make the first withdrawal when you turn 65 and the last withdrawal when you turn 84 (20 payments).

* Since your putting a payment on the day of your birthday and the last payment on the day you turn 64, would the payments be at the "Beginning of the period" or "End of the period". This was the part I was confused on.

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!

1)-An investor considers to invest 150 000 TL for the next year. This investor has 3 options. The first option is to buy a government bond which was issued 4.5 years ago when the market interest...

Using Excel You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the...

You have just turned 3 5 , and you intend to start saving for your retirement. Once you retire in 3 0 years ( when you turn 6 5 ) , you would like to have an income of $ 1 0 0 , 0 0 0 per year for...

"Answer and formula needs to be shown on excel format" ***Since the payments are being made on the day you you turn 35 and the last payment on the day you turn 65, would the payments be calculated at...

Part b. ( Part a is posted as a separate question. Just solve this b part. just attaching part a for reference ) Miscellaneous Corporations: Provide Excel based calculations to the following by...

Question Four: (40 Marks) Suppose you just took a $10 000, five year loan. Payments at the end of each year are flat (equal in every year) at an interest rate of 15 percent. Required: Develop an...

Part a. Miscellaneous Corporations: Provide Excel based calculations to the following by putting data into Excel Sheets and performing the necessary actions: You have just turned 35, and you intend...

You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the next 20...

2. You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the next 20...

You have just turned 35, and you intend to start saving for your retirement. Once you retire in 30 years (when you turn 65), you would like to have an income of $100,000 per year for the next 20...

1. Of the balance of $142,000, $20,000 is incorrect because it represents goods that we didnt receive until January 5, 2021. Follow-up: Inspection of shipping records reveals that the item was...

The following data were obtained from a repeatedmeasures study comparing two treatment conditions. a. Use a repeated-measures t test with a = .05 to determine whether there are significant mean...

What do loan committees of a bank use as goal, resources, and timelines for load decisions. Also, what is a communications protocal?

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

2. Shake up your clothing and artifacts today. Wear something completely out of character for you, and consider how people react. If you normally dress very casually, try wearing a suit, or if youre...

Why We Listen?

2 Should you just buy the conservative suit for your interview and kiss the tongue ring good-bye? Is it ethical to present an image that works for the job, even if its incongruous with the way you...