PREPARE A PENSION WORKSHEET USING EXCEL SOREADSHEET BASED ON TGE ABOVE DATA.

On December 31, 2018, the following pension-related data were available for CPS Industries noncontributory, defined benefit pension plan. The remaining average service life of the employees is 18 years Projected Benefit Obligation Balance, January 1, 2018 Service cost Interest cost, discount rate, 6% Upward adjustment in PBO due to revised actuarial assumptions Pension benefits paid during 2018 ($ in millions) $900 160 20 90