Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

Each year, the Schreiber Corporation must determine how much to contribute to the company's pension plan. The company uses a ten-year planning horizon to determine the contribution which, if made annually in each of the next ten years, would allow for only a 10% chance of the fund running short of money. The company then makes that contribution in the current year and repeats this process in each subsequent year to determine the specific amount to contribute each year. (Last year, the company contributed $23 million to the plan.) The pension plan covers two types of employees: hourly and salaried. In the current year, there will be 6,000 former hourly employees and 3,000 former salaried employees receiving benefits from the plan. The change in the number of retired hourly employees from one year to the next is expected to vary according to a normal distribution with a mean of 4% and standard deviation of 1%. The change in the number of retired salaried employees from one year to the next is expected to vary between 1 % and 4% according to a truncated normal distribution with a mean of 2% and standard deviation of 1%. Currently, hourly retirees receive an average benefit of $15,000 per year, whereas salaried retirees receive an average annual benefit of $40,000. Both of these averages are expected to increase annually with the rate of inflation, which is assumed to vary between 2% and 7% according to a triangular distribution with a most likely value of 3.5%. The current balance in the company's pension fund is $1.5 billion. Investments in this fund earn an annual return that is assumed to be normally distributed with a mean of 12% and standard deviation of 2%. Create a spreadsheet model for this problem and use simulation to determine the pension fund contribution the company should make in the current year. What is your recommendation?

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92069306

Have any Question?


Related Questions in Financial Management

Questions 1 when can there arise a conflict between

Questions 1. When can there arise a conflict between shareholders and managers goals? How does wealth maximization goal take care of this conflict? 2. A company has just tested the market for a new product. The test indi ...

Topic validity and reliability in qualitative

Topic: Validity and Reliability in Qualitative Research Evaluation and standards of research quality are important in both qualitative and quantitative research. Reliability and validity are two measures of research rigo ...

Rsearch paper issue identificationidentify your issue

Research Paper : Issue Identification Identify your issue: Clearly define the issue(s) and or crisis the company is facing. Identify the "triggering event:" This is a recent occurrence (or series of occurrences) that bro ...

Exercise benefits us in so many ways including improving

Exercise benefits us in so many ways, including: improving our physical and mental health; reducing our risk of cardiovascular disease; increasing our energy, stamina, strength, and agility; promoting better sleep; impro ...

Discuss the following questions professional or trade

Discuss the following Questions : Professional or trade organizations can provide ethical guidelines for business or professionals within their selected organization. Research a professional or trade organization. Provid ...

International business letterabout frac34 of a page to one

International business Letter About ¾ of a page to one full page business letter (formatting as researched culture may dictate) + several paragraphs of rationale One of the great things about entering a field under the s ...

Exerciseas the executive of a bank or thrift institution

Exercise As the executive of a bank or thrift institution you are faced with an intense seasonal demand for loans. Assuming that your loanable funds are inadequate to take care of the demand, how might your Reserve Bank ...

Answer each question in 75 words a piece use references if

Answer EACH question in 75 words A PIECE. Use references, if needed and cite. 1. Embark on a virtual field trip. Researching online, explore different career fields that interest you. Share with your classmates which car ...

Nbsppad 6227fall2018nbspassignmenteach problem is worth

PAD 6227 Fall2018   Assignment Each problem is worth one-half of the grade for this assignment. Make sure to carefully edit your work. 1. The Department of Revenue wants to add more people to the unit that attempts to co ...

Based on this weeks reading determine five 5 leadership

Based on this week's reading, determine five (5) leadership characteristics of effective public leadership and ascribe them to transactional and transformational styles of leadership. What is the difference in the applic ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As