Question: Part 2 - Using the financial statement file and the payroll data file perform some analytical tests. You will need to develop some analytical tests

Part 2 - Using the financial statement file and the payroll data file perform some analytical tests. You will need to develop some analytical tests using the Income Statement data using Excel. It can be horizontal and/or vertical analysis, financial ratios, etc. You will need to carry out any analytical tests on the payroll file data, which you deem necessary, using IDEA. Remember that there are tutorial videos about IDEA both in the course and on its website that may be useful to you. Write a 1-2 sentence explanation for each analysis you are performing and print the results along with the history log when you have completed the analysis in IDEA for delivery this week.

Archivo de datos sobre nomina

EMP_ID Fecha de pago de Nmina Tarifa de Pago Deducciones Porcentuales Horas Regulares Horas Extras Salario Bruto Deducciones Salario Neto
117 11/2/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 11/16/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 11/30/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 12/14/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 12/28/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
149 11/2/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 11/16/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 11/30/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 12/14/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 12/28/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
162 11/2/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 11/16/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 11/30/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 12/14/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 12/28/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
179 11/2/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 11/16/2020 12.16 0.0347 80 3 1009.28 35.02 974.26
179 11/30/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 12/14/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 12/28/2020 12.16 0.0347 80 0 972.80 33.76 939.04
182 11/2/2020 16.64 0.1475 80 10 1497.60 220.90 1276.70
182 11/16/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 11/30/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 12/14/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 12/28/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
191 11/2/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 11/16/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 11/30/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 12/14/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 12/28/2020 12.31 0.1653 80 0 984.80 162.79 822.01
212 11/2/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 11/16/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 11/30/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 12/14/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 12/28/2020 12.62 0.1949 0 0 0.00 0.00 0.00
213 11/2/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 11/16/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 11/30/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 12/14/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 12/28/2020 12.2 0.1433 80 0 976.00 139.86 836.14
217 11/2/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/2/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 11/16/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/16/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 11/30/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/30/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 12/14/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 12/14/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 12/28/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 12/28/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
238 11/2/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 11/16/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 11/30/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 12/14/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 12/28/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
247 11/2/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 11/16/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 11/30/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 12/14/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 12/28/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
254 11/2/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 11/16/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 11/30/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 12/14/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 12/28/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
255 11/2/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 11/16/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 11/30/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 12/14/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 12/28/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
269 11/2/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 11/16/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 11/30/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 12/14/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 12/28/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
277 11/2/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 11/16/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 11/30/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 12/14/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 12/28/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
278 11/2/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 11/16/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 11/30/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 12/14/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 12/28/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
319 11/2/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 11/16/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 11/30/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 12/14/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 12/28/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
330 11/2/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 11/16/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 11/30/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 12/14/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 12/28/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
333 11/2/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 11/16/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 11/30/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 12/14/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 12/28/2020 16.44 0.3093 0 0 0.00 0.00 0.00
336 11/2/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 11/16/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 11/30/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 12/14/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 12/28/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
338 11/2/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 11/16/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 11/30/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 12/14/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 12/28/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
341 11/2/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 11/16/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 11/30/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 12/14/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 12/28/2020 12.45 0.3879 80 0 996.00 386.35 609.65
352 11/2/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 11/16/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 11/30/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 12/14/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 12/28/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
353 11/2/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 11/16/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 11/30/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 12/14/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 12/28/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
357 11/2/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 11/16/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 11/30/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 12/14/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 12/28/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
368 11/2/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 11/16/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 11/30/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 12/14/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 12/28/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
373 11/2/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 11/16/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 11/30/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 12/14/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 12/28/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
377 11/2/2020 24.56 0.2163 80 25 2578.80 557.79 2021.01
377 11/16/2020 24.56 0.2163 80 30 2701.60 584.36 2117.24
377 11/30/2020 24.56 0.2163 80 35 2824.40 610.92 2213.48
377 12/14/2020 24.56 0.2163 80 20 2456.00 531.23 1924.77
377 12/28/2020 24.56 0.2163 80 25 2578.80 557.79 2021.01
378 11/2/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 11/16/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 11/30/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 12/14/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 12/28/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
381 11/2/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 11/16/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 11/30/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 12/14/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 12/28/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
382 11/2/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 11/16/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 11/30/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 12/14/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 12/28/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
384 11/2/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 11/16/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 11/30/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 12/14/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 12/28/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
388 11/2/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 11/16/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 11/30/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 12/14/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 12/28/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
396 11/2/2020 14.85 0.3117 80 0 1188.00 370.30 817.70
396 11/16/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 11/30/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 12/14/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 12/28/2020 14.85 0.3117 0 0 0.00 0.00 0.00
407 11/2/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 11/2/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 11/16/2020 21.38 0.1565 80 2 1753.16 274.37 1478.79
407 11/16/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 11/30/2020 21.38 0.1565 80 6 1838.68 287.75 1550.93
407 11/30/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 12/14/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 12/14/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 12/28/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 12/28/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
425 11/2/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 11/16/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 11/30/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 12/14/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 12/28/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
429 11/2/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 11/16/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 11/30/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 12/14/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 12/28/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
431 11/2/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 11/16/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 11/30/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 12/14/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 12/28/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
441 11/2/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 11/16/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 11/30/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 12/14/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 12/28/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
459 11/2/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/16/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/30/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/30/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 12/14/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 12/28/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
463 11/2/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 11/16/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 11/30/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 12/14/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 12/28/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
476 11/2/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 11/16/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 11/30/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 12/14/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 12/28/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
482 11/2/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
482 11/16/2020 15.56 0.2334 80 7 1353.72 315.96 1037.76
482 11/30/2020 15.56 0.2334 80 7 1353.72 315.96 1037.76
482 12/14/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
482 12/28/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
491 11/2/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 11/16/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 11/30/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 12/14/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 12/28/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
492 11/2/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 11/16/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 11/30/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 12/14/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 12/28/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
510 11/2/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 11/16/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 11/30/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 12/14/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 12/28/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
520 11/2/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 11/16/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 11/30/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 12/14/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 12/28/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
522 11/2/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 11/16/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 11/30/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 12/14/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 12/28/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
525 11/2/2020 14.34 0.3292 80 0 1147.20 377.66 769.54
525 11/16/2020 14.34 0.3292 80 3 1190.22 391.82 798.40
525 11/30/2020 14.34 0.3292 80 8 1261.92 415.42 846.50
525 12/14/2020 14.34 0.3292 80 8 1261.92 415.42 846.50
525 12/28/2020 14.34 0.3292 80 0 1147.20 377.66 769.54
531 11/2/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 11/16/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 11/30/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 12/14/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 12/28/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
549 11/2/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 11/16/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 11/30/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 12/14/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 12/28/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
565 11/2/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 11/16/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 11/30/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 12/14/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 12/28/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
575 11/2/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 11/16/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 11/30/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 12/14/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 12/28/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
576 11/2/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 11/16/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 11/30/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 12/14/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 12/28/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
579 11/2/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 11/16/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 11/30/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 12/14/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 12/28/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
590 11/2/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 11/16/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 11/30/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 12/14/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 12/28/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
599 11/2/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 11/16/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 11/30/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 12/14/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 12/28/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
608 11/2/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 11/16/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 11/30/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 12/14/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 12/28/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
613 11/2/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 11/16/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 11/30/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 12/14/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 12/28/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
618 11/2/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 11/16/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 11/30/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 12/14/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 12/28/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
644 11/2/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 11/16/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 11/30/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 12/14/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 12/28/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
650 11/2/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 11/16/2020 21.95 0.1147 80 6 1887.70 216.52 1671.18
650 11/30/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 12/14/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 12/28/2020 21.95 0.1147 80 6 1887.70 216.52 1671.18
656 11/2/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 11/16/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 11/30/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 12/14/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 12/28/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
664 11/2/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 11/16/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 11/30/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 12/14/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 12/28/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
668 11/2/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 11/16/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 11/30/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 12/14/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 12/28/2020 17.91 0 80 0 1432.80 0.00 1432.80
674 11/2/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 11/16/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 11/30/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 12/14/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 12/28/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
682 11/2/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/2/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 11/16/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/16/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 11/30/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/30/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 12/14/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 12/14/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 12/28/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 12/28/2020 16.1 0.295 80 0 1288.00 379.96 908.04
695 11/2/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/2/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/16/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/30/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 12/14/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 12/28/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
710 11/2/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 11/16/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 11/30/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 12/14/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 12/28/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
712 11/2/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 11/16/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 11/30/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 12/14/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 12/28/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
715 11/2/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 11/16/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 11/30/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 12/14/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 12/28/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
719 11/2/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 11/16/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 11/30/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 12/14/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 12/28/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
748 11/2/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 11/16/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 11/30/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 12/14/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 12/28/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
763 11/2/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 11/16/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 11/30/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 12/14/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 12/28/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
768 11/2/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 11/16/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 11/30/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 12/14/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 12/28/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
778 11/2/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 11/16/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 11/30/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 12/14/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 12/28/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
781 11/2/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 11/16/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 11/30/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 12/14/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 12/28/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
804 11/2/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 11/16/2020 18.73 0.3908 80 6 1610.78 629.49 981.29
804 11/30/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 12/14/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 12/28/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
814 11/2/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 11/16/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 11/30/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 12/14/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 12/28/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
825 11/2/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 11/16/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 11/30/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 12/14/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 12/28/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
829 11/2/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 11/16/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 11/30/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 12/14/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 12/28/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
830 11/2/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 11/16/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 11/30/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 12/14/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 12/28/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
834 11/2/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 11/16/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 11/30/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 12/14/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 12/28/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
845 11/2/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 11/16/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 11/30/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 12/14/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 12/28/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
867 11/2/2020 13.52 0.1006 80 0 1081.60 108.81 972.79
867 11/16/2020 13.52 0.1006 80 0 1081.60 108.81 972.79
867 11/30/2020 13.52 0.1006 80 0<

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Using the financial statements file and the payroll data file perform some analytical tests. You will need to develop some analytical tests using the Income Statement data using Excel. It can be...

