1. Build a model to simulate the solvency of the pension fund through 2022. Use the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Build a model to simulate the solvency of the pension fund through 2022. Use the market value of the fund at the end of 2016 as the starting point for your simulation. Next, simulate the market value of the fund through the end of 2017. To do so, you will need to account for: 3. a. b. 5. C. Deductions from the pension that will be made in 2017 to pay out benefits to current retirees. To compute 2017 deductions, use the amount of 2016 deductions provided in the case and assume it grows by a constant annual growth rate. Contributions that will be made to the fund in 2017. In your projections, separate the supplementary contributions made by the County from required contributions by the County and its employees. For example, in 2016, total contributions to the fund were $659.3 million (Exhibit 8). Of that $659.3 million, $270.5 million was a supplementary contribution made by Cook County and the remaining $388.8 million were required contributions by the County and its employees Once you simulate the end-of-2017 asset value for the fund, re-do your analysis for 2018, 2019, upto 2022. Under what assumptions does the fund become insolvent, meaning the value of its assets falls below zero? Investment returns by the fund. Assume that annual returns are normally distributed. First build your simulator by assuming an arbitrary mean and standard deviation, then adjust the inputs afterwards. In addition, assume that investment returns are realized before any contributions and deductions are made in 2017. 2. Historically, what have been the risks and rewards of the asset classes that Hackett can invest in? Use standard deviation to measure of risk and average return to measure reward. Assume that historical performance is a good indication of future performance. Based on your simulation, how does investment into each asset class impact the probability of fund survival? 4. Is it reasonable to assume that past performance is a good indication of future performance? Why or why not? What should Hackett do with the portfolio? Are there other options that Cook County should explore? 1. Build a model to simulate the solvency of the pension fund through 2022. Use the market value of the fund at the end of 2016 as the starting point for your simulation. Next, simulate the market value of the fund through the end of 2017. To do so, you will need to account for: 3. a. b. 5. C. Deductions from the pension that will be made in 2017 to pay out benefits to current retirees. To compute 2017 deductions, use the amount of 2016 deductions provided in the case and assume it grows by a constant annual growth rate. Contributions that will be made to the fund in 2017. In your projections, separate the supplementary contributions made by the County from required contributions by the County and its employees. For example, in 2016, total contributions to the fund were $659.3 million (Exhibit 8). Of that $659.3 million, $270.5 million was a supplementary contribution made by Cook County and the remaining $388.8 million were required contributions by the County and its employees Once you simulate the end-of-2017 asset value for the fund, re-do your analysis for 2018, 2019, upto 2022. Under what assumptions does the fund become insolvent, meaning the value of its assets falls below zero? Investment returns by the fund. Assume that annual returns are normally distributed. First build your simulator by assuming an arbitrary mean and standard deviation, then adjust the inputs afterwards. In addition, assume that investment returns are realized before any contributions and deductions are made in 2017. 2. Historically, what have been the risks and rewards of the asset classes that Hackett can invest in? Use standard deviation to measure of risk and average return to measure reward. Assume that historical performance is a good indication of future performance. Based on your simulation, how does investment into each asset class impact the probability of fund survival? 4. Is it reasonable to assume that past performance is a good indication of future performance? Why or why not? What should Hackett do with the portfolio? Are there other options that Cook County should explore?
Expert Answer:
Answer rating: 100% (QA)
1 The first step in modeling the solvency of the pension fund through 2022 is to simulate the market value of the fund at the end of 2016 as the starting point To do this we need to account for deduct... View the full answer
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date:
Students also viewed these accounting questions
-
Use Figure 32.11 as a starting point for this problem and consider the initial impact of the following circumstances on the aggregate demand, long-run aggregate supply, and short-run aggregate supply...
-
Financial objectives as a starting point for the budget process ... A company must start its budget process. The company's financial goal is to have the same goal for a financial balance at the end...
-
Create a spreadsheet model to simulate the annual income Ray would receive each of the next five years if he decides to buy the store.
-
If a pure discount three-year bond sells for $782 and a pure discount four-year bond sells for $733, what is the expected 12-month interest rate in three years time? Both have a face value of $1000....
-
Given the fact that a projects resource requirements are clearly spelled out in the projects action plan, why are PMs so concerned with resource allocation?
-
Larned Recreational builds two models of dune buggies: Sport and Custom. Both models require the same assembly and finishing process and are assembled in the same factory. They differ in the quality...
-
A horizontal Venturi flow meter consists of a convergingdiverging conduit as indicated in Fig. P5.93. The diameters of cross sections (1) and (2) are 6 and \(4 \mathrm{in}\). The velocity and static...
-
During 2014 and 2015, Cook Co. completed the following transactions relating to its bond issue. The companys fiscal year ends on December 31. 2014 Mar. 1 Issued $200,000 of eight-year, 6 percent...
-
The construction of a new coal mine will cost Yamada Co. Ltd. $430,000, with the expenditure occurring the next year. The investment will bring about cash flows of $200,000 annually over the...
-
Sara-Jayne Parsons is an architect who operates her own business. The accounts and transactions for the business follow. INSTRUCTIONS 1. Analyze the transactions for January 20X1. Record each in the...
-
The return statistics for two stocks and T-bills are given below: A 1 2 Expected return 3 Variance 4 Standard deviation 5 Covariance 3+ decimals B Stock A C D Stock B T-bills 0.094 0.1444 0.0729 0.38...
-
You are a solutions design consultant at a major third-party logistics services provider (3PL). You have been recently engaged to provide advice to a client in the aviation sector. This client would...
-
Find the x-intercepts of the polynomial below. 2 f(x) = x + 4x 5 Show your work here
-
C.C.R.I.T. Logistics Solutions is a firm that includes Software Engineers, Web Application Developers, Desktop Application Developers and a logistics consultant, among other positions. The...
-
How do senior executives navigate the intricate balance between strategic formulation and operational execution within contemporary organizations ?
-
f Find f+g, fg, fg and Determine the domain for each function. g f(x)=5x+6, g(x)=x-5 (f+g)(x)= (Simplify your answer.)
-
The tree diagram in figure below describes the uncertain cash flows for an engineering project. The analysis period is two years, and MARR = 15% per year. Based on this information, a. What are the...
-
Kims Konstructions has assembled the following data for a proposed straw-reinforced brick maker (SRBM): SRBM Cost: $26,000 Life: 5 years Revenue (p.a.) $11,000 Operating Expenses (p.a.) $3,000...
-
An electric utility currently operates ten plants. The following table gives the fixed costs, variable costs, and capacities of each of these plants. Daily demand is highly uncertain, given by a...
-
The database Automobile Losses.xlsx** contains information on the average loss payment per insured year for a number of makes and models of cars. It also contains data on the physical characteristics...
-
A firm operates a docking facility for container ships in Singapore. At present, the facility consists of two identical docks. Ships typically arrive during the night. The number of ships that arrive...
-
Describe the relationship between dynamic modeling, behavioral modeling, and structural modeling.
-
Comment on this statement: Dynamic modeling is about interaction.
-
Explain how objects interact by exchanging messages.
Study smarter with the SolutionInn App