Calculate any five key ratios from the attached for 2019 & 2020 and describe the results. Please show the formula/calculations.
2019 2018 Contributions for plan year beginning October 1: Actuarial accrued liability for plan year beginning October 1: Funded status for plan year beginning October 1: Actuarially determined employer contributions (ADEC)' ADEC' as a percent of payroll Expected employer contributions Shortfall Retired members and beneficiaries Inactive vested members Active members Inactive members due a refund of employee contributions Total Normal cost including administrative expenses Market value of assets (MVA) Unfunded/(overfunded) actuarial accrued liability Funded percentage Projected insolvency in plan year beginning October 1 Net investment return (funding valuation basis) Inflation rate Discount rate prior to projected insolvency 20-year bond rate Blended rate Total pension liability Plan fiduciary net position Net pension liability Plan fiduciary net position as a percentage of total pension liability Number of retired members and beneficiaries Number of active members Total covered payroll Average payroll $365,803,372 91.59% 90,860,529 274,942,843 $2,953,200,280 383,454,721 1,744,402,145 11,241,555 5,092,298,701 91,896,341 $678,120.265 4,414,178,436 13.32% 2023 4.00% 2.50% 4.00% 2.66% 2.67% $5,992,768,058 678,120,265 5,314,647,793 11.32% 8,761 8,736 $399,386,941 45,717 $277,523,563 68.56% 82,979,021 194,544,533 $2,307,472,963 204,418,060 1,182,100,271 9,047,179 3,703,038,473 53,750,366 $768,820,663 2,934,217,810 20.76% 2023 7.00% 2.50% 7.00% 4.18% 4.25% $4,941,600,552 768,820,663 4,172,779,889 15.56% 8,702 9,368 $404,775,714 43,208 Key assumptions GASB information Demographic data for plan year beginning October 1: 2020 2019 Contributions for plan year beginning October 1: Actuarial accrued liability for plan year beginning October 1: Actuarially determined employer contributions (ADEC)' Actuarially determined employer contributions as a percent of payroll Expected employer contributions Shortfall Retired members and beneficiaries Inactive vested members Active members Inactive members due a refund of employee contributions Total Normal cost including administrative expenses Market value of assets (MVA) Unfunded/(overfunded) actuarial accrued liability Funded percentage Projected Insovlency date Net investment return (long-term basis) Inflation rate Discount rate 20-year bond rate Blended rate Total pension liability Plan fiduciary net position Net pension liability Plan fiduciary net position as a percentage of total pension liability Number of retired members and beneficiaries Number of active members Total covered payroll Average salary $373,748,689 90.77% 96,762,986 276,985,703 $2,971,030,480 398,296,750 1,732,949,728 10,487,389 5,112,764,347 92,850,891 $582,539,738 4,530,224,609 11.39% October 2024 4.00% 2.50% Funded status for plan year beginning October 1: $365,803,372 91.59% 90,860,529 274,942,843 $2,953,200,280 383,454,721 1,744,402,145 11,241,555 5,092,298,701 91,896,341 $678,120,265 4,414,178,436 13.32% July 2024 4.00% 2.50% 4.00% 2.66% 2.67% $5,992,768,058 678,120,265 5,314,647,793 11.32% 8,761 8,736 $399,386,941 $45,717 Key assumptions GASB information 4.00% 2.21% 2.23% $6,358,816,145 582,539,738 5,776,276,407 9.16% 8,792 8,804 $411,757,386 $46,769 Demographic data for plan year beginning October 1: 2019 2018 Contributions for plan year beginning October 1: Actuarial accrued liability for plan year beginning October 1: Funded status for plan year beginning October 1: Actuarially determined employer contributions (ADEC)' ADEC' as a percent of payroll Expected employer contributions Shortfall Retired members and beneficiaries Inactive vested members Active members Inactive members due a refund of employee contributions Total Normal cost including administrative expenses Market value of assets (MVA) Unfunded/(overfunded) actuarial accrued liability Funded percentage Projected insolvency in plan year beginning October 1 Net investment return (funding valuation basis) Inflation rate Discount rate prior to projected insolvency 20-year bond rate Blended rate Total pension liability Plan fiduciary net position Net pension liability Plan fiduciary net position as a percentage of total pension liability Number of retired members and beneficiaries Number of active members Total covered payroll Average payroll $365,803,372 91.59% 90,860,529 274,942,843 $2,953,200,280 383,454,721 1,744,402,145 11,241,555 5,092,298,701 91,896,341 $678,120.265 4,414,178,436 13.32% 2023 4.00% 2.50% 4.00% 2.66% 2.67% $5,992,768,058 678,120,265 5,314,647,793 11.32% 8,761 8,736 $399,386,941 45,717 $277,523,563 68.56% 82,979,021 194,544,533 $2,307,472,963 204,418,060 1,182,100,271 9,047,179 3,703,038,473 53,750,366 $768,820,663 2,934,217,810 20.76% 2023 7.00% 2.50% 7.00% 4.18% 4.25% $4,941,600,552 768,820,663 4,172,779,889 15.56% 8,702 9,368 $404,775,714 43,208 Key assumptions GASB information Demographic data for plan year beginning October 1: 2020 2019 Contributions for plan year beginning October 1: Actuarial accrued liability for plan year beginning October 1: Actuarially determined employer contributions (ADEC)' Actuarially determined employer contributions as a percent of payroll Expected employer contributions Shortfall Retired members and beneficiaries Inactive vested members Active members Inactive members due a refund of employee contributions Total Normal cost including administrative expenses Market value of assets (MVA) Unfunded/(overfunded) actuarial accrued liability Funded percentage Projected Insovlency date Net investment return (long-term basis) Inflation rate Discount rate 20-year bond rate Blended rate Total pension liability Plan fiduciary net position Net pension liability Plan fiduciary net position as a percentage of total pension liability Number of retired members and beneficiaries Number of active members Total covered payroll Average salary $373,748,689 90.77% 96,762,986 276,985,703 $2,971,030,480 398,296,750 1,732,949,728 10,487,389 5,112,764,347 92,850,891 $582,539,738 4,530,224,609 11.39% October 2024 4.00% 2.50% Funded status for plan year beginning October 1: $365,803,372 91.59% 90,860,529 274,942,843 $2,953,200,280 383,454,721 1,744,402,145 11,241,555 5,092,298,701 91,896,341 $678,120,265 4,414,178,436 13.32% July 2024 4.00% 2.50% 4.00% 2.66% 2.67% $5,992,768,058 678,120,265 5,314,647,793 11.32% 8,761 8,736 $399,386,941 $45,717 Key assumptions GASB information 4.00% 2.21% 2.23% $6,358,816,145 582,539,738 5,776,276,407 9.16% 8,792 8,804 $411,757,386 $46,769 Demographic data for plan year beginning October 1
