PREPARE A PENSION WORKSHEET USING AN EXCEL SPREADSHEET BASED ON THE 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