Michelle is attending college and has a part-time job. Once she finishes college
ID: 2637846 • Letter: M
Question
Michelle is attending college and has a part-time job. Once she finishes college, Michelle would like to relocate to a metropolitan area. She wants to build her savings so that she will have a nest egg to start her off. Michelle works out her budget and decides she can afford to set aside $50 per month for savings. Her bank will pay her 3% per year, compounded monthly, on her saving account. What will be Michelles balance in 5 years?
In five years, Michelle's balance will be $______
Twins Jessica and Joshua, both 25, graduated from college and began working in the family restaurant business. The furst year, Jessica began putting $2000 per year in an individual retirement account (IRA) and contributed to it for a total of 10 years. After 10 years she made no further contributions until she retired at age 65. Joshua did not start making contributions to his individual retirement account until he was 35, but he continued making contributions of $2000 each year until he retired at age 65. Assuming both Jessica and Joshua recieve 10% interest per year, how much will Jessica have at retirement? How much did she contribute in total? How much Joshua have at retirement? How much did he contribute in total?
At retirement; Jessica will have $_____
Amy and VInce want to save $7000 so that they can take a trip to Europe in four years. How must they save each month to have the money they need if they can get 8% on their savings?
The amount Amy and Vince will need to save each month is $_______
Lena has just become eligible to participate in her companys retirement plan. Her company does not match contribution, but the plan does average an annual return of 12%. Lena is 40 and plans to work at age 65. If she contributes $200 per month, how much will she have in her plan at retirement
When Lena retires, the amount she will have in her retirement plan is $_____
Stacey would like to have $1 million available to her at retirement. Her investments have an average annual return of 11%. if she makes contribution of $300 per month, will she reach her goal when she retires in 30 years
The amount stacy has after 30 years would be $_____
Jesse has just learned that she won $1 million in her state lottery. She has the choice of recieving a lump-sum payment of $312,950 or $50,000 per year for the next 20 years. Jesse can invest the lump sum at 8%, or she can invest the annual payments at 6%. Which should she choose for the greatest return after 20 years
If Jesse choose the lump-sum option, after 20 years she would have $______
Jen spends $10 per week on lottery tickets. If she takes the same amount that she spends on lottery tickets and invests it each week for the next five years at 10%, how much will she have in five years?
In five years, Jen will have $_____
Explanation / Answer
1)Michelle is attending college and has a part-time job. Once she finishes college, Michelle would like to relocate to a metropolitan area. She wants to build her savings so that she will have a nest egg to start her off. Michelle works out her budget and decides she can afford to set aside $50 per month for savings. Her bank will pay her 3% per year, compounded monthly, on her saving account. What will be Michelles balance in 5 years?
Working
Michelle's balance will be =fv(rate,nper,pmt,pv)
rate = 3%/12
nper =5*12 = 60
pmt = 50
pv = 0
Michelle's balance will be = fv(3%/12,60,50,0)
Michelle's balance will be = $ 3232.34
Answer
In five years, Michelle's balance will be $ 3232.34
2) Twins Jessica and Joshua, both 25, graduated from college and began working in the family restaurant business. The furst year, Jessica began putting $2000 per year in an individual retirement account (IRA) and contributed to it for a total of 10 years. After 10 years she made no further contributions until she retired at age 65. Joshua did not start making contributions to his individual retirement account until he was 35, but he continued making contributions of $2000 each year until he retired at age 65. Assuming both Jessica and Joshua recieve 10% interest per year, how much will Jessica have at retirement? How much did she contribute in total? How much Joshua have at retirement? How much did he contribute in total?
Working
Jessica will have = fv(rate,nper,pmt,pv) * 1.10^30
rate = 10%
nper =10
pmt = 2000
pv = 0
Jessica will have = fv(10%,10,2000,0) * 1.10^30
Jessica will have = $ 556,197.07
She contribute in total = 2000*10 = $ 20000
Joshua will have = fv(rate,nper,pmt,pv)
rate = 10%
nper = 30
pmt = 2000
pv = 0
Joshua will have = fv(10%,30,2000,0)
Joshua will have = $ 328,988.05
He contribute in total = 2000*30 = $ 60000
Answer
At retirement; Jessica will have $ 556,197.07
She contribute in total $ 20,000
At retirement; Joshua will have $ 328,988.05
He contribute in total $ 60,000
3) Amy and VInce want to save $7000 so that they can take a trip to Europe in four years. How must they save each month to have the money they need if they can get 8% on their savings?
Working
The amount Amy and Vince will need to save each month = pmt(rate,nper,pv,fv)
rate = 8%/12
nper = 4*12 = 48
pv = 0
fv =7000
The amount Amy and Vince will need to save each month = pmt(8%/12,48,0,7000)
The amount Amy and Vince will need to save each month = $ 124.22
Answer
The amount Amy and Vince will need to save each month is $ 124.22
4) Lena has just become eligible to participate in her companys retirement plan. Her company does not match contribution, but the plan does average an annual return of 12%. Lena is 40 and plans to work at age 65. If she contributes $200 per month, how much will she have in her plan at retirement
Working
The amount she will have in her retirement plan = fv(rate,nper,pmt,pv)
rate = 12%/12 = 1%
nper =25*12 = 300
pmt = 200
pv = 0
The amount she will have in her retirement plan = fv(1%,300,200,0)
The amount she will have in her retirement plan = $ 375,769.33
Answer
When Lena retires, the amount she will have in her retirement plan is $ 375,769.33
5) Stacey would like to have $1 million available to her at retirement. Her investments have an average annual return of 11%. if she makes contribution of $300 per month, will she reach her goal when she retires in 30 years
Working
The amount stacy has after 30 years would be =fv(rate,nper,pmt,pv)
rate = 11%/12
nper =30*12 = 360
pmt = 300
pv = 0
The amount stacy has after 30 years would be = fv(11%/12,360,300,0)
The amount stacy has after 30 years would be = $ 841,355.92
Answer
The amount stacy has after 30 years would be $ 841,355.92
Will she reach her goal when she retires in 30 years : No
6) Jesse has just learned that she won $1 million in her state lottery. She has the choice of recieving a lump-sum payment of $312,950 or $50,000 per year for the next 20 years. Jesse can invest the lump sum at 8%, or she can invest the annual payments at 6%. Which should she choose for the greatest return after 20 years
Working
1st option
The Amount would be = Fv(rate,nper,pmt,pv)
rate = 8%
nper = 20
pmt = 0
pv = 312950
The Amount would be = fv(8%,20,0,312950)
The Amount would be =$ 1,458,646.54
2nd Option
The Amount would be = Fv(rate,nper,pmt,pv)
rate = 6%
nper = 20
pmt = 50000
pv = 0
The Amount would be = fv(6%,20,50000,0)
The Amount would be =$ 1,839,279.56
Answer
If Jesse choose the lump-sum option, after 20 years she would have $1,458,646.54
If Jesse choose the annual payments option, after 20 years she would have $1,839,279.56
she should choose for the greatest return after 20 years will be Annual Payment option
7)Jen spends $10 per week on lottery tickets. If she takes the same amount that she spends on lottery tickets and invests it each week for the next five years at 10%, how much will she have in five years?
Working
Jen will have = fv(rate,nper,pmt,pv)
rate = 10%/52
nper =52*5 = 260
pmt = 10
pv = 0
Jen will have = fv(10%/52,260,10,0)
Jen will have = $ 3369.24
Answer
In five years, Jen will have $ 3369.24