Q.) Calculate the accounts receivable turnover ratio for Genuine Parts Company (see the attached link to the 10k) for the year ended Dec. 31, 2020, and compare it with the industry averages. Below are the industry averages from the Standard & Poor's NetAdvantage data base. Show your calculations.

Genuine Parts Company and Subsidiaries Consolidated Balance Sheets (In Thousands, Except Share Data and per Share Amounts) As of December 31, 2020 2019 990,166 $ 1,556,966 3,506,271 1,060,360 Assets Current assets: Cash and cash equivalents Trade accounts receivable, net Merchandise inventories, net Prepaid expenses and other current assets Current assets of discontinued operations Total current assets Goodwill Other intangible assets, net Deferred tax assets Operating lease assets Other assets Property, plant and equipment, net Noncurrent assets of discontinued operations Total assets 7,113,763 1,917,477 1,498,257 65,658 1,038,877 644,140 1,162,043 276,992 2,440,252 3,443,876 1,063,245 714.251 7,938,616 2,293,519 1,492,097 45,921 995,667 457,350 1,173,688 248,771 14,645,629 13,440,215 $ 4,128,084 $ 160,531 1,491,426 114,043 Liabilities and equity Current liabilities: Trade accounts payable Current portion of debt Other current liabilities Dividends payable Current liabilities of discontinued operations Total current liabilities Long-term debt Operating lease liabilities Pension and other post-retirement benefit liabilities Deferred tax liabilities Other long-term liabilities Noncurrent liabilities of discontinued operations Equity: Preferred stock, par value $1 per share authorized 10,000,000 shares; none issued Common stock, par value $1 per share - authorized 450,000,000 shares; issued and outstanding - 2020 - 144,354,335 shares and 2019 - 145,378,158 shares Additional paid-in capital Accumulated other comprehensive loss Retained earnings Total parent equity Noncontrolling interests in subsidiaries Total equity Total liabilities and equity 5,894.084 2,516,614 789,294 265,687 212,910 543,623 3,948,000 624,043 1,493,109 110,851 218,117 6,394,120 2,802,056 756,519 249,832 233,044 445,652 68,906 145,378 98,777 144,354 117,165 (1,036,502) 3,979,779 3,204,796 13,207 3,218,003 13,440,215 $ (1,141,308) 4,571,860 3,674,707 20,793 3,695,500 14,645,629 See accompanying notes. 1.9x % 292 F 315 320 320 F 143 F 138 F 247 F 279 F B B C D E F G H J 6 Distributors > Key Stats & RatiosKey Stats & Ratios Latest As of November-27-2021 7 Trading Multiples CY2017 Count CY2018 Count CY2019 Count CY2020 Count Latest Count 8 TEV/Total Revenue 0.8x 253 0.7x 264 0.6x 268 0.8x 269 0.8x 288 9 TEVEBITDA 11.5x 176 10.5x 183 8.4x 181 10 TEVEBIT 10.7x 181 10.3x 197 14.1x 173 13.4x 182 11.9x 180 16.2x 171 15.0x 193 11 PE 17.0x 177 18.4x 192 15.2x 189 21.3x 12 P/BV 167 19.0x 200 1.9x 192 1.8x 204 1.5x 203 1.8x 208 2.0 277 13 P/Tang BV 184 1.8x 196 1.5x 195 2.1x 14 Profitability 201 2.3x 271 15 Return on Assets % 3.5% 229 3.5% 244 F 3.6% 246 F 16 Return on Capital % 3.1% 241 F 3.6% 339 5.0% 230 4.9% 245 5.0% 249 4.4% 243 5.2% 343 17 Return on Equity % 10.0% 231 9.0% 246 92% 250 F 6.7% 18 Margin Analysis 244 9.5% % 344 19 Gross Margin% F 11.4% 305 12.2% 320 11.4% 323 F 11.8% 316 F 20 SG&A Margin % 12.7% 336 9.8% 304 F 10.1% 318 F 10.0% 322 F 9.2% 312 9.5% 21 EBITDA Margin% 335 2.5% 270 3.2% 279 2.4% 2.7% 286 F 3.2% 22 EBITA Margin% 301 F 1.7% 304 F 2.3% 319 1.6% 322 F 1.8% 315 F 2.2% 335 23 EBIT Margin % 1.7% 304 F 2.3% 319 F 1.6% 322 F 1.8% 2.2% 335 24 Earnings from Cont. Ops Margin % 1.4% 305 F 1.6% 320 F 1.0% 323 F 1.0% 316 F 1.3% % 336 25 Net Income Margin % F 1.1% 305 F 1.1% % 320 F 1.0% 323 0.8% 316 F 1.1% 336 26 Net Income Avail. for Common Margin % F 1.1% 305 F 1.1% 0.9% 323 F 0.7% % 316 F 1.1% % 336 27 Normalized Net Income Margin % 0.8% 305 0.8% 0.6% 323 28 0.6% 316 0.9% 336 Levered Free Cash Flow Margin % (0.1%) 178 F (3.7%) 185 F (1.5%) 187 F 2.8% % 29 188 F (2.5%) 277 Unlevered Free Cash Flow Margin % 0.5% 178 F (3.1%) 185 (0.8%) 187 3.6% 188 (1.8%) 277 30 Asset Turnover 31 Total Asset Turnover 1.2x 226 1.3x 235 1.2x 235 1.2x 235 1.2x 32 Fixed Asset Turnover 310 9.3x 218 9.0x 231 6.9x 232 6.9% 232 7.4x 33 Accounts Receivable Turnover 297 8.9x 217 8.5x 229 8.3x 230 8.4x 226 34 Inventory Turnover 7.9x 295 5.5x 207 5.8x 223 5.8x 220 6.0x 35 Short Term Liquidity 220 6.1x 277 36 Current Ratio 1.2x 230 1.2x 245 1.2x 247 1.2x 242 1.2x 37 Avg Days Inventory Outstanding 340 64.2 179 64.9 196 62.5 201 61.2 201 38 Quick Ratio 59.2 253 1.4x 231 1.5x 246 1.5x 250 1.5x 244 1.5x 344 39 Avg Days Payable Outstanding 51.4 171 49.6 186 51.6 191 55 192 51.2 238 40 Avg Days Sales Outstanding 41.8 188 41.7 205 442 209 44.1 209 47.6 41 Avg Cash Conversion Cycle 272 63.3 170 652 185 62.3 189 61.6 191 57.1 233 42 Cash from Operations to Current Liabilities 0.1x 195 NM 207 0.0x 205 43 Long Term Solvency 0.2x 202 0.0x 317 44 Total DebtEquity 63.4% 231 F 75.7% 246 F 81.1% 45 Total DebtCapital 250 F 78.5% 244 F 86.6% 344 38.8% 231 43.1% 246 F 44.8% 250 F 44.0% 244 46.4% 46 LT DebvEquity 344 20.2% 124 18.6% 138 F 21.2% 133 47 LT Debt Capital 22.1% 19.6% 178 11.8% 124 F 10.1% 10.7% 133 F 12.0% 143 48 Total Liabilities/Total Assets 10.1% 178 59.2% 230 61.0% 245 F 62.4% 49 EBIT/Interest Expenses 61.7% 242 63.0% 340 1.9x 245 2.0x 270 1.4x 290 1.5x 280 50 EBITDA/InterestExp. 2.0x 306 2.7x 229 3.5x 243 2.5x 51 (EBITDA-CAPEX) / Interest Exp. 263 2.2x 261 2.8x 282 9.3x 229 8.0x 243 8.2x 263 8.7x 261 52 Total DebVEBITDA 10.9x 282 5.0x 218 4.2x 226 5 4x 229 5,8x 232 5.7 x 53 Net DebVEBITDA 298 3.3x 218 3.0x 226 3.5x 229 3.5x 54 Growth Over Prior Year 232 4.1x 298 55 Total Revenue, 1 Yr Growth % F 11.8% 262 5.7% 2.8% 287 F (3.4%) 294 8.6% 308 56 Gross Profit, 1 Yr Growth % 12.8% 266 10.8% 283 4.0% 293 F 57 EBITDA, 1 Yr Growth % (5.4%) 298 F 7.7% 317 F 154% 229 F 3.5% 11.8% 258 F (7.3%) 276 F 11.6% 289 58 EBITA, 1 Yr Growth % F 15.5% 272 1.2% 9.7% 311 F (9.8%) 320 15.4% 59 EBIT, 1 Yr Growth % 343 F 15.0% 272 F 0.1% 10.4% 311 (10.0%) ( 320 16.6% 60 Earnings from Cont. Ops., 1 Yr Growth % 343 F 17.9% 273 (10.5%) 292 F 6.3% 312 (20.5%) 321 45.2% 344 61 Net Income, 1 Yr Growth % F 16.6% 273 F 7.9% (12.5%) 312 F (20.4%) 321 F 78.3% 344 62 Normalized Net Income, 1 Yr Growth % F 16.6% 273 F (7.5%) 6.5% 4.4% 63 Accounts Receivable, 1 Yr Growth % 321 37.5% 344 F 15.8% 181 F 6.8% 4.4% 205 F (5.0%) 208 F 4.5% 279 64 Inventory, 1 Yr Growth % F 16.5% 172 F 3.8% 1.3% 198 F (5.7%) 202 72% 255 65 NetPP&E, 1 Yr Growth % F 17.2% 183 F 9.7% 32.8% 207 (2.5%) 212 1.3% 285 66 Common Equity, 1 Yr Growth % F 14.7% 195 1.1% 6.0% 220 9.4% 67 Total Assets, 1 Yr Growth % 7.8% 315 F 18.7% 194 F 0.7% 8.3% 217 2.4% 222 5.5% 310 68 Tangible Book Value, 1 Yr Growth % F 6.7% (2.8%) 9.7% 220 14.8% 224 F 10.6% 315 69 Cash from Operations, 1 Yr Growth % F (28.0%) 159 46.3% 175 4.0% 186 42.1% 187 F 20.6% 70 Capital Expenditures, 1 Yr Growth % 277 NM 137 NM 151 NM 161 NM 163 NM 212 71 Levered Free Cash Flow, 1 Yr Growth % F (80.6%) 154 NM 166 F 67.2% % 174 F 97.5% 180 F (10.4%) 258 72 Unlevered Free Cash Flow, 1 Yr Growth % (69.9%) 154 F 223.4% 166 54.7% 174 F 81.4% 180 (10.7%) 73 Compound Annual Growth Rate Over Two Years 258 74 Total Revenue, 2 Yr CAGR % 5.9% 240 F 255 F 4.3% 261 F (0.3%) 75 Gross Profit, 2 Y CAGR % 271 F 2.6% 290 F 8.4% 244 F 12.1% 259 7.4% 267 (0.8%) 277 2.4% 76 EBITDA, 2 Yr CAGR % 297 11.1% 205 F 9.5% 220 8.0% 238 F 1.8% 245 5.9% 265 77 EBITA, 2 Yr CAGR % F 12.1% 250 F 8.4% 268 F 5.9% 282 (0.6%) 78 EBIT, 2 Y CAGR % 292 F 6.3% 321 F 11.4% 250 F 7.5% 268 F 5.6% 282 F (0.4%) 292 F 7.3% 321 79 Earnings from Cont. Ops., 2 Y CAGR % 14.7% 4.7% 269 (1.7%) 283 (8.4%) 293 F 9.7% 80 Net Income, 2 Y CAGR % 322 F 1.5% 251 F 1.4% 269 (3.2%) 283 F (17.1%) 293 15.4% 81 Normalized Net Income, 2 Y CAGR % 322 6.6% 3.9% 269 (0.7%) 283 F 5.3% 293 F 16.6% 322 82 Accounts Receivable, 2 Y CAGR % F 10.9% 163 F 10.0% 182 5.9% 192 (0.4%) 196 F 83 Inventory, 2 Y CAGR % (2.3%) 262 F 8.2% 156 F 9.8% 174 F 2.9% 180 F (2.5%) 191 F (0.4%) 237 84 NetPP&E, 2 Y CAGR % 10.6% 165 13.6% 181 F 21.1% 1917 13.9% 198 F 0.3% 269 85 Common Equity, 2 Yr CAGR % F 10.6% 175 F 6.9% 194 F 3.5% 200 7.7% 6.6% 294 86 Total Assets, 2 Yr CAGR % 13.2% 175 9.9% 193 4.6% 198 5.3% 207 F 3.3% 291 87 Tangible Book Value, 2 Yr CAGR % F 3.9% 175 F 0.5% 194 3.0% 200 12.1% 209 88 Cash from Operations, 2 Y CAGR % 10.0% 294 (20.3%) 142 F 1.5% % 157 23.8% 166 21.4% 175 24.7% 242 89 Capital Expenditures, 2 Y CAGR % NM 122 NM 135 NM 147 NM 151 NM 90 Levered Free Cash Flow, 2 Yr Growth % 188 F (55.9%) 135 F (26.7%) 150 NM 157 89.7% % 165 41.7% 213 91 Unlevered Free Cash Flow, 2 Yr Growth % F (47.5%) 135 F (19.4%) 150 153.5% 157 F 74.2% 165 34.7% 92 Compound Annual Growth Rate Over Three Years 213 93 Total Revenue, 3 Yr CAGR % F 1.6% 228 F 5.7% 230 F 6.8% 236 1.5% 250 F 94 Gross Profit, 3 Yr CAGR % 2.7% 270 F 42% 232 F 9.2% 9.5% 242 2.7% 256 3.2% 278 95 EBITDA, 3 Yr CAGR % F 1.8% 195 10.6% 211 2.4% 232 5.6% 243 96 EBITA, 3 Yr CAGR % F 1.6% 238 F 8.2% 242 9.1% 258 F 0.2% % 268 F 5.1% 299 97 EBIT, 3 Yr CAGR % F 1.0% 238 F 7.3% 8.8% 258 (0.1%) 268 5.4% 299 98 Earnings from Cont. Ops., 3 Yr CAGR % F 1.1% 239 F 7.1% 4.8% 259 F (9.3%) 269 F 3.6% 300 99 Net Income, 3 Yr CAGR % F 1.4% 239 (2.6%) 3.6% 259 (10.2%) 269 F (0.3%) 300 100 Normalized Net Income, 3 Yr CAGR % F 2.4% 239 F 1.7% 3.9% 259 1.0% % 269 F 10.4% 300 101 Accounts Receivable, 3 Yr CAGR % F 5.4% 8.3% 159 8.4% 172 F 1.6% 185 0.3% 230 102 Inventory, 3 Yr CAGR % F 2.4% 152 6.5% 7.5% 161 F (1.9%) 177 F 0.7% 206 103 NetPP&E, 3 Yr CAGR % F 3.3% 155 F 10.3% 20.2% 170 F 12.4% 186 F 104 Common Equity, 3 Y CAGR % 12.2% 236 F 8.3% 165 F 6.5% 6.8% 183 F 5.2% % 193 F 5.0% 261 105 Total Assets, 3 Yr CAGR % F 7.7% 165 F 9.1% 169 9.7% 181 3.5% 4.5% 259 106 Tangible Book Value, 3 Yr CAGR % F 4.7% 165 F 0.5% 3.5% 183 6.6% 193 F 7.7% 261 107 Cash from Operations, 3 Yr CAGR % F 12.3% 134 (3.6%) 140 5.1% 151 F 32.1% 160 20.2% 200 108 Capital Expenditures, 3 Yr CAGR % NM 118 NM 122 NM 132 NM 142 NM 171 109 Levered Free Cash Flow, 3 Yr Growth % 93.0% 130 (25.1%) 6.1% 144 F 230.1% 152 NA NA 110 Unlevered Free Cash Flow, 3 Yr Growth % 44.2% (20.0%) 134 8.4% 1111 144 F 130.9% 152 138.8% 176 112 Note: Aggregate Financials are calculated by Capital Q based upon the currentconstituents of the Watch List Banks are notincluded in Watch Listcalculations for any financials using TEV, EBIT, EBITDA and EBITA. 245 F 291 291 312 F 292 F 292 F 200 1917 1997 210 F 209 210 F 224 F 195 8.8% 251 F 251 F 209 8.3% 234 F 196 F 242 F 243 F 243 F 243 F 159 154 F 160 F 170 F 192 F 170 F 134 130 F