Compute the missing amount of “schedule of changes in the County’s Net pension liability and related ratios”.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 8, Problem 26EP

To determine

Compute the missing amount of “schedule of changes in the County’s Net pension liability and related ratios”.

Expert Solution & Answer

Explanation of Solution

Fiduciary activities: Fiduciary activities are those activities done by persons or organizations to another parties with utmost good faith and trust. A fiduciary activity may involve managing funds, assets and other valuables of a person or a group of people.

The person or organization involved in fiduciary activities need to act ethically in the best interest of others. Government also involve in fiduciary activities by holding the assets of individuals or organization to benefit them.

Prepare the financial statement of County B:

Accounting For Governmental & Nonprofit Entities, Chapter 8, Problem 26EP

Table (1)

Working note (a): Calculate interest during the year 2020:

Interest amount is calculated by deducting all other pension liabilities from net change in total pension liability. Total pension liabilities except interest includes service costs, difference between expected and experience, and benefit payments. The amount of service cost is $123,225, difference between expected and experience is $1,250, and benefit payment is -$248,000. The net change in total pension liability is $66,205.

Calculation of interest is as follows:

Interest=Net change in total pension liability−(Service cost+difference between expected and experience+Benefit payment)=$66,205−($123,225+$1,250−$248,000)=$66,205+$123,525=$189,730

Hence, the interest amount is $189,730.

Working note (b): Calculate net change in plan fiduciary net position:

Net change in plan fiduciary net position is the difference between plan fiduciary net position at the end of the year and plan fiduciary net position at the beginning of the year. Plan fiduciary net position at the ending is $1,057,720. Plan fiduciary net position at the beginning is $1,011,680.

Calculation of net change in plan fiduciary net position is as follows:

Net change in plan fiduciary net position=(Plan fiduciary net position at the end−Plan fiduciary net position at the beginning)=($1,057,720−$1,011,680)=$46,040

Hence, the net change in plan fiduciary net position is $46,040.

Working note (c): Calculate net change in plan fiduciary net position:

Net change in plan fiduciary net position is the difference between plan fiduciary net position incomes and plan fiduciary net position expenses. Plan fiduciary net position income includes contribution from employee $32,450, contribution from employers $98,620, and net investment income $18,990. Plan fiduciary net position expenses include benefit payments of $64,500 and administrative expenses of $3,290.

Calculation of net change in plan fiduciary net position is as follows:

Net change in plan fiduciary net position=(Plan fiduciary net position incomes−Plan fiduciary net position expenses)=(($32,450+$98,620+$18,990)−($64,500+$3,290))=$150,060−$67,790=$82,270

Hence, the net change in plan fiduciary net position is $82,270.

Working note (d): Calculate plan fiduciary net position at the beginning of the year 2020:

Plan fiduciary net position at the beginning is computed as the difference between plan fiduciary net position at the end of the year and net change in plan fiduciary net position. Plan fiduciary net position at the end of the year is $1,220,490.

Calculation of plan fiduciary net position at the beginning is as given below:

Plan fiduciary net position at the beginning}=(Plan fiduciary net position at the end of the year−Net change in plan fiduciary net position)=($1,220,490−$82,270)=$1,138,220

Hence, the plan fiduciary net position at the beginning of the year 2020 is $1,138,220.

Working note (e): Calculate plan fiduciary net position as the percentage of total pension liability:

Plan fiduciary net position as a percentage of total pension liability is calculated by dividing plan fiduciary net position at the end of the year by total pension liability at the end of the year. Plan fiduciary net position at the end of the year is given as $1,220,490 and total pension liability at the end of the year is calculated as $2,149,920.

Calculate plan fiduciary net position as the percentage of total pension liability:

(Plan fiduciary net position as a percentage of total pension liability)=(Plan fiduciary net position at the end of the year)(Total pension liability at the end of the year)×100=$1,220,490$2,49,920×100=56.77%

Hence, the plan fiduciary net position as percentage of total pension liability is 56.77%.

Working note (f): Calculate covered-employee payroll:

The calculation of covered-employee payroll is by dividing net pension liability at the ending by net pension liability as a percentage of covered-employee payrolls. Net pension liability at the ending is given as $929,430 and net pension liability as a percentage of covered-employee payrolls is 185.09%.

Calculate covered-employee payroll:

Covered-employee payroll=Net pension liability at the ending(Net pension liability as a percentage of covered-employee payrolls)=$929,4301.8509=$502,150

Hence, the covered-employee payroll is $502,150.

Working note (g): Calculate benefit payment for the year 2019:

Benefit payment is calculated by deducting all other pension liabilities from net change in total pension liability. Total pension liabilities except benefit payment includes service costs, interest, and difference between expected and experience. The amount of service cost is $125,440, interest amount is $182,580, and difference between expected and experience is -$850, and benefit payment is -$248,000. The net change in total pension liability is $75,590.

