Question description<\/p>\n
I will attach two examples when you bid to paraphrase\u00a0Unit Project: Saving for RetirementReview the requirements for completing the Graded Assignment.GOALSSome people say that compound interest is the eighth wonder of the world. During this unit, you will see why compound interest is so highly thought of.First you\u2019ll find the entry-level salary for a career of your choosing. Then you\u2019ll calculate and compare how much money an employee with this starting salary can have in his or her retirement account under different scenarios. Lastly, you\u2019ll determine what percent of that person\u2019s gross salary must be saved to meet certain financial goals.TEMPLATE1.\u00a0Download the project ( help with nursing paper writing from experts with MSN & DNP degrees) template and rename the file as RetirementPresentation_YourName. This file will become your presentation.2.\u00a0Download the spreadsheet template and rename the file as Spreadsheet_YourName. You will use this file to help you create your presentation.PROJECT RESEARCH1.\u00a0Look on the Internet for the entry-level salary, sometimes called the starting salary, of a career that you are interested in.(a)\u00a0If you have a certain career in mind, include the career name in your search. For example, you could enter entry-level salary of a police officer or average starting salary of a journalist in the search bar.(b)\u00a0You could also look at websites that list salaries for all kinds of careers. Enter entry-level salary information, or starting salary information, in the search bar.(c)\u00a0You may need to enter your ZIP code for results. Skip over any websites that require payment for information or want your specific contact information.(d)\u00a0If you find a range for the average salary, but not necessarily the starting salary, then choose the lower end of the range as the starting salary.2.\u00a0Open your presentation. On slide 1, type your name. On slide 2, complete the table.(a)\u00a0If you are given an hourly salary, assume working 40 h\/week for 52 weeks to calculate the annual salary.(b)\u00a0Determine the monthly salary by dividing the annual salary by 12.PROJECT WRITING1.\u00a0Complete Lesson Checkpoint: Percents and Interest, an online, ungraded assessment. You\u2019ll practice solving percent problems and calculating compound interest\u2014skills essential to completing your project ( help with nursing paper writing from experts with MSN & DNP degrees). Reach out to your teacher with any questions you have after taking this assessment.2.\u00a0Open your spreadsheet. Make sure that you are in the Worksheet tab. This worksheet approximates the total amount in a retirement account for different numbers of years, assuming a 7% rate of return, compounded monthly.Assume that an employee with the starting salary you listed on slide 2 has 5% of his or her gross monthly paycheck amount deposited into a retirement account. In cell B3, enter 5% of this gross monthly salary. Other cells will automatically populate. These cells have formulas in them. Do not change these formulas.Notice the following.\u00b7\u00a0Each row, starting with Row 3, represents a year.\u00b7\u00a0Amounts for up to 40 years are shown. You may need to scroll down to see them.\u00b7\u00a0The monthly deposits for each year increase. That increase is for yearly raises and promotions.\u00b7\u00a0The total amount in the account at the end of each year is in Column N. You may need to scroll right to see it.\u00b7\u00a0The total amount the employee contributed into the account during a given year is in Column P. The total amount he or she contributed from Year 1 up to that year is in Column Q.\u00b7\u00a0A bar graph that shows the total amount in the account at the end of each year is in the Graph tab. This graph automatically updates upon entering an amount in cell B3.3.\u00a0Open your presentation. Complete slide 3.(a)\u00a0Complete the table. The total contribution after 40 years is in cell Q42. The total amount in the account after 40 years is in cell N42.(b)\u00a0Insert an image of the bar graph.4.\u00a0Complete slide 4, which compares how much the employee would have saved up by the retirement age of 65 if he or she started contributing at different ages.(a)\u00a0First record the monthly deposit amounts (from Column B) for each given age below.It is important that you copy these amounts now, because you will be changing the spreadsheet.Monthly Deposit AmountAge 25 (Year 1: cell B3)Age 35 (Year 11: cell B13)Age 45 (Year 21: cell B23)(b)\u00a0You can complete the first row of the table in slide 4 by copying the amounts from your table on slide 3. This represents 40 years of saving.(c)\u00a0Suppose an employee starts saving at age 35 instead. The first monthly deposit will be what you recorded in the second row of the table above. Enter that amount in cell B3. Because the employee will retire at 65, he or she will save for a total of only 30 years. Complete the second row of the table in slide 4 by copying the new amounts in cells Q32 and N32 from your spreadsheet.(d)\u00a0Now suppose an employee starts saving at age 45 instead. The first monthly deposit will be what you recorded in the last row of the table above. Enter that amount in cell B3. Because the employee will retire at 65, he or she will save for a total of only 20 years. Complete the third row of the table in slide 4 by copying the new amounts in cells Q22 and N22 from your spreadsheet.(e)\u00a0Write a brief discussion about how the amounts in the table in slide 4 compare. Include in your discussion whether you found any of the results surprising.5.\u00a0Open your spreadsheet. In the Worksheet tab, change the amount in cell B3 back to the monthly deposit amount for an employee who begins saving 5% of gross monthly pay at age 25. This is the amount you recorded in the first row of the table in Step 4a above.6.\u00a0Open your presentation. Complete slide 5, which compares other possible scenarios.(a)\u00a0Assume an employee starts saving for retirement at age 25, but stops making contributions after 10 years. The employee just lets the total amount in the account after 10 years gain interest for another 30 years. Find the total amount in the account after those 30 years by using the compound interest formula, where:\u00b7\u00a0P\u00a0is the total amount in the account after 10 years of saving. This is the amount in cell N12.\u00b7\u00a0r\u00a0is the rate of return. For this project ( help with nursing paper writing from experts with MSN & DNP degrees),\u00a0r\u00a0= 0.07.\u00b7\u00a0n\u00a0is the number of compounding intervals per year. For this project ( help with nursing paper writing from experts with MSN & DNP degrees),\u00a0n\u00a0= 12.\u00b7\u00a0t\u00a0is the number of years, so\u00a0t\u00a0= 30.Complete the first row of the table. (The amount contributed is what you used for the principal.)(b)\u00a0The second row in the table represents an employee who started saving 5% of gross pay at age 35 and continued to save for the next 30 years. You can copy these amounts from the table on slide 4.(c)\u00a0In your spreadsheet, change the amount in cell B3 to the first monthly deposit amount for an employee who begins saving 10% of gross monthly pay at age 45. That is twice the amount you recorded in the last row of the table in Step 4a above. Because the person saves only for 20 years, use the amounts in cells Q22 and N22 to complete the third row in the table.(d)\u00a0Write a brief discussion about your findings. Include in your discussion whether you found any of the results surprising.7.\u00a0Open your spreadsheet. Continue to change the amount in cell B3, and check the amount in cell N42, until you have determined the smallest first year\u2019s monthly deposit, in whole dollar amounts only, that an employee can deposit into his or her retirement account to have at least each of the following amounts of money saved up after 40 years. Then calculate what percent of gross pay that is. (Use the monthly salary from slide 2 of your presentation.)\u00a0Record your percents here so that you can refer to them in the next step.Retirement GoalAmountPercentAt least $250,000At least $750,000At least $1,000,0008.\u00a0Open your presentation. On slide 6, complete the table. Then write a brief discussion that tells whether and why it is reasonable to expect someone who earns the salary on slide 2 to have a million dollars in an account at retirement time.PROJECT REFLECTION1.\u00a0Join the online session set up for you and your classmates.2.\u00a0Write a response to any of the following.\u00b7\u00a0Suppose you are talking to both a recent college graduate who does not have much money in his budget for retirement savings and a 40-year-old employee who never opened a retirement account for herself until now. How would the retirement advice you give to each of them differ?\u00b7\u00a0If you were considering an offer of employment, how much of a factor would the employer\u2019s retirement package make in your decision? Why?\u00b7\u00a0The Social Security Administration might want to raise the full retirement age for people born in the year 2000 or later. Why do you think the agency might want to do that? Do you think it would be fair? If so, what would be a fair age? If you don\u2019t think it would be fair, why not?3.\u00a0Comment on at least one other student\u2019s post.Alternate Reflection AssignmentIf your teacher excuses you from the online discussion, then add a slide (slide 7) to the end of your presentation. On the slide, consider these two general savings strategies:1.\u00a0Begin saving a small amount at a young age.2.\u00a0Begin saving a large amount of money at an older age.Name possible pros and cons of each strategy. Tell which strategy you think might be best for you and why.SUBMISSIONConfirm that your project ( help with nursing paper writing from experts with MSN & DNP degrees) contains all your work:\u00b7\u00a0Salary information\u00b7\u00a0Overall look at the retirement account (amounts and bar graph)\u00b7\u00a0Starting-age comparisons (amounts and discussion)\u00b7\u00a0Other comparisons (amounts and discussion)\u00b7\u00a0Reaching certain goals (amounts and discussion)\u00b7\u00a0Alternate reflection assignment slide (ONLY if you did not participate in the online discussion)Submit your project ( help with nursing paper writing from experts with MSN & DNP degrees) to your teacher.<\/p>\n","protected":false},"excerpt":{"rendered":"
Question description I will attach two examples when you bid to paraphrase\u00a0Unit Project: Saving for RetirementReview the requirements for completing the Graded Assignment.GOALSSome people say\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7641,8827,10535,10533,10534,10531,10529,6744,10532,10530,7741],"tags":[10553,10549,10616,10615,7687,10254,10627,10104,10247,8857,10552,10295,10900,2984,3903,10548,10622,8901,10551,8907],"class_list":["post-127748","post","type-post","status-publish","format-standard","hentry","category-australia-essay-writers","category-australia-essays","category-do-my-university-assignment-for-me","category-essay-pro-dissertation-writers","category-homework-help-services-best-websites","category-i-need-help-writing-a-page-paper-assignment","category-masters-essays","category-nursing-studybay","category-pay-someone-to-write-a-paper-for-you","category-website-that-writes-assignments","category-studybay","tag-1-assignment-help-online-service-for-students-in-the-usa","tag-ai-plagiarism-free-essay-writing-tool","tag-australian-best-tutors","tag-best-trans-tutors","tag-buy-essay-uk","tag-can-someone-write-my-assignment-for-me","tag-cheap-dissertation-writer","tag-essypro","tag-help-me-write-my-dissertation","tag-help-with-writing-an-essay","tag-help-write-my-paper-ai-free","tag-homework-for-you","tag-nursing-bay","tag-nursing-essay","tag-nursing-study-bay","tag-online-essay-writers","tag-phd-essays","tag-studbay","tag-write-my-assignment-help-for-college-students","tag-write-my-essay-for-me"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/127748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=127748"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/127748\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=127748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=127748"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=127748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}