Tarzwell Limited is preparing some analysis of past financial performance and positions to include in the MD&A portion of the annual report to shareholders. You have suggested that it would be useful for users of the MD&A to include a trend analysis of key balances. You have asked your assistant to analyze the proportion of the percentage increase in each year’s sales compared with the percentage change in net income and in total assets over the past five fiscal years. The following table provides amounts reported on the past five years’ financial statements that will be used in the analysis (in ’000s).

InstructionsCalculate the percentage change in each of the three elements for each year. Round to one decimal place. Graph the results using an Excel bar chart, then create a second chart using a line chart type.

Transcribed Image Text:

Sales Net income Total assets 2019 $5,700 640 7,820 2020 $6,500 760 8,440 2021 $8,150 920 9,525 2022 $10,900 1,140 11,625 2023 $12,600 1,380 13,740