Find trend percentages (Using year 1 for base)

   

Sales Cost of sales Gross profit Year 5 $1,195,400 752,400 $443,000 Year 4 Year 3 Year 2 Year 1 $755,000 $1,118,000 $1,049,000 $963,200 704,000 671,000 616,700 599,000 $414,000 $378,000 $346,500 $246,000