Question
Retirement Problem budget plan. Please fill out whole thing.
RETIREMENT PROBLEM How much do you want to spend monthly when you reti you must determine how big of a nest egg you need wan

The funds can be made up by yourself it doesnt really matter how its done.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

(A)

$1000

(B)

80 year

(C)

65 year

(D)

80 - 65 = 15 years

(E)

N = 15x12 = 180 months

(F)

i = 0.06/12 =0.005

(G)

PV = 1000(1 + v + v2 + v3 + ............+ v179)

where v = (1+i)-1 = 1.005-1

\large \Rightarrow PV = 1000{(1 - v180) / v} = 1000{(1 - 1.005-180) / (1 - 1.05-1) = $119096

(H)

FV = $119096

(I)

65 year

(J)

50 year

(K)

N =12x(65 - 50) = 180 months

(L)

j = 0.09/12= 1.0075

(M)

PV = 0

(N)

119096 = PMT.{ (1+j)180 + (1+j)179 + (1+j)178 + ..........+ (1+j) }

\large \Rightarrow 119096 = PMT.(1+j)[{(1+j)180 - 1} / (1+j-1)]

\large \Rightarrow119096 = PMTx1.0075x{(1.0075180 - 1) / 0.0075}

\large \Rightarrow 119096 = PMTx381.2438

\large \Rightarrow PMT = $312.38

The goal is obtainable and adequate

(P)

PV = 1000x1.0025-180 = $639

The goal is adequate.

Add a comment
Know the answer?
Add Answer to:
Retirement Problem budget plan. Please fill out whole thing. The funds can be made up by...
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
  • A) If you delay saving by 5 years, what would the interest rate (APR) need to...

    A) If you delay saving by 5 years, what would the interest rate (APR) need to be for you to hit the target amount ($349,881.67)? Use excel RATE function and show values for arguments (nper, pmt, pv, fv, type, guess).. B) Convert that APR to an EAR. Use excel EFFECT function and show values for arguments (nominal_rate, npery) C) Amount you need in your account at retirement in order to spend $5000 each period? Use excel PV function and show...

  • Huey, Dewey and Louie are triplets.  They are 25 years old and are trying to set up...

    Huey, Dewey and Louie are triplets.  They are 25 years old and are trying to set up savings plans for themselves.  They plan to retire at age 65.  They each have different ideas.  All APR’s are 4%. Huey’s plan:  deposit $100 each month into the account and leave the money in the bank until he retires at age 65.   Dewey’s plan:  Dewey doesn’t want to be bothered with monthly payments like Huey. He wants to hang onto his money throughout the year, and then make just...

  • Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of...

    Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of $2,500,000 on the day you retire. Suppose also that you’ve saved $100,000 toward your retirement so far, and that your investment account earns a nominal rate of 7.5% per year, compounded monthly. In addition, suppose you expect a windfall inheritance of $200,000 five years from now that you will invest in this account. a) What is the effective interest rate, or annual percentage yield,...

  • Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of...

    Suppose you have 25 years until you retire, and that you desire a retirement nest-egg of $2,500,000 on the day you retire. Suppose also that you’ve saved $100,000 toward your retirement so far, and that your investment account earns a nominal rate of 7.5% per year, compounded monthly. In addition, suppose you expect a windfall inheritance of $200,000 five years from now that you will invest in this account. a) What is the effective interest rate, or annual percentage yield,...

  • Imagine you are 25 years old right now. You would like to retire in 40 years...

    Imagine you are 25 years old right now. You would like to retire in 40 years (at age 65). You would like to fund your retirement. You would like to have enough saving to withdraw $50,000 each year in retirement and you want to plan for 20 hears (the last withdrawal is at age 85). You will earn 7% annually on your saving before you retire. Then once you retire, you will move your nest egg into a safer investment,...

  • Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's...

    Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of...

  • Suppose you want to save in order to purchase a new boat. Take the APR to be 6.0%.

     Suppose you want to save in order to purchase a new boat. Take the APR to be 6.0%. If you deposit $250 each month, how much will you have toward the purchase of a boat after three years? (Round your answer to the nearest cent.) You plan to work for 40 years and then retire using a 25-year annuity. You want to arrange a retirement income of $4300 per month. You have access to an account that pays an APR of 4.8%...

  • please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully!...

    please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully! Suppose you invest $100, $200, & $300 at the end of year 1 to 3 in the next 3 years and earn 6% each year. What is the future value at the end of year 3? tcompute the PV: using CF function: CO0-0, CO1- 100, C02=200 , C03-300, I-6, CPT NPV= FV,=PV (1r)624.36 Suppose you expect your investment to earn 6 %...

  • John and Jane Smith are a middle class couple that spends $4,000.00 a month.  If John and...

    John and Jane Smith are a middle class couple that spends $4,000.00 a month.  If John and Jane want to retire at the age of 67 (and they are now 27): How much money will they be spending per month assuming 3% inflation?  How much is that per year?  Assume that social security is still in existence and will meet four tenths (or 40%) of their spending needs. Assume that John and Jane primarily save for retirement through their 401(k) plans at work....

  • QUESTION 5 You would like to plan for your retirement. You have gathered or assumed the...

    QUESTION 5 You would like to plan for your retirement. You have gathered or assumed the following information:  You just turned 30 years of age, and currently have zero savings.  You plan to work until you turn 50 years old, at which time you would like to retire. During retirement, assume that you will have no sources of income other than what you can earn on the money that you have saved up for retirement.  For the...

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