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....
-
Consider the plasma jet of Problem 7.96. When new ceramic coating materials are developed, spray trials are performed using small, circular substrates called coupons that can be coated easily and...
-
Compute the pseudo inverse of A. A =
-
George Clooney Company's income statement for the year ended December 31 2002, contained the following condensed information. Clooney s balance sheet contained the following comparative data at...
-
Jae Company lost 70% of its inventory in a fire on March 25, 2012. The accounting records showed the following gross profit data for February and March. Jae Company is fully insured for fire losses...
-
Wilkes Manufacturing sells one product with a variable unit cost of $18. The company knows that the price charged will affect demand. Fixed costs are $265,000. If sales exceed 50,000 units, the...
-
Complete Tsate's Form 1040-SR, Schedules A, B and D, Form 8949, Form 6252 and Qualified Dividends and Capital Gain Tax Worksheet. Tsate Kongia (birthdate 02/14/1954) is an unmarried high school...
-
12. Vector u has components <3/2, -2> and vector v has components find the angle e between u and v and then find the component vector of u that is perpendicular to vector v.
-
er 3 (3) - Word erences Mailings Review View Help COST-VOLUME-PROFIT CHART Revenues Variable Contribution Fixed Costs Margin Costs Operating Taxes@ Income 20% Net Income 10,000 8,000 2,000 1,500 500...
-
XYZ Corporation uses job order costing. At the beginning of September, the jobs were in process: No. 223No. 225 MaterialsP 36,000P 13,000 Labor10,0002,000 Applied Overhead15,0003,000 Star had no...
-
MNO company would like to know if their company is profitable or not. What they have are only the following data: Sales for the 1 st quarter is Php 300,000.00, same with the 3 rd & 4 th quarters....
-
Calculate equivalent units in the Withholding Department using the Average method! Calculate equivalent units in the Assembly Department using the Average method, with assuming a 100% completion rate...
-
Conduct a Competitive Analysis on Allucent Marketing - http://allucent.io Identify competitors: who are they and who are their competitors? Identify the strengths and weaknesses of competitors...
-
Consider the following two projects:Cash FlowsProject AProject BC0-$200-$200C180100C280100C380100C480Instructions: (2 marks each) 2 answers
-
The trade-off theory relies on the threat of financial distress. But why should a public corporation ever have to land in financial distress? According to the theory, the firm should operate at the...
-
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...
-
The hotel chain CIGA provides information to the market on value creation, measured by a ROCE calculated as the ratio between EBITDA and the historic value (i.e. gross before depreciation and...
-
How does using different scenarios differ from simple cash flow discounting?
-
In a simplified form, can the Monte Carlo method be implemented without a computer?
Study smarter with the SolutionInn App