please explain in excel with formula
How do we solve Piotroski-score ??
2018 2019 2020 9.45% 16718 17233 54353 11195 11220 25243 24718 42401 9993 Balance sheet analysis (accounts receivable, inventories, PP&E, liabilities, stockholders equity, etc) in Millions 2016 2017 ASSETS Cash and cash equivalents 15905 6.68% 18492 7.17% Marketable securities 22922 9.63% 20435 7.93% Financial Services finance receivables, net 46266 19.44 52210 20.25% Trade and other receivables, less allowances 11102 4.679 10599 4.11% Inventories 8898 3.74% 10277 3.9996 Assets held for sale O 0.00% 0 0.00% Other assets 3368 3889 1.51% Total current assets 108461 45.58% 115902 44.96% Financial Services finance receivables, net 49924 20.98% 56182 21.79% Net investment in operating leases 28829 12.12% 28235 10.95% Net property 32072 13.48% 35327 13.70% Equity in net assets of affiliated companies 304 1.399 30RS 1.2017 Deferred income taxes 9705 4.08 10973 4.26% Other assets 5656 2.38% 8104 3.14% Total long term assets 129490 54.42% 141906 55,04% Total assets 217951 100% 257808 100% 3930 1146-49 55544 29119 36178 2709 10412 7929 141891 2565-40 6.5294 6.72% 21.1996 4 16% 4.37% 0.00% 1.53% 44.69% 21.6596 11.35% 14.10% 1.06% 4,06% 3.09% 55.31% 100% 17504 17147 53651 9237 10786 2383 3339 114047 53703 29230 36469 2519 11863 10706 144490 258537 6.77 6.63% 20.75% 3.57 4.17 0.92% 1.29% 44.11% 20,779 11.31% 14.11% 0.97% 4.59% 4.14% 55.89% 100% 10808 47 3534 116744 55277 27951 370N 4901 12423 12882 150517 267261 9.25% 15.87% 3.74% 4.0494 0.029 1.32% 43.68% 20.68% 10.46% 13.18% 1.83% 4.65% 4.82% 56.32% 100% 21296 19116 2685 40984 D 21520 20556 2314 51179 0 0 LIABILITIES Payables Other liabilities and deferred revenue Automotive debt payable within one year Financial Services debt payable within one year Other debt payable within one year Liabilities held for sale Total current liabilities Other liabilities and deferred revenue Automotive long-term debt Financial Services long-term debt Other long-term debt Deferred income taxes Total long term liabilities Total liabilities Redeemable non controlling interest 0 90 2NI 24395 13222 N0079 8.95% 8.1294 1.13% 19.75% 0.00% 0.00% 37.94% 10.25% 5.569 33.65% 0.00% 02094 49.75% 87.69% 0.04% 23282 19697 3356 48265 0 0 94600 24711 12575 90091 599 NIS 128791 223391 ON 9.019 7.6290 1.30% 186 0.00% 0.007% 36,61% 9.56% 4.8796 34.86% 0.2394 0.1999 49.14% N6.45% 0.04 8.1996 8.01% 0.90% 19.9524 0.00% 0.00 37.25% 9.19% 4 119 14,65% 0.2394 95569 23588 11233 88887 000 592 124905 220474 100 20673 22987 1445 52371 130 526 98132 25324 13233 87658 470 400 127175 225.307 0 XX1 8,89% 0.56% 20.26 0.09 0.20% 37.96% 9.80 5. 1291 33.919 0.18 0.19% 49.1991 N7.15% 222041 23645 1194 49969 INO 0 97192 28379 22342 87708 291 SIX 1.1925 216-450 0 8,31% 8.85% 0.45% 18.70 0.07% 0.00% 36.37% 10.62% 8.36% 32.82% 0.1196 0.2014 52.11% NN.47% 0.00 0.21 691 11837 20866 48.69% N5.94% 0.04% 00 40 0.029 1 0.00 8.45% N.21% EQUITY Common Stock Class B Stock Capital in excess of par value of stock Retained earnings Accumulated other comprehensive income/loss) Treasury stock Total equity attributable to Ford Motor Company Equity attributable to noncontrolling interests Total equity 40 1 21630 15634 -70131 -1122 29170 17 29187 21843 21218 -6959 22290 18243 0.00% 9.00 6.57% -2.95% -0.47% 12.26% 0.01% 12.27% 40 1 22000 22668 -7366 -1417 35932 14 35966 0.0290 0.00% 8.58% 8,84% 2.87% -0.55% 14,01% 0,01% 40 1 221651 20320 -7728 -1613 33INS 45 33230 0.02% 0,00 8.57% 7.86 -2.99 -0.62% 12.86% 0,02% 12.85% 0.0190 0.00% 8.34% 6.N3% -3.109 -0.59% 34890 2x 34918 -0.48% 13.50 0.01% 13.51% -1590 30690 121 30811 0.05% 11.53% Total liabilities and equity 237951 100% 258407 100% 2565-40 100% 258537 267261 2020 FORD Income statement analysis (sales, cost of sales, marketing, and R&D expense, Transitory versus persistent line items, EPS, business segment information, etc). in Millions 2016 2017 2018 2019 Revenues Automotive 141.346 93.25% 145,653 92.91941 148.294 92.49% 143,590 92.1194 Financial Services 10.253 6.75% 11113 7.00 12018 7.500 12260 7.86% 1 0.001% 10 0.019 26 0.029 1 41 0.03% Total Revenues 151.NO 10096 156776 100% 160338 100% 155900 100% 115.885 11203 56 91.14% 8,81% 0.049 10096 Other 127144 Costs and Expenses Cost of sales Selling administrative, and other expenses Financial Services interest, operating, and other expenses Total costs and expenses Operating income 126584 12196 8904 147684 4,116 83.399 8,03% 5.879 97.29% 2.719 131332 11527 9104 151963 4881 83.77% 7.35% 5.819 96.93% 3.119 136269 11401 9463 157135 3203 84.999 7.11% 5.907 98.00% 2.000 134693 11161 9472 155326 574 86.409 7.16% 6.08% 99.6.1% 112752 10193 60 131552 -440R 88.6896 8.02% 6.7794 101.4794 -3.4794 0.3794 194 0.6290 Interest expense on Automotive debt Interest expense on Other debt 0.59% 0.04 1131 57 0.729 0,04% 0.73% 0.04% 963 57 1603 46 1.26% 0,04% 37 37 00 2247 1.4094 -0.149 899 -3.859 1356 43% 1780 6796 2189 3060 207 1201 8148 Non-Financial Services other income foss.net Financial Services other income (loss.net Equity in net income of affiliated companies Income before income taxes Provision for Benefit from income taxes Net Income Less: Income (Loss) attributable to noncontrolling interests Net Income attributable to Ford Motor Company 42 0.899 0.299 1.179 4.4896 1.444 3.63% 0,01% 3,03% 1.959 0.13% 0.72941 5.10% 0319 4879 $20 1231 4345 650 3695 18 3671 0.00 2.71% 0.41% 2.00% 0.019 2.29% 32 -610 -724 84 37 47 0.0296 -0.41% -0.46% 0.05% 0.0294 0.03% 4601 0.0196 -0.1N 0.13% -1.00% 0.00 -1.01% -1116 160 -1276 3 -1270 7628 20 7602 11 4596 0039 4.85% 2018 2019 2020 9.45% 16718 17233 54353 11195 11220 25243 24718 42401 9993 Balance sheet analysis (accounts receivable, inventories, PP&E, liabilities, stockholders equity, etc) in Millions 2016 2017 ASSETS Cash and cash equivalents 15905 6.68% 18492 7.17% Marketable securities 22922 9.63% 20435 7.93% Financial Services finance receivables, net 46266 19.44 52210 20.25% Trade and other receivables, less allowances 11102 4.679 10599 4.11% Inventories 8898 3.74% 10277 3.9996 Assets held for sale O 0.00% 0 0.00% Other assets 3368 3889 1.51% Total current assets 108461 45.58% 115902 44.96% Financial Services finance receivables, net 49924 20.98% 56182 21.79% Net investment in operating leases 28829 12.12% 28235 10.95% Net property 32072 13.48% 35327 13.70% Equity in net assets of affiliated companies 304 1.399 30RS 1.2017 Deferred income taxes 9705 4.08 10973 4.26% Other assets 5656 2.38% 8104 3.14% Total long term assets 129490 54.42% 141906 55,04% Total assets 217951 100% 257808 100% 3930 1146-49 55544 29119 36178 2709 10412 7929 141891 2565-40 6.5294 6.72% 21.1996 4 16% 4.37% 0.00% 1.53% 44.69% 21.6596 11.35% 14.10% 1.06% 4,06% 3.09% 55.31% 100% 17504 17147 53651 9237 10786 2383 3339 114047 53703 29230 36469 2519 11863 10706 144490 258537 6.77 6.63% 20.75% 3.57 4.17 0.92% 1.29% 44.11% 20,779 11.31% 14.11% 0.97% 4.59% 4.14% 55.89% 100% 10808 47 3534 116744 55277 27951 370N 4901 12423 12882 150517 267261 9.25% 15.87% 3.74% 4.0494 0.029 1.32% 43.68% 20.68% 10.46% 13.18% 1.83% 4.65% 4.82% 56.32% 100% 21296 19116 2685 40984 D 21520 20556 2314 51179 0 0 LIABILITIES Payables Other liabilities and deferred revenue Automotive debt payable within one year Financial Services debt payable within one year Other debt payable within one year Liabilities held for sale Total current liabilities Other liabilities and deferred revenue Automotive long-term debt Financial Services long-term debt Other long-term debt Deferred income taxes Total long term liabilities Total liabilities Redeemable non controlling interest 0 90 2NI 24395 13222 N0079 8.95% 8.1294 1.13% 19.75% 0.00% 0.00% 37.94% 10.25% 5.569 33.65% 0.00% 02094 49.75% 87.69% 0.04% 23282 19697 3356 48265 0 0 94600 24711 12575 90091 599 NIS 128791 223391 ON 9.019 7.6290 1.30% 186 0.00% 0.007% 36,61% 9.56% 4.8796 34.86% 0.2394 0.1999 49.14% N6.45% 0.04 8.1996 8.01% 0.90% 19.9524 0.00% 0.00 37.25% 9.19% 4 119 14,65% 0.2394 95569 23588 11233 88887 000 592 124905 220474 100 20673 22987 1445 52371 130 526 98132 25324 13233 87658 470 400 127175 225.307 0 XX1 8,89% 0.56% 20.26 0.09 0.20% 37.96% 9.80 5. 1291 33.919 0.18 0.19% 49.1991 N7.15% 222041 23645 1194 49969 INO 0 97192 28379 22342 87708 291 SIX 1.1925 216-450 0 8,31% 8.85% 0.45% 18.70 0.07% 0.00% 36.37% 10.62% 8.36% 32.82% 0.1196 0.2014 52.11% NN.47% 0.00 0.21 691 11837 20866 48.69% N5.94% 0.04% 00 40 0.029 1 0.00 8.45% N.21% EQUITY Common Stock Class B Stock Capital in excess of par value of stock Retained earnings Accumulated other comprehensive income/loss) Treasury stock Total equity attributable to Ford Motor Company Equity attributable to noncontrolling interests Total equity 40 1 21630 15634 -70131 -1122 29170 17 29187 21843 21218 -6959 22290 18243 0.00% 9.00 6.57% -2.95% -0.47% 12.26% 0.01% 12.27% 40 1 22000 22668 -7366 -1417 35932 14 35966 0.0290 0.00% 8.58% 8,84% 2.87% -0.55% 14,01% 0,01% 40 1 221651 20320 -7728 -1613 33INS 45 33230 0.02% 0,00 8.57% 7.86 -2.99 -0.62% 12.86% 0,02% 12.85% 0.0190 0.00% 8.34% 6.N3% -3.109 -0.59% 34890 2x 34918 -0.48% 13.50 0.01% 13.51% -1590 30690 121 30811 0.05% 11.53% Total liabilities and equity 237951 100% 258407 100% 2565-40 100% 258537 267261 2020 FORD Income statement analysis (sales, cost of sales, marketing, and R&D expense, Transitory versus persistent line items, EPS, business segment information, etc). in Millions 2016 2017 2018 2019 Revenues Automotive 141.346 93.25% 145,653 92.91941 148.294 92.49% 143,590 92.1194 Financial Services 10.253 6.75% 11113 7.00 12018 7.500 12260 7.86% 1 0.001% 10 0.019 26 0.029 1 41 0.03% Total Revenues 151.NO 10096 156776 100% 160338 100% 155900 100% 115.885 11203 56 91.14% 8,81% 0.049 10096 Other 127144 Costs and Expenses Cost of sales Selling administrative, and other expenses Financial Services interest, operating, and other expenses Total costs and expenses Operating income 126584 12196 8904 147684 4,116 83.399 8,03% 5.879 97.29% 2.719 131332 11527 9104 151963 4881 83.77% 7.35% 5.819 96.93% 3.119 136269 11401 9463 157135 3203 84.999 7.11% 5.907 98.00% 2.000 134693 11161 9472 155326 574 86.409 7.16% 6.08% 99.6.1% 112752 10193 60 131552 -440R 88.6896 8.02% 6.7794 101.4794 -3.4794 0.3794 194 0.6290 Interest expense on Automotive debt Interest expense on Other debt 0.59% 0.04 1131 57 0.729 0,04% 0.73% 0.04% 963 57 1603 46 1.26% 0,04% 37 37 00 2247 1.4094 -0.149 899 -3.859 1356 43% 1780 6796 2189 3060 207 1201 8148 Non-Financial Services other income foss.net Financial Services other income (loss.net Equity in net income of affiliated companies Income before income taxes Provision for Benefit from income taxes Net Income Less: Income (Loss) attributable to noncontrolling interests Net Income attributable to Ford Motor Company 42 0.899 0.299 1.179 4.4896 1.444 3.63% 0,01% 3,03% 1.959 0.13% 0.72941 5.10% 0319 4879 $20 1231 4345 650 3695 18 3671 0.00 2.71% 0.41% 2.00% 0.019 2.29% 32 -610 -724 84 37 47 0.0296 -0.41% -0.46% 0.05% 0.0294 0.03% 4601 0.0196 -0.1N 0.13% -1.00% 0.00 -1.01% -1116 160 -1276 3 -1270 7628 20 7602 11 4596 0039 4.85%
