all about the benamins
It’s All About the Benjamins! You and your co-worker Benjamin have both just turned 22 and are having dinner to celebrate. You begin saving for retirement. Your company offers an invesment portfolio that has historically earned 11% interes semi-annually. You both decide to invest in this portfolio, but you have different investment strategies. Benjamin plans to start immediately. He has decided to invest a certain amount of money annually for exa point, Benjamin will stop investing in the account and will let the money grow until he turns 65. You decide you’d rather wait until you are in a better place financially, so you are not going to begin invest You will invest the same annual amount as Benjamin and plan to invest that amount every year until you re You and Benjamin make a friendly bet to see who will have more money in their retirement account at age Part I 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. p= Part II How much does Benjamin have in his account after 1 year? Use the compound interest formula and show Part III Review the two tables below which calculate the amount of money you and Benjamin will each have at the stick to your investment strategies. Note: The two tables below have populated automatically based on the annual amount of money invested an interest rate of 11% per year, compounded semi-annually until age 65. Age 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 BENJAMIN Annual Investment Ben’s Total Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ – YOU Age 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 $ $ $ $ $ $ – $ $ $ $ $ $ – 60 61 62 63 64 65 Part IV Your age, Ben’s Account Value and Your Account Value are provided here. Create an Excel graph using the data below to provide a visual representation of the data using a line grap You will need to select all data below (blue cells). Then, click on the Insert tab at the top of the page to cho line graph from the Recommended Charts section. If you need assistance with Excel, explore the Microsoft Excel For Windows Training Age 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Ben’s Total Value Your Total Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ – Paste Your graph In the box below 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ – $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ – 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? 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. s! o celebrate. You begin talking about cally earned 11% interest, compounded vestment strategies. money annually for exactly 8 years. At that he turns 65. ot going to begin investing until age 30. nt every year until you reach age 65. tirement account at age 65! erest formula and show all work. min will each have at the age of 65 if you ount of money invested (green box), YOU Annual Investment Your Total Value $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ – $ $ $ $ $ $ – $ $ $ $ $ $ e data using a line graph. e top of the page to choose your el, explore the Microsoft Excel site: Your graph In the box below: –
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
