MATH201 – It's All About the Benjamins Assignment – Devin Sloan

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 brownsugah31

Report
It's All About the Benjamins! You and your co-worker Benjamin have both just turned 22 and are having dinner to celebra saving for retirement. Your company offers an invesment portfolio that has historically earn 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 a point, Benjamin will stop investing in the account and will let the money grow until he turns You decide you'd rather wait until you are in a better place financially, so you are not going t You will invest the same annual amount as Benjamin and plan to invest that amount every y You and Benjamin make a friendly bet to see who will have more money in their retirement Part I p = $ 9,000.00 Part II How much does Benjamin have in his account after 1 year? Use the compound interest form A=$9,000(1+0.11/2)(2)(1) A=$9,000(1+0.055)(2) A=$10,017.23 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 $ 9,000 $ 10,017 22 23 $ 9,000 $ 21,167 23 24 $ 9,000 $ 33,576 24 25 $ 9,000 $ 47,388 25 26 $ 9,000 $ 62,762 26 27 $ 9,000 $ 79,873 27 28 $ 9,000 $ 98,917 28 29 $ 9,000 $ 120,115 29 30 $ - $ 133,691 30 31 $ - $ 148,801 31 32 $ - $ 165,619 32 33 $ - $ 184,339 33 34 $ - $ 205,173 34 35 $ - $ 228,363 35 36 $ - $ 254,174 36 37 $ - $ 282,902 37 38 $ - $ 314,877 38 39 $ - $ 350,466 39 40 $ - $ 390,077 40 41 $ - $ 434,166 41 42 $ - $ 483,237 42 43 $ - $ 537,855 43 44 $ - $ 598,646 44 45 $ - $ 666,308 45 46 $ - $ 741,618 46 47 $ - $ 825,439 47 48 $ - $ 918,734 48 49 $ - $ 1,022,574 49 50 $ - $ 1,138,151 50 51 $ - $ 1,266,790 51 52 $ - $ 1,409,969 52 53 $ - $ 1,569,331 53 54 $ - $ 1,746,704 54 55 $ - $ 1,944,126 55 56 $ - $ 2,163,860 56
57 $ - $ 2,408,431 57 58 $ - $ 2,680,643 58 59 $ - $ 2,983,623 59 60 $ - $ 3,320,847 60 61 $ - $ 3,696,186 61 62 $ - $ 4,113,947 62 63 $ - $ 4,578,926 63 64 $ - $ 5,096,459 64 65 $ - $ 5,672,487 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 $ 10,017 $ - 23 $ 21,167 $ - 24 $ 33,576 $ - 25 $ 47,388 $ - 26 $ 62,762 $ - 27 $ 79,873 $ - 28 $ 98,917 $ - 29 $ 120,115 $ - 30 $ 133,691 $ 10,017 31 $ 148,801 $ 21,167 32 $ 165,619 $ 33,576 33 $ 184,339 $ 47,388 34 $ 205,173 $ 62,762 35 $ 228,363 $ 79,873 36 $ 254,174 $ 98,917 37 $ 282,902 $ 120,115 38 $ 314,877 $ 143,708 39 $ 350,466 $ 169,968 40 $ 390,077 $ 199,196 41 $ 434,166 $ 231,727 Create an Excel graph using the data below to provide a visual representation of the data us You will need to select all data below (blue cells). Then, click on the Insert tab at the top of t line graph from the Recommended Charts section. If you need assistance with Excel, explore Excel For Windows Training 1 3 5 7 9 11 13 15 17 19 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 Annual Inv Ben's Total Value Paste Your graph In the 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
42 $ 483,237 $ 267,935 43 $ 537,855 $ 308,236 44 $ 598,646 $ 353,091 45 $ 666,308 $ 403,017 46 $ 741,618 $ 458,585 47 $ 825,439 $ 520,434 48 $ 918,734 $ 589,273 49 $ 1,022,574 $ 665,893 50 $ 1,138,151 $ 751,172 51 $ 1,266,790 $ 846,091 52 $ 1,409,969 $ 951,737 53 $ 1,569,331 $ 1,069,325 54 $ 1,746,704 $ 1,200,202 55 $ 1,944,126 $ 1,345,872 56 $ 2,163,860 $ 1,508,007 57 $ 2,408,431 $ 1,688,467 58 $ 2,680,643 $ 1,889,323 59 $ 2,983,623 $ 2,112,881 60 $ 3,320,847 $ 2,361,706 61 $ 3,696,186 $ 2,638,655 62 $ 4,113,947 $ 2,946,907 63 $ 4,578,926 $ 3,289,998 64 $ 5,096,459 $ 3,671,867 65 $ 5,672,487 $ 4,096,897 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 won by $1,575,590 b) How much money did Benjamin invest and how much money did you invest? Benjamin invested $72,000 You invested $324,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. Data:A=P(1+r/n)nt. Benjamin invested less and came out with more money. Strategies for future investors are value, growth,momentum investing, finding lower cost ways to invest and think long term.
ate. You begin talking about ned 11% interest, compounded t strategies. annually for exactly 8 years. At that 65. to begin investing until age 30. year 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 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 9,000 $ 10,017 $ 9,000 $ 21,167 $ 9,000 $ 33,576 $ 9,000 $ 47,388 $ 9,000 $ 62,762 $ 9,000 $ 79,873 $ 9,000 $ 98,917 $ 9,000 $ 120,115 $ 9,000 $ 143,708 $ 9,000 $ 169,968 $ 9,000 $ 199,196 $ 9,000 $ 231,727 $ 9,000 $ 267,935 $ 9,000 $ 308,236 $ 9,000 $ 353,091 $ 9,000 $ 403,017 $ 9,000 $ 458,585 $ 9,000 $ 520,434 $ 9,000 $ 589,273 $ 9,000 $ 665,893 $ 9,000 $ 751,172 $ 9,000 $ 846,091 $ 9,000 $ 951,737 $ 9,000 $ 1,069,325 $ 9,000 $ 1,200,202 $ 9,000 $ 1,345,872 $ 9,000 $ 1,508,007
$ 9,000 $ 1,688,467 $ 9,000 $ 1,889,323 $ 9,000 $ 2,112,881 $ 9,000 $ 2,361,706 $ 9,000 $ 2,638,655 $ 9,000 $ 2,946,907 $ 9,000 $ 3,289,998 $ 9,000 $ 3,671,867 $ 9,000 $ 4,096,897 In the box below: sing a line graph . the page to choose your e the Microsoft Excel site: 9 21 23 25 27 29 31 33 35 37 39 41 43 vestment Your Total Value x below: