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