MATH201 – It's All About the Benjamins Assignment – Desrae Sears

xlsx

School

Bryant & Stratton College *

*We aren’t endorsed by this school

Course

201

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

8

Uploaded by JusticeSteel12842

Report
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 = $ 4,000.00 Part II How much does Benjamin have in his account after 1 year? Use the compound interest form 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. After one year Benjamin has $4,452.10, if rounded $4,452. I found this using the following steps: R = R/100, R = 11/100, R = 0.11(interest rate) I then did the following: A = P(1 + R/N), A = $4,000 (1 + 0.11/2), A = $4,000(1 + 0.055), A = $4,452.10. P = $4,000, Interest = $452.10
an interest rate of 11% per year, compounded semi-annually until age 65. BENJAMIN Age Annual InvestmentBen's Total Value Age 22 $ 4,000 $ 4,452 22 23 $ 4,000 $ 9,407 23 24 $ 4,000 $ 14,923 24 25 $ 4,000 $ 21,062 25 26 $ 4,000 $ 27,894 26 27 $ 4,000 $ 35,499 27 28 $ 4,000 $ 43,963 28 29 $ 4,000 $ 53,384 29 30 $ - $ 59,418 30 31 $ - $ 66,134 31 32 $ - $ 73,609 32 33 $ - $ 81,928 33 34 $ - $ 91,188 34 35 $ - $ 101,495 35 36 $ - $ 112,966 36 37 $ - $ 125,734 37 38 $ - $ 139,945 38 39 $ - $ 155,763 39 40 $ - $ 173,368 40 41 $ - $ 192,962 41 42 $ - $ 214,772 42 43 $ - $ 239,047 43 44 $ - $ 266,065 44 45 $ - $ 296,137 45 46 $ - $ 329,608 46 47 $ - $ 366,862 47 48 $ - $ 408,326 48 49 $ - $ 454,477 49 50 $ - $ 505,845 50 51 $ - $ 563,018 51 52 $ - $ 626,653 52 53 $ - $ 697,480 53 54 $ - $ 776,313 54 55 $ - $ 864,056 55 56 $ - $ 961,716 56 57 $ - $ 1,070,414 57
58 $ - $ 1,191,397 58 59 $ - $ 1,326,055 59 60 $ - $ 1,475,932 60 61 $ - $ 1,642,749 61 62 $ - $ 1,828,421 62 63 $ - $ 2,035,078 63 64 $ - $ 2,265,093 64 65 $ - $ 2,521,105 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 $ 4,452 $ - 23 $ 9,407 $ - 24 $ 14,923 $ - 25 $ 21,062 $ - 26 $ 27,894 $ - 27 $ 35,499 $ - 28 $ 43,963 $ - 29 $ 53,384 $ - 30 $ 59,418 $ 4,452 31 $ 66,134 $ 9,407 32 $ 73,609 $ 14,923 33 $ 81,928 $ 21,062 34 $ 91,188 $ 27,894 35 $ 101,495 $ 35,499 36 $ 112,966 $ 43,963 37 $ 125,734 $ 53,384 38 $ 139,945 $ 63,870 39 $ 155,763 $ 75,541 40 $ 173,368 $ 88,531 41 $ 192,962 $ 102,990 42 $ 214,772 $ 119,082 43 $ 239,047 $ 136,994 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 36 38 40 4 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 Chart Ben's Total Value
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 $ 266,065 $ 156,929 45 $ 296,137 $ 179,118 46 $ 329,608 $ 203,815 47 $ 366,862 $ 231,304 48 $ 408,326 $ 261,899 49 $ 454,477 $ 295,952 50 $ 505,845 $ 333,854 51 $ 563,018 $ 376,040 52 $ 626,653 $ 422,994 53 $ 697,480 $ 475,255 54 $ 776,313 $ 533,423 55 $ 864,056 $ 598,166 56 $ 961,716 $ 670,225 57 $ 1,070,414 $ 750,430 58 $ 1,191,397 $ 839,699 59 $ 1,326,055 $ 939,058 60 $ 1,475,932 $ 1,049,647 61 $ 1,642,749 $ 1,172,736 62 $ 1,828,421 $ 1,309,736 63 $ 2,035,078 $ 1,462,221 64 $ 2,265,093 $ 1,631,941 65 $ 2,521,105 $ 1,820,843 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? b) How much money did Benjamin invest and how much money did you invest? $4,000 At the age of 65, Ben had $2,521,105 so he had more money
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. When evaluating the data, I notice that benjamin did not invest nearlyas much as I did myself. I believe this to be because he startedinvesting right away and then let the interest accumulate over time.Rather than myself, I waited to invest therefor, no interested wasbeing accumlated over that 8 year period of time. I would recommendto future investors to invest right away so that the interest startsaccumulating right away
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 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 4,000 $ 4,452 $ 4,000 $ 9,407 $ 4,000 $ 14,923 $ 4,000 $ 21,062 $ 4,000 $ 27,894 $ 4,000 $ 35,499 $ 4,000 $ 43,963 $ 4,000 $ 53,384 $ 4,000 $ 63,870 $ 4,000 $ 75,541 $ 4,000 $ 88,531 $ 4,000 $ 102,990 $ 4,000 $ 119,082 $ 4,000 $ 136,994 $ 4,000 $ 156,929 $ 4,000 $ 179,118 $ 4,000 $ 203,815 $ 4,000 $ 231,304 $ 4,000 $ 261,899 $ 4,000 $ 295,952 $ 4,000 $ 333,854 $ 4,000 $ 376,040 $ 4,000 $ 422,994 $ 4,000 $ 475,255 $ 4,000 $ 533,423 $ 4,000 $ 598,166 $ 4,000 $ 670,225 $ 4,000 $ 750,430
$ 4,000 $ 839,699 $ 4,000 $ 939,058 $ 4,000 $ 1,049,647 $ 4,000 $ 1,172,736 $ 4,000 $ 1,309,736 $ 4,000 $ 1,462,221 $ 4,000 $ 1,631,941 $ 4,000 $ 1,820,843 In the box below: ng a line graph . he page to choose your e the Microsoft Excel site: 42 44 46 48 50 52 54 56 58 60 62 64 Title Your Total Value