Selected financial information for Excelsior Limited for a six-year period follows:

Required

1. Prepare a horizontal analysis to compare 2020 to 2019. Round percentages to two decimal places. Which accounts increased the most?

2. Compute trend percentages for 2016 through 2020, using 2015 as the base year. Round to the nearest whole percentage.

3. From the above data, what can we infer about expenses from 2015 through 2020? sales less net income will give amount of expenses. Compare the rate of growth in expenses to that of sales.

4. Have total assets grown at the same rate as the growth in sales?

Transcribed Image Text:

A в с D E F G 1 (Amounts in thousands) 2020 2019 2018 2017 2016 2015 2 3 Net sales 4 Net income 5 Total assets $804 $912 $662 $714 $616 $604 112 92 65 82 68 58 654 610 522 470 462 410