Q:

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Q:

Australian International Training Academy Pty Ltd t/a My Business College (MBC) ABN: 76 141 358 045 CRICOS Provider Code: 03694G National Provider Code: 45368 Level 4,225 Clarence Street, Sydney, NSW...

Q:

Adam Kleen Enterprise (AKE) was initially set up as a convenient shop selling laundry related items by Adam Bollan. Despite having good results in the national-level examination and was even offered...

Q:

In Alomar Company, employees are entitled to 1 days vacation for each month worked. In January, 50 employees worked the full month. Record the vacation pay liability for January assuming the average...

Q:

Calculate the flow spread in a 2 m wide asphalt gutter for a flow of 0.08 m3/s. The gutter is at 2% longitudinal and 4% cross slopes, respectively.

Q:

We say that is a p-percentile of the distribution F if F( ) = p. Show that if is a p-percentile of the IFRA distribution F, then F(x) e x , x F(x) e x , x

Q:

Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelley Couts, who inherited the company. When it was founded over 70 years...

Q:

a . Determine the fair value in excess of book value for Persoff's acquisition date investment in Sea Cliff. b . Determine Persoff's Equity earnings in Sea Cliff's balance for the year ended December...

Q:

Given the following graph, which of the following statement is correct? CML M E(RM) E(R) ft B D E(R) E(R) A A M M A M SML Securities A, B, C and D should all sell for the same price because they all...

