A company is offering 401k matching retirement plan for its employees who stay with the company for more than 10 years. The company's CFO finds that the average retirement account holds $490,000, with a standard deviation of $55,000, distributed normally.
Use Excel to calculate the amount of money that separates the lowest 20% of the means of retirement accounts from the highest 80% in a sampling of 80 employees.
We are provided with the following information:

n = 80
Therefore:

We need to find x such that:

Using excel we have:
=NORM.INV(0.2,490000,55000/SQRT(80))
=484824.713703665
Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!
A company is offering 401k matching retirement plan for its employees who stay with the company...
Research 401K retirement savings plan. Then, consider the following scenario. John Smith's Scenario John is single living in Brooklyn, and he works at the XYZ company as a webpage designer. His annual salary is $75,000 a year. His company offers a 401K retirement savings benefit and it matches up to 6% of the participating employee's salary. John wants to participate in the program because it gives many benefits including that additional 6% money toward his retirement savings. He wants to...
A local real-estate company invests in retirement accounts for all full-time employees. The company automatically deposits an amount equal to 3% of the employee’s base salary into a 401K account through an investment firm. Employees of the company may choose to have a portion of their pay deposited into these accounts as well, but they are not required to do so. The company has access to the annual return rate data on all 254 of their employee’s accounts for the...
A company makes all its employees take a leadership test where a simple random sample of 25 employees is selected. Recall that the population of scores is normally distributed with mean of 145 and a population standard deviation of 20. Answer the following probability question for random samples like this. (a) What is the mean of the distribution of means for all samples of this size? What standard error applies to the distribution of means for groups of this size?...
Waddle Company amended its defined benefit pension plan on January 1, 2024, to increase retirement benefits earned with each service year. The actuary estimated the prior service cost to be $216,000. Waddle's 80 present employees are expected to retire at the rate of about 10 each year at the end of each of the next eight years.Required:Using the service method, calculate the amount of prior service cost to be amortized to pension expense in 2024.Using the straight-line method, calculate the...
Chapter Case. A Job at S&S Air
A Job at S&S Air V ou recently graduated from college, and your job search led you to S&S Air. Because you felt the company's business was headed I skyward, you accepted the job offer. As you are finishing your employment paperwork, Chris Guthrie, who works in the finance department, stops by to inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan offered by many companies....
A Job at S&S Air V ou recently graduated from college, and your job search led you to S&S Air. Because you felt the company's business was headed I skyward, you accepted the job offer. As you are finishing your employment paperwork, Chris Guthrie, who works in the finance department, stops by to inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan offered by many companies. A 401(k) is tax deferred, which means...
PART III Risk A JOB AT EAST COAST YACHTS You recently graduated from college and your job search led you to East Coast Yachts. Became you felt the company's business was seaworthy, you accepted a job offer. The first day on the job, while you are finishing your employment paperwork, Dan Ervin, who works in Finance stops by to inform you about the company's 401(k) plan. A 401(k) plan is a retirement plan offered by many companies. Such plans are...
STA2221 examples on CI & Testing of Hypothesis Name MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answer the question Provide an appropriate response. 1) Find the critical value,te for 0.99 and n-10. A) 3.250 B) 3.169 1.833 D) 2.262 2) Find the critical value to forc=0.95 and n=16. A) 2.947 B) 2.602 2120 D) 2.131 3) Find the value of E, the margin of error, for A) 1.69 B) 0.42 0.99, n=16 and s=2.6. C)...
What should Ajanta do about its recent order from SF?
AJANTA PACKAGING: KEY ACCOUNT MANAGEMENT Sandeep Puri and Rakesh Singh wrote this case solely to provide material for class discussion. The authors do not intend to iustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality This publication may not be transmitted, photocopied, digitized, or otherwise reproduced in any form or by any means without the...
CASE 20 Enron: Not Accounting for the Future* INTRODUCTION Once upon a time, there was a gleaming office tower in Houston, Texas. In front of that gleaming tower was a giant "E" slowly revolving, flashing in the hot Texas sun. But in 2001, the Enron Corporation, which once ranked among the top Fortune 500 companies, would collapse under a mountain of debt that had been concealed through a complex scheme of off-balance-sheet partnerships. Forced to declare bankruptcy, the energy firm...