how did they calculate quick ratio and cash in 2nd/3rd pic.

and please show formulas for last 2 pics.

ROE Decomposition and Analysis Firm Net Profit Pretax Profit EBIT Sales Debt Assets Equity McDonald's 2017 5,192 4,687 4,529 2016 8,573.5 6,866.0 6,555.7 9,552.7 7,744.5 7,145.5 22,820.4 24,621.9 25,413,0 37,071.7 33,228.2 30,850.8 33,804 31,024 37,939 3,268 -2,204 7,088 2015 Wendy's 2017 194.03 129.62 161.14 101.02 201.69 234.13 214.76 314.78 274.47 1,223,41 1,435.42 1,870.3 2016 2015 3,523.7 3,411.6 3,355.8 4,096.9 3,939.3 4,108.7 5732 527.7 752.9 YUM Brands 2017 2,274 2,274 11,645 1,340 1.643 1,283 1,345 1,345 5,878 6,356 6,418 11,068 5,311 5,453 8,061 2016 2015 -6,334 5,615 911 1,253 1,253 7,150 CMG Brands 2757 2757 1764 691 1264 2017 D Focus 1 ROE ROE Net Prelle Pretax Prof. BIT/Sales Sale Assets Tunover Assets/Equity Equity Multiplier Compound Net Profiles Profit Marin Det McDonald's 2017 2016 2015 -1.59 2.13 0.64 0.61 0.68 0.69 0.9 0.89 0.92 0.42 0.31 0.28 0.60 0.79 0.67 -10.14 -14.00 5.35 -9.20 -12.48 491 0.19 Wendy's 2017 2016 2015 034 0.25 0.21 1.921 0.64 0.69 0.47 0.54 0.85 0.18 0.22 0.15 03 0.36 0.46 7.15 7.47 5.46 3.36 4.78 4.66 0.36 0.00 0.00 YUM Brands 2017 2016 2015! -0.21 -0.25 1.41 0.59 1.22 1.02 1.00 1.00 1.00 0.39 0.21 0.20 1.11 1.17 0.80 0.84 -0.97 8.85 0.84 0.97 RRS 0.26 0.30 CMG Brands 2017 2016 2015 0.13 0.02 0.22 0.64 0.59 1.00 1.00 1.00 0.06 0.01 0.17 2.19 1.93 1.65 1.50 144 1.50 144 1.28 0.04 0.01 0.11 0.62 Weight Debt to Equity (Debt/ Cash Current Ratio (CA/d Quick Ratid ROA (NI/Assits) -11.34384945 - 15.07631579) 4.352539503 0.85 0.35 2.6 1.84 1.4 3.27 1.82 1.38 3.23 0.15 0.15 0.12 6.15 6.46 4.46 1.17 1.44 1.63 1.78) 1.97 2.29 1.77 1.95 2.28 0.05 0.03 0.04 1.14 0.66 0.13 -1.838490685 -1.971148709 7.848518112 1.66 1.15 0.55 1.65 1.12 0.53 0.25 0.30 0.16 0.499267077 0.444634581 0.280545113 1.57 1.48 2.37 1.94 1.85 2.91 1.88 1.8 2.86 0.09 0.01 0.17 Firm Net Profit/P Pretax Profit/EBIT/Sales ROE ROE Sales/Assets Tunover Assets/Equity Equity Multiplier Compound Net Profit Prof Man Industry 2017 2016 2015 0.06 -0.01 0.46 0.62 0.66 0.71 0.16 0.11 0.13 0.90 0.86 0.73 1.95 1.99 3.90 1.01 131 3.70 0.11 0.09 0.10 Current Ratio (CN Weight Debt to Equity (Debt/Cash Assets Assets/Equity Equity Multiplier Compound Net Profit/ Sales Profit Margin 1.01 131 3.70 0.11 0.09 0.10 1.20 1.23 3.15 0.97 0.90 103 1.35 1.24 1.44 1.33 1.22 142 0.10 0.00 0.09 ROE Decomposition and Analysis Firm Net Profit Pretax Profit EBIT Sales Debt Assets Equity McDonald's 2017 5,192 4,687 4,529 2016 8,573.5 6,866.0 6,555.7 9,552.7 7,744.5 7,145.5 22,820.4 24,621.9 25,413,0 37,071.7 33,228.2 30,850.8 33,804 31,024 37,939 3,268 -2,204 7,088 2015 Wendy's 2017 194.03 129.62 161.14 101.02 201.69 234.13 214.76 314.78 274.47 1,223,41 1,435.42 1,870.3 2016 2015 3,523.7 3,411.6 3,355.8 4,096.9 3,939.3 4,108.7 5732 527.7 752.9 YUM Brands 2017 2,274 2,274 11,645 1,340 1.643 1,283 1,345 1,345 5,878 6,356 6,418 11,068 5,311 5,453 8,061 2016 2015 -6,334 5,615 911 1,253 1,253 7,150 CMG Brands 2757 2757 1764 691 1264 2017 D Focus 1 ROE ROE Net Prelle Pretax Prof. BIT/Sales Sale Assets Tunover Assets/Equity Equity Multiplier Compound Net Profiles Profit Marin Det McDonald's 2017 2016 2015 -1.59 2.13 0.64 0.61 0.68 0.69 0.9 0.89 0.92 0.42 0.31 0.28 0.60 0.79 0.67 -10.14 -14.00 5.35 -9.20 -12.48 491 0.19 Wendy's 2017 2016 2015 034 0.25 0.21 1.921 0.64 0.69 0.47 0.54 0.85 0.18 0.22 0.15 03 0.36 0.46 7.15 7.47 5.46 3.36 4.78 4.66 0.36 0.00 0.00 YUM Brands 2017 2016 2015! -0.21 -0.25 1.41 0.59 1.22 1.02 1.00 1.00 1.00 0.39 0.21 0.20 1.11 1.17 0.80 0.84 -0.97 8.85 0.84 0.97 RRS 0.26 0.30 CMG Brands 2017 2016 2015 0.13 0.02 0.22 0.64 0.59 1.00 1.00 1.00 0.06 0.01 0.17 2.19 1.93 1.65 1.50 144 1.50 144 1.28 0.04 0.01 0.11 0.62 Weight Debt to Equity (Debt/ Cash Current Ratio (CA/d Quick Ratid ROA (NI/Assits) -11.34384945 - 15.07631579) 4.352539503 0.85 0.35 2.6 1.84 1.4 3.27 1.82 1.38 3.23 0.15 0.15 0.12 6.15 6.46 4.46 1.17 1.44 1.63 1.78) 1.97 2.29 1.77 1.95 2.28 0.05 0.03 0.04 1.14 0.66 0.13 -1.838490685 -1.971148709 7.848518112 1.66 1.15 0.55 1.65 1.12 0.53 0.25 0.30 0.16 0.499267077 0.444634581 0.280545113 1.57 1.48 2.37 1.94 1.85 2.91 1.88 1.8 2.86 0.09 0.01 0.17 Firm Net Profit/P Pretax Profit/EBIT/Sales ROE ROE Sales/Assets Tunover Assets/Equity Equity Multiplier Compound Net Profit Prof Man Industry 2017 2016 2015 0.06 -0.01 0.46 0.62 0.66 0.71 0.16 0.11 0.13 0.90 0.86 0.73 1.95 1.99 3.90 1.01 131 3.70 0.11 0.09 0.10 Current Ratio (CN Weight Debt to Equity (Debt/Cash Assets Assets/Equity Equity Multiplier Compound Net Profit/ Sales Profit Margin 1.01 131 3.70 0.11 0.09 0.10 1.20 1.23 3.15 0.97 0.90 103 1.35 1.24 1.44 1.33 1.22 142 0.10 0.00 0.09