Calculate benefit payment for the year 2019:

Benefit payment=Net change in total pension liability−(Service cost+Interest−difference between expected and experience)=$75,590−($125,440+$182,580−$850)=$75,590−$307,170=−$231,580

Hence, the benefit payment for the year 2019 is ($231,580).

Working note (h): Calculate total pension liability at the beginning of the year 2019:

Total pension liability at the beginning of the year is computed as the difference between total pension liability at the end of the year and net change in total pension liability. The total pension liability at the ending is $2,083,715. The calculation is as follows:

Calculate total pension liability at the beginning of the year 2019:

Total pension liability at the beginning of the year}=(Total liability at the ending−Net cahnge in total pension liability)=($2,083,715−$75,590)=$2,008,125

Hence, the total pension liability at the beginning of the year is $2,008,125.

Working note (i): Calculate total pension liability at the end of the year 2019:

The total pension liability at the end of the year 2019 will be the same as the total pension liability at the beginning of the year 2020. The total pension liability at the beginning of the year 2020 is $2,083,715. Hence, the total pension liability at the end of the year 2019 is also $2,083,175.

Working note (j): Calculate net investment income for 2019:

Net investment income is the difference between net change in plan fiduciary net position and the difference between plan fiduciary net position incomes and plan fiduciary net position expenses. Plan fiduciary net position income includes contribution from employee $36,240, contribution from employers $102,530. Plan fiduciary net position expenses include benefit payments of -$42,780 and administrative expenses of -$3,110. The net change in plan fiduciary net position is given as $80,500.

Calculate net investment income for 2019:

Net investment income=(Net change in plan fiduciary net position)−(Plan fiduciary net position incomes−Plan fiduciary net position expenses)=$80,500−(($36,240+$102,530)−($42,780+$3,110))=$80,500−$92,880=−$12,380

Hence, the net investment income for 2019 is ($12,380).

Working note (k): Calculate plan fiduciary net position at the beginning of 2019:

The plan fiduciary net position at the beginning of the year 2019 will be the same as the plan fiduciary net position at the end of the year 2018. The plan fiduciary net position at the end of the year 2018 is $1,057,720. Hence, the plan fiduciary net position at the beginning of the year 2019 is also $1,057,720.

Working note (l): Calculate plan fiduciary net position at the end of the year 2019:

Plan fiduciary net position at the ending is computed as the sum of plan fiduciary net position at the beginning of the year and net change in plan fiduciary net position. Plan fiduciary net position at the beginning of the year is $1,057,720.

Calculation of plan fiduciary net position at the beginning is as given below:

Plan fiduciary net position at the ending}=(Plan fiduciary net position at the beginning of the year−Net change in plan fiduciary net position)=($1,057,720+$80,500)=$1,138,220

Hence, the plan fiduciary net position at the end of the year 2019 is $1,138,220.

Working note (m): Calculate net pension liability at the end of the year 2019:

Net pension liability at the end of the year 2019 is calculated as the difference between total pension liability at the ending of 2019 and plan fiduciary net position at the ending. Total pension liability at the ending of 2019 is calculated as $2,083,715 and plan fiduciary net position at the ending of 2019 is $1,138,220.

Calculate net pension liability at the end of the year 2019:

Net pension liability at the ending}=(Total pension liability at the ending−Plan fiduciary net position at the ending)=($2,083,715−$1,138,220)=$945,495

Hence, the net pension liability at the end of the year 2019 is $945,495.

Working note (n): Calculate covered-employee payroll:

The calculation of covered-employee payroll is by dividing net pension liability at the ending by net pension liability as a percentage of covered-employee payrolls. Net pension liability at the ending is given as $945,495 and net pension liability as a percentage of covered-employee payrolls is 194.86%.

Calculate covered-employee payroll:

Covered-employee payroll=Net pension liability at the ending(Net pension liability as a percentage of covered-employee payrolls)=$945,4951.9486=$485,218

Hence, the covered-employee payroll is $485,218.

Working note (o): Calculate net change in total pension liability for the year 2018:

Net change in total pension liability is calculated by deducting benefit payment from all other pension liabilities. Total pension liabilities except benefit payment includes service costs, interest, and difference between expected and experience. The amount of service cost is $127,950, interest amount is $169,960, and difference between expected and experience is $625. The benefit payment is given as -$217,960.

Calculate net change in total pension liability for the year 2018:

Net change in total pension liability=(Service cost+Interest+difference between expected and experience−Benefit payment)=($127,950+$169,960+$625−$217,960)=$298,535−$217,960=$80,575

Hence, the net change in total pension liability for the year 2018 is $80,575.

Working note (p): Calculate total pension liability at the end of the year 2018:

