MATH201 W3 It's All About The Benjamins AssignmentCHill
xlsx
School
West Virginia Junior College, Charleston *
*We aren’t endorsed by this school
Course
101
Subject
Finance
Date
Jan 9, 2024
Type
xlsx
Pages
8
Uploaded by lunagirl84
It's All About the Benjamins!
You and your co-worker Benjamin have both just turned 22 and are having dinner to celebrat
saving for retirement.
Your company offers an invesment portfolio that has historically earne
semi-annually.
You both decide to invest in this portfolio, but you have different investment
Benjamin plans to start immediately.
He has decided to invest a certain amount of money an
point, Benjamin will stop investing in the account and will let the money grow until he turns 6
You decide you'd rather wait until you are in a better place financially, so you are not going to
You will invest the same annual amount as Benjamin and plan to invest that amount every ye
You and Benjamin make a friendly bet to see who will have more money in their retirement a
Part I
p =
$
10,000.00
Part II
How much does Benjamin have in his account after 1 year?
Use the compound interest form
P= 10,000
r= 11%=0.11 10(1+0.11)/1
A= 11,000
Part III
Review the two tables below which calculate the amount of money you and Benjamin will ea
stick to your investment strategies.
Note:
The two tables below have populated automatically based on the annual amount of m
Choose an amount between
$1,000 and $10,000 for p, the
annual amount of money invested
by both you and Benjamin. Enter
the chosen amount in the green
box.
an interest rate of 11% per year, compounded semi-annually until age 65.
BENJAMIN
Age
Annual InvestmentBen's Total Value
Age
22
$
10,000 $
11,130
22
23
$
10,000 $
23,518
23
24
$
10,000 $
37,307
24
25
$
10,000 $
52,654
25
26
$
10,000 $
69,735
26
27
$
10,000 $
88,747
27
28
$
10,000 $
109,908
28
29
$
10,000 $
133,461
29
30
$
-
$
148,545
30
31
$
-
$
165,335
31
32
$
-
$
184,022
32
33
$
-
$
204,821
33
34
$
-
$
227,970
34
35
$
-
$
253,737
35
36
$
-
$
282,415
36
37
$
-
$
314,335
37
38
$
-
$
349,863
38
39
$
-
$
389,406
39
40
$
-
$
433,419
40
41
$
-
$
482,406
41
42
$
-
$
536,930
42
43
$
-
$
597,617
43
44
$
-
$
665,162
44
45
$
-
$
740,342
45
46
$
-
$
824,020
46
47
$
-
$
917,154
47
48
$
-
$
1,020,816
48
49
$
-
$
1,136,193
49
50
$
-
$
1,264,612
50
51
$
-
$
1,407,544
51
52
$
-
$
1,566,632
52
53
$
-
$
1,743,701
53
54
$
-
$
1,940,783
54
55
$
-
$
2,160,139
55
56
$
-
$
2,404,289
56
57
$
-
$
2,676,034
57
58
$
-
$
2,978,493
58
59
$
-
$
3,315,137
59
60
$
-
$
3,689,830
60
61
$
-
$
4,106,873
61
62
$
-
$
4,571,053
62
63
$
-
$
5,087,696
63
64
$
-
$
5,662,733
64
65
$
-
$
6,302,763
65
Part IV
Your age, Ben's Account Value and Your Account Value are provided
here.
Age
Ben's Total Value
Your Total Value
Paste Your graph I
22
$
11,130 $
-
23
$
23,518 $
-
24
$
37,307 $
-
25
$
52,654 $
-
26
$
69,735 $
-
27
$
88,747 $
-
28
$
109,908 $
-
29
$
133,461 $
-
30
$
148,545 $
11,130
31
$
165,335 $
23,518
32
$
184,022 $
37,307
33
$
204,821 $
52,654
34
$
227,970 $
69,735
35
$
253,737 $
88,747
36
$
282,415 $
109,908
37
$
314,335 $
133,461
38
$
349,863 $
159,676
39
$
389,406 $
188,853
40
$
433,419 $
221,328
41
$
482,406 $
257,474
42
$
536,930 $
297,706
43
$
597,617 $
342,484
Create an
Excel
graph
using the data below to provide
a visual representation of the data usin
You will need to select all data below (blue cells). Then, click on the
Insert
tab at the top of th
line graph from the
Recommended Charts
section. If you need assistance with Excel, explore
Excel For Windows Training
22
24
26
28
30
32
34
3
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
$7,000,000
A
Ben's
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
44
$
665,162 $
392,324
45
$
740,342 $
447,796
46
$
824,020 $
509,539
47
$
917,154 $
578,259
48
$
1,020,816 $
654,748
49
$
1,136,193 $
739,881
50
$
1,264,612 $
834,636
51
$
1,407,544 $
940,101
52
$
1,566,632 $
1,057,486
53
$
1,743,701 $
1,188,139
54
$
1,940,783 $
1,333,558
55
$
2,160,139 $
1,495,414
56
$
2,404,289 $
1,675,563
57
$
2,676,034 $
1,876,074
58
$
2,978,493 $
2,099,248
59
$
3,315,137 $
2,347,645
60
$
3,689,830 $
2,624,118
61
$
4,106,873 $
2,931,839
62
$
4,571,053 $
3,274,341
63
$
5,087,696 $
3,655,553
64
$
5,662,733 $
4,079,852
65
$
6,302,763 $
4,552,108
Part V
Summarize and evaluate your findings by answering the following questions:
a) Who had more money at age 65 and how much more did the winner have?
Benjamin had more by 1,750,655
b) How much money did Benjamin invest and how much money did you invest?
Benjamin invested 80,000 and I invested
360,000
c) Evaluate the data above.
What conclusions do you draw from your data
analysis?
Recommend the strategies you would provide to future
investors. Justify your answer in 3-4 sentences.
The Conclusions I came up with is to start investing when Benjamin
started at the age of 22 because you will invest way less and come out with
way more money then when I started at the age of 30. Be smart like
Benjamin and start investing at early age.
te.
You begin talking about
ed 11% interest, compounded
strategies.
nnually for exactly 8 years. At that
65.
o begin investing until age 30.
ear until you reach age 65.
account at age 65!
mula and show all work.
ach have at the age of 65 if you
money invested (green box),
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
YOU
Annual Investment Your Total Value
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
-
$
10,000 $
11,130
$
10,000 $
23,518
$
10,000 $
37,307
$
10,000 $
52,654
$
10,000 $
69,735
$
10,000 $
88,747
$
10,000 $
109,908
$
10,000 $
133,461
$
10,000 $
159,676
$
10,000 $
188,853
$
10,000 $
221,328
$
10,000 $
257,474
$
10,000 $
297,706
$
10,000 $
342,484
$
10,000 $
392,324
$
10,000 $
447,796
$
10,000 $
509,539
$
10,000 $
578,259
$
10,000 $
654,748
$
10,000 $
739,881
$
10,000 $
834,636
$
10,000 $
940,101
$
10,000 $
1,057,486
$
10,000 $
1,188,139
$
10,000 $
1,333,558
$
10,000 $
1,495,414
$
10,000 $
1,675,563
$
10,000 $
1,876,074
$
10,000 $
2,099,248
$
10,000 $
2,347,645
$
10,000 $
2,624,118
$
10,000 $
2,931,839
$
10,000 $
3,274,341
$
10,000 $
3,655,553
$
10,000 $
4,079,852
$
10,000
$
4,552,108
In the box below:
ng a
line graph
.
he page to choose your
e the Microsoft Excel site:
36
38
40
42
44
46
48
50
52
54
56
58
60
62
64
ccount Value
Total Value
Your Total Value
Related Documents
Related Questions
It's All About the Benjamins!
3 You and your co-worker Benjamin have both just turned 22 and are having dinner to celebrate. You begin talking about
4 saving for retirement. Your company offers an invesment portfolio that has historically earned 11% interest, compounded
5 semi-annually. You both decide to invest in this portfolio, but you have different investment strategies.
6
7 Benjamin plans to start immediately. He has decided to invest a certain amount of money annually for exactly 8 years. At that
point, Benjamin will stop investing in the account and will let the money grow until he turns 65.
8
9
10 You decide you'd rather wait until you are in a better place financially, so you are not going to begin investing until age 30.
11 You will invest the same annual amount as Benjamin and plan to invest that amount every year until you reach age 65.
12
13 You and Benjamin make a friendly bet to see who will have more money in their retirement account at age 65!
14
15 Part I
16
Choose…
arrow_forward
Tom plans to buy a house. He notice that current interest rate is really high. Considering that the stock market is volatile, he decides to take out $100,000 from the stock markets and create a certificate of deposit account at a rate of 3.5%. He predicts that later when the house price drops, he can buy a very good single-family house with about $750,000. The down payment rate is 20%. Please predict the exact time when he can buy a house.
Group of answer choices
14.33
8.47
14.66
arrow_forward
Please show working.
Please answer a, b, and c
Your client is 35 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $7,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 8% in the future.
a. If she follows your advice, how much money will she have at 65? Do not round intermediate calculations. Round your answer to the nearest cent. $ _________
b. How much will she have at 70? Do not round intermediate calculations. Round your answer to the nearest cent. $ ________
c. She expects to live for 20 years if she retires at 65 and for 15 years if she retires at 70. If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age? Do not round intermediate calculations. Round your answers to the nearest cent.
Annual withdrawals if she retires at 65: $ ____________
Annual…
arrow_forward
Don Hildebrand is trying to decide whether to invest money in a bank or in something a little riskier that will pay a higher return. One very simple investment promises to pay a minimum of 8% compounded annually, but he must leave all of the money and interest invested for 9 years. How much interest will Don earn during the 9 years if he invests $7,150 and the investment pays the minimum?
arrow_forward
Your client is 26 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $4,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 12% in the future.
If she follows your advice, how much money will she have at 65? Do not round intermediate calculations. Round your answer to the nearest cent.
$
How much will she have at 70? Do not round intermediate calculations. Round your answer to the nearest cent.
$
She expects to live for 20 years if she retires at 65 and for 15 years if she retires at 70. If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age? Do not round intermediate calculations. Round your answers to the nearest cent.
Annual withdrawals if she retires at 65: $
Annual withdrawals if she retires at 70: $
arrow_forward
Monique Gonzales just graduated and was hired by a new cybersecurity firm in Colorado. She needs to set up her retirement plan portfolio. Monique has completed the following payoff table for different investment options and estimated the potential profits that could be realized in one month. Monique can use the Hurwicz Criterion strategy to make her decision.Payoff Table
State of Nature
Alternatives
Good Economy
Fair Economy
Poor Economy
Mutual Fund
1,0001,000
650650
270270
Stock Market
6,5006,500
4,7004,700
3,3003,300
CDs
1,5001,500
850850
710710
Bonds
650650
270270
205205
Step 2 of 2:
What is Monique’s potential payoff based on the the Hurwicz Criterion strategy and an α=0.35α=0.35?
arrow_forward
2. Marjorie Yan recently retired from
work and wants to use a portion of
her retirement money for investment.
She has two investment options,
namely (1) a bond fund, and (2) a
stock fund. Each investment would
be for one year and will give a return
to of 6% for the bond fund and 10%
for stock fund. Whatever portion of
her retirement money she commits
for investment, she wants to invest at
least 25% of that amount in the bond
fund. Moreover, she wants to select a
mix that will give her a total return of
at least 7.5%. Marjorie wants to
determine the percentage that
should be allocated to each possible
investment alternative to maximize
*
returns.
1 Add File
arrow_forward
After her first finance class in WBS, Samantha started a Twitter campaign to convince Elon Musk to let her buy one of his shares in SpaceX (which is currently traded privately). She succeeded and managed to buy one share at a price of $169. She expects to sell this share at a price of $250 when she graduates 3 years from now. What is the internal rate of return of this investment? (Calculate it in annual terms and to the closest integer).
arrow_forward
Geoff recently graduated from a state university with a degree
in art history. He has no student loans and has saved $7,000
toward retirement while in school. He's heard rumors about the
stock market being unstable right now, and he has friends his
age who have seen their investment accounts go down in value.
Geoff has decided to keep his money in a savings account until
mutual fund returns look better; then he will invest the money.
1
2
3
4
Did Geoff make a good decision to keep his money in a
savings account until the market goes back up? Why or
why not?
If he did put his money in the stock market instead of a
savings account, should he leave it alone or take it out
when the market goes down? Explain your answer.
For long-term savings, what is the better option: Keep
your money in a savings account or invest it into the
stock market? Why?
If Geoff came to you for advice about his money situation,
what would you tell him?
arrow_forward
You are thinking of building a new machine that will save you $3,000 in the first year. The machine will then begin to wear out so that the savings decline at a rate of 2% per year forever. What is
the present value of the savings if the interest rate is 9% per year?
The present value of the savings is $
(Round to the nearest dollar.)
Enter your answer in the answer box and then click Check Answer.
All parts showing
Clear All
Check Answer
MacBook Air
arrow_forward
Suppose that Paolo is 45 years old and has no retirement savings. He wants to begin saving for retirement, with the first payment coming one
year from now. He can save $12,000 per year and will invest that amount in the stock market, where it is expected to yield an average annual
return of 8.00% return. Assume that this rate will be constant for the rest of his's life.
Paolo would like to calculate how much money he will have at age 65.
Using a financial calculator yields a future value of this ordinary annuity to be approximately
Paolo would now like to calculate how much money he will have at age 70.
Using a financial calculator yields a future value of this ordinary annuity to be approximately
at age 65.
Paolo expects to live for another 25 years if he retires at age 65, with the same expected percent return on investments in the stock market.
Using a financial calculator, you can calculate that Paolo can withdraw
retirement at age 65), assuming a fixed withdrawal each year and $0…
arrow_forward
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years
Years until retirement:
Amount to withdraw each year:
Years to withdraw in retirement:
Interest rate:
30
$
90,000
20
8%
Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into
In order to answer any of these questions, first we need to know how much your friend will need when she is ready to retire. Since this amount will be the
Amount needed at retirement:
a. The amount your friend must save each year to fund her retirement is:
Amount to save each year:
b. The lump sum your friend must deposit today to fund her retirement is:
Lump sum deposited today:
c. Your friend's annual deposit is:
Employer's annual contribution:
Amount to save each year now:
$
1,500
arrow_forward
N. Ebriate, a college student at a party university, decides to forego beerdrinking and invest the $100 he saves at the end of each month in a mutualfund that is currently earning 11 percent annually. He has a job where heearns income and invests this money in a Roth IRA.a. How much will he have in his fund in 4 years on graduation?b. If he graduates at 22 and leaves this investment in the mutual fund withoutadding any additional funds, how much will he have at age 60?c. If he really enjoys his work and decides to leave the money in the fund untilage 75, how much will he have?d. If he never touches this mutual fund and dies at the age of 90, how muchwill he leave in his estate from only this investment?
arrow_forward
Becky Scholes has $150,000 to invest. She
wants to be able to withdraw $12,500 every
year forever without using up any of her
principal. What interest rate would her
investment have to earn in order for her to be
able to so?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Related Questions
- It's All About the Benjamins! 3 You and your co-worker Benjamin have both just turned 22 and are having dinner to celebrate. You begin talking about 4 saving for retirement. Your company offers an invesment portfolio that has historically earned 11% interest, compounded 5 semi-annually. You both decide to invest in this portfolio, but you have different investment strategies. 6 7 Benjamin plans to start immediately. He has decided to invest a certain amount of money annually for exactly 8 years. At that point, Benjamin will stop investing in the account and will let the money grow until he turns 65. 8 9 10 You decide you'd rather wait until you are in a better place financially, so you are not going to begin investing until age 30. 11 You will invest the same annual amount as Benjamin and plan to invest that amount every year until you reach age 65. 12 13 You and Benjamin make a friendly bet to see who will have more money in their retirement account at age 65! 14 15 Part I 16 Choose…arrow_forwardTom plans to buy a house. He notice that current interest rate is really high. Considering that the stock market is volatile, he decides to take out $100,000 from the stock markets and create a certificate of deposit account at a rate of 3.5%. He predicts that later when the house price drops, he can buy a very good single-family house with about $750,000. The down payment rate is 20%. Please predict the exact time when he can buy a house. Group of answer choices 14.33 8.47 14.66arrow_forwardPlease show working. Please answer a, b, and c Your client is 35 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $7,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 8% in the future. a. If she follows your advice, how much money will she have at 65? Do not round intermediate calculations. Round your answer to the nearest cent. $ _________ b. How much will she have at 70? Do not round intermediate calculations. Round your answer to the nearest cent. $ ________ c. She expects to live for 20 years if she retires at 65 and for 15 years if she retires at 70. If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age? Do not round intermediate calculations. Round your answers to the nearest cent. Annual withdrawals if she retires at 65: $ ____________ Annual…arrow_forward
- Don Hildebrand is trying to decide whether to invest money in a bank or in something a little riskier that will pay a higher return. One very simple investment promises to pay a minimum of 8% compounded annually, but he must leave all of the money and interest invested for 9 years. How much interest will Don earn during the 9 years if he invests $7,150 and the investment pays the minimum?arrow_forwardYour client is 26 years old. She wants to begin saving for retirement, with the first payment to come one year from now. She can save $4,000 per year, and you advise her to invest it in the stock market, which you expect to provide an average return of 12% in the future. If she follows your advice, how much money will she have at 65? Do not round intermediate calculations. Round your answer to the nearest cent. $ How much will she have at 70? Do not round intermediate calculations. Round your answer to the nearest cent. $ She expects to live for 20 years if she retires at 65 and for 15 years if she retires at 70. If her investments continue to earn the same rate, how much will she be able to withdraw at the end of each year after retirement at each retirement age? Do not round intermediate calculations. Round your answers to the nearest cent. Annual withdrawals if she retires at 65: $ Annual withdrawals if she retires at 70: $arrow_forwardMonique Gonzales just graduated and was hired by a new cybersecurity firm in Colorado. She needs to set up her retirement plan portfolio. Monique has completed the following payoff table for different investment options and estimated the potential profits that could be realized in one month. Monique can use the Hurwicz Criterion strategy to make her decision.Payoff Table State of Nature Alternatives Good Economy Fair Economy Poor Economy Mutual Fund 1,0001,000 650650 270270 Stock Market 6,5006,500 4,7004,700 3,3003,300 CDs 1,5001,500 850850 710710 Bonds 650650 270270 205205 Step 2 of 2: What is Monique’s potential payoff based on the the Hurwicz Criterion strategy and an α=0.35α=0.35?arrow_forward
- 2. Marjorie Yan recently retired from work and wants to use a portion of her retirement money for investment. She has two investment options, namely (1) a bond fund, and (2) a stock fund. Each investment would be for one year and will give a return to of 6% for the bond fund and 10% for stock fund. Whatever portion of her retirement money she commits for investment, she wants to invest at least 25% of that amount in the bond fund. Moreover, she wants to select a mix that will give her a total return of at least 7.5%. Marjorie wants to determine the percentage that should be allocated to each possible investment alternative to maximize * returns. 1 Add Filearrow_forwardAfter her first finance class in WBS, Samantha started a Twitter campaign to convince Elon Musk to let her buy one of his shares in SpaceX (which is currently traded privately). She succeeded and managed to buy one share at a price of $169. She expects to sell this share at a price of $250 when she graduates 3 years from now. What is the internal rate of return of this investment? (Calculate it in annual terms and to the closest integer).arrow_forwardGeoff recently graduated from a state university with a degree in art history. He has no student loans and has saved $7,000 toward retirement while in school. He's heard rumors about the stock market being unstable right now, and he has friends his age who have seen their investment accounts go down in value. Geoff has decided to keep his money in a savings account until mutual fund returns look better; then he will invest the money. 1 2 3 4 Did Geoff make a good decision to keep his money in a savings account until the market goes back up? Why or why not? If he did put his money in the stock market instead of a savings account, should he leave it alone or take it out when the market goes down? Explain your answer. For long-term savings, what is the better option: Keep your money in a savings account or invest it into the stock market? Why? If Geoff came to you for advice about his money situation, what would you tell him?arrow_forward
- You are thinking of building a new machine that will save you $3,000 in the first year. The machine will then begin to wear out so that the savings decline at a rate of 2% per year forever. What is the present value of the savings if the interest rate is 9% per year? The present value of the savings is $ (Round to the nearest dollar.) Enter your answer in the answer box and then click Check Answer. All parts showing Clear All Check Answer MacBook Airarrow_forwardSuppose that Paolo is 45 years old and has no retirement savings. He wants to begin saving for retirement, with the first payment coming one year from now. He can save $12,000 per year and will invest that amount in the stock market, where it is expected to yield an average annual return of 8.00% return. Assume that this rate will be constant for the rest of his's life. Paolo would like to calculate how much money he will have at age 65. Using a financial calculator yields a future value of this ordinary annuity to be approximately Paolo would now like to calculate how much money he will have at age 70. Using a financial calculator yields a future value of this ordinary annuity to be approximately at age 65. Paolo expects to live for another 25 years if he retires at age 65, with the same expected percent return on investments in the stock market. Using a financial calculator, you can calculate that Paolo can withdraw retirement at age 65), assuming a fixed withdrawal each year and $0…arrow_forwardThis is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years Years until retirement: Amount to withdraw each year: Years to withdraw in retirement: Interest rate: 30 $ 90,000 20 8% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into In order to answer any of these questions, first we need to know how much your friend will need when she is ready to retire. Since this amount will be the Amount needed at retirement: a. The amount your friend must save each year to fund her retirement is: Amount to save each year: b. The lump sum your friend must deposit today to fund her retirement is: Lump sum deposited today: c. Your friend's annual deposit is: Employer's annual contribution: Amount to save each year now: $ 1,500arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Pfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning