Data Visualization $17-1$ Reporting Pension Plan Funding

Traveltime Tours has a defined benefit pension plan. As a new employee, you are interested in the future well$-$belng of the plan. help you visualize your assessment, you use your Excel skills to graph the key numbers. The line graph below plots the balance company's Projected Benefit Obligation and Its Plan Assets over the most recent six years.

DEFINED BENEFIT PENSION PLAN

Click here to open the graph$($s$)$ In a new tab.

Required:

Year $1,$ Year $2,$ Year $3.$

Year $4,$ Year $5,$ Year $6.$

ear $1,$ Year $2,$ Year $3,$ Year $4,$ Year $5,$ Year $6.$

The stock market performed increasingly well for several years.

Employees covered by the pension plan are retiring at an increasing rate.

The pension plan experienced several actuarial losses.