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

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 = $ 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