Q:

Yolanda, a single taxpayer, has W-2 Income of $87,500. She also has a short-term capital loss of $7,000, a short-term capltal galn of $1,000, and a long-term capltal gain of $2,000. What Is Yolanda's...

Q:

What is the speedup of the basic pipeline (with branch predictions) shown in the Introduc- tion slides (Tsequential / Tpipelined) if 1/5 of all instructions are conditional branches and 4/5 of them...

Q:

3.You borrow $10,000 from Friendly Finance for four years with quarterly payments keyed to a 10% interest rate.$1,000 interest each year plus $10,000 equals $14,000.Spread over 4 years this loan...

Q:

reword Chaukhats should be seasoned teak wood. Shutters should be teaked wood 4.3cm thick penelled and partly glazed as required with additional wire gauge shutters. Allfitting should be brass. Doors...

Q:

A town has a water treatment plant with capacity to handle 253 gigalitres per year. The current demand for water per year is 210 gigalitres. However, this seems to fluctuate over time with an annual...

Q:

Determine miller indices of plane X z 2/3 90% a/3

Q:

Ayayai Company had the following Shareholders' Equity section as of February 1, 2021: Share capital: $961,000 6,040,000 Preferred shares, 31,000 issued and outstanding Class A common shares,...

Q:

What services are provided by the provincial and territorial governments?

Q:

Understand how "cause and effect" is established by experimentation

Q:

Learn the basic tools of psychological research

Q:

Why do we need scientific methods?