using the excel sheet, answer the following questions. please select all that apply. show work

Use the Edmonton Opera Excel Template posted in the announcement. Complete the horizontal and vertical analysis (green cells). Consider your horizontal/vertical analysis of the statement of financial position, which of the statements are correct? Please select all that apply. The primary item with the highest percentage in total assets (for each year from 2017 to 2020 ) is capital assets Cash (not restricted) in 2020 decreased significantly compared to 2019 which implied the negative impact of COVID-19 Accounts payable and accruals in 2020 increased by 381 percent in 2020 over 2017 Total assets in 2020 decreased compared to 2019 due to write down of capital assets \begin{tabular}{|l|r|r|r|r|} \hline & 2020 & 2019 & 2018 & 2017 \\ \hline Revenue & & & \\ \hline Donations and sponsorships & 1,802,006 & 1,985,392 & 1,666,188 & 1,733,753 \\ \hline Grant revenue & 1,441,329 & 1,270,086 & 1,290,952 & 1,250,782 \\ \hline Ticket sales & 673,181 & 1,007,163 & 1,041,176 & 1,106,468 \\ \hline Special events & 594,698 & 614,591 & 744,886 & 563,758 \\ \hline Set rentals and other & 27,231 & 44,965 & 93,577 & 92,841 \\ \hline Fund development & 4,538,445 & 4,966,605 & 4,836,779 & 4,747,602 \\ \hline & & & & \\ \hline Expenses & 2,512,482 & 2,789,780 & 2,655,035 & 2,297,852 \\ \hline Production costs & 676,062 & 765,508 & 713,517 & 743,598 \\ \hline Special events and development & 524,896 & 657,862 & 490,053 & 580,872 \\ \hline General and administrative & 347,343 & 325,410 & 450,954 & 403,546 \\ \hline Promotion and advertising & (151,349) & & & \\ \hline Government wage subsidy & 3,909,434 & 4,538,560 & 4,309,559 & 4,025,868 \\ \hline & 629,011 & 428,045 & 527,220 & 721,734 \\ \hline Excess of revenue over expenses before amortization & 361,644 & 397,123 & 379,616 & 447,989 \\ \hline Amortization expense & 202,453 & & 55,128 & 166,170 \\ \hline Writedown of capital assets & 64,914 & 30,922 & 92,476 & 107,575 \\ \hline Excess of revenue over expenses before other items & & & & \\ \hline Other income (expenses) & 10,000 & & & \\ \hline CEBA loan forgiveness & (1,567) & (882) & (863) & (363) \\ \hline Forelgn exchange loss & 8,433 & (882) & (863) & (363) \\ \hline & 73,347 & 30,040 & 91,613 & 107,212 \\ \hline Excess of revenues over expenses & 4 \\ \hline \end{tabular} Use the Edmonton Opera Excel Template posted in the announcement. Complete the horizontal and vertical analysis (green cells). Consider your vertical analysis of the statement of operations in 2018 or 2017 , which of the statement(s) are correct? Please select all that apply. In 2018, the largest source of revenue is donations and sponsorship In 2018, "set rentals and other" represented a small percentage of total revenue In 2017, almost half of the expenses are from production costs In 2017, revenue from "special events" is higher than expenses in "special events and development". This means that the company is gaining money by hosting special events