Exercise (1): The following data are some of the Comparative Statement of Profit or Loss of...

 

Transcribed Image Text:

Exercise (1): The following data are some of the Comparative Statement of Profit or Loss of Salem Computin financial periods between 2015 and 2018, as Student Name Student ID ABCDEG s shown in figure (5-2 EXI Salem Company of Comparative Year Ended December For Sales 9000 2015 2016 2017 2013 13000 25000 41000 61000 41300 2015 2016 2017 2018 277 272 ??? 2015 2016 222 222 ??? 222 222 222 17200 28175 222 ??? ??? -4000 fing Expenses Papfit Loss 2000 800 efore Tax 1200 7900 3850 12825 19700 222 ??? ??? ??? ??? ??? 6410 9920 ??? ??? ??? 222 322 mm 1400 1800 3200 2450 4610 6720 ??? 899 222 222 322 222 ??? ??? 222 222 737 (Figure 5-20) Required: 1. Create a new worksheet "Chapter5 EXI", and enter the p data in it. 2. Insert necessary equations in the related cells to conduct analysis for the items of the Comparative Statement of Loss for the years (2015, 2016, 2017, and 2018). 3. Insert necessary equations in the related cells to horizontal analysis for the items of the Comparative of Profit or Loss for the years (2015, 2016, 2017, and 2 the grounds that the year 2015 is the base year. Stal Exercise (2): The following data are the Comparative S of Profit or Loss of Petra Company for the financial periods b 2016 and 2018, as shown in figure (5-21): Exercise (1): The following data are some of the Comparative Statement of Profit or Loss of Salem Computin financial periods between 2015 and 2018, as Student Name Student ID ABCDEG s shown in figure (5-2 EXI Salem Company of Comparative Year Ended December For Sales 9000 2015 2016 2017 2013 13000 25000 41000 61000 41300 2015 2016 2017 2018 277 272 ??? 2015 2016 222 222 ??? 222 222 222 17200 28175 222 ??? ??? -4000 fing Expenses Papfit Loss 2000 800 efore Tax 1200 7900 3850 12825 19700 222 ??? ??? ??? ??? ??? 6410 9920 ??? ??? ??? 222 322 mm 1400 1800 3200 2450 4610 6720 ??? 899 222 222 322 222 ??? ??? 222 222 737 (Figure 5-20) Required: 1. Create a new worksheet "Chapter5 EXI", and enter the p data in it. 2. Insert necessary equations in the related cells to conduct analysis for the items of the Comparative Statement of Loss for the years (2015, 2016, 2017, and 2018). 3. Insert necessary equations in the related cells to horizontal analysis for the items of the Comparative of Profit or Loss for the years (2015, 2016, 2017, and 2 the grounds that the year 2015 is the base year. Stal Exercise (2): The following data are the Comparative S of Profit or Loss of Petra Company for the financial periods b 2016 and 2018, as shown in figure (5-21):

Answer rating: 100% (QA)

To transcribe the given image text accurately we need to extract the data from the Comparative State... View the full answer