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