The total pension liability at the end of the year 2018 will be the same as the total pension liability at the beginning of the year 2019. The total pension liability at the beginning of the year 2019 is $2,008,125. Hence, the total pension liability at the end of the year 2018 is also $2,008,125.

Working note (q): Calculate contribution from employees for 2018:

Contribution from employees is calculated as the difference between net change in plan fiduciary net position and the difference between plan fiduciary net position incomes and plan fiduciary net position expenses. Plan fiduciary net position income includes contribution from employers $91,550 and net investment income is -$21,510. Plan fiduciary net position expenses include benefit payments of -$51,330 and administrative expenses of -$2,840. The net change in plan fiduciary net position is calculated as $46,040.

Calculate contribution from employees for 2018:

Contribution from employees=(Net change in plan fiduciary net position)−(Plan fiduciary net position incomes−Plan fiduciary net position expenses)=$46,040−(($91,550−$21,510)−($51,330+$2,840))=$46,040−$15,870=$30,170

Hence, the contribution from employee for 2018 is $30,170.

Working note (r): Calculate net change in plan fiduciary net position:

Net change in plan fiduciary net position is the difference between plan fiduciary net position at the end of the year and plan fiduciary net position at the beginning of the year. Plan fiduciary net position at the ending is $1,057,720. Plan fiduciary net position at the beginning is $1,011,680.

Calculation of net change in plan fiduciary net position is as follows:

Net change in plan fiduciary net position=(Plan fiduciary net position at the end−Plan fiduciary net position at the beginning)=($1,057,720−$1,011,680)=$46,040

Hence, the net change in plan fiduciary net position is $46,040.

Working note (s): Calculate net pension liability at the end of the year 2018:

Net pension liability at the end of the year 2018 is calculated as the difference between total pension liability at the ending of 2018 and plan fiduciary net position at the ending. Total pension liability at the ending of 2018 is calculated as $2,008,125 and plan fiduciary net position at the ending of 2018 is $1,057,720.

Calculation of net pension liability at the end of the year 2018 is as given below:

Net pension liability at the ending}=(Total pension liability at the ending−Plan fiduciary net position at the ending)=($2,008,125−$1,057,720)=$950,405

Hence, the net pension liability at the end of the year 2018 is $950,405.

Working note (t): Calculate net pension liability as a percentage of covered-employee payrolls:

The calculation of net pension liability as a percentage of covered-employee payroll is by dividing net pension liability at the ending by covered-employee payroll. Net pension liability at the ending is given as $950,405 and covered-employee payroll is $489,810. The calculation of covered-employee payroll is as follows:

Net pension liability as a percentage of covered-employee payroll}=Net pension liability at the endingCovered-employee payroll×100=$950,405$489,810×100=194.04%

Hence, the net pension liability as a percentage of covered-employee payrolls is 194.04%.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Bluff County's schedule of changes in net pension liability and related ratios is shown below. (Deductions should be indicated by a minus sign. Do not round Intermediate calculations. Round percentage answers to 2 decimal places and other answers to nearest whole dollar.) Required Compute the missing amounts. Total pension liability Service cost Interest BLUFF COUNTY EMPLOYEE RETIREMENT SYSTEM Schedule of Changes in the County's Net Pension Liability and Related Ratios Last Three Fiscal Years Differences between expected and actual experience Benefit payments (including refunds of employee contributions) Net change in total pension liability Total pension liability, beginning Total pension liability, ending Plan fiduciary net position Contributions-employee Contributions-employer Net investment income Benefit payments (including refunds of employee contributions) Administrative expenses Net change in plan fiduciary net position Plan fiduciary net position, beginning Plan fiduciary net…

The following incomplete (columns have missing amounts) pension spreadsheet is for the current year for First Republic Corporation (FRC). ($ in millions)Debit(Credit)PBO Plan Assets Prior Service Cost Net(Gain)/Loss Pension Expense Cash Net Pension (Liability)/Asset Beginning balance (740) 32 (94) Service cost 66 Interest cost 37 Expected return on assets 72 Gain/loss on assets (4) Amortization of: Prior service cost (10) Net gain/loss 5 Loss on PBO (12) Contributions to fund (49) Retiree benefits paid (69) Ending balance 745 (85) What was the net pension asset/liability reported in the balance sheet at the end of the year? Multiple Choice Net pension liability of $41 million. Net pension asset of $58 million. Net pension…

Warrick Boards calculated pension expense for its underfunded pension plan as follows: ($ in millions) Service cost $ 224 Interest cost 150 Expected return on the plan assets ($100 actual, less $10 gain) (90 ) Amortization of prior service cost 8 Amortization of net loss 2 Pension expense $ 294 Required: Which elements of Warrick’s balance sheet are affected by the components of pension expense? What are the specific changes in these accounts?

Answer 2