Based on past workers compensation claims data, TRSs risk manager estimated loss development factors of 5.2 for year-end values one year ago, 4.3 for year-end values two years ago, 3.7 for year-end values three years ago, 2.6 for year-end values four years ago, and 1.2 for year-end values five years ago. Workers compensation losses settled to date for the previous five years are as follows:

5 Years Ago	4 Years Ago	3 Years Ago	2 Years Ago	Last Year
$500,000	$445,000	$375,000	$310,000	$260,000

Based on the loss development factors and claims settled to date, what are the ultimate claims expected for each of the past five years? SHOW ALL WORK IN EXCEL

1. Calculate the claims expected in each year

Losses 5 Years Ago Losses 4 Years Ago Losses 3 Years Ago Losses 2 Years Ago Losses Last Year Loss Development Factor Loss Development Factor Loss Development Factor Loss Development Factor Loss Development Factor Claims Expected 5 Years Ago Claims Expected 4 Years Ago Claims Expected 3 Years Ago Claims Expected 2 Years Ago Claims Expected Last Year