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, 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

The City of Huble has a defined benefit pension plan for a number of its employees. Which of thefollowing is not included immediately in the determination of pension expense that this government should recognize in its government-wide financial statements?a. Service cost.b. Interest on total pension liability.c. Changes in pension liability as a result of a change in benefit terms.d. Changes in pension liability as a result of a change in economic or demographic assumptions.

The City of Huble has a defined benefit pension plan for a number of its employees. Which of the following is not included immediately in the determination of pension expense that this government should recognize in its government-wide financial statements? Service cost. Interest on total pension liability. Changes in pension liability as a result of a change in benefit terms. Changes in pension liability as a result of a change in economic or demographic assumptions.

The factors affecting pension expense are not always obvious.As the accountant for Sunlight City, you determine the following with respect to the city's pensions in a particular year.Service cost $356,000Interest on total pension liability 400,000Actual earnings on pension plan investments 500,000Projected earnings on pension plan investments 450,000Employer contribution to the plan 180,000Benefits paid to retirees 211,000 Based on the information provided, what should the city report as its pension expense for the year? Suppose that the benefits paid to retirees were actually $251,000 rather than $211,000. How would that affect the pension expense? Explain. Suppose also that the city failed to contribute anything to the pension plan. How would that affect the pension expense to be reported on the government‐wide statements? Explain. How would it affect the pension expenditure to be reported on the statements of the general fund?

Answer 2