Question

Your job pays you once a year for all the work you did over the previous...

Your job pays you once a year for all the work you did over the previous 12 months. Today, December 31st, you received your salary of $55,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 9% of your annual salary in an account that will earn 10% per year. Your salary will increase at 3% per year throughout your career. How much money will you have on the date of your retirement 40 years from today?

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Salary 55000 56650 58349.5 60099.99 61902.98 63760.07 65672.88 67643.06 69672.35 71762.53 73915.4 76132.86 78416.85 80769.35 83192.43 85688.21 88258.85 90906.62
Invested 0 5098.5 5761.305 5985.129 6169.782 6355.385 6546.097 6742.485 6944.76 7153.103 7367.696 7588.727 7816.389 8050.881 8292.407 8541.179 8797.415 9061.337
Interest 0 509.85 576.1305 598.5129 616.9782 635.5385 654.6097 674.2485 694.476 715.3103 736.7696 758.8727 781.6389 805.0881 829.2407 854.1179 879.7415 906.1337
Year 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
Salary 93633.82 96442.83 99336.12 102316.2 105385.7 108547.3 111803.7 115157.8 118612.5 122170.9 125836 129611.1 133499.4 137504.4 141629.6 145878.4 150254.8 154762.4
Invested 9333.177 9613.173 9901.568 10198.61 10504.57 10819.71 11144.3 11478.63 11822.99 12177.68 12543.01 12919.3 13306.88 13706.09 14117.27 14540.79 14977.01 15426.32
Interest 933.3177 961.3173 990.1568 1019.861 1050.457 1081.971 1114.43 1147.863 1182.299 1217.768 1254.301 1291.93 1330.688 1370.609 1411.727 1454.079 1497.701 1542.632
Year 36 37 38 39 40
Salary 159405.3 164187.5 169113.1 174186.5 179412.1
Invested 15889.11 16365.78 16856.76 17362.46 17883.33
Interest 1588.911 1636.578 1685.676 1736.246 0
Formulas entered in year 1(for example)
(same formulas carried forward)
Salary in Year 1 (Salary in Year 0)*1.03
Invested in Year 1 (Salary in Year 1)*0.09+Int in Year 0
Interest(C50) (Invested in year 1)*0.1
Add a comment
Know the answer?
Add Answer to:
Your job pays you once a year for all the work you did over the previous...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Your job pays you only once a year for all the work you did over the...

    Your job pays you only once a year for all the work you did over the previous 12 months. Today, December 31, you just received your salary of $46,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 2 percent of your annual salary in an account that will earn 9 percent per year. Your salary will increase...

  • Your job pays you only once a year, for all the work you did over the...

    Your job pays you only once a year, for all the work you did over the previous 12 months. Today, December 31, you just received your salary of $67,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 10 percent of your annual salary in an account that will earn 10.7 percent per year. Your salary will increase...

  • Your job pays you only once a year for all the work you did over the...

    Your job pays you only once a year for all the work you did over the previous 12 months. Today, December 31, you received your salary of $68,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 10 percent of your annual salary in an account that will earn 10.8 percent per year. Your salary will increase at...

  • You are saving for your retirement. You have decided that one year from today you will...

    You are saving for your retirement. You have decided that one year from today you will deposit 4 percent of your annual salary in an account which will earn 8 percent per year. Your salary currently (today) is $70,000, and it will increase at 2 percent per year throughout your career. How much money will you have for your retirement, which will begin in 35 years? Assume your first payment into the account is one year from today after your...

  • 1. You are saving for retirement. You have decided that one year from today you will...

    1. You are saving for retirement. You have decided that one year from today you will begin investing 10 percent of your annual salary in a mutual fund which is expected to earn a return of 12 percent per year (compounded semi-annually). Your present salary is $30,000, and you expect that it will grow by 4 percent per year throughout your career (consequently, your investment at time 1 will be $3,000, your investment at time 2 will be $3,120, etc.)....

  • When you start your first full-time job, you plan to open a retirement savings account. Your...

    When you start your first full-time job, you plan to open a retirement savings account. Your goal is to retire 25 years from the day you start working. You will use a retirement investment account that pays 5.5% nominal interest, compounded annually, and you want to have exactly $400,000 in that account when you retire. You will make end of year deposits every year for the 25 years working, and you expect your income will increase 4% per year throughout...

  • Your new job offers a savings plan that pays 0.25 percent in interest each month. You...

    Your new job offers a savings plan that pays 0.25 percent in interest each month. You can't participate in the plan, however, until you have 9 years with the company. At that time you will start saving $200 a month for the next 22 years. How much will you have in this savings account in 31 years? Round your answer to two decimals SO Another perk of your new job is that, after 9 years with the company, you will...

  • Your new job offers a savings plan that pays 1.00 percent in interest each month. You...

    Your new job offers a savings plan that pays 1.00 percent in interest each month. You can't participate in the plan, however, until you have 8 years with the company. At that time you will start saving $550 a month for the next 28 years. How much will you have in this savings account in 36 years? Round your answer to two decimals. Another perk of your new job is that, after 8 years with the company, you will also...

  • Hi please provide formulas used. Thanks :) Your new job offers a savings plan that pays...

    Hi please provide formulas used. Thanks :) Your new job offers a savings plan that pays 0.75 percent in interest each month. You can't participate in the plan, however, until you have 10 years with the company.  At that time you will start saving $450 a month for the next 29 years. How much will you have in this savings account in 39 years? Round your answer to two decimals. $ Another perk of your new job is that, after 10...

  • To quantify the values of two potential career paths (work or go to college), you assume...

    To quantify the values of two potential career paths (work or go to college), you assume the followings. 1. Your parents will give you $55,000 from a college fund today whichever career path you choose. 2. Your salary directly goes to your saving account and sits there. 3. Your total living cost and taxes are always zero. 4. You will retire in 45 years from now. 5. The interest rate of your saving account is 2% per year, compounded annually....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT