The budget director says, In the worst case, we cannot do anything about the cost of living
Fantastic news! We've Found the answer you've been seeking!
Question:
The budget director says, “In the worst case, we cannot do anything about the cost of living adjustment, the stock market tanks, and we earn very little—say 3 percent. Productivity goes to zero and other factors remain the same. That is the ‘worst case.’ How bad would that be?” Explain the logical reason.
Transcribed Image Text:
CONSTANTS 2018 2020 2021 2022 2016 2017 2019 2023 2024 2025 Retiree Years of Service 25 25 25 25 25 25 25 25 25 25 Average Increase in Teacher Salary 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 Retiree Rate 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 Mortality Rate Expected Average Final Salary Expected Administrative Expense 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 $ 83,648 $ 85.330 $ 86,183 $ $26,015,100 82,000 $ 82,820 $ 84,485 $ 87,045 $ 87,915 $ 88,794 $ 89,682 NA $25,000,000 $25,250,000 $25,502,500 $25,757,525 $26,275,251 $26,538,004 $26,803,384 $27,071,418 INPUTS Value Cost of Living Adjustment Long Term Rate of Return Productivity Factor Employee Contribution Rate 0.03 0.03 0.00 0.095 Final Salary Give Back State Contribution Factor 2.5 SUMMARY OF KEY RESULTS NPV of Unfunded Liability Value 23,685,305,718 Ratio of Assets to Liability NPV 62% CALCULATIONS Average Teacher Salary 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2$ 68,500 $ 69,185 $ 69,877 $ 70,576 $ 71,281 $ 71,994 $ 72,714 $ 73,441 $ 74,176 $ 74,917 Number of Active Teachers 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 Number of New Retirees Number of Retirees NA 5320 5320 5320 5320 5320 5320 5320 5320 5320 101,500 2$ 101,745 101,977 102,198 102,408 102,607 102,796 102,976 103,147 103,309 Total Teacher Compensation Employee Contribution to Fund State Contribution to Fund 9,293,621,050 $ 9,575,227,061 $ 909,646,571 $ 9,767,689,125$ 927,930,467 $ NA 9,201,605,000 $ 9,386,557,261 $ 9,480,422,833 $ 9,670,979,332 $ 9,865,366,017 $ 9,964,019,677 NA 2$ 874,152,475 $ 882,894,000 $ 891,722,940$ 900,640,169$ 918,743,037 $ 937,209,772 $ 946,581,869 NA 2,185,381,188 $ 2,207,234,999 $ 2,229,307,349 $ 2,251,600,423 $ 2,274,116,427 $ 2,296,857,591 $ 2,319,826,167 $ 2,343,024,429 $ 2,366,454,673 Average Retiree Benefit Expected Benefits Payout $ 49,311 $ 49,804 $ 5,128,606,768 $ NA 46,918 $ 47,387 $ 47,861 $ 48,339 $ 48,823 $ 50,302 $ 50,805 NA $ 4,773,624,090 $ 4,832,354,046 $ 4,891,254,773 $ 4,950,318,548 $ 5,009,537,425 $ 5,068,952,540 $ 5,188,494,468 $ 5,248,609,816 CONSTANTS 2018 2020 2021 2022 2016 2017 2019 2023 2024 2025 Retiree Years of Service 25 25 25 25 25 25 25 25 25 25 Average Increase in Teacher Salary 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 Retiree Rate 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 Mortality Rate Expected Average Final Salary Expected Administrative Expense 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 $ 83,648 $ 85.330 $ 86,183 $ $26,015,100 82,000 $ 82,820 $ 84,485 $ 87,045 $ 87,915 $ 88,794 $ 89,682 NA $25,000,000 $25,250,000 $25,502,500 $25,757,525 $26,275,251 $26,538,004 $26,803,384 $27,071,418 INPUTS Value Cost of Living Adjustment Long Term Rate of Return Productivity Factor Employee Contribution Rate 0.03 0.03 0.00 0.095 Final Salary Give Back State Contribution Factor 2.5 SUMMARY OF KEY RESULTS NPV of Unfunded Liability Value 23,685,305,718 Ratio of Assets to Liability NPV 62% CALCULATIONS Average Teacher Salary 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2$ 68,500 $ 69,185 $ 69,877 $ 70,576 $ 71,281 $ 71,994 $ 72,714 $ 73,441 $ 74,176 $ 74,917 Number of Active Teachers 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 133,000 Number of New Retirees Number of Retirees NA 5320 5320 5320 5320 5320 5320 5320 5320 5320 101,500 2$ 101,745 101,977 102,198 102,408 102,607 102,796 102,976 103,147 103,309 Total Teacher Compensation Employee Contribution to Fund State Contribution to Fund 9,293,621,050 $ 9,575,227,061 $ 909,646,571 $ 9,767,689,125$ 927,930,467 $ NA 9,201,605,000 $ 9,386,557,261 $ 9,480,422,833 $ 9,670,979,332 $ 9,865,366,017 $ 9,964,019,677 NA 2$ 874,152,475 $ 882,894,000 $ 891,722,940$ 900,640,169$ 918,743,037 $ 937,209,772 $ 946,581,869 NA 2,185,381,188 $ 2,207,234,999 $ 2,229,307,349 $ 2,251,600,423 $ 2,274,116,427 $ 2,296,857,591 $ 2,319,826,167 $ 2,343,024,429 $ 2,366,454,673 Average Retiree Benefit Expected Benefits Payout $ 49,311 $ 49,804 $ 5,128,606,768 $ NA 46,918 $ 47,387 $ 47,861 $ 48,339 $ 48,823 $ 50,302 $ 50,805 NA $ 4,773,624,090 $ 4,832,354,046 $ 4,891,254,773 $ 4,950,318,548 $ 5,009,537,425 $ 5,068,952,540 $ 5,188,494,468 $ 5,248,609,816
Expert Answer:
Answer rating: 100% (QA)
When we want to apply risk management effectively the concept of worstcase scenario is a concept where planner cosider for potential disasters losses ... View the full answer
Related Book For
International Financial Management
ISBN: 978-0132162760
2nd edition
Authors: Geert Bekaert, Robert J. Hodrick
Posted Date:
Students also viewed these accounting questions
-
The 2017 and 2018 balance sheets and related income statement of Watson and Holmes Detective Agency follow: REQUIRED: Prepare a statement of cash flows under both the direct and indirect methods for...
-
Do we have a global stock market as we have a global foreign exchange market?
-
In general, employee stock options cannot be sold to another party. How do you think this affects the value of an employee stock option compared to a market-traded option?
-
CPA firm brings in a yoga instructor during the tax busy season to help relieve stress of the employees. Which is true about the CPA firm's ability to take a deduction for the yoga instructor's...
-
How are net losses treated in the Section 1231 netting process? How is a net Section 1231 gain taxed?
-
In 2016, Samantha loaned her friend Lo Ping $15,000. The loan required Lo Ping to pay interest at 8% per year and to pay back the $15,000 loan principal on July 31, 2018. Lo Ping used the loan to...
-
Construct a frequency histogram for the data set using seven classes. Use the data set shown in the table at the left, which represents the actual liquid volumes (in ounces) in 25 twelve-ounce cans....
-
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of...
-
Cherokee Incorporated is a merchandiser that provided the following information: Number of units sold Selling price per unit Variable selling expense per unit Variable administrative expense per unit...
-
. With the information generated from the following table derivate from the Bureau of Economic Analysis (https://apps.bea.gov/iTable/index_nipa.cfm), please do the regression analysis, with the...
-
1. Construct a stem and teat diagram for the following data. Calculate me sample mean, standard deviation ad the median. 2. Construct a mass scale histogram of the data set. 64 66 67 65 68 61 65 67...
-
Which of the following is part of the Family and Medical Leave Act for the employer: a.Must provide for 9 months of unpaid leave b.Must pay the employee 50% of their salary during the leave c.Must...
-
There are four regions of a certain country that meet at a common corner. The areas of the four regions, in square miles, are shown in the table. Region 1 71,723 (a) Mentally estimate the combined...
-
Suppose two friends go out to eat. Each individual i has utility ui obtained from slices of pizza, xi , and money, mi , given by ui(xi ,mi) = 5xi 0.5x 2 i +mi ,i = 1,2, (1) where mi is in dollars....
-
Give examples on Developimg and describe a personal philosophy on the contribution of DNP-prepared nurses to healthcare outcomes. show how Appraise and elaborate on how this knowledge from a DNP...
-
Andrew is the sole owner of. Cherry Co. He has $30,000 basis in his stock during the year he received. A $50,000 distribution from. Cherry Co. If Cherry Co. had $21,000 of current E&P, and an...
-
A billiard ball moving at 5.90 m/s strikes a stationary ball of the same mass. After the collision, the first ball moves at 5.06 m/s, at an angle of 31 with respect to the original line of motion....
-
Write the binomial probability in words. Then, use a continuity correction to convert the binomial probability to a normal distribution probability. P(x 110)
-
What is a moving-average crossover rule?
-
What is likely to happen if a central bank suddenly prints a large amount of new money?
-
Valuing Metallwerkes Contract with Safe Air, Inc. Consider the discounted expected value of the 10- year contract that Metallwerke may sign with Safe Air in Chapter 9. In the initial year of the...
-
__________ is the special systems test that determines the time duration to process transaction data. (a) Peak load testing (b) Performance time testing (c) Unit testing (d) Recovery testing
-
The testing technique that requires devising test cases to exercise the internal logic of a software module is called ___________. (a) Black box testing (b) Special systems testing (c) Glass box...
-
From where test data (to test the system) are made available? (a) Live environment (b) Test libraries (c) Dummy data (d) All of these
Study smarter with the SolutionInn App