(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
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) }
119096 = PMT.(1+j)[{(1+j)180 - 1} / (1+j-1)]
119096
= PMTx1.0075x{(1.0075180 - 1) / 0.0075}
119096 = PMTx381.2438
PMT = $312.38
The goal is obtainable and adequate
(P)
PV = 1000x1.0025-180 = $639
The goal is adequate.
Retirement Problem budget plan. Please fill out whole thing. The funds can be made up by...
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 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 $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 $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 (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 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%. 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! 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 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 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...