Financial Analysis Rogers and RBC (Use the two most recent annual financial statements)

Open High Low Close 57.74 57.81 58.9 59.86 56.99 57.97 58.89 57.35 57.11 64.07 61.15 63.43 66,06 66.34 65.59 Rogers(Open and Low) Open Low 64.36 64.15 64.56 64.54 80 63.82 63.61 61.52 61.35 62.02 65.44 64.53 65.73 60 64.67 65.92 68.92 69.4 71.11 66.36 69.11 67.7 70.42 69.4 40 70.8 71.27 67,61 67.23 67 20 Rogers Currency in CAD Date May 29, 2020 Apr 30, 2020 Mar. 31, 2020 Feb. 28, 2020 Jan. 31, 2020 Dec. 31, 2019 Nov. 29, 2019 Oct 31, 2019 Sep 30, 2019 Aug. 30, 2019 Jul. 31, 2019 Jun. 28, 2019 May 31, 2019 Apr 30, 2019 Mar. 29, 2019 Feb. 28, 2019 Jan. 31, 2019 Dec 31, 2018 Nov. 30, 2018 Oct. 31, 2018 Sep. 28, 2018 Aug 31, 2018 Jul. 31, 2018 Jun. 29, 2018 May 31, 2018 Apr 30, 2018 Mar. 29, 2018 Feb. 28, 2018 Jan. 31, 2018 Dec. 29, 2017 Nov. 30, 2017 Oct. 31, 2017 Sep. 29, 2017 Aug. 31, 2017 Jul. 31, 2017 Jun 30, 2017 72.12 72.76 69,99 72.4 73.59 71.43 70.7 71.18 68,26 71.68 72.7 69.82 69.63 70.21 67.08 65.89 Adj Close** Volume 57.7 57.21 1,596,502 58.3 57.81 1,200,439 58.74 58.25 1,741,669 61.51 60.51 7,634,716 66.26 65.19 767,694 64.48 63.44 413,311 64.42 62.88 1,131,300 62.01 60,53 1,050,243 64.53 62.99 1,119,070 65.91 63.84 1,282,223 68.51 66.36 884,458 70.1 67.9 905,164 71.11 68.4 685,955 67.45 64.88 1,230,217 71.87 69.13 1,254,526 72.71 69.45 1,035,771 71.08 67.89 1,507,145 69.96 66.82 442,076 70.87 67.23 1,216,365 67.79 64.31 1,106,089 66.43 63.02 1,110,738 67.62 63.7 1,014,660 66.32 62.47 793,569 62.44 58.82 574,654 60.85 56.87 1,195,037 60.61 56.65 856,060 57.54 53.78 1,085,628 57.82 53.6 1,737,412 60.03 55.65 1,383,009 64.05 59.38 485,517 66.96 61.62 1,521.150 66.94 61.61 919,037 64.34 59.21 554,783 65.19 59.54 1,033,503 64.83 59.22 989,174 61.25 55.951 1,090,095 0 July 1, 2017 January 1, 2018 70.08 70.43 July 1, 2018 January 1, 2019 July 1, 2019 January 1, 2020 Date 68 67.26 67.32 68,42 68.15 65.77 62.54 67.19 65.52 66.32 62.55 62.11 60.21 61.11 61.11 60.84 61 60.54 57.21 57.4 58.88 59.92 64.12 57.64 58.99 60.12 64.31 67,67 57.77 59.57 63.52 66,68 67.54 67.97 66.94 67.83 64.26 65.3 64.64 65.41 64.96 64.01 64.4 64.47 64.49 61.9 61.9 60.54 RBC Open High Low Adj Close** Close 88.99 RBC(Open and Low) 90.36 91.12 89.33 89.33 86.92 87.35 85.52 85.63 85.63 84.27 87.77 87.17 125 83.87 98,54 86.05 98.53 100 101.01 105.4 105 99.82 104.58 102.75 103.23 104.4 102.46 100 103 103.01 100.43 108.55 108.85 108.35 108.73 106.28 75 106.22 106.8 105.72 106.24 103.84 107.4 107.47 107.4 99.4 108.06 100.11 50 99.35 103.46 104.02 96.38 100.87 104 104.39 104.17 25 99.75 103.62 101.43 97,37 99.58 104.22 104.07 101.58 106.77 100.82 102.85 103.7 101.75 106.27 102 102.9 0 102.13 106,93 102.04 106.15 100.82 102.34 95.72 July 1, 2017 January 1, 2018 July 1, 2018 January 1, 2019 July 1, 2019 January 1, 2020 Date 102.56 99.66 100.02 Currency in CAD Date May 29, 2020 Apr 30, 2020 Mar. 31, 2020 Feb. 28, 2020 Jan. 31, 2020 Dec. 31, 2019 Nov. 29, 2019 Oct 31, 2019 Sep 30, 2019 Aug. 30, 2019 Jul. 31, 2019 Jun. 28, 2019 May 31, 2019 Apr 30, 2019 Mar. 29, 2019 Feb. 28, 2019 Jan. 31, 2019 Dec 31, 2018 Nov. 30, 2018 Oct. 31, 2018 Sep. 28, 2018 Aug. 31, 2018 Jul. 31, 2018 Jun. 29, 2018 May 31, 2018 Apr 30, 2018 Mar 29, 2018 Feb. 28, 2018 Jan. 31, 2018 Dec 29, 2017 Nov. 30, 2017 Oct. 31, 2017 Sep. 29, 2017 Aug. 31, 2017 Jul 31, 2017 Jun 30, 2017 May 31, 2017 103.28 100.27 93.95 97.87 97.65 94.96 87,85 91.59 93.09 93.44 99.75 93.57 97.65 96.11 104.58 104.75 101.09 Volume 4,124,200.00 3,816,100.00 5,492,400.00 7,776,500.00 2,763,300.00 1,419,400.00 1,020,300.00 2,285,900.00 2,554,900.00 2,028,100.00 2,687,500.00 3,094,100.00 2,037,700.00 3,045,100.00 2,685,600.00 2,508,000.00 3,032,400.00 2,420,500.00 3,550,200.00 2,967,700.00 2,427,900.00 2,364,100.00 2,480,300.00 2,162,500.00 3,701,300.00 1,893,400.00 2,365,000.00 2,672,600.00 2,403,600.00 1,560,600.00 3.871.000.00 2,080,100.00 2,349,900.00 3,314,300.00 1,546,200.00 2,750,100.00 7,454,200.00 96,78 96.89 95.87 103.42 90.18 104.61 104.77 101.59 97.42 95.92 103.54 103.66 101.55 98.99 103.66 100,96 96.37 96.49 94.52 91.29 90.38 99 99.4 96,89 98.05 98,81 90.04 98.15 99.21 98.76 96.25 97.62 98.58 101.09 104.79 98 97.64 99.52 101.09 105.32 103 105.36 99.68 103.25 105.76 102.67 101.95 101.24 102.15 100.85 102.65 100.85 102.65 101.43 101.05 96.13 92.8 90.9 92.33 96.2 92.16 90.55 90.57 85.91 82.47 82.76 100.79 100.87 96.54 96.1 96.98 93.2 92.19 92.68 92.52 93.45 92.52 93.01 94.16 94.81 93.58 83.02 94.98 94.05 93.97 92.74 93.37 82.32 i. Horizontal Analysis Prepare horizontal analysis (2018, 2019) Using key financial statement figures. ii. Vertical Analysis Prepare component percentages (2019): Using key financial statement figures. iii. Ratio Analysis Prepare a chart with the two years' data for the following ratios, calculations and answers: Liquidity Ratios: Working Capital Current Ratio Inventory turnover Days Sales In Inventory Receivables Turnover Collection Period Solvency Ratios: Debts to Total Assets Equity to Total Assets Profitability Ratios: Payout Ratio Gross Profit Margin Profit Margin Return on Assets Return on Equity Earnings Per Share Price Earnings Ratio The chart of ratios MUST look like this: * Acronyms are acceptable Ratio 2018 Calculation 2019 Calcuation Answer Answer Liquidity Working Capital $146,000 = $139,000 444,000 305,000 = CA - CL = 325,000 - 179,000 = CA/CL Current Ratio Open High Low Close 57.74 57.81 58.9 59.86 56.99 57.97 58.89 57.35 57.11 64.07 61.15 63.43 66,06 66.34 65.59 Rogers(Open and Low) Open Low 64.36 64.15 64.56 64.54 80 63.82 63.61 61.52 61.35 62.02 65.44 64.53 65.73 60 64.67 65.92 68.92 69.4 71.11 66.36 69.11 67.7 70.42 69.4 40 70.8 71.27 67,61 67.23 67 20 Rogers Currency in CAD Date May 29, 2020 Apr 30, 2020 Mar. 31, 2020 Feb. 28, 2020 Jan. 31, 2020 Dec. 31, 2019 Nov. 29, 2019 Oct 31, 2019 Sep 30, 2019 Aug. 30, 2019 Jul. 31, 2019 Jun. 28, 2019 May 31, 2019 Apr 30, 2019 Mar. 29, 2019 Feb. 28, 2019 Jan. 31, 2019 Dec 31, 2018 Nov. 30, 2018 Oct. 31, 2018 Sep. 28, 2018 Aug 31, 2018 Jul. 31, 2018 Jun. 29, 2018 May 31, 2018 Apr 30, 2018 Mar. 29, 2018 Feb. 28, 2018 Jan. 31, 2018 Dec. 29, 2017 Nov. 30, 2017 Oct. 31, 2017 Sep. 29, 2017 Aug. 31, 2017 Jul. 31, 2017 Jun 30, 2017 72.12 72.76 69,99 72.4 73.59 71.43 70.7 71.18 68,26 71.68 72.7 69.82 69.63 70.21 67.08 65.89 Adj Close** Volume 57.7 57.21 1,596,502 58.3 57.81 1,200,439 58.74 58.25 1,741,669 61.51 60.51 7,634,716 66.26 65.19 767,694 64.48 63.44 413,311 64.42 62.88 1,131,300 62.01 60,53 1,050,243 64.53 62.99 1,119,070 65.91 63.84 1,282,223 68.51 66.36 884,458 70.1 67.9 905,164 71.11 68.4 685,955 67.45 64.88 1,230,217 71.87 69.13 1,254,526 72.71 69.45 1,035,771 71.08 67.89 1,507,145 69.96 66.82 442,076 70.87 67.23 1,216,365 67.79 64.31 1,106,089 66.43 63.02 1,110,738 67.62 63.7 1,014,660 66.32 62.47 793,569 62.44 58.82 574,654 60.85 56.87 1,195,037 60.61 56.65 856,060 57.54 53.78 1,085,628 57.82 53.6 1,737,412 60.03 55.65 1,383,009 64.05 59.38 485,517 66.96 61.62 1,521.150 66.94 61.61 919,037 64.34 59.21 554,783 65.19 59.54 1,033,503 64.83 59.22 989,174 61.25 55.951 1,090,095 0 July 1, 2017 January 1, 2018 70.08 70.43 July 1, 2018 January 1, 2019 July 1, 2019 January 1, 2020 Date 68 67.26 67.32 68,42 68.15 65.77 62.54 67.19 65.52 66.32 62.55 62.11 60.21 61.11 61.11 60.84 61 60.54 57.21 57.4 58.88 59.92 64.12 57.64 58.99 60.12 64.31 67,67 57.77 59.57 63.52 66,68 67.54 67.97 66.94 67.83 64.26 65.3 64.64 65.41 64.96 64.01 64.4 64.47 64.49 61.9 61.9 60.54 RBC Open High Low Adj Close** Close 88.99 RBC(Open and Low) 90.36 91.12 89.33 89.33 86.92 87.35 85.52 85.63 85.63 84.27 87.77 87.17 125 83.87 98,54 86.05 98.53 100 101.01 105.4 105 99.82 104.58 102.75 103.23 104.4 102.46 100 103 103.01 100.43 108.55 108.85 108.35 108.73 106.28 75 106.22 106.8 105.72 106.24 103.84 107.4 107.47 107.4 99.4 108.06 100.11 50 99.35 103.46 104.02 96.38 100.87 104 104.39 104.17 25 99.75 103.62 101.43 97,37 99.58 104.22 104.07 101.58 106.77 100.82 102.85 103.7 101.75 106.27 102 102.9 0 102.13 106,93 102.04 106.15 100.82 102.34 95.72 July 1, 2017 January 1, 2018 July 1, 2018 January 1, 2019 July 1, 2019 January 1, 2020 Date 102.56 99.66 100.02 Currency in CAD Date May 29, 2020 Apr 30, 2020 Mar. 31, 2020 Feb. 28, 2020 Jan. 31, 2020 Dec. 31, 2019 Nov. 29, 2019 Oct 31, 2019 Sep 30, 2019 Aug. 30, 2019 Jul. 31, 2019 Jun. 28, 2019 May 31, 2019 Apr 30, 2019 Mar. 29, 2019 Feb. 28, 2019 Jan. 31, 2019 Dec 31, 2018 Nov. 30, 2018 Oct. 31, 2018 Sep. 28, 2018 Aug. 31, 2018 Jul. 31, 2018 Jun. 29, 2018 May 31, 2018 Apr 30, 2018 Mar 29, 2018 Feb. 28, 2018 Jan. 31, 2018 Dec 29, 2017 Nov. 30, 2017 Oct. 31, 2017 Sep. 29, 2017 Aug. 31, 2017 Jul 31, 2017 Jun 30, 2017 May 31, 2017 103.28 100.27 93.95 97.87 97.65 94.96 87,85 91.59 93.09 93.44 99.75 93.57 97.65 96.11 104.58 104.75 101.09 Volume 4,124,200.00 3,816,100.00 5,492,400.00 7,776,500.00 2,763,300.00 1,419,400.00 1,020,300.00 2,285,900.00 2,554,900.00 2,028,100.00 2,687,500.00 3,094,100.00 2,037,700.00 3,045,100.00 2,685,600.00 2,508,000.00 3,032,400.00 2,420,500.00 3,550,200.00 2,967,700.00 2,427,900.00 2,364,100.00 2,480,300.00 2,162,500.00 3,701,300.00 1,893,400.00 2,365,000.00 2,672,600.00 2,403,600.00 1,560,600.00 3.871.000.00 2,080,100.00 2,349,900.00 3,314,300.00 1,546,200.00 2,750,100.00 7,454,200.00 96,78 96.89 95.87 103.42 90.18 104.61 104.77 101.59 97.42 95.92 103.54 103.66 101.55 98.99 103.66 100,96 96.37 96.49 94.52 91.29 90.38 99 99.4 96,89 98.05 98,81 90.04 98.15 99.21 98.76 96.25 97.62 98.58 101.09 104.79 98 97.64 99.52 101.09 105.32 103 105.36 99.68 103.25 105.76 102.67 101.95 101.24 102.15 100.85 102.65 100.85 102.65 101.43 101.05 96.13 92.8 90.9 92.33 96.2 92.16 90.55 90.57 85.91 82.47 82.76 100.79 100.87 96.54 96.1 96.98 93.2 92.19 92.68 92.52 93.45 92.52 93.01 94.16 94.81 93.58 83.02 94.98 94.05 93.97 92.74 93.37 82.32 i. Horizontal Analysis Prepare horizontal analysis (2018, 2019) Using key financial statement figures. ii. Vertical Analysis Prepare component percentages (2019): Using key financial statement figures. iii. Ratio Analysis Prepare a chart with the two years' data for the following ratios, calculations and answers: Liquidity Ratios: Working Capital Current Ratio Inventory turnover Days Sales In Inventory Receivables Turnover Collection Period Solvency Ratios: Debts to Total Assets Equity to Total Assets Profitability Ratios: Payout Ratio Gross Profit Margin Profit Margin Return on Assets Return on Equity Earnings Per Share Price Earnings Ratio The chart of ratios MUST look like this: * Acronyms are acceptable Ratio 2018 Calculation 2019 Calcuation Answer Answer Liquidity Working Capital $146,000 = $139,000 444,000 305,000 = CA - CL = 325,000 - 179,000 = CA/CL Current Ratio