fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

BUSI 201 Intermediate Business Computer Applications

tag 0 Download4 Pages / 891 Words
  • Course Code: BUSI201
  • University: Liberty University

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: United States

Question:

  1. Review the work completed by each group member for the individual submission portion of the Microsoft Excel Project. Together, determine which project will represent the group in your final version, making any adjustments or corrections as needed.

We’ll use Mitchell’s spreadsheet.

  1. Unhide the Retirementworksheet in the Payroll file. Choose 1 employee from the Payroll worksheet to create a retirement plan for. This worksheet will help you calculate how much is being saved for retirement, and how that will affect the amount that can be withdrawn through the retirement years.

Let’s use employee Oliver Pittman.

  1. Begin by determining the yearly/monthly gross income that this employee can expect given his/her current pay and hours.
  2. Many companies offer to match retirement contributions when their employees participate in a 401(k) plan. In this scenario, the employer will contribute up to 5% of the employee’s gross income if the employee also contributes 5%. (E.g. employees contributing 3% of their income would receive an additional 3% from the company and employees contributing 7% would receive an additional 5% from the company, etc.)

Mitchell, will you complete steps 2a and 2b?

  1. Use a formula to add a contribution amount of your choice as well as any company match in cells B14:B15. Use an IF function to automatically determine the company match based on your chosen percentage. Be sure to use the assumption cells B22:B23 in your formulas. Test various contribution amounts to ensure that your formula works in all cases.

I can work on this step.

  1. Roth IRAs can be used for low to upper middle class workers to fund retirement with post-tax dollars (i.e. net pay). Consider adding additional funds to a Roth IRA in cell B16. Total the contributions to your retirement in cell B17 and calculate the monthly contributions (D12:D17). The monthly contribution will now appear in cell B2.

Dan, will you work on this one (2d)?

  1. Calculate the percentage (%) of income that is being contributed to retirement in B20.

Jennifer, would you work on this step (2e) as well as 3a (below)

  1. Now that you have calculated the amount to save for retirement, you will calculate how much this amount will yield in 30 years and what the monthly income will be in retirement.
    1. In cell B5, use the appropriate financial function to calculate how much money will be in the account when the employee is ready to retire. Remember to use a negative value for the PMT argument. There is no money currently in the account and payments will be applied at the end of every
    2. Once you have saved for retirement, how much can you draw from the retirement account every month over the 30 years that you expect to be retired? Assume that at the end of 30 years, the account balance will be zero and the payments to you will be made at the beginning of every month. (Hint: Use the PMT function to calculate the payments to yourself. Use the ending balance in your retirement account as the present value. Add a negative sign before the present value so the result appears as a positive)
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 4 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). BUSI 201 Intermediate Business Computer Applications. Retrieved from https://myassignmenthelp.com/free-samples/busi201-intermediate-business-computer-applications/pmt-function.html.

"BUSI 201 Intermediate Business Computer Applications." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/busi201-intermediate-business-computer-applications/pmt-function.html.

My Assignment Help (2021) BUSI 201 Intermediate Business Computer Applications [Online]. Available from: https://myassignmenthelp.com/free-samples/busi201-intermediate-business-computer-applications/pmt-function.html
[Accessed 02 December 2021].

My Assignment Help. 'BUSI 201 Intermediate Business Computer Applications' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/busi201-intermediate-business-computer-applications/pmt-function.html> accessed 02 December 2021.

My Assignment Help. BUSI 201 Intermediate Business Computer Applications [Internet]. My Assignment Help. 2021 [cited 02 December 2021]. Available from: https://myassignmenthelp.com/free-samples/busi201-intermediate-business-computer-applications/pmt-function.html.


With time, MyAssignmenthelp.com has become one of the best college essay writing service. Our comprehensive coverage of essay topics coupled with logical synchronous paragraphs, sound grammar and punctuation, usage of recent facts and examples have helped many students score guaranteed As. Our services are quick and can satisfy any pressing deadline. Some of our most common essay services include college application essay, literature reviews, selecting essay research paper topics and more.

Latest Operations Samples

ACC6010 Accounting Concepts And Applications

Download : 0 | Pages : 5
  • Course Code: ACC6010
  • University: Edith Cowan University

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Answers: Specific names are given to the substituted orientations of spreadsheet. The main motive is to consider the easy association of depictions made in the spreadsheet with the calculations. The sort of example is seen with substituting the orientations of a cell with the names. A different location for the data entry is pivotal for accountants working in spreadsheet as it assist them in illustrating the data in single view under each row. ...

Read More arrow

MGT701 Leading And Managing Organisations

Download : 0 | Pages : 16

Answer: Introduction The way people relate with each other and at their places of work is highly affected by perceptions and personality. Managers are supposed to be aware of attention that is selective, some stereotypes and distortions that are attitudinal in nature. This leads to their effective contributions towards group dynamics, inequalities at work places and conflicts that are interpersonal. Therefore for managers to be assisted in t...

Read More arrow Tags: Australia Taylors Lakes Management University of New South Wales Masters in Business Administration 

THT2114 Sustainable Operations And Destinations

Download : 0 | Pages : 8

Answers Task A: 1. Tourism management or destination management inclusive of tourism have a lol lot of external and internal factors associated with the resource management. The landmark destinations that act as the tourist attractions have a lot of cultural and religious values associated with the natives which the tourism management a destination management has to respect and save card while managing the operations resources and sustainabilit...

Read More arrow Tags: Australia Melbourne Management THT2114 Sustainable Operations and Destination Academies Australia Polytechinic THT2114 Sustainable Operatio 

MKST304 Marketing Strategy

Download : 0 | Pages : 4
  • Course Code: MKST304
  • University: Kent Institute Australia

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Answer: Introduction Australian post is the government owned corporation which renders postal services both internationally and locally. The corporation also operates the retail stores. In this topic, it is important to discuss the rise and fall of Australian post would determine the marketing opportunities which would further explore the ways of continuing the marketing strategies, its marketing mix strategies and its SWOT (Auspost.com. 201...

Read More arrow

POSC315 Human Rights In International Relations

Download : 0 | Pages : 9

Answer: Introduction The Association of Southeast Asian Nations (ASEAN) is made up of diverse nations in the Southeast Asia area which includes the Singapore, Laos, Philippines, Malaysia, Thailand, Brunei, Vietnam, Cambodia, Indonesia and Myanmar. The objective of the ASEAN incorporation is to assist these nations in building up their own countries with the assist, coordination and security of on another while encouraging superior working rappo...

Read More arrow Tags: Australia Mckinnon Management Essay Victoria Masters in Business Administration 
Next

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?