{
"cells": [
{
"attachments": {},
"cell_type": "markdown",
"id": "55822295",
"metadata": {},
"source": [
"![Finance Toolkit](https://github.com/JerBouma/FinanceToolkit/assets/46355364/198d47bd-e1b3-492d-acc4-5d9f02d1d009)\n",
"\n",
"**The FinanceToolkit** is an open-source toolkit in which all relevant financial ratios (100+), indicators and performance measurements are written down in the most simplistic way allowing for complete transparency of the calculation method. This allows you to not have to rely on metrics from other providers and, given a financial statement, allow for efficient manual calculations. This leads to one uniform method of calculation being applied that is available and understood by everyone."
]
},
{
"cell_type": "markdown",
"id": "2937a8f2",
"metadata": {},
"source": [
"# Installation\n",
"To install the FinanceToolkit it simply requires the following:\n",
"\n",
"```\n",
"pip install financetoolkit -U\n",
"```\n",
"\n",
"From within Python use:\n",
"\n",
"```python\n",
"from financetoolkit import Toolkit\n",
"```\n",
" \n",
"To be able to get started, you need to obtain an API Key from FinancialModelingPrep. This is used to gain access to 30+ years of financial statement both annually and quarterly. Note that the Free plan is limited to 250 requests each day, 5 years of data and only features companies listed on US exchanges.\n",
"\n",
"___ \n",
"\n",
"
Obtain an API Key from FinancialModelingPrep here.
\n",
"___\n",
"\n",
"Through the link you are able to subscribe for the free plan and also premium plans at a **15% discount**. This is an affiliate link and thus supports the project at the same time. I have chosen FinancialModelingPrep as a source as I find it to be the most transparent, reliable and at an affordable price. When you notice that data is inaccurate or have any other issue related to the data, note that I simply provide the means to access this data and I am not responsible for the accuracy of the data itself. For this, use their contact form or provide the data yourself. \n",
"\n",
"The current Notebook is revolved around the Ratios class. If you are interested in the other modules, you can find the related Notebooks below. **Please view the documentation here to find all the available functionality.**\n",
"\n",
"\n",
"\n",
"
"
]
},
{
"cell_type": "code",
"execution_count": 1,
"id": "11269a00",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"\n",
"from financetoolkit import Toolkit\n",
"\n",
"API_KEY = \"FINANCIAL_MODELING_PREP_API_KEY\""
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "a3f7fc24",
"metadata": {},
"source": [
"**Initializing only is required once.** This is the case for any function so once you have obtained a balance sheet statement, it will be stored accordingly which means that requests to FinancialModelingPrep, the source used in these examples, are kept to a minimum. Note that in this example annual data is used but by adding `quarterly=True` to the Toolkit initialization, quarterly data can also be collected. Note that this requires a Premium subscription from FMP."
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "b3507cb1",
"metadata": {},
"outputs": [],
"source": [
"# Initialize the Toolkit with company tickers\n",
"companies = Toolkit(\n",
" [\"AAPL\", \"AMZN\", \"META\", \"WMT\"], api_key=API_KEY, start_date=\"2005-01-01\"\n",
")"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "af12299f",
"metadata": {},
"source": [
"After initialization of `Toolkit`, you can get access to the Ratios module which includes over 50 different ratios. This can be done by calling the `ratios` property. Please view the documentation here to find all the available ratios. \n",
"\n",
"Within this ratios module, the distinction is made between `collect_` and `get_`. The former obtains a collection of ratios (e.g. all solvency ratios) whereas the latter obtains a specific ratio. You will note that it will collect data first, this is done only once so that the ratios can be calculated efficiently. For example, let's start with getting all ratios."
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "3c79b76d",
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"Obtaining financial statements: 100%|██████████| 3/3 [00:04<00:00, 1.35s/it]\n",
"Obtaining historical data: 100%|██████████| 5/5 [00:00<00:00, 9.30it/s]\n"
]
},
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
\n",
"
2005
\n",
"
2006
\n",
"
2007
\n",
"
2008
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
2018
\n",
"
2019
\n",
"
2020
\n",
"
2021
\n",
"
2022
\n",
"
2023
\n",
"
\n",
" \n",
" \n",
"
\n",
"
AAPL
\n",
"
Days of Inventory Outstanding (DIO)
\n",
"
NaN
\n",
"
5.7875
\n",
"
7.0918
\n",
"
7.314
\n",
"
7.5193
\n",
"
6.9509
\n",
"
5.175
\n",
"
3.2554
\n",
"
4.3739
\n",
"
6.2997
\n",
"
5.8102
\n",
"
6.2247
\n",
"
9.0404
\n",
"
9.8195
\n",
"
9.0944
\n",
"
8.7903
\n",
"
9.1181
\n",
"
9.4097
\n",
"
9.6109
\n",
"
\n",
"
\n",
"
Days of Sales Outstanding (DSO)
\n",
"
NaN
\n",
"
39.2779
\n",
"
52.258
\n",
"
36.2483
\n",
"
28.8857
\n",
"
37.1715
\n",
"
36.4852
\n",
"
35.4592
\n",
"
42.0003
\n",
"
47.7828
\n",
"
44.9482
\n",
"
50.4763
\n",
"
51.7261
\n",
"
58.1785
\n",
"
66.4971
\n",
"
55.3447
\n",
"
44.3762
\n",
"
52.0377
\n",
"
58.0504
\n",
"
\n",
"
\n",
"
Operating Cycle (CC)
\n",
"
NaN
\n",
"
45.0654
\n",
"
59.3498
\n",
"
43.5623
\n",
"
36.4051
\n",
"
44.1224
\n",
"
41.6601
\n",
"
38.7146
\n",
"
46.3742
\n",
"
54.0824
\n",
"
50.7584
\n",
"
56.7011
\n",
"
60.7665
\n",
"
67.998
\n",
"
75.5915
\n",
"
64.135
\n",
"
53.4943
\n",
"
61.4474
\n",
"
67.6613
\n",
"
\n",
"
\n",
"
Days of Accounts Payable Outstanding (DPO)
\n",
"
NaN
\n",
"
68.7718
\n",
"
96.2465
\n",
"
89.7359
\n",
"
86.7454
\n",
"
81.306
\n",
"
75.4773
\n",
"
74.389
\n",
"
74.54
\n",
"
85.4527
\n",
"
85.572
\n",
"
101.1074
\n",
"
111.718
\n",
"
116.9484
\n",
"
115.2021
\n",
"
95.2889
\n",
"
83.1683
\n",
"
97.0504
\n",
"
108.0033
\n",
"
\n",
"
\n",
"
Cash Conversion Cycle (CCC)
\n",
"
NaN
\n",
"
-23.7064
\n",
"
-36.8967
\n",
"
-46.1736
\n",
"
-50.3404
\n",
"
-37.1836
\n",
"
-33.8172
\n",
"
-35.6744
\n",
"
-28.1658
\n",
"
-31.3703
\n",
"
-34.8136
\n",
"
-44.4063
\n",
"
-50.9515
\n",
"
-48.9504
\n",
"
-39.6106
\n",
"
-31.1539
\n",
"
-29.674
\n",
"
-35.603
\n",
"
-40.3419
\n",
"
\n",
"
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
...
\n",
"
\n",
"
\n",
"
WMT
\n",
"
EV-to-EBIT
\n",
"
9.5833
\n",
"
9.0818
\n",
"
8.9111
\n",
"
9.4147
\n",
"
8.4392
\n",
"
8.1809
\n",
"
8.1931
\n",
"
9.1931
\n",
"
9.8347
\n",
"
10.941
\n",
"
8.0224
\n",
"
10.0524
\n",
"
14.318
\n",
"
17.9074
\n",
"
29.033
\n",
"
20.7407
\n",
"
19.8916
\n",
"
21.6887
\n",
"
25.0026
\n",
"
\n",
"
\n",
"
EV-to-EBITDA
\n",
"
7.5981
\n",
"
7.2093
\n",
"
6.6802
\n",
"
7.2297
\n",
"
6.4941
\n",
"
6.1906
\n",
"
6.4623
\n",
"
6.8813
\n",
"
7.3773
\n",
"
8.1003
\n",
"
5.9216
\n",
"
7.1292
\n",
"
9.684
\n",
"
9.7107
\n",
"
11.8294
\n",
"
13.7822
\n",
"
13.2585
\n",
"
13.1213
\n",
"
16.2302
\n",
"
\n",
"
\n",
"
EV-to-Operating-Cash-Flow
\n",
"
10.8567
\n",
"
9.5046
\n",
"
8.5991
\n",
"
10.0567
\n",
"
8.2868
\n",
"
7.3363
\n",
"
9.0699
\n",
"
9.8412
\n",
"
10.465
\n",
"
12.4487
\n",
"
7.5295
\n",
"
8.7352
\n",
"
10.0875
\n",
"
10.6116
\n",
"
13.9103
\n",
"
18.3919
\n",
"
12.5076
\n",
"
18.318
\n",
"
16.7812
\n",
"
\n",
"
\n",
"
Tangible Asset Value
\n",
"
38593000000.0
\n",
"
40983000000.0
\n",
"
47814000000.0
\n",
"
48537000000.0
\n",
"
50025000000.0
\n",
"
57110000000.0
\n",
"
54892000000.0
\n",
"
55514000000.0
\n",
"
61760000000.0
\n",
"
63320000000.0
\n",
"
67835000000.0
\n",
"
66916000000.0
\n",
"
63498000000.0
\n",
"
62580000000.0
\n",
"
48453000000.0
\n",
"
50479000000.0
\n",
"
58548000000.0
\n",
"
62877000000.0
\n",
"
55817000000.0
\n",
"
\n",
"
\n",
"
Net Current Asset Value
\n",
"
-4397000000.0
\n",
"
-5002000000.0
\n",
"
-5166000000.0
\n",
"
-10869000000.0
\n",
"
-6441000000.0
\n",
"
-7230000000.0
\n",
"
-6591000000.0
\n",
"
-7325000000.0
\n",
"
-11878000000.0
\n",
"
-8160000000.0
\n",
"
-1994000000.0
\n",
"
-4380000000.0
\n",
"
-9239000000.0
\n",
"
-18857000000.0
\n",
"
-15580000000.0
\n",
"
-15984000000.0
\n",
"
-2578000000.0
\n",
"
-6309000000.0
\n",
"
-16543000000.0
\n",
"
\n",
" \n",
"
\n",
"
268 rows × 19 columns
\n",
"
"
],
"text/plain": [
" 2005 2006 \\\n",
"AAPL Days of Inventory Outstanding (DIO) NaN 5.7875 \n",
" Days of Sales Outstanding (DSO) NaN 39.2779 \n",
" Operating Cycle (CC) NaN 45.0654 \n",
" Days of Accounts Payable Outstanding (DPO) NaN 68.7718 \n",
" Cash Conversion Cycle (CCC) NaN -23.7064 \n",
"... ... ... \n",
"WMT EV-to-EBIT 9.5833 9.0818 \n",
" EV-to-EBITDA 7.5981 7.2093 \n",
" EV-to-Operating-Cash-Flow 10.8567 9.5046 \n",
" Tangible Asset Value 38593000000.0 40983000000.0 \n",
" Net Current Asset Value -4397000000.0 -5002000000.0 \n",
"\n",
" 2007 2008 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 7.0918 7.314 \n",
" Days of Sales Outstanding (DSO) 52.258 36.2483 \n",
" Operating Cycle (CC) 59.3498 43.5623 \n",
" Days of Accounts Payable Outstanding (DPO) 96.2465 89.7359 \n",
" Cash Conversion Cycle (CCC) -36.8967 -46.1736 \n",
"... ... ... \n",
"WMT EV-to-EBIT 8.9111 9.4147 \n",
" EV-to-EBITDA 6.6802 7.2297 \n",
" EV-to-Operating-Cash-Flow 8.5991 10.0567 \n",
" Tangible Asset Value 47814000000.0 48537000000.0 \n",
" Net Current Asset Value -5166000000.0 -10869000000.0 \n",
"\n",
" 2009 2010 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 7.5193 6.9509 \n",
" Days of Sales Outstanding (DSO) 28.8857 37.1715 \n",
" Operating Cycle (CC) 36.4051 44.1224 \n",
" Days of Accounts Payable Outstanding (DPO) 86.7454 81.306 \n",
" Cash Conversion Cycle (CCC) -50.3404 -37.1836 \n",
"... ... ... \n",
"WMT EV-to-EBIT 8.4392 8.1809 \n",
" EV-to-EBITDA 6.4941 6.1906 \n",
" EV-to-Operating-Cash-Flow 8.2868 7.3363 \n",
" Tangible Asset Value 50025000000.0 57110000000.0 \n",
" Net Current Asset Value -6441000000.0 -7230000000.0 \n",
"\n",
" 2011 2012 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 5.175 3.2554 \n",
" Days of Sales Outstanding (DSO) 36.4852 35.4592 \n",
" Operating Cycle (CC) 41.6601 38.7146 \n",
" Days of Accounts Payable Outstanding (DPO) 75.4773 74.389 \n",
" Cash Conversion Cycle (CCC) -33.8172 -35.6744 \n",
"... ... ... \n",
"WMT EV-to-EBIT 8.1931 9.1931 \n",
" EV-to-EBITDA 6.4623 6.8813 \n",
" EV-to-Operating-Cash-Flow 9.0699 9.8412 \n",
" Tangible Asset Value 54892000000.0 55514000000.0 \n",
" Net Current Asset Value -6591000000.0 -7325000000.0 \n",
"\n",
" 2013 2014 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 4.3739 6.2997 \n",
" Days of Sales Outstanding (DSO) 42.0003 47.7828 \n",
" Operating Cycle (CC) 46.3742 54.0824 \n",
" Days of Accounts Payable Outstanding (DPO) 74.54 85.4527 \n",
" Cash Conversion Cycle (CCC) -28.1658 -31.3703 \n",
"... ... ... \n",
"WMT EV-to-EBIT 9.8347 10.941 \n",
" EV-to-EBITDA 7.3773 8.1003 \n",
" EV-to-Operating-Cash-Flow 10.465 12.4487 \n",
" Tangible Asset Value 61760000000.0 63320000000.0 \n",
" Net Current Asset Value -11878000000.0 -8160000000.0 \n",
"\n",
" 2015 2016 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 5.8102 6.2247 \n",
" Days of Sales Outstanding (DSO) 44.9482 50.4763 \n",
" Operating Cycle (CC) 50.7584 56.7011 \n",
" Days of Accounts Payable Outstanding (DPO) 85.572 101.1074 \n",
" Cash Conversion Cycle (CCC) -34.8136 -44.4063 \n",
"... ... ... \n",
"WMT EV-to-EBIT 8.0224 10.0524 \n",
" EV-to-EBITDA 5.9216 7.1292 \n",
" EV-to-Operating-Cash-Flow 7.5295 8.7352 \n",
" Tangible Asset Value 67835000000.0 66916000000.0 \n",
" Net Current Asset Value -1994000000.0 -4380000000.0 \n",
"\n",
" 2017 2018 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 9.0404 9.8195 \n",
" Days of Sales Outstanding (DSO) 51.7261 58.1785 \n",
" Operating Cycle (CC) 60.7665 67.998 \n",
" Days of Accounts Payable Outstanding (DPO) 111.718 116.9484 \n",
" Cash Conversion Cycle (CCC) -50.9515 -48.9504 \n",
"... ... ... \n",
"WMT EV-to-EBIT 14.318 17.9074 \n",
" EV-to-EBITDA 9.684 9.7107 \n",
" EV-to-Operating-Cash-Flow 10.0875 10.6116 \n",
" Tangible Asset Value 63498000000.0 62580000000.0 \n",
" Net Current Asset Value -9239000000.0 -18857000000.0 \n",
"\n",
" 2019 2020 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 9.0944 8.7903 \n",
" Days of Sales Outstanding (DSO) 66.4971 55.3447 \n",
" Operating Cycle (CC) 75.5915 64.135 \n",
" Days of Accounts Payable Outstanding (DPO) 115.2021 95.2889 \n",
" Cash Conversion Cycle (CCC) -39.6106 -31.1539 \n",
"... ... ... \n",
"WMT EV-to-EBIT 29.033 20.7407 \n",
" EV-to-EBITDA 11.8294 13.7822 \n",
" EV-to-Operating-Cash-Flow 13.9103 18.3919 \n",
" Tangible Asset Value 48453000000.0 50479000000.0 \n",
" Net Current Asset Value -15580000000.0 -15984000000.0 \n",
"\n",
" 2021 2022 \\\n",
"AAPL Days of Inventory Outstanding (DIO) 9.1181 9.4097 \n",
" Days of Sales Outstanding (DSO) 44.3762 52.0377 \n",
" Operating Cycle (CC) 53.4943 61.4474 \n",
" Days of Accounts Payable Outstanding (DPO) 83.1683 97.0504 \n",
" Cash Conversion Cycle (CCC) -29.674 -35.603 \n",
"... ... ... \n",
"WMT EV-to-EBIT 19.8916 21.6887 \n",
" EV-to-EBITDA 13.2585 13.1213 \n",
" EV-to-Operating-Cash-Flow 12.5076 18.318 \n",
" Tangible Asset Value 58548000000.0 62877000000.0 \n",
" Net Current Asset Value -2578000000.0 -6309000000.0 \n",
"\n",
" 2023 \n",
"AAPL Days of Inventory Outstanding (DIO) 9.6109 \n",
" Days of Sales Outstanding (DSO) 58.0504 \n",
" Operating Cycle (CC) 67.6613 \n",
" Days of Accounts Payable Outstanding (DPO) 108.0033 \n",
" Cash Conversion Cycle (CCC) -40.3419 \n",
"... ... \n",
"WMT EV-to-EBIT 25.0026 \n",
" EV-to-EBITDA 16.2302 \n",
" EV-to-Operating-Cash-Flow 16.7812 \n",
" Tangible Asset Value 55817000000.0 \n",
" Net Current Asset Value -16543000000.0 \n",
"\n",
"[268 rows x 19 columns]"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies.ratios.collect_all_ratios()"
]
},
{
"cell_type": "markdown",
"id": "3fcf7e9a",
"metadata": {},
"source": [
"Given that you might not be interested in all of them, it is possible to also call each and every single one seperately."
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "8b9fa8b4",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
date
\n",
"
2005
\n",
"
2006
\n",
"
2007
\n",
"
2008
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
2018
\n",
"
2019
\n",
"
2020
\n",
"
2021
\n",
"
2022
\n",
"
2023
\n",
"
\n",
" \n",
" \n",
"
\n",
"
AAPL
\n",
"
0.2645
\n",
"
0.2942
\n",
"
0.3019
\n",
"
0.2989
\n",
"
0.2856
\n",
"
0.2442
\n",
"
0.2422
\n",
"
0.2516
\n",
"
0.2615
\n",
"
0.2613
\n",
"
0.2637
\n",
"
0.2556
\n",
"
0.2456
\n",
"
0.1834
\n",
"
0.1594
\n",
"
0.1443
\n",
"
0.133
\n",
"
0.162
\n",
"
0.1472
\n",
"
\n",
"
\n",
"
AMZN
\n",
"
0.222
\n",
"
0.496
\n",
"
0.2788
\n",
"
0.2741
\n",
"
0.2179
\n",
"
0.2351
\n",
"
0.3116
\n",
"
1.1003
\n",
"
0.3701
\n",
"
-2.2568
\n",
"
0.6145
\n",
"
0.3754
\n",
"
0.2023
\n",
"
0.1062
\n",
"
0.17
\n",
"
0.1183
\n",
"
0.1256
\n",
"
-0.5417
\n",
"
NaN
\n",
"
\n",
"
\n",
"
META
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
0.3988
\n",
"
0.41
\n",
"
0.8927
\n",
"
0.4553
\n",
"
0.4012
\n",
"
0.4046
\n",
"
0.1838
\n",
"
0.2263
\n",
"
0.1281
\n",
"
0.255
\n",
"
0.1216
\n",
"
0.1674
\n",
"
0.195
\n",
"
NaN
\n",
"
\n",
"
\n",
"
WMT
\n",
"
0.347
\n",
"
0.3343
\n",
"
0.3356
\n",
"
0.342
\n",
"
0.3419
\n",
"
0.3235
\n",
"
0.322
\n",
"
0.3256
\n",
"
0.3101
\n",
"
0.3287
\n",
"
0.322
\n",
"
0.3031
\n",
"
0.3027
\n",
"
0.3042
\n",
"
0.3736
\n",
"
0.2443
\n",
"
0.3335
\n",
"
0.2544
\n",
"
0.3364
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"date 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 \\\n",
"AAPL 0.2645 0.2942 0.3019 0.2989 0.2856 0.2442 0.2422 0.2516 0.2615 0.2613 \n",
"AMZN 0.222 0.496 0.2788 0.2741 0.2179 0.2351 0.3116 1.1003 0.3701 -2.2568 \n",
"META NaN NaN NaN NaN NaN 0.3988 0.41 0.8927 0.4553 0.4012 \n",
"WMT 0.347 0.3343 0.3356 0.342 0.3419 0.3235 0.322 0.3256 0.3101 0.3287 \n",
"\n",
"date 2015 2016 2017 2018 2019 2020 2021 2022 2023 \n",
"AAPL 0.2637 0.2556 0.2456 0.1834 0.1594 0.1443 0.133 0.162 0.1472 \n",
"AMZN 0.6145 0.3754 0.2023 0.1062 0.17 0.1183 0.1256 -0.5417 NaN \n",
"META 0.4046 0.1838 0.2263 0.1281 0.255 0.1216 0.1674 0.195 NaN \n",
"WMT 0.322 0.3031 0.3027 0.3042 0.3736 0.2443 0.3335 0.2544 0.3364 "
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies.ratios.get_effective_tax_rate()"
]
},
{
"attachments": {},
"cell_type": "markdown",
"id": "3508a5ee",
"metadata": {},
"source": [
"Some of these ratios also include optional fields depending on whether there is room for different methods of calculation. E.g. whether you'd like to have the diluted average shares included in the calculation."
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "70fb0e5d",
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
date
\n",
"
2005
\n",
"
2006
\n",
"
2007
\n",
"
2008
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
2018
\n",
"
2019
\n",
"
2020
\n",
"
2021
\n",
"
2022
\n",
"
2023
\n",
"
\n",
" \n",
" \n",
"
\n",
"
AAPL
\n",
"
Debt-to-Assets Ratio
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
inf
\n",
"
0.8584
\n",
"
0.458
\n",
"
0.219
\n",
"
0.1394
\n",
"
0.0156
\n",
"
0.0198
\n",
"
0.0874
\n",
"
0.0236
\n",
"
-0.0419
\n",
"
-0.0743
\n",
"
\n",
"
\n",
"
Debt-to-Equity Ratio
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
inf
\n",
"
1.3044
\n",
"
0.707
\n",
"
0.2564
\n",
"
0.2717
\n",
"
0.2381
\n",
"
0.1175
\n",
"
0.4412
\n",
"
0.1488
\n",
"
0.1987
\n",
"
-0.2456
\n",
"
\n",
"
\n",
"
Debt Service Coverage Ratio
\n",
"
NaN
\n",
"
-0.1995
\n",
"
0.2506
\n",
"
-0.0607
\n",
"
-0.108
\n",
"
1.2336
\n",
"
0.3617
\n",
"
0.1864
\n",
"
-0.1933
\n",
"
-0.2843
\n",
"
0.0678
\n",
"
-0.1038
\n",
"
-0.2316
\n",
"
-0.003
\n",
"
-0.0033
\n",
"
0.0402
\n",
"
0.3804
\n",
"
-0.1066
\n",
"
0.0141
\n",
"
\n",
"
\n",
"
Equity Multiplier
\n",
"
NaN
\n",
"
2.4795
\n",
"
0.0533
\n",
"
0.0517
\n",
"
0.0474
\n",
"
-0.1076
\n",
"
-0.0976
\n",
"
-0.0251
\n",
"
0.0556
\n",
"
0.178
\n",
"
0.2119
\n",
"
0.093
\n",
"
0.0748
\n",
"
0.1562
\n",
"
0.1598
\n",
"
0.193
\n",
"
0.2362
\n",
"
0.1772
\n",
"
0.0106
\n",
"
\n",
"
\n",
"
Free Cash Flow Yield
\n",
"
NaN
\n",
"
-0.4425
\n",
"
0.2023
\n",
"
3.2654
\n",
"
-0.5744
\n",
"
0.18
\n",
"
0.432
\n",
"
0.0285
\n",
"
0.0051
\n",
"
-0.1531
\n",
"
0.5241
\n",
"
-0.2996
\n",
"
-0.3138
\n",
"
0.4062
\n",
"
-0.4784
\n",
"
-0.2735
\n",
"
-0.0216
\n",
"
0.6782
\n",
"
-0.3816
\n",
"
\n",
"
\n",
"
Net-Debt to EBITDA Ratio
\n",
"
NaN
\n",
"
0.2505
\n",
"
-0.171
\n",
"
-0.1107
\n",
"
-0.6423
\n",
"
-0.0785
\n",
"
-0.5247
\n",
"
-0.3341
\n",
"
-1.2571
\n",
"
6.5191
\n",
"
0.4804
\n",
"
0.7333
\n",
"
0.4649
\n",
"
-0.1884
\n",
"
-0.285
\n",
"
0.243
\n",
"
-0.224
\n",
"
-0.0108
\n",
"
-0.127
\n",
"
\n",
"
\n",
"
Cash Flow Coverage Ratio
\n",
"
NaN
\n",
"
-0.4425
\n",
"
0.2023
\n",
"
3.2654
\n",
"
-0.5744
\n",
"
0.18
\n",
"
0.432
\n",
"
0.0285
\n",
"
0.0051
\n",
"
-0.1531
\n",
"
0.5241
\n",
"
-0.2996
\n",
"
-0.3138
\n",
"
0.4062
\n",
"
-0.4784
\n",
"
-0.2735
\n",
"
-0.0216
\n",
"
0.6782
\n",
"
-0.3816
\n",
"
\n",
"
\n",
"
CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.6534
\n",
"
0.6418
\n",
"
0.4426
\n",
"
0.0465
\n",
"
0.0468
\n",
"
-0.4256
\n",
"
0.0741
\n",
"
0.0932
\n",
"
0.0291
\n",
"
0.1625
\n",
"
-0.3132
\n",
"
0.023
\n",
"
0.1702
\n",
"
0.1368
\n",
"
0.6694
\n",
"
-0.1497
\n",
"
0.2154
\n",
"
-0.1158
\n",
"
\n",
"
\n",
"
Dividend CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.6534
\n",
"
0.6418
\n",
"
0.4426
\n",
"
0.0465
\n",
"
0.0468
\n",
"
-0.4256
\n",
"
-0.1507
\n",
"
-0.3611
\n",
"
0.0437
\n",
"
0.2363
\n",
"
-0.2735
\n",
"
-0.0287
\n",
"
0.1517
\n",
"
-0.0161
\n",
"
0.3378
\n",
"
0.0795
\n",
"
0.1742
\n",
"
-0.1102
\n",
"
\n",
"
\n",
"
AMZN
\n",
"
Debt-to-Assets Ratio
\n",
"
NaN
\n",
"
-0.2943
\n",
"
-0.2865
\n",
"
-0.7283
\n",
"
-0.8597
\n",
"
3.3165
\n",
"
0.6422
\n",
"
1.1
\n",
"
0.0969
\n",
"
0.776
\n",
"
-0.0541
\n",
"
-0.1583
\n",
"
0.5833
\n",
"
-0.153
\n",
"
0.1472
\n",
"
-0.0638
\n",
"
0.0537
\n",
"
0.0939
\n",
"
-15.0499
\n",
"
\n",
"
\n",
"
Debt-to-Equity Ratio
\n",
"
NaN
\n",
"
-0.5245
\n",
"
-0.6181
\n",
"
-0.8441
\n",
"
-0.8818
\n",
"
3.5121
\n",
"
0.9529
\n",
"
1.563
\n",
"
0.1371
\n",
"
1.1872
\n",
"
-0.0886
\n",
"
-0.2555
\n",
"
0.7349
\n",
"
-0.3325
\n",
"
0.1147
\n",
"
-0.1128
\n",
"
-0.0682
\n",
"
0.1396
\n",
"
-5.4343
\n",
"
\n",
"
\n",
"
Debt Service Coverage Ratio
\n",
"
NaN
\n",
"
-0.3143
\n",
"
0.1484
\n",
"
0.0057
\n",
"
-0.1359
\n",
"
-0.1155
\n",
"
-0.573
\n",
"
-0.3851
\n",
"
-0.0899
\n",
"
-0.8056
\n",
"
9.4603
\n",
"
0.4492
\n",
"
-0.2576
\n",
"
1.5614
\n",
"
-0.0881
\n",
"
0.0942
\n",
"
-0.0348
\n",
"
-0.5495
\n",
"
-54.9886
\n",
"
\n",
"
\n",
"
Equity Multiplier
\n",
"
NaN
\n",
"
52.1429
\n",
"
-0.4402
\n",
"
-0.426
\n",
"
-0.2704
\n",
"
-0.0359
\n",
"
0.1205
\n",
"
0.2029
\n",
"
0.1179
\n",
"
0.1399
\n",
"
0.076
\n",
"
-0.0836
\n",
"
0.0028
\n",
"
-0.0971
\n",
"
-0.1097
\n",
"
-0.043
\n",
"
-0.089
\n",
"
-0.0297
\n",
"
-2.3694
\n",
"
\n",
"
\n",
"
Free Cash Flow Yield
\n",
"
NaN
\n",
"
0.0919
\n",
"
0.0404
\n",
"
1.0388
\n",
"
-0.2048
\n",
"
-0.3752
\n",
"
-0.147
\n",
"
-0.8652
\n",
"
2.0556
\n",
"
0.2364
\n",
"
0.6765
\n",
"
0.1754
\n",
"
-0.5821
\n",
"
1.0536
\n",
"
0.013
\n",
"
-0.3305
\n",
"
-1.5513
\n",
"
1.314
\n",
"
212.7839
\n",
"
\n",
"
\n",
"
Net-Debt to EBITDA Ratio
\n",
"
NaN
\n",
"
-0.5509
\n",
"
-4.2153
\n",
"
0.5367
\n",
"
0.0858
\n",
"
-0.2821
\n",
"
0.2472
\n",
"
-0.144
\n",
"
-0.4221
\n",
"
-0.5167
\n",
"
-0.5426
\n",
"
0.5459
\n",
"
-4.3337
\n",
"
-0.7408
\n",
"
1.5779
\n",
"
0.1779
\n",
"
0.5377
\n",
"
0.1776
\n",
"
-3.6725
\n",
"
\n",
"
\n",
"
Cash Flow Coverage Ratio
\n",
"
NaN
\n",
"
0.0919
\n",
"
0.0404
\n",
"
1.0388
\n",
"
-0.2048
\n",
"
-0.3752
\n",
"
-0.147
\n",
"
-0.8652
\n",
"
2.0556
\n",
"
0.2364
\n",
"
0.6765
\n",
"
0.1754
\n",
"
-0.5821
\n",
"
1.0536
\n",
"
0.013
\n",
"
-0.3305
\n",
"
-1.5513
\n",
"
1.314
\n",
"
212.7839
\n",
"
\n",
"
\n",
"
CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-0.5956
\n",
"
-0.3963
\n",
"
-0.4876
\n",
"
0.4394
\n",
"
-0.1204
\n",
"
0.8576
\n",
"
-0.0604
\n",
"
-0.3683
\n",
"
0.484
\n",
"
-0.0017
\n",
"
-0.2795
\n",
"
-0.5389
\n",
"
-0.0319
\n",
"
4.7913
\n",
"
\n",
"
\n",
"
Dividend CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-0.5956
\n",
"
-0.3963
\n",
"
-0.4876
\n",
"
0.4394
\n",
"
-0.1204
\n",
"
0.8576
\n",
"
-0.0604
\n",
"
-0.3683
\n",
"
0.484
\n",
"
-0.0017
\n",
"
-0.2795
\n",
"
-0.5389
\n",
"
-0.0319
\n",
"
4.7913
\n",
"
\n",
"
\n",
"
META
\n",
"
Debt-to-Assets Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-1.0179
\n",
"
-0.3243
\n",
"
0.4593
\n",
"
-0.8295
\n",
"
-0.782
\n",
"
-0.6034
\n",
"
-1.0
\n",
"
NaN
\n",
"
inf
\n",
"
14.1765
\n",
"
-0.1357
\n",
"
0.2496
\n",
"
0.7129
\n",
"
-30.7088
\n",
"
\n",
"
\n",
"
Debt-to-Equity Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-1.0248
\n",
"
-0.3684
\n",
"
0.4501
\n",
"
-0.8463
\n",
"
-0.789
\n",
"
-0.6
\n",
"
-1.0
\n",
"
NaN
\n",
"
inf
\n",
"
16.322
\n",
"
-0.1879
\n",
"
0.3386
\n",
"
0.9037
\n",
"
-21.1149
\n",
"
\n",
"
\n",
"
Debt Service Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-1.3005
\n",
"
-0.2637
\n",
"
-0.7382
\n",
"
3.9846
\n",
"
0.3758
\n",
"
-0.0779
\n",
"
0.3366
\n",
"
0.2431
\n",
"
-0.3392
\n",
"
-0.5512
\n",
"
0.3686
\n",
"
0.0144
\n",
"
-0.5158
\n",
"
-4.9723
\n",
"
\n",
"
\n",
"
Equity Multiplier
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-1.3005
\n",
"
-0.5024
\n",
"
-0.0251
\n",
"
-0.0583
\n",
"
-0.0707
\n",
"
-0.0096
\n",
"
-0.0086
\n",
"
0.0122
\n",
"
0.0252
\n",
"
0.0857
\n",
"
0.0243
\n",
"
0.0068
\n",
"
0.0923
\n",
"
-4.0312
\n",
"
\n",
"
\n",
"
Free Cash Flow Yield
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-inf
\n",
"
NaN
\n",
"
-1.0
\n",
"
3.75
\n",
"
-0.1627
\n",
"
0.1714
\n",
"
0.6878
\n",
"
-0.0318
\n",
"
0.197
\n",
"
-0.1047
\n",
"
-0.1671
\n",
"
0.3612
\n",
"
0.4398
\n",
"
-73.599
\n",
"
\n",
"
\n",
"
Net-Debt to EBITDA Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-0.8731
\n",
"
-0.6416
\n",
"
-0.9412
\n",
"
30.6229
\n",
"
-0.123
\n",
"
-0.1036
\n",
"
0.0274
\n",
"
-0.423
\n",
"
-0.0635
\n",
"
-0.0958
\n",
"
-0.4054
\n",
"
-0.715
\n",
"
-7.3427
\n",
"
-14.4417
\n",
"
\n",
"
\n",
"
Cash Flow Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-inf
\n",
"
NaN
\n",
"
-1.0
\n",
"
3.75
\n",
"
-0.1627
\n",
"
0.1714
\n",
"
0.6878
\n",
"
-0.0318
\n",
"
0.197
\n",
"
-0.1047
\n",
"
-0.1671
\n",
"
0.3612
\n",
"
0.4398
\n",
"
-73.599
\n",
"
\n",
"
\n",
"
CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-0.7302
\n",
"
0.073
\n",
"
-0.4893
\n",
"
1.3749
\n",
"
-0.0386
\n",
"
0.1436
\n",
"
0.0524
\n",
"
0.0028
\n",
"
-0.4151
\n",
"
0.143
\n",
"
0.0661
\n",
"
0.2119
\n",
"
-0.4831
\n",
"
1.6492
\n",
"
\n",
"
\n",
"
Dividend CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
-0.0955
\n",
"
0.9299
\n",
"
-0.1875
\n",
"
0.7324
\n",
"
-0.7302
\n",
"
0.073
\n",
"
-0.4893
\n",
"
1.3749
\n",
"
-0.0386
\n",
"
0.1436
\n",
"
0.0524
\n",
"
0.0028
\n",
"
-0.4151
\n",
"
0.143
\n",
"
0.0661
\n",
"
0.2119
\n",
"
-0.4831
\n",
"
1.6492
\n",
"
\n",
"
\n",
"
WMT
\n",
"
Debt-to-Assets Ratio
\n",
"
NaN
\n",
"
0.0738
\n",
"
-0.0812
\n",
"
0.0585
\n",
"
-0.0545
\n",
"
-0.0627
\n",
"
0.14
\n",
"
0.0007
\n",
"
-0.0351
\n",
"
0.0379
\n",
"
-0.1059
\n",
"
0.0137
\n",
"
-0.0786
\n",
"
-0.016
\n",
"
0.1641
\n",
"
0.1576
\n",
"
-0.1822
\n",
"
-0.0655
\n",
"
0.0337
\n",
"
\n",
"
\n",
"
Debt-to-Equity Ratio
\n",
"
NaN
\n",
"
0.1467
\n",
"
-0.132
\n",
"
0.0911
\n",
"
-0.0647
\n",
"
-0.097
\n",
"
0.2457
\n",
"
0.0298
\n",
"
-0.0535
\n",
"
0.0475
\n",
"
-0.1667
\n",
"
0.0036
\n",
"
-0.0494
\n",
"
0.011
\n",
"
0.2206
\n",
"
0.2189
\n",
"
-0.1864
\n",
"
-0.1367
\n",
"
0.1246
\n",
"
\n",
"
\n",
"
Debt Service Coverage Ratio
\n",
"
NaN
\n",
"
-0.0477
\n",
"
0.0435
\n",
"
-0.0497
\n",
"
0.0938
\n",
"
0.0474
\n",
"
0.013
\n",
"
-0.0238
\n",
"
-0.092
\n",
"
0.001
\n",
"
0.0733
\n",
"
-0.1031
\n",
"
-0.0882
\n",
"
-0.2346
\n",
"
0.0887
\n",
"
-0.067
\n",
"
-0.0794
\n",
"
0.2198
\n",
"
-0.256
\n",
"
\n",
"
\n",
"
Equity Multiplier
\n",
"
NaN
\n",
"
5.3222
\n",
"
0.001
\n",
"
-0.0111
\n",
"
0.0092
\n",
"
-0.0241
\n",
"
0.027
\n",
"
0.0603
\n",
"
0.004
\n",
"
-0.0047
\n",
"
-0.0306
\n",
"
-0.0388
\n",
"
0.0104
\n",
"
0.0298
\n",
"
0.0385
\n",
"
0.0508
\n",
"
0.0227
\n",
"
-0.0415
\n",
"
0.0016
\n",
"
\n",
"
\n",
"
Free Cash Flow Yield
\n",
"
NaN
\n",
"
0.4557
\n",
"
0.4043
\n",
"
0.0248
\n",
"
1.281
\n",
"
0.1921
\n",
"
-0.2767
\n",
"
-0.1137
\n",
"
0.026
\n",
"
-0.2635
\n",
"
1.2294
\n",
"
-0.1574
\n",
"
-0.072
\n",
"
-0.0632
\n",
"
-0.2514
\n",
"
-0.3039
\n",
"
0.752
\n",
"
-0.5631
\n",
"
0.0035
\n",
"
\n",
"
\n",
"
Net-Debt to EBITDA Ratio
\n",
"
NaN
\n",
"
0.1541
\n",
"
-0.1253
\n",
"
0.1328
\n",
"
-0.1434
\n",
"
-0.0921
\n",
"
0.1915
\n",
"
0.0559
\n",
"
-0.0551
\n",
"
0.0815
\n",
"
-0.1777
\n",
"
0.0844
\n",
"
-0.034
\n",
"
0.0786
\n",
"
0.2015
\n",
"
0.212
\n",
"
-0.2843
\n",
"
-0.0571
\n",
"
0.319
\n",
"
\n",
"
\n",
"
Cash Flow Coverage Ratio
\n",
"
NaN
\n",
"
0.4557
\n",
"
0.4043
\n",
"
0.0248
\n",
"
1.281
\n",
"
0.1921
\n",
"
-0.2767
\n",
"
-0.1137
\n",
"
0.026
\n",
"
-0.2635
\n",
"
1.2294
\n",
"
-0.1574
\n",
"
-0.072
\n",
"
-0.0632
\n",
"
-0.2514
\n",
"
-0.3039
\n",
"
0.752
\n",
"
-0.5631
\n",
"
0.0035
\n",
"
\n",
"
\n",
"
CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
0.0377
\n",
"
0.063
\n",
"
0.0587
\n",
"
0.4772
\n",
"
0.0702
\n",
"
-0.1358
\n",
"
-0.0357
\n",
"
0.1052
\n",
"
-0.1062
\n",
"
0.3231
\n",
"
0.0171
\n",
"
0.2442
\n",
"
-0.0505
\n",
"
-0.0483
\n",
"
-0.1207
\n",
"
0.4897
\n",
"
-0.475
\n",
"
-0.0643
\n",
"
\n",
"
\n",
"
Dividend CAPEX Coverage Ratio
\n",
"
NaN
\n",
"
0.0371
\n",
"
0.0572
\n",
"
0.0065
\n",
"
0.3817
\n",
"
0.0541
\n",
"
-0.138
\n",
"
-0.0527
\n",
"
0.0724
\n",
"
-0.1382
\n",
"
0.2881
\n",
"
-0.0094
\n",
"
0.2152
\n",
"
-0.0646
\n",
"
-0.0368
\n",
"
-0.1067
\n",
"
0.4609
\n",
"
-0.4299
\n",
"
0.009
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
"date 2005 2006 2007 2008 2009 \\\n",
"AAPL Debt-to-Assets Ratio NaN NaN NaN NaN NaN \n",
" Debt-to-Equity Ratio NaN NaN NaN NaN NaN \n",
" Debt Service Coverage Ratio NaN -0.1995 0.2506 -0.0607 -0.108 \n",
" Equity Multiplier NaN 2.4795 0.0533 0.0517 0.0474 \n",
" Free Cash Flow Yield NaN -0.4425 0.2023 3.2654 -0.5744 \n",
" Net-Debt to EBITDA Ratio NaN 0.2505 -0.171 -0.1107 -0.6423 \n",
" Cash Flow Coverage Ratio NaN -0.4425 0.2023 3.2654 -0.5744 \n",
" CAPEX Coverage Ratio NaN -0.6534 0.6418 0.4426 0.0465 \n",
" Dividend CAPEX Coverage Ratio NaN -0.6534 0.6418 0.4426 0.0465 \n",
"AMZN Debt-to-Assets Ratio NaN -0.2943 -0.2865 -0.7283 -0.8597 \n",
" Debt-to-Equity Ratio NaN -0.5245 -0.6181 -0.8441 -0.8818 \n",
" Debt Service Coverage Ratio NaN -0.3143 0.1484 0.0057 -0.1359 \n",
" Equity Multiplier NaN 52.1429 -0.4402 -0.426 -0.2704 \n",
" Free Cash Flow Yield NaN 0.0919 0.0404 1.0388 -0.2048 \n",
" Net-Debt to EBITDA Ratio NaN -0.5509 -4.2153 0.5367 0.0858 \n",
" Cash Flow Coverage Ratio NaN 0.0919 0.0404 1.0388 -0.2048 \n",
" CAPEX Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Dividend CAPEX Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
"META Debt-to-Assets Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Debt-to-Equity Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Debt Service Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Equity Multiplier NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Free Cash Flow Yield NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Net-Debt to EBITDA Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Cash Flow Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" CAPEX Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
" Dividend CAPEX Coverage Ratio NaN -0.0955 0.9299 -0.1875 0.7324 \n",
"WMT Debt-to-Assets Ratio NaN 0.0738 -0.0812 0.0585 -0.0545 \n",
" Debt-to-Equity Ratio NaN 0.1467 -0.132 0.0911 -0.0647 \n",
" Debt Service Coverage Ratio NaN -0.0477 0.0435 -0.0497 0.0938 \n",
" Equity Multiplier NaN 5.3222 0.001 -0.0111 0.0092 \n",
" Free Cash Flow Yield NaN 0.4557 0.4043 0.0248 1.281 \n",
" Net-Debt to EBITDA Ratio NaN 0.1541 -0.1253 0.1328 -0.1434 \n",
" Cash Flow Coverage Ratio NaN 0.4557 0.4043 0.0248 1.281 \n",
" CAPEX Coverage Ratio NaN 0.0377 0.063 0.0587 0.4772 \n",
" Dividend CAPEX Coverage Ratio NaN 0.0371 0.0572 0.0065 0.3817 \n",
"\n",
"date 2010 2011 2012 2013 2014 \\\n",
"AAPL Debt-to-Assets Ratio NaN NaN NaN inf 0.8584 \n",
" Debt-to-Equity Ratio NaN NaN NaN inf 1.3044 \n",
" Debt Service Coverage Ratio 1.2336 0.3617 0.1864 -0.1933 -0.2843 \n",
" Equity Multiplier -0.1076 -0.0976 -0.0251 0.0556 0.178 \n",
" Free Cash Flow Yield 0.18 0.432 0.0285 0.0051 -0.1531 \n",
" Net-Debt to EBITDA Ratio -0.0785 -0.5247 -0.3341 -1.2571 6.5191 \n",
" Cash Flow Coverage Ratio 0.18 0.432 0.0285 0.0051 -0.1531 \n",
" CAPEX Coverage Ratio 0.0468 -0.4256 0.0741 0.0932 0.0291 \n",
" Dividend CAPEX Coverage Ratio 0.0468 -0.4256 -0.1507 -0.3611 0.0437 \n",
"AMZN Debt-to-Assets Ratio 3.3165 0.6422 1.1 0.0969 0.776 \n",
" Debt-to-Equity Ratio 3.5121 0.9529 1.563 0.1371 1.1872 \n",
" Debt Service Coverage Ratio -0.1155 -0.573 -0.3851 -0.0899 -0.8056 \n",
" Equity Multiplier -0.0359 0.1205 0.2029 0.1179 0.1399 \n",
" Free Cash Flow Yield -0.3752 -0.147 -0.8652 2.0556 0.2364 \n",
" Net-Debt to EBITDA Ratio -0.2821 0.2472 -0.144 -0.4221 -0.5167 \n",
" Cash Flow Coverage Ratio -0.3752 -0.147 -0.8652 2.0556 0.2364 \n",
" CAPEX Coverage Ratio -0.5956 -0.3963 -0.4876 0.4394 -0.1204 \n",
" Dividend CAPEX Coverage Ratio -0.5956 -0.3963 -0.4876 0.4394 -0.1204 \n",
"META Debt-to-Assets Ratio -1.0179 -0.3243 0.4593 -0.8295 -0.782 \n",
" Debt-to-Equity Ratio -1.0248 -0.3684 0.4501 -0.8463 -0.789 \n",
" Debt Service Coverage Ratio -1.3005 -0.2637 -0.7382 3.9846 0.3758 \n",
" Equity Multiplier -1.3005 -0.5024 -0.0251 -0.0583 -0.0707 \n",
" Free Cash Flow Yield -inf NaN -1.0 3.75 -0.1627 \n",
" Net-Debt to EBITDA Ratio -0.8731 -0.6416 -0.9412 30.6229 -0.123 \n",
" Cash Flow Coverage Ratio -inf NaN -1.0 3.75 -0.1627 \n",
" CAPEX Coverage Ratio -0.7302 0.073 -0.4893 1.3749 -0.0386 \n",
" Dividend CAPEX Coverage Ratio -0.7302 0.073 -0.4893 1.3749 -0.0386 \n",
"WMT Debt-to-Assets Ratio -0.0627 0.14 0.0007 -0.0351 0.0379 \n",
" Debt-to-Equity Ratio -0.097 0.2457 0.0298 -0.0535 0.0475 \n",
" Debt Service Coverage Ratio 0.0474 0.013 -0.0238 -0.092 0.001 \n",
" Equity Multiplier -0.0241 0.027 0.0603 0.004 -0.0047 \n",
" Free Cash Flow Yield 0.1921 -0.2767 -0.1137 0.026 -0.2635 \n",
" Net-Debt to EBITDA Ratio -0.0921 0.1915 0.0559 -0.0551 0.0815 \n",
" Cash Flow Coverage Ratio 0.1921 -0.2767 -0.1137 0.026 -0.2635 \n",
" CAPEX Coverage Ratio 0.0702 -0.1358 -0.0357 0.1052 -0.1062 \n",
" Dividend CAPEX Coverage Ratio 0.0541 -0.138 -0.0527 0.0724 -0.1382 \n",
"\n",
"date 2015 2016 2017 2018 2019 \\\n",
"AAPL Debt-to-Assets Ratio 0.458 0.219 0.1394 0.0156 0.0198 \n",
" Debt-to-Equity Ratio 0.707 0.2564 0.2717 0.2381 0.1175 \n",
" Debt Service Coverage Ratio 0.0678 -0.1038 -0.2316 -0.003 -0.0033 \n",
" Equity Multiplier 0.2119 0.093 0.0748 0.1562 0.1598 \n",
" Free Cash Flow Yield 0.5241 -0.2996 -0.3138 0.4062 -0.4784 \n",
" Net-Debt to EBITDA Ratio 0.4804 0.7333 0.4649 -0.1884 -0.285 \n",
" Cash Flow Coverage Ratio 0.5241 -0.2996 -0.3138 0.4062 -0.4784 \n",
" CAPEX Coverage Ratio 0.1625 -0.3132 0.023 0.1702 0.1368 \n",
" Dividend CAPEX Coverage Ratio 0.2363 -0.2735 -0.0287 0.1517 -0.0161 \n",
"AMZN Debt-to-Assets Ratio -0.0541 -0.1583 0.5833 -0.153 0.1472 \n",
" Debt-to-Equity Ratio -0.0886 -0.2555 0.7349 -0.3325 0.1147 \n",
" Debt Service Coverage Ratio 9.4603 0.4492 -0.2576 1.5614 -0.0881 \n",
" Equity Multiplier 0.076 -0.0836 0.0028 -0.0971 -0.1097 \n",
" Free Cash Flow Yield 0.6765 0.1754 -0.5821 1.0536 0.013 \n",
" Net-Debt to EBITDA Ratio -0.5426 0.5459 -4.3337 -0.7408 1.5779 \n",
" Cash Flow Coverage Ratio 0.6765 0.1754 -0.5821 1.0536 0.013 \n",
" CAPEX Coverage Ratio 0.8576 -0.0604 -0.3683 0.484 -0.0017 \n",
" Dividend CAPEX Coverage Ratio 0.8576 -0.0604 -0.3683 0.484 -0.0017 \n",
"META Debt-to-Assets Ratio -0.6034 -1.0 NaN inf 14.1765 \n",
" Debt-to-Equity Ratio -0.6 -1.0 NaN inf 16.322 \n",
" Debt Service Coverage Ratio -0.0779 0.3366 0.2431 -0.3392 -0.5512 \n",
" Equity Multiplier -0.0096 -0.0086 0.0122 0.0252 0.0857 \n",
" Free Cash Flow Yield 0.1714 0.6878 -0.0318 0.197 -0.1047 \n",
" Net-Debt to EBITDA Ratio -0.1036 0.0274 -0.423 -0.0635 -0.0958 \n",
" Cash Flow Coverage Ratio 0.1714 0.6878 -0.0318 0.197 -0.1047 \n",
" CAPEX Coverage Ratio 0.1436 0.0524 0.0028 -0.4151 0.143 \n",
" Dividend CAPEX Coverage Ratio 0.1436 0.0524 0.0028 -0.4151 0.143 \n",
"WMT Debt-to-Assets Ratio -0.1059 0.0137 -0.0786 -0.016 0.1641 \n",
" Debt-to-Equity Ratio -0.1667 0.0036 -0.0494 0.011 0.2206 \n",
" Debt Service Coverage Ratio 0.0733 -0.1031 -0.0882 -0.2346 0.0887 \n",
" Equity Multiplier -0.0306 -0.0388 0.0104 0.0298 0.0385 \n",
" Free Cash Flow Yield 1.2294 -0.1574 -0.072 -0.0632 -0.2514 \n",
" Net-Debt to EBITDA Ratio -0.1777 0.0844 -0.034 0.0786 0.2015 \n",
" Cash Flow Coverage Ratio 1.2294 -0.1574 -0.072 -0.0632 -0.2514 \n",
" CAPEX Coverage Ratio 0.3231 0.0171 0.2442 -0.0505 -0.0483 \n",
" Dividend CAPEX Coverage Ratio 0.2881 -0.0094 0.2152 -0.0646 -0.0368 \n",
"\n",
"date 2020 2021 2022 2023 \n",
"AAPL Debt-to-Assets Ratio 0.0874 0.0236 -0.0419 -0.0743 \n",
" Debt-to-Equity Ratio 0.4412 0.1488 0.1987 -0.2456 \n",
" Debt Service Coverage Ratio 0.0402 0.3804 -0.1066 0.0141 \n",
" Equity Multiplier 0.193 0.2362 0.1772 0.0106 \n",
" Free Cash Flow Yield -0.2735 -0.0216 0.6782 -0.3816 \n",
" Net-Debt to EBITDA Ratio 0.243 -0.224 -0.0108 -0.127 \n",
" Cash Flow Coverage Ratio -0.2735 -0.0216 0.6782 -0.3816 \n",
" CAPEX Coverage Ratio 0.6694 -0.1497 0.2154 -0.1158 \n",
" Dividend CAPEX Coverage Ratio 0.3378 0.0795 0.1742 -0.1102 \n",
"AMZN Debt-to-Assets Ratio -0.0638 0.0537 0.0939 -15.0499 \n",
" Debt-to-Equity Ratio -0.1128 -0.0682 0.1396 -5.4343 \n",
" Debt Service Coverage Ratio 0.0942 -0.0348 -0.5495 -54.9886 \n",
" Equity Multiplier -0.043 -0.089 -0.0297 -2.3694 \n",
" Free Cash Flow Yield -0.3305 -1.5513 1.314 212.7839 \n",
" Net-Debt to EBITDA Ratio 0.1779 0.5377 0.1776 -3.6725 \n",
" Cash Flow Coverage Ratio -0.3305 -1.5513 1.314 212.7839 \n",
" CAPEX Coverage Ratio -0.2795 -0.5389 -0.0319 4.7913 \n",
" Dividend CAPEX Coverage Ratio -0.2795 -0.5389 -0.0319 4.7913 \n",
"META Debt-to-Assets Ratio -0.1357 0.2496 0.7129 -30.7088 \n",
" Debt-to-Equity Ratio -0.1879 0.3386 0.9037 -21.1149 \n",
" Debt Service Coverage Ratio 0.3686 0.0144 -0.5158 -4.9723 \n",
" Equity Multiplier 0.0243 0.0068 0.0923 -4.0312 \n",
" Free Cash Flow Yield -0.1671 0.3612 0.4398 -73.599 \n",
" Net-Debt to EBITDA Ratio -0.4054 -0.715 -7.3427 -14.4417 \n",
" Cash Flow Coverage Ratio -0.1671 0.3612 0.4398 -73.599 \n",
" CAPEX Coverage Ratio 0.0661 0.2119 -0.4831 1.6492 \n",
" Dividend CAPEX Coverage Ratio 0.0661 0.2119 -0.4831 1.6492 \n",
"WMT Debt-to-Assets Ratio 0.1576 -0.1822 -0.0655 0.0337 \n",
" Debt-to-Equity Ratio 0.2189 -0.1864 -0.1367 0.1246 \n",
" Debt Service Coverage Ratio -0.067 -0.0794 0.2198 -0.256 \n",
" Equity Multiplier 0.0508 0.0227 -0.0415 0.0016 \n",
" Free Cash Flow Yield -0.3039 0.752 -0.5631 0.0035 \n",
" Net-Debt to EBITDA Ratio 0.212 -0.2843 -0.0571 0.319 \n",
" Cash Flow Coverage Ratio -0.3039 0.752 -0.5631 0.0035 \n",
" CAPEX Coverage Ratio -0.1207 0.4897 -0.475 -0.0643 \n",
" Dividend CAPEX Coverage Ratio -0.1067 0.4609 -0.4299 0.009 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies.ratios.collect_solvency_ratios(diluted=False, growth=True)"
]
},
{
"cell_type": "markdown",
"id": "e7ec2674",
"metadata": {},
"source": [
"For all ratios, it is also possible to show the growth instead. E.g. if you are interested in the growth of the Price-to-Book ratio you can use the following:"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "48b75204",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
"
],
"text/plain": [
"date 2005 2006 2007 2008 2009 2010 2011 2012 \\\n",
"AAPL Lag 1 NaN -0.2416 0.0531 0.0426 -0.236 0.0694 -0.2003 -0.07 \n",
" Lag 2 NaN NaN -0.2013 0.0979 -0.2034 -0.183 -0.1448 -0.2563 \n",
" Lag 3 NaN NaN NaN -0.1673 -0.1612 -0.1482 -0.3466 -0.2047 \n",
"AMZN Lag 1 NaN -0.1227 0.0437 -0.067 0.0255 -0.0038 -0.1141 -0.0455 \n",
" Lag 2 NaN NaN -0.0843 -0.0262 -0.0432 0.0217 -0.1174 -0.1544 \n",
" Lag 3 NaN NaN NaN -0.1456 -0.0013 -0.0468 -0.0949 -0.1576 \n",
"META Lag 1 NaN NaN NaN NaN NaN NaN -0.113 1.0913 \n",
" Lag 2 NaN NaN NaN NaN NaN NaN NaN 0.855 \n",
" Lag 3 NaN NaN NaN NaN NaN NaN NaN NaN \n",
"WMT Lag 1 NaN 0.0001 0.0029 -0.0957 0.0856 -0.0157 0.02 -0.0055 \n",
" Lag 2 NaN NaN 0.003 -0.093 -0.0183 0.0686 0.0041 0.0144 \n",
" Lag 3 NaN NaN NaN -0.0929 -0.0154 -0.0337 0.09 -0.0015 \n",
"\n",
"date 2013 2014 2015 2016 2017 2018 2019 2020 \\\n",
"AAPL Lag 1 0.1222 -0.3566 0.0265 0.22 -0.0566 -0.1193 0.3704 -0.1146 \n",
" Lag 2 0.0436 -0.2779 -0.3395 0.2523 0.1509 -0.1692 0.2069 0.2133 \n",
" Lag 3 -0.1654 -0.3285 -0.2588 -0.1942 0.1814 0.0136 0.1386 0.0686 \n",
"AMZN Lag 1 -0.0438 0.0408 -0.0353 -0.0289 -0.0047 0.0559 -0.001 -0.0427 \n",
" Lag 2 -0.0873 -0.0049 0.0041 -0.0632 -0.0334 0.051 0.0549 -0.0436 \n",
" Lag 3 -0.1915 -0.0501 -0.0399 -0.025 -0.0675 0.0206 0.05 0.0099 \n",
"META Lag 1 0.1094 -0.1921 0.1717 0.0638 0.0794 -0.443 -0.3885 0.1481 \n",
" Lag 2 1.3201 -0.1037 -0.0534 0.2464 0.1483 -0.3988 -0.6594 -0.2979 \n",
" Lag 3 1.0579 0.8745 0.0502 0.007 0.3454 -0.3604 -0.6323 -0.6089 \n",
"WMT Lag 1 -0.0542 0.0572 0.0987 -0.0384 -0.0754 -0.1185 0.0514 -0.0055 \n",
" Lag 2 -0.0594 -0.0001 0.1616 0.0565 -0.1109 -0.1849 -0.0731 0.0456 \n",
" Lag 3 -0.0405 -0.0056 0.0986 0.117 -0.0231 -0.2162 -0.143 -0.0782 \n",
"\n",
"date 2021 2022 2023 \n",
"AAPL Lag 1 -0.212 -0.1817 0.1236 \n",
" Lag 2 -0.3023 -0.3551 -0.0805 \n",
" Lag 3 -0.0439 -0.429 -0.2754 \n",
"AMZN Lag 1 0.0814 -0.1683 0.0 \n",
" Lag 2 0.0353 -0.1005 -0.1683 \n",
" Lag 3 0.0343 -0.1389 -0.1005 \n",
"META Lag 1 -0.3755 -0.3015 0.0 \n",
" Lag 2 -0.283 -0.5638 -0.3015 \n",
" Lag 3 -0.5615 -0.4992 -0.5638 \n",
"WMT Lag 1 0.2236 -0.0456 -0.115 \n",
" Lag 2 0.2169 0.1677 -0.1554 \n",
" Lag 3 0.2794 0.1613 0.0334 "
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies.ratios.get_current_ratio(growth=True, lag=[1, 2, 3])"
]
},
{
"cell_type": "markdown",
"id": "4408750c",
"metadata": {},
"source": [
"It is also possible to get trailing results. E.g. the TTM Earnings per Share ratio can be acquired by setting trailing to 4 (quarters). Note that this does not lead to meaningful results when using yearly data and therefore this image now shows the 4 year trailing result. Set `quarterly=True` in the Toolkit initialization to use quarterly data."
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "f28ffcb0",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
""
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAABN4AAAE8CAYAAAAfRXwIAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8pXeV/AAAACXBIWXMAAA9hAAAPYQGoP6dpAACj/UlEQVR4nOzdd3gU5f428Hu276YnpJNGhwRE6UWKUoP1KKjAUeD8VGxYjg1UFCtYUVEsJ4IooGJ7jwoiHgGlI4ooHUkIkISQXrbvzvvH7k52s7tJNqQR7s917ZXdmWdmnkk2k+TO93lGEEVRBBERERERERERETUpWWt3gIiIiIiIiIiIqD1i8EZERERERERERNQMGLwRERERERERERE1AwZvREREREREREREzYDBGxERERERERERUTNg8EZERERERERERNQMGLwRERERERERERE1AwZvREREREREREREzYDBGxERERERERERUTNg8EZERK3qqaeegiAIHstSU1MxY8YM6fWmTZsgCAI2bdrUsp1rw0aNGoVRo0a1djfahdTUVFxxxRWt3Y0GOXPmDK6//npERUVBEAQsXry4tbvUrGbMmIHU1NTW7gZRk/D18641CYKAp556qrW7QUTU7jF4IyJqQs899xwEQUBGRkad7crKyhAfH49hw4ZBFEWv9Tt27IBMJsNDDz3UXF2tV2pqKgRBqPexfPnyVutjS1i+fHmd579jx47W7iL5kZOTg5kzZ6Jz587QaDSIi4vDiBEj8OSTT7Z21xrt/vvvx/r16zF37lx89NFHmDBhQosct6ysDBqNBoIg4ODBgy1yzNZw8OBBCIIAjUaDsrKy1u5Om+Z+bdyyZYvXelEUkZSUBEEQvILtuq6ps2fPlv7Z0pCHuylTpkAQBDzyyCPNeu7N6c4774RMJkNJSYnH8pKSEshkMqjVahiNRo91x48fhyAImDdvXkt2tVnk5eXhqaeewt69e1u7K0RETUbR2h0gImovTp06heeffx5BQUH1tg0PD8fixYtx44034v3338dtt90mrbNarZg9ezZSUlKwYMGC5uxynRYvXoyqqirp9dq1a7F69Wq89tpr6NChg7R86NCh53Scxx9/HI8++midbUaMGAGDwQCVSnVOxzoXTz/9NNLS0ryWd+nSpRV6A/zwww+tctzzxbFjxzBgwABotVrMmjULqampyM/Px2+//YZFixa16vfWufjpp59w9dVX48EHH2zR465ZswaCICAuLg4rV67Es88+26LHbykff/wx4uLiUFpais8//xz/93//19pdavM0Gg1WrVqF4cOHeyzfvHkzTp06BbVa7XO7sWPH4uabb/Za3q1bN6SkpOCjjz7yWD537lwEBwfjscce87m/iooKfPPNN0hNTcXq1auxcOHCNlVd1lDDhw/H0qVLsXXrVlx55ZXS8m3btkEmk8FiseDXX3/1+Hxv3bpV2vZ8l5eXhwULFiA1NRV9+/Zt7e4QETUJBm9ERE3kwQcfxODBg2Gz2VBUVFRv+xtuuAEffvghHn30UVx99dWIjY0FALz++uv4448/sHbtWuh0uubuNqqrq32Ghddcc43H64KCAqxevRrXXHNNnUO//O3PH4VCAYWi7h9HMpkMGo2mwftsDhMnTkT//v2bZd92ux1mszmgc2zNELKtqOu99tprr6Gqqgp79+5FSkqKx7rCwsKW6J4Ho9EIlUoFmezcBhsUFhYiPDy8aTqFhvfr448/RmZmJlJSUrBq1ap2GbyJoohVq1Zh6tSpyM7OxsqVKxm8NUBmZibWrFmDN954w+NavmrVKvTr18/vz8Nu3bph+vTpfvdbe93ChQvRoUMHv9t88cUXsNls+OCDD3DZZZfh559/xsiRIxtxRq3LFZ5t2bLFI3jbunUr+vTpA4PBgC1btniEbFu2bIFMJjvnf4S1JqvVCrvd3trdICJqFhxqSkTUBH7++Wd8/vnnAc+39Pbbb8NkMuGBBx4AAJw8eRJPPfUUbrjhBkycOBEAsG7dOlx66aUICgpCSEgIJk2ahP3793vsZ9++fZgxYwY6deokDambNWsWiouLPdq55pc5cOAApk6dioiIiHP6D/mMGTMQHByMv//+G5mZmQgJCcG0adMAAL/88gsmT56M5ORkqNVqJCUl4f7774fBYPDZp7r4muNt1KhRyMjIwIEDBzB69GjodDokJibixRdf9Nr+xIkTuOqqqxAUFISYmBhpuF5Tzxv38ssvY+jQoYiKioJWq0W/fv3w+eefe7UTBAF33303Vq5cifT0dKjVanz//ffS0K2tW7figQceQHR0NIKCgnDttdfi7NmzHvuoPceb63P02Wef4bnnnkPHjh2h0Whw+eWX49ixY159eOutt9CpUydotVoMHDgQv/zyi8954958802kp6dDp9MhIiIC/fv3x6pVq+r8PLj68umnn2LevHmIi4tDUFAQrrrqKpw8edKr/c6dOzFhwgSEhYVBp9Nh5MiRUgWHS6Dv3b///hsdO3b0Ct0AICYmxuc2W7ZswcCBA6HRaNCpUyesWLHCY31JSQkefPBB9O7dG8HBwQgNDcXEiRPxxx9/+Dz/Tz75BI8//jgSExOh0+lQUVHR4POtzfXeEEURb731ltcwu+PHj2Py5MmIjIyETqfD4MGD8d133wXUL39yc3Pxyy+/4MYbb8SNN96I7OxsbNu2zaud63tyz549GDp0KLRaLdLS0vDOO+/47EdD3x+12e12LF68GOnp6dBoNIiNjcXtt9+O0tLSerety9atW5GTkyOd588//4xTp055tXPNCbhp0yb0798fWq0WvXv3lq4lX375JXr37g2NRoN+/frh999/99i+IdfrnJycBg+vXLNmDfr16wetVisFU6dPn/Zo47pWnz59Gtdccw2Cg4MRHR2NBx98EDab7Zw+bzfddBOKi4uxYcMGaZnZbMbnn3+OqVOnntO+A7Fy5UqMHTsWo0ePRs+ePbFy5coGbxvotfvrr79GRkYG1Go10tPT8f3333u13bJlCwYMGACNRoPOnTvj3XffbVBfkpOTkZSU5HVN2Lp1K4YNG4ahQ4f6XJeeno7w8HCYzWbMnz8f/fr1Q1hYGIKCgnDppZdi48aN9R7bdZ09cuQIpk+fjrCwMERHR+OJJ56AKIo4efIkrr76aoSGhiIuLg6vvPKKx/YNPbbr/f3yyy9j8eLF6Ny5M9RqNd5++20MGDAAADBz5swLZkoLImr/WPFGRHSObDYb7rnnHvzf//0fevfuHdC2qampWLBgAR566CHMmDEDb7/9NhQKhRTgffTRR7jlllswfvx4LFq0CHq9HkuXLsXw4cPx+++/S5VnGzZswPHjxzFz5kzExcVh//79eO+997B//37s2LHD6w+1yZMno2vXrnj++ed9zjEXCKvVivHjx2P48OF4+eWXpSq9NWvWQK/X44477kBUVBR27dqFN998E6dOncKaNWvO6ZgupaWlmDBhAv7xj39gypQp+Pzzz/HII4+gd+/eUnBZXV2Nyy67DPn5+bj33nsRFxeHVatWNeiPEHfl5eVelRuCICAqKkp6/frrr+Oqq67CtGnTYDab8cknn2Dy5Mn49ttvMWnSJI9tf/rpJ3z22We4++670aFDB6Smpkpz2txzzz2IiIjAk08+iZycHCxevBh33303Pv3003r7uXDhQshkMjz44IMoLy/Hiy++iGnTpmHnzp1Sm6VLl+Luu+/GpZdeivvvvx85OTm45pprEBERgY4dO0rt3n//fcyZMwfXX3897r33XhiNRuzbtw87d+5s0B/UrjkPH3nkERQWFmLx4sUYM2YM9u7dC61WK30eJk6ciH79+uHJJ5+ETCbDsmXLcNlll+GXX37BwIEDPfbZ0PduSkoKfvzxR/z000+47LLL6u3rsWPHcP311+Nf//oXbrnlFnzwwQeYMWMG+vXrh/T0dACOcOvrr7/G5MmTkZaWhjNnzuDdd9/FyJEjceDAASQkJHjs85lnnoFKpcKDDz4Ik8kElUoV8Pm6jBgxAh999BH++c9/eg3RO3PmDIYOHQq9Xo85c+YgKioKH374Ia666ip8/vnnuPbaa+vtV11Wr16NoKAgXHHFFdBqtejcuTNWrlzps7qmtLQUmZmZmDJlCm666SZ89tlnuOOOO6BSqTBr1iyPtg15f/hy++23Y/ny5Zg5cybmzJmD7OxsLFmyBL///ju2bt0KpVJZ5/n4s3LlSnTu3BkDBgxARkYGdDodVq9e7XOuzWPHjmHq1Km4/fbbMX36dLz88su48sor8c4772DevHm48847AQAvvPACpkyZgsOHD0tVhQ25XkdHR3sNtbRYLLj//vs9vl6uz8OAAQPwwgsv4MyZM3j99dexdetW/P777x7VkTabDePHj8egQYPw8ssv48cff8Qrr7yCzp0744477mjU5wxw/BwbMmQIVq9e7fEPo/Lyctx444144403fG5nNBp9VsOFhoYGXNGbl5eHjRs34sMPPwTgCANfe+01LFmypEH7CuTavWXLFnz55Ze48847ERISgjfeeAPXXXcdcnNzpZ8Hf/75J8aNG4fo6Gg89dRTsFqtePLJJ6XK9voMHz4cX375JUwmE9RqNcxmM3bv3o077rgDer0eDz/8MERRhCAIKC0txYEDBzB79mwAjiG3//nPf3DTTTfh1ltvRWVlJbKysjB+/Hjs2rWrQcM3b7jhBvTs2RMLFy7Ed999h2effRaRkZF49913cdlll2HRokVYuXIlHnzwQQwYMAAjRoxo1LGXLVsGo9GI2267DWq1Gtdeey0qKysxf/583Hbbbbj00ksBnPuUFkRErU4kIqJzsmTJEjEsLEwsLCwURVEUR44cKaanpzd4e4vFIvbt21eMjIwUAYjvvvuuKIqiWFlZKYaHh4u33nqrR/uCggIxLCzMY7ler/fa7+rVq0UA4s8//ywte/LJJ0UA4k033RTQOYqiKL700ksiADE7O1tadsstt4gAxEcffdSrva8+vfDCC6IgCOKJEye8+uQuJSVFvOWWW6TXGzduFAGIGzdulJaNHDlSBCCuWLFCWmYymcS4uDjxuuuuk5a98sorIgDx66+/lpYZDAaxR48eXvv0ZdmyZSIAnw+1Wl3nOZvNZjEjI0O87LLLPJYDEGUymbh//36fxxozZoxot9ul5ffff78ol8vFsrIyj/MfOXKk1+eoZ8+eoslkkpa//vrrIgDxzz//lD5HUVFR4oABA0SLxSK1W758uQjAY59XX311QO/l2n1JTEwUKyoqpOWfffaZCEB8/fXXRVEURbvdLnbt2lUcP368x/nq9XoxLS1NHDt2rLQs0PfuX3/9JWq1WhGA2LdvX/Hee+8Vv/76a7G6utqrbUpKitf3SmFhoahWq8V///vf0jKj0SjabDaPbbOzs0W1Wi0+/fTTXuffqVMnj/dEIOfrDwDxrrvu8lh23333iQDEX375RVpWWVkppqWliampqVKf/fWrPr179xanTZsmvZ43b57YoUMHj/ePKNZ8T77yyivSMpPJJPbt21eMiYkRzWazRz/qe3+IouMak5KSIr3+5ZdfRADiypUrPY79/fff+1zeUGazWYyKihIfe+wxadnUqVPFiy66yKut6/2ybds2adn69etFAKJWq/W4vr377rte15mGXq9ru/POO0W5XC7+9NNPUp9jYmLEjIwM0WAwSO2+/fZbEYA4f/58aZnrWu3+PhVFUbz44ovFfv36+T1mXVzXq927d4tLliwRQ0JCpHObPHmyOHr0aFEUHZ+vSZMmeWzr75oKQFy9erXP46Wnp3tcn9y9/PLLolarld5PR44cEQGIX331VYPOJZBrt0qlEo8dOyYt++OPP0QA4ptvviktu+aaa0SNRuPxXjhw4IAol8u9ft758tZbb3l8T2/fvl0EIJ44cUI8cOCACED6+eH6erve+1ar1eNngCiKYmlpqRgbGyvOmjXL63yefPJJ6bXrOnvbbbdJy6xWq9ixY0dREARx4cKFHvvUarUeP6sbeuzs7GwRgBgaGir97uSye/duEYC4bNmyej9PRETnCw41JSI6B8XFxZg/fz6eeOIJREdHN2ofCoUC7733HkpKSjB48GDceuutABxVEWVlZbjppptQVFQkPeRyOQYNGuRRseVeHeKqIhg8eDAA4LfffvM6pus/403FV7WEe5+qq6tRVFSEoUOHQhRFr6FXjRUcHOwx349KpcLAgQNx/Phxadn333+PxMREXHXVVdIyjUYjfZ4b6q233sKGDRs8HuvWrfNo437OpaWlKC8vx6WXXurzazBy5Ej06tXL57Fuu+02jyrFSy+9FDabDSdOnKi3nzNnzvSo8HBVDLg+J7/++iuKi4tx6623eszHNG3aNERERHjsKzw8HKdOncLu3bvrPa4vN998M0JCQqTX119/PeLj47F27VoAwN69e3H06FFMnToVxcXF0nu8uroal19+OX7++WevOX8a+t5NT0/H3r17MX36dOTk5OD111/HNddcg9jYWLz//vte7Xv16iV9rgAgOjoa3bt393gvqdVqqWrJZrOhuLgYwcHB6N69u8+v8S233OLxnmjM+TbE2rVrMXDgQI+ht8HBwbjtttuQk5ODAwcO1Nmvuuzbtw9//vknbrrpJmmZ65q0fv16r/YKhQK333679FqlUuH2229HYWEh9uzZ49G2vveHL2vWrEFYWBjGjh3rcV3s168fgoODA65kdVm3bh2Ki4u9zvOPP/7wGtoPON4vQ4YMkV4PGjQIAHDZZZchOTnZa7n7+yjQ6zUArFixAm+//TZefPFFjB49GoDje7mwsBB33nmnx/yQkyZNQo8ePbyGGgPe3z+XXnqpR98aa8qUKTAYDPj2229RWVmJb7/9tt6q2Kuvvtrrmrphwwbp/AKxcuVKTJo0SXo/de3aFf369WvwcNNArt1jxoxB586dpdd9+vRBaGio9Hm02WxYv349rrnmGo/3Qs+ePTF+/PgG9cd9njfAMZQ0MTERycnJ6NGjByIjI6XhprVvrCCXy6WfAXa7HSUlJbBarejfv7/f91dt7nMbyuVy9O/fH6Io4l//+pe0PDw83OsaGeixr7vuukb/7kREdD7hUFMionPw+OOPIzIyEvfcc8857cc1p0m/fv2kwOXo0aMA4HeYXGhoqPS8pKQECxYswCeffOI1cXx5ebnXtr7uztlYCoXCY3iiS25uLubPn4///ve/XnMv+epTY3Ts2NFrGG1ERAT27dsnvT5x4gQ6d+7s1S7Qu5EOHDiw3psrfPvtt3j22Wexd+9emEwmabmvOezq+hq4/7EGQArEGjKHVX3busK72uevUCi8bprxyCOP4Mcff8TAgQPRpUsXjBs3DlOnTsWwYcPq7Qfg+OPXnSAI6NKlC3JycgDUvMdvueUWv/soLy/3CAQDee9269YNH330EWw2Gw4cOIBvv/0WL774Im677TakpaVhzJgxUtvanzfA8blz/5zb7Xa8/vrrePvtt5Gdne0xN5b7kGN/fW3M+TbEiRMnpIDHXc+ePaX1GRkZfvtVl48//hhBQUHo1KmTNFegRqNBamqqFHa4S0hI8LrhRbdu3QA45nVyBUxA/e8PX44ePYry8nK/8/Q19sYZH3/8MdLS0qBWq6Xz7Ny5M3Q6HVauXInnn3/eo33t90tYWBgAICkpyedy9/dRoNfrvXv3Yvbs2bjpppuk+UCBmu/l7t27e23To0cPKbRx0Wg0XiFH7fd4Y0VHR2PMmDFYtWoV9Ho9bDYbrr/++jq36dixo8f3YGMdPHgQv//+O26++WaP+SxHjRqFt956CxUVFR4/L30J5Npd37Xi7NmzMBgMXu9vwPG1qitYdsnIyEB4eLhHuOa67gqCgCFDhmDr1q249dZbsXXrViQlJXn068MPP8Qrr7yCQ4cOwWKxSMsb+r3v6/2t0Wg87mjuWl57LtlAjt2Uv4sQEbVlDN6IiBrp6NGjeO+997B48WLk5eVJy41GIywWC3JychAaGorIyMhG7d9V+fLRRx8hLi7Oa717tdKUKVOwbds2PPTQQ+jbty+Cg4Nht9sxYcIEnxU0Da12aQj3KiAXm82GsWPHoqSkBI888gh69OiBoKAgnD59GjNmzGiyO5fJ5XKfy8VznLeuMX755RdcddVVGDFiBN5++23Ex8dDqVRi2bJlPm9GUNfX4FzOqyk/Jz179sThw4fx7bff4vvvv8cXX3yBt99+G/Pnz8eCBQsC3l9trvfBSy+95HfeoeDgYI/XjXnvyuVy9O7dG71798aQIUMwevRorFy50uOP/oZ83p5//nk88cQTmDVrFp555hlERkZCJpPhvvvua9D3WWPOtzk09HMoiiJWr16N6upqn9WZhYWFqKqqapE+u9jtdsTExPitZGpM9UxFRQW++eYbGI1Gn2HJqlWrpPnoXPy9XxryPgrkel1aWorrrrsO3bp1w3/+85+Az60hfWsqU6dOxa233oqCggJMnDixSe++W5ePP/4YAHD//ffj/vvv91r/xRdfYObMmX63D/Ta3RI/d2QyGYYMGYJt27ZBFEVs3boV8+bNk9YPHToUH3zwgTT3m/tdyD/++GPMmDED11xzDR566CHExMRALpfjhRdewN9//92g4/s6x4acd6DHbsrfRYiI2jIGb0REjXT69GnY7XbMmTMHc+bM8VqflpaGe++9N+A7nbq4hrLExMTUWRVQWlqK//3vf1iwYAHmz58vLXdV17SGP//8E0eOHMGHH37oMQm8+13vWkpKSgoOHDggTUTt4utOn+fiiy++gEajwfr166FWq6Xly5Yta9LjnCvXXT6PHTvmMaTLarUiJycHffr08WgfFBSEG264ATfccAPMZjP+8Y9/4LnnnsPcuXM9hrf5Uvs9KIoijh07Jh3D9R4PDQ1tksqXhnBVLebn5we87eeff47Ro0cjKyvLY3lZWZlXJYgvzXW+KSkpOHz4sNfyQ4cOSesbY/PmzTh16hSefvppqXrOpbS0FLfddhu+/vprj+HeeXl5qK6u9qh6O3LkCAB4VVTW9/7wpXPnzvjxxx8xbNiwJvuj/csvv4TRaMTSpUu9vo6HDx/G448/jq1bt57THaBdArle2+12TJs2DWVlZfjxxx+lG9e4uL6uhw8f9qqMPnz4cKO/7o117bXX4vbbb8eOHTsadCOYpiCKIlatWoXRo0dLN7Rw98wzz2DlypV1Bm9Nfe2Ojo6GVqv1+TX19X3qz/Dhw7Fu3Tr897//RWFhoUel8dChQ/HYY49h7dq1MBgMHu/Nzz//HJ06dcKXX37p8TPvySefbNT5BKIpjl3fXc6JiM5HnOONiKiRMjIy8NVXX3k90tPTkZycjK+++spjPpRAjR8/HqGhoXj++ec9hmu4nD17FkDNf6Fr/7e9sYFfU/DVJ1EU8frrr7d4X8aPH4/Tp0/jv//9r7TMaDT6nOfrXMjlcgiC4DH8MCcnB19//XWTHudc9e/fH1FRUXj//fdhtVql5StXrvQaclZ7CJFKpUKvXr0giqLP92RtK1asQGVlpfT6888/R35+vnTnw379+qFz5854+eWXUVVV5bW96z3eGL/88ovPPrqGefkanlcfuVzu9X22Zs0anD59ukHbN9f5ZmZmYteuXdi+fbu0rLq6Gu+99x5SU1P9ziVYH9cw04ceegjXX3+9x+PWW29F165dvSrPrFYr3n33Xem12WzGu+++i+joaPTr18+jbX3vD1+mTJkCm82GZ555xmud1WpFWVlZo86zU6dOmD17ttd5PvjggwgODm7wXGH1CeR6vWDBAqxfvx6rV6/2OSSvf//+iImJwTvvvOMxPHLdunU4ePCg1zDg5hYcHIylS5fiqaeewpVXXtkix9y6dStycnIwc+ZMr6/d9ddfjxtuuAEbN270qEqvramv3XK5HOPHj8fXX3+N3NxcafnBgwd9zovojytMW7RoEXQ6nUeV7MCBA6FQKPDiiy96tHUdH/B8j+3cudPj+tBcmuLYrtC+Md/LRERtFSveiIgaqUOHDh7DO1xcf0D5WheI0NBQLF26FP/85z9xySWX4MYbb0R0dDRyc3Px3XffYdiwYViyZAlCQ0MxYsQIvPjii7BYLEhMTMQPP/yA7Ozsczr+uejRowc6d+6MBx98EKdPn0ZoaCi++OKLJplLKFC33347lixZgptuugn33nsv4uPjsXLlSqlaq6H/XV+3bp1UQeRu6NCh6NSpEyZNmoRXX30VEyZMwNSpU1FYWIi33noLXbp08ZhzrrWpVCo89dRTuOeee3DZZZdhypQpyMnJwfLly73mwhs3bhzi4uIwbNgwxMbG4uDBg1iyZInHJOZ1iYyMxPDhwzFz5kycOXMGixcvRpcuXaQbW8hkMvznP//BxIkTkZ6ejpkzZyIxMRGnT5/Gxo0bERoaim+++aZR57lo0SLs2bMH//jHP6QKqt9++w0rVqxAZGQk7rvvvoD3ecUVV+Dpp5/GzJkzMXToUPz5559YuXIlOnXq1KDtm+t8H330UaxevRoTJ07EnDlzEBkZiQ8//BDZ2dn44osvvIaCN4TJZMIXX3yBsWPH+q1svOqqq/D666+jsLBQmnMtISEBixYtQk5ODrp164ZPP/0Ue/fuxXvvvQelUumxfX3vD19GjhyJ22+/HS+88AL27t2LcePGQalU4ujRo1izZg1ef/11aW6x5cuXY+bMmVi2bBlmzJjhc395eXnYuHGjz6plwDGUfvz48VizZg3eeOMNr3MIVEOv13/++SeeeeYZjBgxAoWFhdJwSpfp06dDqVRi0aJFmDlzJkaOHImbbroJZ86cweuvv47U1FSfwy4bYsaMGdL7p3aVYn3qmr+wtiNHjnidFwDExsZi7NixDdrHypUrIZfL/YaMV111FR577DF88sknHvPjuWuOa/eCBQvw/fff49JLL8Wdd94Jq9WKN998E+np6Q3e58CBA6FSqbB9+3aMGjXKY3oJnU6Hiy66CNu3b0d4eLjHHI5XXHEFvvzyS1x77bWYNGkSsrOz8c4776BXr14+A/+m1BTH7ty5M8LDw/HOO+8gJCQEQUFBGDRoEOeDI6LzGoM3IqI2bOrUqUhISMDChQvx0ksvwWQyITExEZdeeqnH0JlVq1bhnnvuwVtvvQVRFDFu3DisW7cOCQkJrdJvpVKJb775BnPmzMELL7wAjUaDa6+9FnfffTcuuuiiFu1LcHAwfvrpJ9xzzz14/fXXERwcjJtvvhlDhw7FddddV+9wSRf3YWHuli1bhk6dOuGyyy5DVlYWFi5ciPvuuw9paWlSANGWgjcAuPvuuyGKIl555RU8+OCDuOiii/Df//4Xc+bM8fh83H777Vi5ciVeffVVVFVVoWPHjpgzZw4ef/zxBh1n3rx52LdvH1544QVUVlbi8ssvx9tvv+0xZG7UqFHYvn07nnnmGSxZsgRVVVWIi4vDoEGDPO6OGah58+Zh1apV2Lx5M1auXAm9Xo/4+HjceOONeOKJJxr1R9y8efNQXV2NVatW4dNPP8Ull1yC7777Do8++miD99Ec5xsbG4tt27bhkUcewZtvvgmj0Yg+ffrgm2++aXTV03fffYeysrI6K5euvPJKvPLKK/jkk0+k4CoiIgIffvgh7rnnHrz//vuIjY3FkiVLfIZpDXl/+PLOO++gX79+ePfddzFv3jzpxiDTp0/3GI7n+kM/Pj7e774++eQT2O32es/ziy++wLp16zzujtxYDbleFxcXQxRFbN68GZs3b/bah2t474wZM6DT6bBw4UI88sgjCAoKwrXXXotFixY1eo61qqoqaLXaZp+jzXUX09pGjhzZoODNYrFgzZo1GDp0qN+5VDMyMpCWloaPP/7Yb/DWHNfuPn36YP369XjggQcwf/58dOzYEQsWLEB+fn6D96nRaNCvXz9s374dQ4cO9Vo/bNgw7NmzB0OGDPEI12fMmIGCggK8++67WL9+PXr16oWPP/4Ya9aswaZNmxp1Pg3VFMdWKpX48MMPMXfuXMyePRtWqxXLli1j8EZE5zVBbI0ZqImIiFrZ4sWLcf/99+PUqVNITExs7e60OrvdjujoaPzjH/8452G4mzZtwujRo7FmzZp672xI7ceoUaNQVFSEv/76q852LfX+cFVz7tq1q9mO0R7Fxsbi5ptvxksvvdTaXSEiImoXWPFGRETtnsFg8JiI3Wg04t1330XXrl0vyNDNaDRCrVZ7DCtdsWIFSkpKMGrUqNbrGFETEUURmzZt8jmUkfzbv38/DAYDHnnkkdbuChERUbvB4I2IiNq9f/zjH0hOTkbfvn1RXl6Ojz/+GIcOHWqyCdPPNzt27MD999+PyZMnIyoqCr/99huysrKQkZGByZMnt3b3iM6ZIAgoLCxs7W6cd9LT01FRUdHa3SAiImpXGLwREVG7N378ePznP//BypUrYbPZ0KtXL3zyySe44YYbWrtrrSI1NRVJSUl44403UFJSgsjISNx8881YuHAhVCpVa3ePiIiIiKjd4BxvREREREREREREzSDw+8sTERERERERERFRvRi8ERERERERERERNYN2P8eb3W5HXl4eQkJCPO7eRkREREREREREFxZRFFFZWYmEhATIZM1fj9bug7e8vDwkJSW1djeIiIiIiIiIiKiNOHnyJDp27Njsx2nV4O3nn3/GSy+9hD179iA/Px9fffUVrrnmGmm9KIp48skn8f7776OsrAzDhg3D0qVL0bVr1wYfIyQkBIDjExoaGtrUp0DnAYvFgh9++AHjxo2DUqls7e4QUSvgdYCIAF4LiIjXASICSkpKkJaWJuVFza1Vg7fq6mpcdNFFmDVrFv7xj394rX/xxRfxxhtv4MMPP0RaWhqeeOIJjB8/HgcOHIBGo2nQMVzDS0NDQxm8XaAsFgt0Oh1CQ0P5w5XoAsXrABEBvBYQEa8DROS4DgBosenIWjV4mzhxIiZOnOhznSiKWLx4MR5//HFcffXVAIAVK1YgNjYWX3/9NW688Uaf25lMJphMJul1RUUFAMcn1vXJpQuL6+vOrz/RhYvXASICeC0gIl4HiKjlv//b7Bxv2dnZKCgowJgxY6RlYWFhGDRoELZv3+43eHvhhRewYMECr+U//PADdDpds/WX2r4NGza0dheIqJXxOkBEAK8FRMTrANGFTK/Xt+jx2mzwVlBQAACIjY31WB4bGyut82Xu3Ll44IEHpNcVFRVISkrCuHHjONT0AmWxWLBhwwaMHTuW5eREFyheB4gI4LWAiHgdICKguLi4RY/XZoO3xlKr1VCr1V7LlUql3wurKIqwWq2w2WzN3b0Lklwuh0KhaLHx0/7U9R4gogsDrwNEBPBaQES8DhBdyFr6e7/NBm9xcXEAgDNnziA+Pl5afubMGfTt27fJjmM2m5Gfn9/ipYYXGp1Oh/j4eKhUqtbuChERERERERFRi2izwVtaWhri4uLwv//9TwraKioqsHPnTtxxxx1Ncgy73Y7s7GzI5XIkJCRApVK1elVWeyOKIsxmM86ePYvs7Gx07doVMpmstbtFRERERERERBcIURRhspmgt+qRV5XXosdu1eCtqqoKx44dk15nZ2dj7969iIyMRHJyMu677z48++yz6Nq1K9LS0vDEE08gISEB11xzTZMc32w2w263IykpiTdeaEZarRZKpRInTpyA2WyGRqNp7S4RERERERERURtks9tgsBqgt+qht+g9P1r1MFgc6wxWg/d6t48e66162EW7Y/+Glp1mrFWDt19//RWjR4+WXrtuinDLLbdg+fLlePjhh1FdXY3bbrsNZWVlGD58OL7//vsmD25YgdX8+DkmIiIiIiIiaj9EUYTFbvEZjnkFYG6Bmb/2rqDMaDO29qk1qVYN3kaNGgVRFP2uFwQBTz/9NJ5++ukW7BURERERERERUfthF+0wWo1+q8N8hWW1K8ZqtzNYDLCK1tY+NZ/kghw6pQ46hc7rIwzAQRxssb602TneiIiIiIiIiIguNK4qsvqGUvqqFvM3BNNgNbT2afmlkWugU+qgVWhrQjIfgZlrvUc7P+2VMqXfOfyLi4vxFt5qsfNj8EZEREREREREFCBRFGG0GeucV8xfYFZ72KX7nGYWu6W1T80nmSDzCLl8BmDKWusVOmiV2jrDNLlM3tqn1qwYvJ3Htm/fjuHDh2PChAn47rvvfLZZvXo1pk+fjtmzZ+OttzwT3U2bNnnMsRcTE4Phw4fjpZdeQqdOnQAAqampuO+++3Dfffc123kQERERERERtQSLzYJTVad8B2V1VJX5mp/MYDVAhP/ps1qTSqbyDrlcAZifKjH3IM1XqKaWq/1WkZF/DN7OY1lZWbjnnnuQlZWFvLw8JCQk+Gzz8MMP491338Urr7zi88YUhw8fRkhICI4ePYrbbrsNV155Jfbt2we5vH2nzkRERERERNT+2ew27CrYhXXZ6/DjiR9Raals7S5JBAg+Q666qsT8hWWu7bQKLZQyZWufGjkxeDtPVVVV4dNPP8Wvv/6KgoICLF++HPPmzfNok52djW3btuGLL77Axo0b8eWXX2Lq1Kle+4qJiUF4eDji4+Mxf/58TJs2DceOHUP37t1b6nSIiIiIiIiImowoiviz6E+szV6L9TnrUWQoOud9KmVKz5DLvUKsdjWZnznIaodsGrmGVWTtHIO3Wq58cwvOVppa/LjRIWp8c8/wBrf/7LPP0KNHD3Tv3h3Tp0/Hfffdh7lz53p8wy5btgyTJk1CWFgYpk+fjqysLJ/BmzutVgsAMJvNjTsRIiIiIiIiolbyd9nf+O74d1iXvQ6nqk55rdcpdBiWOAyRmsg6J/L3NVeZUs4qMgocg7dazlaaUFBhbO1u1CsrKwvTp08HAEyYMAHl5eXYvHkzRo0aBQCw2+1Yvnw53nzzTQDAjTfeiH//+9/Izs5GWlqaz33m5+fj5ZdfRmJiIqvdiIiIiIiI6LyQV5WHddnrsC57HQ6XHvZar5QpMaLjCGSmZWJExxHQKLynYCJqLgzeaokOUbf54x4+fBi7du3CV199BQBQKBS44YYbkJWVJQVvGzZsQHV1NTIzMwEAHTp0wNixY/HBBx/gmWee8dhfx44dIYoi9Ho9LrroInzxxRdQqVRNc2JERERERERETazEWIIfcn7A2uy1+L3wd6/1MkGGgXEDkZmWictTLkeoKrQVeknE4M1LIMM9W0tWVhasVqvHzRREUYRarcaSJUsQFhaGrKwslJSUSENHAUcV3L59+7BgwQLIZDJp+S+//ILQ0FDExMQgJCSkRc+FiIiIiIiIqCGqLdX4KfcnfJf9HXbk7YBNtHm16RPdB5lpmRifOh4dtB1aoZdEnhi8nWesVitWrFiBV155BePGjfNYd80112D16tWYPHky/t//+3/45JNPkJ6eLq232WwYPnw4fvjhB0yYMEFanpaWhvDw8JY6BSIiIiIiIqIGMdvM+OX0L1h7fC02n9oMk817TvbOYZ2R2SkTE9MmIikkqRV6SeQfg7fzzLfffovS0lL861//QlhYmMe66667DllZWTAajYiKisKUKVO87o6SmZmJrKwsj+CtPqdPn8bevXs9lqWkpCAiIqLR50FERERERETki81uw+4zu7H2+Fr8eOJHVFoqvdrEB8VjYtpEZKZloltEN94ZlNosBm/nmaysLIwZM8YrdAMcwduLL76IPXv24I477vB54bnuuuvwz3/+E0VFDb+V8ssvv4yXX37ZY9lHH30k3dyBiIiIiIiI6FyIoog/i/7Euux1+D7nexQZvP9mjVBHYFzqOEzqNAkXRV8EmSDzsSeitoXB23nmm2++8btu4MCBEEWxzu2nTJmCKVOmAABGjRpVb/ucnJyA+0hERERERETUEH+X/Y212Wux9vhanKo65bVep9BhTMoYTEybiEHxg6CUKVuhl0SNx+CNiIiIiIiIiFpMflU+1uWsw9rja3G49LDXeqVMiREdRyAzLRMjOo6ARqFphV4SNQ0Gb0RERERERETUrEqMJdiQswFrs9fit8LfvNbLBBkGxg1EZlomLk+5HKGq0FboJVHTY/BGRERERERERE2u2lKNn3J/wtrstdietx020ebVpk+HPsjslInxqePRQduhFXpJ1LwYvBERERERERFRkzDbzPjl9C9Yl70Om05ugslm8mrTOawzMjtlYmLqRCSFJrV8J4laEIM3IiIiIiIiImo0m92G3Wd2Y+3xtfjxxI+otFR6tYkPisfEtInITMtEt4huEAShFXpK1PIYvBERERERERFRQERRxF9Ff2Ft9lp8n/M9igxFXm0i1BEYlzoOkzpNwkXRF0EmyFqhp0Sti8EbERERERERETXI8bLj+C77O6zLXoeTlSe91usUOlyefDkyO2ViUPwgKGXKVuglUdvB4I2IiIiIiIiI/Mqvyse6nHVYe3wtDpce9lqvlClxaeKlyOyUiREdR0Cr0LZCL4naJgZvREREREREROSh1FiKH3J+wNrstfit8Dev9TJBhoFxA5GZlonLUy5HqCq0FXpJ1PYxeCMiIiIiIiIiVFuq8VPuT1ibvRY78nbAKlq92vTp0AcT0yZifOp4ROuiW6GXROcXzmx4Htu+fTvkcjkmTZrksTwnJweCIEAul+P06dMe6/Lz86FQKCAIAnJycgAAo0aNgiAIfh+bN28GAMyYMQOCIGDhwoUe+/z66695RxoiIiIiIqLzkNlmxk+5P+HBzQ9i1KejMG/LPGw5vcUjdOsU1gl3970ba69di5WTVmJ6r+kM3YgaiBVv57GsrCzcc889yMrKQl5eHhISEjzWJyYmYsWKFZg7d6607MMPP0RiYiJyc3OlZV9++SXMZrPHtmazGZMmTYJGo8GgQYOk5RqNBosWLcLtt9+OiIiIZjozIiIiIiIiai42uw27z+zGuux12HBiAyrNlV5t4oPiMTFtIjLTMtEtohuLLYgaicHbeaqqqgqffvopfv31VxQUFGD58uWYN2+eR5tbbrkFy5Yt8wjeli1bhltuuQXPPPOMtCwyMtJr/7feeiuKioqwe/duaDQaafmYMWNw7NgxvPDCC3jxxReb4cyIiIiIiIioqYmiiL+K/sLa7LVYn7MeZw1nvdpEqCMwLnUcMtMy0TemL2QCB8kRnSsGb7W9OxKoKmz54wbHALdvbnDzzz77DD169ED37t0xffp03HfffZg7d67HfyGuuuoqvPPOO9iyZQuGDx+OLVu2oLS0FFdeeaVH8Fbb22+/jRUrVmDjxo3o2LGjxzq5XI7nn38eU6dOxZw5c7zWExERERERUdtxvOw41mavxdrstThZedJrvU6hw+XJl2Ni2kQMThgMpUzZCr0kar8YvNVWVQhU5rV2L+qVlZWF6dOnAwAmTJiA8vJybN68GaNGjZLaKJVKTJ8+HR988AGGDx+ODz74ANOnT4dS6f9C+vPPP+O+++7D22+/jaFDh/psc+2116Jv37548sknkZWV1aTnRUREREREROcmvyof63LWYV32OhwqOeS1XilT4tLES5HZKRMjOo6AVqFthV4SXRgYvNUWHNPmj3v48GHs2rULX331FQBAoVDghhtuQFZWlkfwBgCzZs3C0KFD8fzzz2PNmjXYvn07rFbvO9MAQG5uLq6//nrcdttt+L//+786+7Bo0SJcdtllePDBBxvcbyIiIiIiImoepcZS/JDzA9Zmr8Vvhb95rZcJMgyIG4BJaZNwecrlCFWFtkIviS48DN5qC2C4Z2vJysqC1Wr1uJmCKIpQq9VYsmSJR9vevXujR48euOmmm9CzZ09kZGRg7969Xvs0GAy49tprkZ6ejsWLF9fbhxEjRmD8+PGYO3cuZsyYcY5nRERERERERIGqtlTjp9yfsC57Hbbnbfe4E6lL7w69kZmWifGp43knUqJWwODtPGO1WrFixQq88sorGDdunMe6a665BqtXr8aECRM8ls+aNQt33nknli5d6ne///d//4eSkhKsX78eCkXD3hYLFy5E37590b1798BPhIiIiIiIiAJmtpmx5fQWrMteh00nN8FoM3q16RTWCZlpmZiYNhHJockt30kikjB4O898++23KC0txb/+9S+EhYV5rLvuuuuQlZXlFbzdeuutmDx5MsLDw33u86WXXsKaNWvwzTffwGq1oqCgwGN9WFgYtFrvMf+9e/fGtGnT8MYbb5zbSREREREREZFfNrsNv575FWuz12LDiQ2oNFd6tYkLisPEtImYlDYJ3SK6edx4j4haT5sO3mw2G5566il8/PHHKCgoQEJCAmbMmIHHH3/8gr2IZGVlYcyYMV6hG+AI3l588UVUVFR4LFcoFOjQoYPffb799tuwWCxegZ3LsmXL/A4nffrpp/Hpp582/ASIiIiIiIioXqIoYn/xfnx3/Dusz1mPs4azXm0i1BEYlzoOmWmZ6BvTFzJB1go9JaK6tOngbdGiRVi6dCk+/PBDpKen49dff8XMmTMRFhaGOXPmtHb3WsU333zjd93AgQMhiiIASB996du3r8f67OzsBh17+fLlXstSU1NhMpkatD0RERERERHV7XjZcazNXot12euQW5nrtV6n0OGy5MuQmZaJwQmDoZQpW6GXRNRQbTp427ZtG66++mpMmjQJgCPkWb16NXbt2tXKPSMiIiIiIiJqGgXVBViXvQ5rs9fiUMkhr/VKmRKXJl6KiZ0mYmTHkdAqvKcCIqK2qU0Hb0OHDsV7772HI0eOoFu3bvjjjz+wZcsWvPrqq363MZlMHhVYrmGXFosFFovFo63FYoEoirDb7bDb7c1zEgQAsNvtEEURFosFcrm8RY/t+rrX/voT0YWD1wEiAngtIKK2dR0oNZbifyf/h3U56/D72d+91gsQMCB2ACakTsBlSZchVBXqWCG2jf4Tna9a+vtHEOsak9jK7HY75s2bhxdffBFyuRw2mw3PPfcc5s6d63ebp556CgsWLPBavmrVKuh0Oo9lCoUCcXFxSEpKgkqlavL+Uw2z2YyTJ0+ioKAAVqv3La6JiIiIiIjaO5NowkHLQewz78Mx6zHY4V0A0lHeEX2UfZChykCoLLQVeknUvun1ekydOhXl5eUIDW3+77E2Hbx98skneOihh/DSSy8hPT0de/fuxX333YdXX30Vt9xyi89tfFW8JSUloaioyOsTajQacfLkSaSmpkKj0TTruVzojEYjcnJykJSU1OKfa4vFgg0bNmDs2LFQKjn/AdGFiNcBIgJ4LSCi1rkOmG1mbM/fjnU56/Dz6Z9htBm92qSGpiIzNRPjUsYhOSS5RfpFdKEqLi5GfHx8iwVvbXqo6UMPPYRHH30UN954IwCgd+/eOHHiBF544QW/wZtarYZarfZarlQqvS6sNpsNgiBAJpNBJuPdX5qTTCaDIAg+vw4tpTWPTURtA68DRATwWkBEzX8dsNlt+PXMr1iXvQ4/nPgBleZKrzZxQXGYmDYRmWmZ6B7RHYIgNFt/iKhGS/8O0KjgraysDJ9//jn+/vtvPPTQQ4iMjMRvv/2G2NhYJCYmNlnn9Hq9VyAml8s5HxsRERERERG1KaIoYn/xfnx3/Dusz1mPs4azXm3C1eEYnzoeE9Mm4uKYiyETWABC1N4FHLzt27cPY8aMQVhYGHJycnDrrbciMjISX375JXJzc7FixYom69yVV16J5557DsnJyUhPT8fvv/+OV199FbNmzWqyYxARERERERE11vHy41h7fC3WZa9DbmWu13qtQovLky/HxLSJGJIwBEoZK26JLiQBB28PPPAAZsyYgRdffBEhISHS8szMTEydOrVJO/fmm2/iiSeewJ133onCwkIkJCTg9ttvx/z585v0OEREREREREQNVVBdgHXZ67Auex0Olhz0Wq+UKTE8cTgyO2ViZMeR0Cq0rdBLImoLAg7edu/ejXfffddreWJiIgoKCpqkUy4hISFYvHgxFi9e3KT7JSIiIiIiIgpEqbEUG05swNrstdhzZo/XegECBsYNRGanTFyefDnC1GGt0EsiamsCDt7UajUqKiq8lh85cgTR0dFN0ikiIiIiIiKi1qa36PHTyZ+w9vhabM/bDqto9WqTEZWBzE6ZGJ86HjG6mFboJRG1ZQHP5HjVVVfh6aefhsViAQAIgoDc3Fw88sgjuO6665q8g+TbjBkzIAgCZs+e7bXurrvugiAImDFjhkfb2o8JEyZg06ZNPte5PzZt2gQAOHXqFFQqFTIyMlrwTImIiIiIiFqOxWbBxtyNeGjzQxj56UjM/WUufjn9i0folhaWhrv63oXvrv0Oq69YjX/2+idDNyLyKeCKt1deeQXXX389YmJiYDAYMHLkSBQUFGDIkCF47rnnmqOP5EdSUhI++eQTvPbaa9BqHXMGGI1GrFq1CsnJyR5tJ0yYgGXLlnksU6vVCAoKQn5+vrTs3nvvRUVFhUfbyMhIAMDy5csxZcoU/Pzzz9i5cycGDRrUXKdGRERERETUYmx2G/ac2YO12Wux4cQGVJi9R3nFBcVhYupEZHbKRPeI7hAEoRV6SkTnm4CDt7CwMGzYsAFbt27FH3/8gaqqKlxyySUYM2ZMc/SP6nDJJZfg77//xpdffolp06YBAL788kskJycjLS3No61arUZcXJzP/bgv12q1MJlMXm1FUcSyZcvw9ttvo2PHjsjKymLwRkRERERE5y1RFHGg+AC+y/4O32d/j7OGs15twtXhGJcyDpmdMnFxzMWQCQEPGiOiC1xAwZvFYoFWq8XevXsxbNgwDBs2rLn61Wpu+PYGFBmKWvy4HbQd8OkVnwa83axZs7Bs2TIpePvggw8wc+ZMaXhoU9m4cSP0ej3GjBmDxMREDB06FK+99hqCgoKa9DhERERERETN6aztLJbuW4r1J9YjtzLXa71WocVlyZchMy0TQxKGQClTtkIviai9CCh4UyqVSE5Ohs1ma67+tLoiQxEK9YWt3Y0Gmz59OubOnYsTJ04AALZu3YpPPvnEK3j79ttvERwc7LFs3rx5mDdvXoOOk5WVhRtvvBFyuRwZGRno1KkT1qxZI80jR0RERERE1BaZbCb8duY3bM/bjl9O/4JjlceAvzzbKGQKXJp4KTLTMjEyaSS0Cm3rdJaI2p2Ah5o+9thjmDdvHj766CNp7q/2pIO2w3l13OjoaEyaNAnLly+HKIqYNGkSOnTw3tfo0aOxdOlSj2UN/fqVlZXhyy+/xJYtW6Rl06dPR1ZWFoM3IiIiIiJqU0RRxPHy49h6eiu25W/DnoI9MNqMXu0ECBgYNxCZnTJxefLlCFOHtUJviai9Czh4W7JkCY4dO4aEhASkpKR4DTX87bffmqxzraExwz1b26xZs3D33XcDAN566y2fbYKCgtClS5dG7X/VqlUwGo0ec7qJogi73Y4jR46gW7dujdovERERERFRUygzlmFH/g5sy9uGbXnbcEZ/xmc7AQIS5YmYctEUTOo8iXciJaJmF3Dwds011zRDN+hcTJgwAWazGYIgYPz48U2+/6ysLPz73//2qm6788478cEHH2DhwoVNfkwiIiIiIiJ/LHYL9p3d5wjaTm/D/uL9ECH6bBuji8HQhKEYljAMl3S4BNt/2o7MHplQKjl3GxE1v4CDtyeffLI5+kHnQC6X4+DBg9JzX0wmEwoKCjyWKRQKn8NS3e3duxe//fYbVq5ciR49enisu+mmm/D000/j2WefhUIR8FuJiIiIiIiowU5WnMTWvK3YlrcNuwp2odpS7bOdWq5G/9j+GJowFEMThqJzeGcIggDAccNAIqKWxLSknQgNDa1z/ffff4/4+HiPZd27d8ehQ4fq3C4rKwu9evXyCt0A4Nprr8Xdd9+NtWvX4qqrrgq800RERERERH5Umiuxq2AXtudtx9bTW3Gq6pTftt0iuklB2yWxl0AtV7dgT4mI/As4eLPZbHjttdfw2WefITc3F2az2WN9SUlJk3WO/Fu+fHmd67/++muPtvW197ffN99802/buLi4dn2HWyIiIiIiajk2uw0Hig9ga95WbM/bjj/O/gGb6PvvjUhNJAbHD8awxGEYEj8E0broFu4tEVHDBBy8LViwAP/5z3/w73//G48//jgee+wx5OTk4Ouvv8b8+fObo49ERERERETUDhVUF0g3RNiRvwPlpnKf7RQyBS6JuQRDEoZgaMJQ9IjsAZkga+HeEhEFLuDgbeXKlXj//fcxadIkPPXUU7jpppvQuXNn9OnTBzt27MCcOXOao59ERERERER0ntNb9NhzZo8Uth0vP+63bWpoquOmCInD0D+2P3RKXQv2lIioaQQcvBUUFKB3794AgODgYJSXO/4jccUVV+CJJ55o2t4RERERERHReUsURRwpPSLdFOG3M7/BYvd9g4MQVQgGxw+W5mpLCE5o4d4SETW9gIO3jh07Ij8/H8nJyejcuTN++OEHXHLJJdi9ezfUak5gSUREREREdCErMhRhe952bM/bjm1521BsLPbZTibI0KdDH0fQljgU6VHpUMh4/z8ial8Cvqpde+21+N///odBgwbhnnvuwfTp05GVlYXc3Fzcf//9zdFHIiIiIiIiaqPMNjN+L/xduinCoZJDftsmBCVgaOJQDEsYhoHxAxGqCm3BnhIRtbyAg7eFCxdKz2+44QYkJydj+/bt6Nq1K6688som7RwRERERERG1LaIoIrsiG9tOO+Zp+/XMrzBYDT7bahVaDIobhCEJQzAscRiSQ5IhCEIL95iIqPWccx3vkCFDMGTIkKboCxEREREREbVB5aZy7MjfId0UoaC6wG/bXlG9pHna+kb3hVKubMGeEhG1LY0K3o4ePYqNGzeisLAQdrvdY938+fObpGNERERERETUOqx2K/4s+hNbTzuGj/5V/Bfsot1n22httBS0DU4YjEhNZAv3loio7Qo4eHv//fdxxx13oEOHDoiLi/MoExYEgcEbERERERHReehU5Smpom1n/k5UWap8tlPL1egX208K27qEd+HwUSIiPwIO3p599lk899xzeOSRR5qjP0RERERERNQCqi3V2JW/S7opQm5lrt+2XcK7YGiC46YIl8ReAo1C04I9JSI6fwUcvJWWlmLy5MnN0RdqoHfeeQcPPfQQSktLoVA4voRVVVWIiIjAsGHDsGnTJqntpk2bMHr0aBw7dgyXX345Tpw4gdWrV+PGG2/02Gd6ejoOHDiAZcuWITU1FaNHj66zDxs3bsSoUaOa+tSIiIiIiKiZ2EU7DhYfxNa8rdiWtw1/FP4Bq2j12TZCHYHBCYMxNGEohsQPQWxQbAv3loiofQg4eJs8eTJ++OEHzJ49uzn6Qw0wevRoVFVV4ddff8XgwYMBAL/88gvi4uKwc+dOGI1GaDSO/0Bt3LgRycnJ6Ny5MwAgKSkJy5Yt8wjeduzYgYKCAgQFBQEAhg4divz8fGn9vffei4qKCixbtkxaFhnJeRuIiIiIiNq6M9VnpOGjO/J3oMxU5rOdQlCgb0xfx/DRxKHoGdkTMkHWsp0lImqHGhS8vfHGG9LzLl264IknnsCOHTvQu3dvKJWed6iZM2dO0/aQvHTv3h3x8fHYtGmTFLxt2rQJV199NX766Sfs2LFDqkZzVby5TJs2Da+99hpOnjyJpKQkAMAHH3yAadOmYcWKFQAAlUqFuLg4aRutVguTyeSxjIiIiIiI2h6D1YDfzvwmDR89VnbMb9uU0BQMiR+CYYnDMCBuAIKUQS3YUyKiC0ODgrfXXnvN43VwcDA2b96MzZs3eywXBOG8D96yr7se1qKiFj+uokMHpH3xeYPbjx49Ghs3bsSjjz4KwFHZ9vDDD8Nms0nDQA0GA3bu3IlZs2ZJ28XGxmL8+PH48MMP8fjjj0Ov1+PTTz/F5s2bpeCNiIiIiIjOD6Io4kjpEWzP246teVvx25nfYLabfbYNUYZgUPwgDEkYgqEJQ9ExpGML95aI6MLToOAtOzu7ufvRZliLimA9c6a1u1Gv0aNH47777oPVaoXBYMDvv/+OkSNHwmKx4J133gEAbN++HSaTyWu+tlmzZuHf//43HnvsMXz++efo3Lkz+vbt2wpnQUREREREgSo2FGNH/g5pCGmRwXfhgEyQIaNDhnRThIwOGVDIAp5tiIiIzsE5X3WtViuMRiOCg4Oboj+tTtGhw3lx3FGjRqG6uhq7d+9GaWkpunXrhujoaIwcORIzZ86E0WjEpk2b0KlTJyQnJ3tsO2nSJNx+++34+eef8cEHH3hUxBERERERUdtisVmw9+xebD3tuCnCwZKDftvGB8U75mlLGIpB8YMQpg5rwZ4SEVFtDQ7evvnmGxQXF2PGjBnSsueeew7PPPMMrFYrLrvsMnz66aeIiIhojn62mECGe7amLl26oGPHjti4cSNKS0sxcuRIAEBCQgKSkpKwbds2bNy4EZdddpnXtgqFAv/85z/x5JNPYufOnfjqq69auvtEREREROSHKIrIqciRKtp2F+yGwWrw2Var0GJA3AApbEsNTYUgCC3cYyIi8qfBwdurr76K66+/Xnq9bds2zJ8/H08//TR69uyJxx57DM888wxeffXVZukoeRs9ejQ2bdqE0tJSPPTQQ9LyESNGYN26ddi1axfuuOMOn9vOmjULL7/8Mm644YbzPiwlIiIiIjrflZvKsatgF7aedtwUIa86z2/bnpE9paCtb0xfqOSqFuwpEREFosHB2/79+z1Ctc8//xxjx47FY489BgDQaDS49957Gby1oNGjR+Ouu+6CxWKRKt4AYOTIkbj77rthNpu95ndz6dmzJ4qKiqDT6Vqqu0RERERE5GS1W/FX0V9SVdufRX/CLtp9tu2g7YChCUMxJGEIhsQPQZQ2qoV7S0REjdXg4K2yshJRUTUX+C1btmDy5MnS6/T0dOTl+f+vDDW90aNHw2AwoEePHoiNjZWWjxw5EpWVlejevTvi4+P9bu/+9SQiIiIiouZ1uuq0I2g7vQ0783ei0lLps51KpsIlsZdIVW3dIrpx+CgR0XmqwcFbYmIiDh48iOTkZFRVVeGPP/7Aa6+9Jq0vLi5uluqp06dP45FHHsG6deug1+vRpUsXLFu2DP3792/yY51vUlNTIYqi1/KUlBSfy3NycurcX1lZmc/ly5cvb0TviIiIiIgubHqLHrsLdmNrnmP4aE5Fjt+2ncM6Y2iiI2jrF9sPWoW25TpKRETNpsHB2+TJk3Hfffdh3rx5WLt2LeLi4jB48GBp/a+//oru3bs3aedKS0sxbNgwjB49GuvWrUN0dDSOHj3KOcmIiIiIiKjNsYt2HCw5iO1527H19FbsPbsXVrvVZ9swdRiGxA+RhpDGBcW1cG+JiKglNDh4mz9/Pk6fPo05c+YgLi4OH3/8MeRyubR+9erVuPLKK5u0c4sWLUJSUhKWLVsmLUtLS2vSYxARERERETVWob7QEbTlbcWOvB0oNZX6bKcQFOgT3QfDEodhaMJQ9IzsCblM7rMtERG1Hw0O3rRaLVasWOF3/caNG5ukQ+7++9//Yvz48Zg8eTI2b96MxMRE3Hnnnbj11lv9bmMymWAymaTXFRUVAACLxQKLxeLR1mKxQBRF2O122O2+JzKlpmG32yGKIiwWi0dg2xJcX/faX38iunDwOkBEAK8F1DSMViN+P/s7duTvwPaC7ThWdsxv247BHTEk3nFDhP6x/RGsDJbW2W122G38G6Sl8TpARC39/S+IviYDayM0Gg0A4IEHHsDkyZOxe/du3HvvvXjnnXdwyy23+NzmqaeewoIFC7yWr1q1ymsOOoVCgbi4OCQlJUGl4i24m5PZbMbJkydRUFAAq9V3uT0RERERUVsjiiIK7YU4ZjmGo9ajyLHmwArfv8+qoUYnZSd0UXRBF0UXRMl5MzMiorZGr9dj6tSpKC8vR2hoaLMfr00HbyqVCv3798e2bdukZXPmzMHu3buxfft2n9v4qnhLSkpCUVGR1yfUZDIhNzcXKSkp0Go5eWlzMhgMOHHiBJKTk6FWq1v02BaLBRs2bMDYsWOhVCpb9NhE1DbwOkBEAK8F1HClxlLsLNiJ7QXbsSN/B84azvpsJ0BAelQ6hsQPweC4wcjokAGljO+ttozXASIqLi5GfHx8iwVvDR5q2hri4+PRq1cvj2U9e/bEF1984XcbtVrtM9hRKpVeF1aZTAZBEGA0GhEUFNQ0nSafjEYjBEGAVqtt8aGmLr7eA0R0YeF1gIgAXgvIm8Vmwd6ze6W52g4WH4QI3/UJsbpYDEschiEJjiGkYeqwFu4tNQVeB4guXC39vd+mg7dhw4bh8OHDHsuOHDmClJSUJtm/XC5HeHg4CgsLAQA6nQ6CIDTJvslBFEXo9XoUFhYiPDy81UI3IiIiIiIXURSRW5mLbXnbsO30Nuwq2AW9Ve+zrUauQf+4/hiW4LgpQlpYGv9mICKiBgsoeLNYLJgwYQLeeecddO3atbn6JLn//vsxdOhQPP/885gyZQp27dqF9957D++9916THSMuznHbblf4Rs0jPDxc+lwTEREREbUkURRxRn8G+87uw478HdiWtw2nq077bd89ojuGJg7F0IShuDjmYqjlLTtVChERtR8BBW9KpRL79u1rrr54GTBgAL766ivMnTsXTz/9NNLS0rB48WJMmzatyY4hCALi4+MRExPDO9s0E6VSyUo3IiIiImox5aZy7C/ej7+K/sKfRX/ir6K/UGQo8ts+UhOJoQmOoG1IwhB00HZowd4SEVF7FvBQ0+nTpyMrKwsLFy5sjv54ueKKK3DFFVc0+3HkcjnDISIiIiKi84zJZsKhkkP4q+gv6ZFTkVPnNkqZEpfEXCJVtXWL6AaZIGuZDhMR0QUl4ODNarXigw8+wI8//oh+/fp53ZTg1VdfbbLOERERERERudjsNuRU5EhVbH8W/YkjpUdgtVvr3C5EFYKMqAxkdMhA35i+6B/bHzqlroV6TUREF7KAg7e//voLl1xyCQDHjQ7ccZJRIiIiIiJqCq552dyHi+4v3o9qS3Wd26lkKvSI6oHeHXojPSodvTv0RnJoMivaiIioVQQcvG3cuLE5+kFERERERBewQOdlAwABAjqFdUJGhwz07tAbGdEZ6BbeDUq5soV6TUREVLeAgzeXY8eO4e+//8aIESOg1WohiiIr3oiIiIiIqF4mmwmHSw5LAVtD5mUDgLigOGnIaO8OvdErqheCVcHN32EiIqJGCjh4Ky4uxpQpU7Bx40YIgoCjR4+iU6dO+Ne//oWIiAi88sorzdFPIiIiIiI6D9lFO7LLsz1CtsOlh+ufl00ZgowONSFbRocMROuiW6jXRERETSPg4O3++++HUqlEbm4uevbsKS2/4YYb8MADDzB4IyIiIiK6QDV2XjalTImekT09gjbOy0ZERO1BwMHbDz/8gPXr16Njx44ey7t27YoTJ040WceIiIiIiKhtqzBXOMK1ov1S0HbWcLbObbzmZeuQgW4RnJeNiIjap4CDt+rqauh03rfeLikpgVqtbpJOERERERFR29LYedlidbFSwMZ52YiI6EITcPB26aWXYsWKFXjmmWcAAIIgwG6348UXX8To0aObvINERERERNSy7KIdOeU5+LPoTyloC3ReNtcjRhfTQr0mIiJqewIO3l588UVcfvnl+PXXX2E2m/Hwww9j//79KCkpwdatW5ujj0RERERE1Ew4LxsREVHzCTh4y8jIwJEjR7BkyRKEhISgqqoK//jHP3DXXXchPj6+OfpIRERERERNpMJcgf1F+z2CtobMy5YWliYFbL079Oa8bERERA0QcPAGAGFhYXjssceaui9ERERERNSE3Odlc90AgfOyERERtZxGBW+lpaXIysrCwYMHAQC9evXCzJkzERkZ2aSdIyIiIiKihjmXednSO6RLQRvnZSMiImo6AQdvP//8M6688kqEhYWhf//+AIA33ngDTz/9NL755huMGDGiyTtJRERERESezlR7zsv2V/FfAc/LltEhAymhKZyXjYiIqJkEHLzddddduOGGG7B06VLI5XIAgM1mw5133om77roLf/75Z5N3koiIiIjoQsZ52YiIiM5PAQdvx44dw+effy6FbgAgl8vxwAMPYMWKFU3aOSKi9kIURdcTz4dzmei+rlY71yLAz7bu23htK0qbemzv1k4UpQY++yeKYs32Ae5f2lY6iXr279U3UTqsY52fbV3rvLZ1LLNZrQg6cADVYWFQanUQVEoIShUElRIylQqCUglBpap5KJUQFI2ajYGI6JyZbWZpXjZX0NaQedlidDFe87KFqEKav8NERETkV8B/VVxyySU4ePAgunfv7rH84MGDuOiii5qsY0R0fhOtVogWi+NhNnt+bMRzu9kMOD/Wv53zo8Vc89xqqQlofAVUUsf9hFOu57XbuAKgOraltiERQP6HAfyDSCarCeHcAzmVUnouU6r8tKn9vCbok7atHfTVfq6stZ1SBZlKCSiVEASh2T5PRNSyOC8bERFR+xZw8DZnzhzce++9OHbsGAYPHgwA2LFjB9566y0sXLgQ+/btk9r26dOn6XpKRBJRFAFXyOQWSoluwZTfkMrsDKT8BVQNCcIaEH7Bbm/tTxPRubHbIRqNEI3G1u6Jl/qDPh8hobS8oUGh47lXRWBdz2WcI4qoPrXnZdtfvB9Vlqo6t1HKlOgR2UOqZOO8bEREROePgIO3m266CQDw8MMP+1wnCAJEUYQgCLDZbOfeQ6JWINrtjoqt2mGVuVZI1dgKribYjupWUzXk+AiFHAIEQHA+gJrngmMeHM9l7u3grDDyta1je0czX9u67b+x27qO7WdbCELd5yZVRwV6bvVvC0Hw08atb+ewf0F67b2tq53H/n31zfnz6Mjhw+jaqRNkNpv0vWQ3mz2/z92/12o/d3ttd4bbrUW6DlTXPYl6i1MoPEK/wCoCa4I+eASFvioAfVcTem3DYcPUytznZXM9Cg2F9W7XKayTx7xsXSO6QiVXtUCPiYiIqKkF/JtodnZ2c/SDqEFEUYRoMMBeXQ1bVRXs1XrYq6thr65yfqyGvaoKNul5NayVlUg4mYvTX30NwWqF3eIr/PKs9oK17uEdFzxB8Pyj1j3kashz1x/K0nP34XT+t3NV3sDtua+2UCg4FI88WCwWlKxdi6jMTCiVTTOpuCiK3sF4A54HFPY5K1I9hlq7B/9+AsJWY7U6/mnhfNlm/v3mGjasUkEeHAxZaCjkoaGQhYZAHhpW63mItN6x3PlRo2nts6A2jvOyERERkS8BB28pKSnN0Q9qx0S7HXa9wSsccz33CNCk5Y6PNmd4Jm1XXd2oIYzBAAxNf2rNRy6vVemhrCOw8gym4FzW0JAq4NCM1SNEAByVdoJKBajaVhWKKIqOAMyjqs+tWtejgraOqj6PQM/S8HDRYvYdEFosQGtVwrsNG7ZXVAB5eQHvQlCpagVytYK6kFDIw0J9h3bBwRyG28645mX7q/gv/HnWEbQdKj1U77xswcpgaT62jA4ZyIjKQGxQbAv1moiIiFoD/3omn0SbzSsk8w7B6gvPnM/1+tY+HW9KJWTOEAmu4VC1gy2/FVoNqeDyHDrlVdFVV7ilUEBwu2swEVEgBEGQAngAaEtXE9FtmK+voA/1BYW+wsJAhgybTLBVVcFWURHwUGHRbIatqAi2oqLAT1wQIAsJ8QzsQkIgCwv1Gd55hHahoY5/qlCr4rxsRERE1FgM3toR0WKpc/ilz/DMvfKsumZb0dB26sNkOh1kQUGOR3Cw23PHR7lrua52Gx3kwcGwqdX435YtGJeZCaVO5wi4OAyRiKjFCXI5BK0W0GpbtR+iKEI0GmGrqICtvBz2ykrYyitgr6yArbwCtgq355WVsJeXw1ZZ6VheXh74P5REEfaKCke1XSMIGo1nUOd67l5l53ruCu9CQiALC4MsKIg/8wJUaa7E/mLHvGyuaraGzMuWFpbmMWS0W0Q3zstGREREDN5akyiKjv/y+x1+We0IwtwryKqr/IZnrTqvjztB8BGUOUIw73DMR4Dm/lGrPefqL4vFArvrWE00txMREZ2/BEGAoNVCptVCGRv4MD/RanUEchUVzvDOPaircC6vhK2iHHZneGerKIe9whHeBTrkVjQaYTUagbNnA+4rZDIphJOHhDiDOrfnUmDnrMRzPXe2F9r5z83a87L9VfwXssvrn8+Y87IRERFRQzF4C5Drv+QNH37pIzxzbavXt+pd8TzI5c6wS+cIwIKC/Ydn7st13uGZoNPxv+tERNRuCQoFFBERQEREwNuKouj4vaDSWVnnCu8qKmGvKK+psqsod4Z3FR7PA65It9thKy+HrbwcjfmNQ9DpHHPWuVfZuQ2F9aqyc4Z38pCQNvf7gCiKyKnIwe/m37Fv9z4cKDnQ4HnZ0jukS0Eb52UjIiKiQAQcvJ08eRKCIKBjx44AgF27dmHVqlXo1asXbrvttibvYFOxVVXDYjA2cvilZ3jWmMn9m4OgVPqtHnOEYA0Mz4KCIKjVbeqXYyIiovZIEATIg4MgDw6CMj4+4O1Fs7lm2KsU2tWqsvN47ta2sjLg32FEvR5WvR7WgoKA+wqFwlFZ5yuoc5/vzr3iTprvLqRJbuRzpvoMdhbsxI68HdiRvwNnDc6qwaO+27vPy+Z6pIamcl42IiKi85jNLiK/3ICTJQacLNXj8IlG/F5zDgL+jWbq1Km47bbb8M9//hMFBQUYO3Ys0tPTsXLlShQUFGD+/PnN0c9zdmzkSAS3gQnrBY3GIyST1zH0UhYU5DMkkx6cbJmIiOiCIqhUUERFQREVFfC2ot3u+GeiW5VdnUFdhWdVnmgyBXZAqxW20lLYSksD7isAx+86vqrsfN1V1vkwaOX4TX8EO0r2YEfBznqHjXJeNiIiovOfKIooqTbjZKkBuSV6nCzR41SpXgraTpcaYLWLUnu7qWVvABlw8PbXX39h4MCBAIDPPvsMGRkZ2Lp1K3744QfMnj27zQZv50LQuYZf+g7JatbVDsl0XuFZU/z3loiIiChQgnO+N3lICJSJiQFvbzeZ/FfZOW9Q4R7e2SorHHPcVVTAXlkZ+PGcow+syA9ou3gAV8iB0WqgWuN6CDBq5QiKiIFJqUPPfsOR2n0AwpI6QREXB5lGE3D/iIiIqOVUm6w46QrTSvTO5zXhmt4c2By6LSngFMhisUCtVgMAfvzxR1x11VUAgB49eiA/P7BfjFqSduAAhERGNnxyf9fzJpjcn4iIiOh8J1OrIYuOhiI6OuBtRZsN9qoqxzDZct9BncddZV0Bn/OusmKAc+IqbUC43vFw9gCAFUCe4+XGYyjCchQ518ojIqCMj4ciPh7KuDgoE+KhiIuDMj7esTw6mv88JSIiakYWmx15ZY7hoLnuwVqpAadK9CiubtzNJIPVCnSM0CIpUoekCB2SIrUIlZlw/eKm7X9dAv4NIj09He+88w4mTZqEDRs24JlnngEA5OXlIaoRwx5aSvLSpQgNDW3tbhARERFdcAS53HGn1LAwwDlPcEPlVuRi14kt+OPvrTic+xvslZUIMogIMgFBRtdDRJARiLEHIdYWhDCzEhqDFWJFpWN+3npIQ2IPHPDdQCaDIibGLZSL93weHwd5ZCTnyyUiIvLDbhdxtsrkVq3mqFzLLdHjVKkB+eUGuI0GbTClXEBiuCtY0yJVJyBZZUWCzIoYwQydSQ97RaHjn3vHHP/0Kz1zpulPsA4BB2+LFi3Ctddei5deegm33HILLrroIgDAf//7X2kIKhERERFRY5QYS7Arfxd25DtuiHC66nTNyjAAYQIAR8AVo4vB4PjB6BE/GIPiByFGF+O1P9FqdVTOVVbCVFyMnevW4aKERNjPFsKanw9LfgEsBQWwnjnj/+YTdjusBQWwFhTAsHevzyaCWg1FXCyUcc4qufg45/M4qZpOHhx8bp8cIiKiNqzcYJHmV8t1GwZ60hmumawNuMmTKEJtMyPEYkCw2YBgix5JChuSlBbEyyzoADMi7EaEWgzQGquh0Fd5TIUBa83dykudj9qqbS07LDXg4G3UqFEoKipCRUUFIiIipOW33XYbdDpdk3aOiIiIiNo3vUWP3wp/w468HdhZsBOHSg75bRuiDMGAuAEYnDAYg+MHIzU0td4qM0GhgCIiAoiIgBAfj+rcXIRnZkKpVHq0E61WWM+edQRx+XmwFhQ4Q7l8WPPyYSkogK2kxO9xRJMJlhO5sJzI9dtGFhzsFco5hrc6n8fFQeac0oWIiKitMVpsOFXqCNNOOYeBuqrWTpboUWGsCb1UNguCzXoEWwwIsRjQ16xHiEXvDNOcD+eycJsRYTYjgs0GaIzVkNusdfSihtX5aOsaNVmFXC73CN0AIDU1tSn6U6eFCxdi7ty5uPfee7F48eJmPx4RERERNS2r3Yq/iv6SKtr+OPsHrHbfvzYrZUpcHHMxBsc7graeUT2hkDXPXGuCQiHN6QZc7LON3Wh0BHLOUM5akA+LM5RzPa9raKu9qgqmo0dhOnrUbxt5VJSfIa1xNfPNcf5hIiJqBja7iIIKo/OmBXqcPlOOwvwilJ4pQsXZEljKyqUqtGCLASFmA3pZ9BjkDNhcjxCzHio/P9ubgyw42HHX8/Aw513PQyEPc94RPSzc83VoGMrtNqBv3xbrX8C/uVx88cU+/7MoCAI0Gg26dOmCGTNmYPTo0U3SQZfdu3fj3XffRZ8+fZp0v0RERETUfERRxPHy41LQ9mvBr6iyVPlsK0BAj8geUkXbxTEXQ6vQtnCP/ZNpNFClpkJVxz+cbZWVsOTnuw1jzYc1vwCWfGdAl59f580ibMXFsBUXw7h/v+8GcjkUsTGOKrla88xJQ1rDwznfHBERAQBEi8UxDLO8ArayMpSfLcHZ/CKUnSlGZVEJjCVlsJaVQayshEJfBZ1ZjxCzAV0semTYAru50bmQ6XSQOeeDrR2UOeaJdX8dCnlYmON1SEjAN0DSFxc301n4FnDwNmHCBCxduhS9e/eW5nTbvXs39u3bhxkzZuDAgQMYM2YMvvzyS1x99dVN0smqqipMmzYN77//Pp599tkm2ScRERERNY+C6gLszN+Jnfk7sSN/B84azvptmxSSJFW0DYwbiHBNeMt1tBnIQ0IgDwkBunXzuV6022ErKXEL5bwDOuvZs/7nm7PZYM1zDH81+OmDoNFAGRsLRUK8nyGt8ZAHBzXNCRMRUbOT5istL4etvLwmSKsod8xvVuZcVlEOS1k5TKVlsJaVQ6iqhNxk9NqfEkC089GUBK22JjgLDXUEaaGhvoMz1/qwMEd4VmsKiPYk4OCtqKgI//73v/HEE094LH/22Wdx4sQJ/PDDD3jyySfxzDPPNFnwdtddd2HSpEkYM2ZMvcGbyWSCyWSSXldUVAAALBYLLAHeip7aB9fXnV9/ogsXrwNEzavSXIlfz/yKnQU7sevMLuRU5PhtG6GOwMC4gRgUNwgDYwciITjBY31zfp+2mWtBWBgUYWFQ9Ojuc7VoscBaVARrfr50UwdrwRnH6zMFsBScgb3U13TRzu2NRphPnID5xAm/bWQhIVDEOeaVUzjnl1PEOeaeU8TFQREbA0GlOudTJWpr2sx1gC44os0Ge5XzRgDl5dINAaSPXsucQVtFBcQG3KG7tsZOzGBRKGHRBUMMDoE8NBTqiDDoIiOginAM2ZRJoVooZM5hnTJnhVpjwjMRznnaWvB7sqW//wVRFAO6YWtYWBj27NmDLl26eCw/duwY+vXrh/Lychw6dAgDBgxAZWXlOXfwk08+wXPPPYfdu3dDo9Fg1KhR6Nu3r9853p566iksWLDAa/mqVat48wciIiKiJmAVrci15uJv69/42/o3TttOQ4TvXymVUCJNkYbOis7orOyMGFkMZIKshXvc/ghmMxTl5VCUl0NZWgZFeRmUZY7XirIyKMvKIDObz+kY1pAQWMPCYAkPgzUsHJbwcFhdzyPCYQsOBmT8WhLRBcRuh8xkglyvh8xggNxgqPmor/XaYIBcr695bvSuPGsuFpkclUodqlRax0elFtUqLSxaHUStBoJOB3mwBqoQHTShGgSHaqEK1kLUaSG248ozF71ej6lTp6K8vByhoaHNfryAQ1CNRoNt27Z5BW/btm2DRqMBANjtdun5uTh58iTuvfdebNiwocH7mzt3Lh544AHpdUVFBZKSkjBu3LgW+YRS22OxWLBhwwaMHTvW6w5mRHRh4HWA6NzYRTsOlx7GroJd2FmwE3vP7oXR5vsPCLkgR0ZUBgbGDcTAuIHoE9UHSnnb+L67kK4FoijCXlkJa34BrGecVXP5+bAWnHHeDMLxgNX/5NeKykooKiuhOXXKTwMFFDExNZVzrqo5two6WVgY55ujNuVCug6QJ1EUAZsNsNthN5lgd682c6s6s1VUeq5zVp3ZKypgr6ryPxVAE7MIclSptKhSalFVK0Rzf16pqlmmiQhHREwk4qLD0DFSh44RWnSM0CIpQovYUA3kMl6PAaC4rc/xds8992D27NnYs2cPBgwYAMAxx9t//vMfzJs3DwCwfv169G2CO0Ts2bMHhYWFuOSSS6RlNpsNP//8M5YsWQKTyQR5rbs6qdVqqH3chl2pVPLCeoHje4CIeB0gahhRFHGq8hR2FOzAjrwd2FWwC2WmMr/tu4R3keZp6xfbD8Gq4JbrbCNcMNeCqCjHIyPd52rRboetuNhxl9a8fMedWfNdd23Nc4R2Z88C/gbIWK2w5uXBmpfntwuCVuu4CYSPeeaUCY4bRMg4KoVawfl4HRDtdsBm8/xotXovt9m82olWqyMw8mhnh2hzLBedgZS0rcdrO0S723LptWs7P8s9+mCTjul1Djar93If51DTL8/9iDarx7Frlnvuo6UCM4+vmUwOa1AwTBodqpQ6lCk0KBbUKJFpnIGaFlUqnVt1Wk3IZpSrgFr/uAjTKpEUqUVShA5JkTr0i9QhKUKLpEgdEsO10Ch51+uGaOnv/YCDt8cffxxpaWlYsmQJPvroIwBA9+7d8f7772Pq1KkAgNmzZ+OOO+44585dfvnl+PPPPz2WzZw5Ez169MAjjzziFboRERERUeOUGEuwK3+XdPfR01Wn/baN1cU6graEwRgUNwjRuqaenplagiCTQREdDUV0NLS9e/tsI1ossJwprAnl8j0DOmteHmzl5X6PIRoMMGdnw5yd7beNLCwMynhHCKeIj4MyPsFxl9Y4Z1gXw/nmLmSu0Eg0WwCrxfHcaoVosUC0WCFaLY7wyeJcZ3GtNzvCJld7s2O91WRC+J/7UHr2LOSAI8BxBTl2G0SrzfO1zUew42e5aLcBVpvna4/l7iGUr3CqjtCpjupUamYyGeQhIR43CpCFhsKkCUKlUotSmRpnZRoU2JQ4ZVUg2yTHCbMMlUodDAq1V3hWF7VCho4RWvSOdARrjoBNi47OoC1Me36FxeTQqPn2pk2bhmnTpvldr9U2zW3fQ0JCkJGR4bEsKCgIUVFRXsuJiIiIqOH0Fj1+K/wNO/IcQdvh0sN+24YoQzAwfiAGxw/GoPhBSA1N5fDBC4SgVELVMRGqjol+29j1elgKzjiq5AoKnAGdo2LOUuB4iHq9/+3Ly2EqL4fp0CE/nRCg6NDBEcL5COgUcXFQdOgAgfPNeRFFEbBYakIpj9DKUhNKeYRWtde51ltqgiwp9KoVfFlqHUNaZ63VB+cxvNpbHf11f90MVUoxAIq/+bbJ90vNSBAAudzxfa5QOD66XsvlEORyQC6DIKv1Ua7wWi7I5RBUSunGANLdNsPCpDtuykJCUaXSIs+uwkkjcLLMhJOlepwscTxOlxlgsYmAr6k0FfCbtMgEID5M61G1lhypk153CFZDxuGg7U5jb3QBs9mMwsJC2GtdCJOTk8+5U0RERETUtKx2K/4q+kuqaPvj7B+w2n1XUChlSlwSc4lU0dYrqhfkMo40IN9kOh3UndKg7pTmc70oirCXlzuHsOY7quZcFXPO15YzZ/xX9IgirGfPwnr2LIz79vluo1RCGRtbUyUXHy+FcsqEBMeQ1tDQgAJjURQ9K6ncAqTAKq/8BVBuQZbZRyjltQ/nMbxCLLdj1GoPm63B50vNzD0k8giLGrjcV9gkkwEKuTNUalwIVbN9rXBKIQd8bC/IZYBMLn30t9y1vcdyV9/cXzf0nJvhnz16sxWnSg04WaJHbokeJ0sMOFmox8lDepwqPYUqU+OqDKOCVOjoCtScw0BdlWsJ4Voo5fwnwYUm4ODt6NGjmDVrFrZt2+axXBRFCIIAWzNf3Ddt2tSs+yciIiJqD0RRxPHy446gLW8Hdp/ZjWpLtc+2AgT0jOopVbRdHHMxtIqmGcFAJAgC5OHhkIeHQ9Ojh882ot0Oa1GRM4grgKUg3+2588YQRUX+55uzWGA5dQoWfzeCACDodI4ATqttWOUVh/Y1L6USgkJR83C+hlIBQaGUXksPldIRxCiUPtorIChVbvtyrPdqr1TAJgj4488/cXG//pCrlM4gSFYTCCncX8tqAiG593LXOo/lPgIyyGSsEm4FdruIM5VG5Ba7gjU9TpTUPC+qatydn4NUciRF6pzDP7XOgE3nXKZFkLrR9U3UTgX8jpgxYwYUCgW+/fZbxMfH8wJCRERE1EYUVBdgZ/5O7MjfgZ35O3HWcNZv2+SQZAyKH4TB8YMxMG4gwjXhLddRoloEmQzKmBgoY2Kgvegin21EsxmWwsKaKjkpoHNW0hUUwF7XfHN6PczHjzfXKbQsudwjmILSFUQpGxZk1RFMQdHAIEvldnyF2/GVtY7vWqas1b6V/o60WCyolMsRPH7ceXdzBfJWbbLiZKneZ7h2qsQAsy3wocoKmYDECEeg5grX3IeFRuiUzEEoIAEHb3v37sWePXvQw89/q4iIiIioZVSYK7C7YLc0T1tORY7ftpGaSAyKG+QYPho/CInB/ufsImqLBJUKqo4doerY0W8be3W1c0hrge8bQuTnQzSbawVTnhVUdQZZUjB1DkGWWzBVsy8fwZRSVdPWI8hScD47umD4qlrLdYZr51K1FhOids6t5jYc1PmIC9VAznnWqAkFHLz16tULRUVFzdEXIiIiIqqDyWbCH4V/SPO07S/eD7vo+7/5WoUW/WP7S1VtXSO6Qibwj3Vq32RBQVB37gx1586t3RUiaiBfVWuucO1UqQFma+BVaxqlDMnOCrXkyCAkR2qRHKWTqtg0Ss5bSi0n4OBt0aJFePjhh/H888+jd+/eXuW5oaGhTdY5IiIioguZXbTjUMkhaZ623wt/h9Fm9NlWLsjRu0NvDE4YjMHxg9GnQx8o5RxGRURErctf1Zrr0diqtdjQmqq1lMggJEdppdfRwWoOB6U2I+DgbcyYMQCAyy+/3GN5S91cgYiIiKi9EkURpypPYXv+duzI34HdBbtRZirz275LeBcMjncEbf1i+yFYFdxynSUiInLyV7WWW6LHySaoWnOEazpWrdF5KeDgbePGjc3RDyIiIqILUrGhGLsKdkk3RThdddpv21hdrCNoSxiMQXGDEK2LbsGeEhHRhaolqtaSI3VIidKxao3anYCDt5EjRzZHP4iIiIguCHqLHnvO7JHuPHq49LDftiHKEAyMHyhVtaWEpvCPECIiahYtUbXmHq6xao0uFA0K3vbt24eMjAzIZDLs27evzrZ9+vRpko4RERERtQcWuwX7i/Zje/527MzfiT/O/gGr3eqzrVKmxCUxl0jztPWM7Am5jH+UEBHRuau7as2AoipTo/Zbu2rNFa6xao3IoUHBW9++fVFQUICYmBj07dsXgiBAFEWvdpzjjYiIiC50oiji77K/sbNgJ3bk7cDuM7tRban22VaAgJ5RPaWKtotjLoZGoWnhHhMRUXuhN1sdQVozV625wjVWrRHVr0HBW3Z2NqKjo6XnRERERFSjoLpAmqNtR/4OFBmK/LZNDkmW5mkbGDcQYeqwFuwpERGdz+x2EYWVJpworm72qrVk580MWLVGdG4aFLylpKT4fE5ERER0IaowV2B3/m4paMupyPHbNlITiUHxgzAkfggGxQ9CQnBCy3WUiIjOO3qzFSdLDD7DtaauWnO9ZtUaUfMJ+OYKAHD06FFs3LgRhYWFsNs9v+nnz5/fJB0jIiIiaitMNhP+KPxDCtr2F++HXfT9h49WoUX/2P4YHD8Yg+IHoWtEV8gEWQv3mIiI2ipX1VpuiR4niqubv2otUofoEFatEbWWgIO3999/H3fccQc6dOiAuLg4j29eQRAYvBEREdF5zy7acajkkCNoy9uB3wp/g8nm+w8huSBHn+g+UtDWp0MfKOXKFu4xERG1Ja6qNV/hWnNUrXWM0EGrYtUaUVsUcPD27LPP4rnnnsMjjzzSHP0hIiIianGiKOJk5Umpom1XwS6Um8r9tu8S3kW6IUK/2H4IVgW3YG+JiKi1uVetOW5mUN0kVWsxIWrpjqCsWiNqHwIO3kpLSzF58uTm6AsRERFRiyk2FGNXwS6pqi2vOs9v21hdLIYkOOZoGxQ3CNG66BbsKRERtYbmqFpTK2TSHUFZtUZ0YQg4eJs8eTJ++OEHzJ49uzn6Q0RERNQs9BY99pzZI1W1HSk94rdtiCoEg+IGYVD8IAyOH4yU0BRWGRARtTPNWbXmuiMoq9aIKODgrUuXLnjiiSewY8cO9O7dG0ql5xwmc+bMabLOERERETWG2WbG0dKj2F+8HweKD+BA8QEcLT0Kq2j12V4lU+Hi2Iul4aM9I3tCLmPVARFRW2ezi6g2W1FtsqLaZHN+tKLKZEW12Yoqt2XVJhsqjWbs/1uG149uxamyc6ta8xWusWqNiGoLOHh77733EBwcjM2bN2Pz5s0e6wRBYPBGRERELcpis+BoWU3Itr9oP46WHYXV7jtkAwABAnpF9ZIq2i6OuRgahaYFe01EdGGy20XoLbaacEz6aIPe7L6sVohmsqLa7L7M8dxgsTWiFzIA1XW2kKrWfIRrrFojokAEFLyJoohNmzYhJiYGWq22ufpERERE5JPFbsGx0mOOgM0ZtB0pPQKL3VLndjJBhrTQNPSL7YfBCYMxMG4gwtRhLdRrIqLzlyiK0LsCL7PvwMz1XG/2EZiZHW2qTFbonftoC9yr1pKcc66xao2ImkPAwVvXrl2xf/9+dO3atbn6RERERASL3YLjZcc9KtmOlB6B2W6uczsBAtLC0pAelY5eUb2Q3iEd3SO6Q6fUtVDPiYhajyiKMFrstcKxmgDMIzBzqzCr9rnM8VoUW/usaihkAoLUCgSrFQhSy6XnOpXcbbnzo9synVqBYLUcahnw245fcOPVE6FSqVr7dIjoAhBQ8CaTydC1a1cUFxczeCMiIqImY7Vb8XfZ31Il28HigzhUcqhBIVtqWKojYHMGbT0ieyBIGdRCPSciOjeiKMJktTsrwmxuc5NZvYZVus9l5rm+JiSrNllhb0NBmVwmIEgll8KvIGcAFqSqCclcy3Qey+SeIZozXFMrZOc0zNNiseBvFThUlIhaTMBzvC1cuBAPPfQQli5dioyMjOboExEREbVjVrsV2eXZNZVsxftxpOQIjDZjvdumhjpCNlfQ1jOqJ0M2ImpxJqutVvWYa6hl7UDMc9il93rH0EtbG0rKZAIQpPIOv9wry2oHZv7WB6sV5xyUERGd7wIO3m6++Wbo9XpcdNFFUKlUXnO9lZSUNFnniIiI6Pxms9uQXZ6NAyWOoaIHig/gUMmhBoVsKaEp6BXpGCrqqmQLUYW0QK+JqD0QRRFmmx0Wmwiz1S49DBZf1WK+J+73Neyy2mSFxdZ2gjJBCsrchlq6va69zH3YpStgcw/KNEoGZURETSng4G3x4sXN0A0iIiI639nsNpyoOOFRyXao5BAMVkO92yaFJNXMyRaVjh5RPRCqCm2BXhPRuRJF0RFu2WrCLYvNDpMr7LI5XpvdXpt9rDO5bevRzk971zYWm73WsUWpbVvlmnvMVVXma9hlkBSW+R526dqHVimHTMagjIiorQo4eLvllluaox9ERER0HrGLduRU5Eg3PThQfAAHSw42KGTrGNxRuulBr6he6BnZk3cYJWqA2gGXz8DKT8Dlvs5k9Q7CPIIyn/sSYbba3I4temzf3mmVcp/DKt0DMPf1wbVCM495yhiUERFdUAIO3twZjUaYzZ6THoeG8r/TRERE7YldtCO3Iterkq3aUl3vtonBiR5zsvWK6sWQjdo894DLYvUTWPmqxqodWPlZ57+yyxVm2ZzHFr2CNKohCIBKLoNKIYNaIYPS+dy1TOm2TiWvee0rRPNddeZYrlMpIGdQRkREjRRw8FZdXY1HHnkEn332GYqLi73W22y2JukYERERtTy7aMfJypM1lWwlB3Cw+CCqLFX1bpsQlFBTyRbpCNvCNeHN32m6IImiKE1UX2m0oNJoRaXR6vXasczxusJgQUGhHFknd8BiA8xWm8ewRPeP5EmlkEHtCrZ8hFwqt3U+gy+FDEq5AJVc7tZOcHsud6xX+A/Sah9DLhM4FxkREbV5AQdvDz/8MDZu3IilS5fin//8J9566y2cPn0a7777LhYuXNgcfSQiIqJmIIpiTcjmrGY7WHwQlZbKereNC4rzmJOtV1QvRGgiWqDX1B6YrXa/gZnjoxUVRguq/IRpVc4J8Rt3J0gBqKxo8nNqKq6AS1kraJJCLLlbiKWQQaWQO9sJPtur5LVCLFf1Vx1BWu32CgZcREREjRZw8PbNN99gxYoVGDVqFGbOnIlLL70UXbp0QUpKClauXIlp06Y1Rz+JiIjoHIiiiFNVp6SA7UDRARwoOYBKc/0hW6wu1iNg6xXVC1HaqBboNbU1druIarP/MMxfpZkrTHM8LDC1gYqy2tVTSim4kntWY9UzbLF2lVft9v6CNF/tlXIGXERERO1NwMFbSUkJOnXqBMAxn1tJSQkAYPjw4bjjjjuatndEREQUMFEUcbrqtEcl24HiA6gw11/lE6OL8QrZOmg7tECvqTmJogiT1e5ZWWa0oqJWYOa3Cs312myF2JgisyaiUsgQqnHMvRWiUTo/KhCsUSBUo3Q8d63TONaFuL3WyERs+t8GXDlpIlQqVeudCBEREV0wAg7eOnXqhOzsbCQnJ6NHjx747LPPMHDgQHzzzTcIDw9vhi4SERGRP6IoIr86v+bGB8552cpN5fVuG62Nrhku6rzDKEO2tsdmFx3Bl8l3OOZRWSaFad7hmcXWeomZTIAUiNWEYwoEO197BGS1wjT312qF/Jz6YbFYoJCBVWVERETUYgIO3mbOnIk//vgDI0eOxKOPPoorr7wSS5YsgcViwauvvtocfSQiIiI4QraC6gKPSrb9xftRZiqrd9soTRTSO6R7VLLF6GKav9MXMFEUYbDYfFeWueYwcw7BdA/WXMMxXev05ta9cZVWKfeuHnOGYa5KstA6Ks1CNAroVHKGXURERHRBCjh4u//++6XnY8aMwaFDh7Bnzx506dIFffr0adLOvfDCC/jyyy9x6NAhaLVaDB06FIsWLUL37t2b9DhERERtjSiKOKM/4xGwHSw+iBJjSb3bRmoivW58EKOLYfARAIvNLg2vrPSoHvNfaVZZO0xr9OT/TUMuE6RqsmC10i0MUzjDMWWdlWYhGgWC1Aoo5bJWOwciIiKi813AwVttKSkpSElJaYq+eNm8eTPuuusuDBgwAFarFfPmzcO4ceNw4MABBAUFNcsxiYiIWpooiijUF3pVsjU0ZOsZ1dMjaIvVxV5QIZvVZofRaofBbIPR4ngYLDbHa7flruqzSqMFlT4qzdyHaRotrTv5f5BK7lE9Fqxu2Bxm7q81StkF9T4gIiIiaosaHLxlZmZi9erVCAsLAwAsXLgQs2fPluZ1Ky4uxqWXXooDBw40Wee+//57j9fLly9HTEwM9uzZgxEjRjTZcYiIiFrSWf1Zj4DtQPEBFBmK6t0uXB3uVckWFxTXJsMVURRhsYkwWm0wmp1BmMUGo8UzCPMIyVzrXevMNhitjnWOZXaY3NobLDaYLHaYba1/h0wXlVzmVlGm8JjXrHZA5grTpMDMWXUWrFZALmt7X1MiIiIiClyDg7f169fDZDJJr59//nlMmTJFCt6sVisOHz7c5B10V17umCg6MjLSbxuTyeTRz4oKxx3cLBYLLBZLs/aP2ibX151ff6ILV2teB4oMRThYchAHSg5IHxsSsoWpwtAzsid6RvZEr8he6BnVE/G6eK+QzWq1BtQfURRhttphcAZcJqsNBrO9Jgiz2qWgzGhxrxjzbO++3ugenFntUsDWmsMsAyU4J/8PVjsCsmBnUBasrh2iKRCsliNErUSwxv2j40YBasW5D8u026ywt+60bu0WfycgIl4HiKilv/8FUWzYTeFlMhkKCgoQE+OYiDkkJAR//PEHOnXqBAA4c+YMEhISYLM1z2+KdrsdV111FcrKyrBlyxa/7Z566iksWLDAa/mqVaug0+mapW9EREQAUGWvwmnbaeTZ8nDa6vhYIVbUu51G0CBBnog4WQJihEREIQFaMQIWuwCLHTBLH+H4aIPXctcy6bVznau9a1uLHRBx/lZTKWUiVDJAKUPNR7mf5TJAKQdUMlF6rZE7HwoRGjmglQMahWMdi8yIiIiI2j+9Xo+pU6eivLwcoaGhzX68c57jraXcdddd+Ouvv+oM3QBg7ty5eOCBB6TXFRUVSEpKwrhx41rkE0ptj8ViwYYNGzB27FgolcrW7g4RtYJzuQ645g8zug2VNFpsOFNdhGPlh5FdeQS51UeQZziGSmv9lWwyUQulNQmCOQl2UyKs+o6oMIThrFXEH409wVYmCIBOKYdaKYNWKYdGKYfG7blWKYdaIYNW5Xotg0Yhh0bl1l7hfK5ya6+UO7dxtFcrZJAxHaNzwN8JiIjXgQuUsQIoPwnB+YCxHFAHQ1SFAOpgQBUCqEMgqh0foQoBVEGATN7aPadmUFxc3KLHa3DwJgiC1/CWlppT5u6778a3336Ln3/+GR07dqyzrVqthlqt9lquVCp5Yb3A8T1A1PbZ7CIsNjssNjusNhEWu+Oj1SbCbLPD6nxtsdlhldqKsLo+Otebndtb7Y7lJosFf50ScGhTDsx2SPOHecwxZrF7zSlmtNhgsYkQ5NWQaU5DrjkNmeYU5NpTkCnL6z0f0aaGzZgIu7EjbIZE2IyJEC1RgFfFWfMMyVTIBI8wyyMMU8mhUcjdwrCa9a5lruValczztdv2GpUMKjkn8afzC38nICJeB9oRUQQMpUBZruNRftL53PmxPNcRtDWGMsgRxEmPYEAdWmtZCKDys9z1UGgc/6mkNqGlv/cbHLyJoogZM2ZIoZbRaMTs2bOlu4u6z6vWVERRxD333IOvvvoKmzZtQlpaWpMfg4ioPRBFEVa7WCussnsFUDWhVE1w5QqyLHbHNq59WKyuNs5gy+4KuDxDLosUhNWEYFa7Yx4xq90zFJPa+nhtsdvRsMkPGksOnMxuQLNqyDWnIQ9yBG0qzSnIVGX1buYI2RIcIZsxETZDR4iWSADec36pXNVczrCrdhBWu2rMVxCmVcqh9hOEubZXys99vjEiIiKiViWKQPVZZ5B2wkewdhIwVzXPsS3VjkdVwbntR6aoqaTzF855hXl+lrMK77zT4ODtlltu8Xg9ffp0rzY333zzuffIzV133YVVq1bh//2//4eQkBAUFDje7GFhYdBqtU16LCK6cLnuvmi122Gx1gRXrqoqfwGWVJlVb4AleodSrvDLJvoMtBoTYFEjyPSOkE17GjLNaSi0pyAoS+vdTAENIpVpiFZ1Rry2K5J0XZEQlAStSukWjtUK1pzL1Ao571hJRERE5GK3O4It9wo1j2DtFGA1NG7fMgUQmgiEJzseYUmOj7pIwFwNmCo9H+ZK72WmSsBUBZgq0OhRCnaroyrPUP/vmfVS6hoe0nk9Qp3VeSGAUssqvBbS4OBt2bJlzdkPn5YuXQoAGDVqlFdfZsyY0eL9IaLWY7baUW2yospkRaXRimqzFVVGx+sqkxXVzuXSc+dHVxuDxQaL1TMUMzuDrfPpzovnI0EAlDIZFHIBCpkAlUIGhfO1Ui6DQub4qJQLUPh4rZQLNe1lMigVjtfSemf7mraO5Sq585hyGQTRjl9/34rEXiE4Yz6O3OojyKk8ggL96Xr7r1VoHXcWjeqFXlG9kN4hHamhqZAJrCYjIiIiqpfNClTmeVaolZ2oeV1xGrCZG7dvucoZpjkDtTBnwOZ6HRLfdBVidjtg0dcT1FU4Qzofy81uy63GxvfDonc8qs6c2/kI8powThpG6yekc19Wu60qBJCfN7cPaBVt+rPTwBuuElEbZbHVhGXu4Vi1yYYqk8XjeZXJJrWpMroFZ86H2Wpv7dNpFTIBniGSFDg5wylZTbhUE0D5DrTcAyzv/cl8hGKu9Z4hl2tfylr7kI7tFqop5bIWre4y2Uw4VXkKORXHkVuRixMVJ6THWdlZ4FDd22sVWvSI7OEI2KLS0SuqF1JDUyFnST8RERGRb1YzUHGqVrCW6xmsibbG7Vuh9QzSXBVrrkdQDCBroX+GymTOwCkYQPy57ctqdgZxtYO6Cmeg52OZVHlXK9BrbBWeaAOMZY7HuVLq/IR0foI7j7ZuYZ5S1y6r8Np08EZELc9mF2sCMCkoqwnAqtxe164qq6oVlhktbSMsUytk0KnktQIsz5CqvgDLsa0zoPIKlwIPsNxDsboCLN7B0ZvFbkFeVZ5HqOYK2fKr8yE28JcPjVxTE7J1SEevyF5IC0tjyEZERETkzmJwDPf0d/OCynw0OvxRhfgJ1pKA8BRAF9UugxgoVIAi0jHk9VyIYq0qPF8hnduyugK9xg7nBWqq8KoLz+18BFmtMK6OkM5rWa228rZz8xQGb0TtgN0uOoZe+qgqqzLZUGW0OMMwx7Jqk807UHMGaAZLI/8b1cSUcgHBagWCNQoEq5UIVssRrFYgSK1AiEaBIJVrnUJqF6RWIMTZJtjVTq3gBPPnIbtoR0F1AXIqcjwq13Irc3G68jSsojWg/UWoIxBiDcGQzkOQEZ2B9Kh0pIWlQSHjj0EiIiK6wJmqnGGan5sXnEuYogn3rFDzCNaSHevbY7DWUgQBUAU5HiFx57Yvm8XHnHdVtQI6t/nu6morNrIAQ7Q77kDb2LvQulNoa4V0NQGdzNKyfwPwLw6iViKKIvRmm1clWaXrudl3tZmvOcyqzW0jLFPIBEcApqoJvaTwTOUjHNN4BmU1AZpjAnpq30RRxFnDWa+qtRMVJ3Cy8iTM9sDm+ghRhiAlNAXJoclICU2RHsmhydAKWqxduxaZ/TNb/PbhRERERK3KWO59F1D3OdYMJY3ft65DrYo1tznWwpIATWjTnQc1L7nSUYHX5FV4Ph5+b2JR63EuVXhWg+PhIziWm1p2WjMGb0QBEEURRosdlc6qMcdcZJZa1WV1DNN0H5pptqItTGMoE+CsDlMiyE9VmXtQ5grIaodlwWoF1AoZBP7HityIoogyU5nHsFBX5dqJihMwBPjDVKvQIjkkGcmhyUgNTfX4GKGO8Pv+s1gsTXE6RERERG2LKDrulOkepNWuWDOdQ/VQcJyPoaApNcGaStd050LtQ5NW4Vn9hHS+bmJR6wYWtds2dp7BJsDgjdo9URRhsQPFVSYYbWafc5G5z1Hms9rMbX1buAGmIMCjgizYRwgW7BGWyZ3DNT2rykLUSmiUDMvo3FWaK5FbkVszNLTyBE6Un8CJyhOoNFcGtC+lTCmFax6VayHJiNHF8P1KREREFw5RBKoK3cI0H8Gapbpx+xZkQGhirbuCut28IDQRUGqa9nyIAiFXANoIx+NciKJjrkJnGGctyAUWXt40fWwABm/UZlhsdujNNhjMNlSbrTCYbdCbbdCbrc6PNhicz6vdnrvau567b2Mw26C32GCzK4Cdm1v7FBGkknvPS+ZjrjL34MzXsEydSs7wgVqc3qLHycqTUsVaTnmOVLlWYgxsiIJckCMxONGjYs0VsMXp4niDAyIiIrow2G1AZYFnsOYerpWfAqzGxu1bpgDCOnpWqbmHa6EJbWoCeqJmIwiO6kyVDgiJhSicY5AXIAZvFBCbXYTeIxSrFYxZHJP6S+stVuhNNev0ZpvjtcU7KLPY2kApmQ86ldxr0n6vcEyjcIZqyloBmqPSLEgtR5BKwTtUUptntplxqvKUZ+Wac3hooT6wiXUFCIgPivdZuZYYkgiljL/oERERUTtnswIVp72r1MpdAdtpwN7IKTHk6pohn+53AnW9DokD+M9MolbH4K0dsttFGK02nyFXtclx10opNDNZobe4AjCrs5LM5jdcM1kbeXeSFqSSy6BVyRGkkkOrkkOrlMNYVY7k+BiEaJVewzJrV5XVrkaTMyyjdsZqtyKvKs/nnGv51fmwB3gXomhttMeNDFJCU5ASkoKk0CSo5epmOgsiIiKiNsBqclSleQVrzo8VeY2fW0qp830nUNcNDIKiAZmsac+HiJocg7dWIooiTFa7FGoZnMMn9X6HWNYeflmruszi3IfJBoOlbdzhsi5ymQCdSu58KKTnWpUCOqVzudqxTiu9rlmndVahSetUCkd7pRwKuecPH4vF4ribYebFvJshXTDsoh1nqs94Va7lVuTiVOUpWEVrQPuLUEd4VK4lhyYjJcTxMUgZ1ExnQURERNTKLAZHmOaqUKsdrFUWAGjkyB11qJ9gzVm5pot0DJEjovMag7d6mK12H3OIWT0qwQwWZ+DlWm7xU11Wax9tYZL+uggCHEGXc04xV8jlHnhpVY4hllJo5grF3J57h2tyqOSc0J/oXImiiCJDUc2ca66QreIETlaehMlmCmh/wcpgz6o1Z+VacmgywtRhzXQWRERERK3IVOkM1vzMsVZ9tvH71kZ43wnUPWjThjfZaRBR23XBBG+f7M4FlNqGTcbvVl1mbevpGOAWgjkCr5qwqybw8h2AKaThmFI7pVyavF+tYDhG1BaUGcscoZpzOKircu1ExQnorfqA9qWRazwr10KSkRqWiuSQZERqIvk9T0REROc/ixHQF9c8DCWAvgTQF0NWdRYDjv8ORdbLjnDNUNr44wRFe98JVHqdBKhDmu6ciOi8dcEEb89+exAyta7Vjq9WyKTgq3YwplU5hkgGqWueu4ZS1lSaOYdSquTQKRXO9XJoFHJO2E/UDlSZqxzDQctP4ERlTbB2ouIEKswVAe1LKVMiKSRJGg6aElZTuRaji4FM4FwgREREdJ6wmhyhmaHEM0zT+3rtXGap9rs7OYAEACiv78CC4+YE/uZYC+vouEMiEVE9LpjgrSGUckGq+JLCMWVN4KVVKhpYSVZ7qCUn6CciwGA1ILci12flWrGxOKB9yQU5EoITPCvXQlORHJqM+KB4yHkHKyIiImprbBZHhZlHYOYjOHNfZq5slq6IggxCaKL/OdbCOgIK3iSKiM7dBRO8PXtNBjpEhtc5/5hSzioQIjo3FpsFJ6tO4kT5CY+A7UTFCZzRnwl4f/FB8TWVa6E1j8TgRCjlvFkIERERtRK7zU+IVuK/Is1Ub5lZ4wlyx80ItJGALsrxXBfl9bCqQvHTrr8w+qqpUGpYsUZEze+CCd6uuTgRoaGhrd0NImoHrHYr8qvypTuFuleu5VXnwS7aA9pfB20Hn5VrSSFJ0Cg0zXQWRERERE52O2Asq2cYp/t8acWAoQyNvptnvQTHjQk8QrNIP8+dr9VhgKz+QgrRYoFBfQbgPzCJqIVcMMEbEVEg7KIdhfpCjzuFuh6nqk7BarcGtL9wdTiSQ52hWojbzQ1CkxGkDGqmsyAiIqILjt3uqCzzOXTTFZ6Ver8O8B+HAdGE+6g+qx2suT00YQCnzSCidoLBGxFdsERRRLGxWKpYc4VsORU5OFl5EiabKaD9BSmDHIGa80YG7kNDw9RhzXQWRERE1G6JImCq9F2F5nGzgVrPRVvz9Ukd5lZxVlcVWpRj2Kc2ApDzz04iunDxCkhE7ZLNboPRZoTBaoDBakCJscSrci23MhfVddz1yheNXIOk0CSflWtRmigIAm+kQkRERD6IImCu9g7L6rxbZwlgtzRfn1QhfirPIj3DM+l5BKBQNV9/iIjaIQZvRNTiRFGExW6RQjGj1RGQGW1GGCwGGGy1lltrAjT3dq5gzWu91Qiz3dzo/ilkCiSFJPmsXIvRxUAm8EYsREREFzyzvlb1mZ9hnXq3YZ0BVtMHRKmro/LMT7jGu3YSETU7Bm9E5MUu2mG0GusMtjyW+wnKPNbXCspszTkEogFkggwJQQlICasZGuq6qUF8UDwUMl4eiYiILhgWY/2VZ7WfWw3N1x+5Ggjq4L/yzNfNBZTa5usPERE1Gv+yJDoPWe3WBlWC/f/27j04yrve4/hn70kgF2lDaGm4jYfaWg0hFko7rQckgELvVUQd7vQgiZbGDiPoFOkM5lgp0gsz/GEJ1got8aD0CsYE8NRGp+aILVdbBbGVpAVLQkhINrvP+SPZZa/JJtlnN5u8XzMZ9vnt8/wuFL5NPvyeZ6MFZZc9l9XS0RI1KLvsuZzsJfaKw+pQmj1N6fZ0/1earfPY157pzOzcxda1c+264dfJwadZAQCQugxD8rR33r7Z3ty5A639kuS+1NUW8uVrb70QHqL18tETvWJz9rDzLDBI6/rVkSHx+AoAGBQI3oA4MwxD7d72qLvEIgZiATvBIgZiIbdg9vYTNZMtUhDWU1CWZk9Thj0j7Pw0W3g7u9MAABjAggKyCEFY1PaWrkDtkuQOeO0L2Nqbzf0QgUis9h52nvnaAtqdwwnRAGAI46dVDDm+2yijhV9Rb6cM3FXW3e2Xnsvymvlx7HFms9giB2K29Ijt/kDMlqZ0R3BgFikoc9lcPBMNAIBUECkg6zEcixaQtQSfOxD/0dBi7SZEi3ArZ8ZVkiuLEA0A0CsEbxgwAh+473u+WGCY1dbRplZP13tdX0HHAYFY6PUfX/xYm/5nk1o7WtVm5kNtTeC0OsN3hwUcB+4Ei3ROdzvLMuwZslvtfBInAACppNuALIZdYu6A16kQkPlYbJ27x5zDur4yrhw7Al47M7rahgWcO+xKW3pO5y2faTmSlX8cBACYi+ANMXF73UGBly/UCgq7AoOyCMFZ0HWRwjKzd4qZkLdZZAkOwXq6nbKXIZnL5uI2SgAAUllHezdBWA+7xLrbaZaKAZmjKxBzDr8SjkULyCK125zsNgMApBx+ok9xHq8nYqgVGHYFBV8hx22eth6Ds8sdl9VhDOBv7rpht9qVZkuTpcOinGE5SneE7BizpYfdLhk1KHOE337psrnYLQYAwGDgC8gi7gbrYZdYWDgWEKqlTEAWEIr1JiCL1EZABgCAH8GbSbyGV22etsi3RHZzi2SkIKy7691ed7KX2idWi9UfaAWGW2n2rq+Q176wK+j80OOQa1x2lxxWh9xut1577TV96UtfksPBp1gCAJCyvJ6uUKslIAxr6Qq/WoJ3jvmCMveVkMzW1qzbGt6X7dknOtsHY0AW6+4xAjIAABJiyAVvoZ842dMtkr7wrKfgLNJOslQUeOuky+bqc/AV9Xp7mtJt6TxXDACAwcrrDQi1LgWHX92GZgHPKIsQmsndInVc7tfUrJKulqTmeCw0gkgBWW+CsKD2gGeWEZABAJCyhkzw9sX/+aLczs7nlBkykj2dPukuCPMFWv4dX13HLrsr9uDMnian1UkgBgDAYGcY4cGX/7bJ0NCshzAsNDTraE326npkWGyy9PU5YxEf5E9ABgAAIhsywdvHbR/LZrWZ0rfD6ugx+Iq2KyzW4CzNniarhU9dAgBgyDAMyd3azW6xnnaQdXPbpbsl2auLgSUg5Ap8OH9GVxgWuKMs48ptl46MkIAswx+euS1O7av5X82Ze5ccTmeyFwgAAIaAIRO8XTvsWmVmZXYbfIXeEul/r4fbKfnUSQAAhijD6Lz9MeyWye52kLVE3y0Wen4q7NIPDb4Cw6+Q4CsoNPPvGovSZk+L/+4xt1teq4NdaQAAIGGGTGK05+49ysrKSvY0AACA2Qyj8yH8hif4V9+D+WPZLdabWywNb7JX3DNHRh93i3W3gyxDsqdLVnbkAwAARDNkgjcAAAYsrzc8JDI88WmPFEDFq2/DG+G8jl6cG629n+tLhV1ikdjTQnaBhQZfgTvDou0gixCaOTIIxwAAAJIkJYK3rVu36sc//rHq6+tVUFCgp59+WlOmTOldJ0aKfhMOAMlkGMHBSFBI4u08DgxQgl5Hus4b4VxfuzfCGJ6uOfRmjPC5WT0duvGDd2WtelOyKIaQqDdBU2/DowhtSB02V4y3TobcahnL88lMehYtAAAAkmfAB28vvviiysrKtG3bNk2dOlVbtmzR7NmzdfLkSY0cOTL2jv47X3JZJFkki7Xz2R4Wa+dXWFvgeQHtYW2h7ZH6tHb+kBfx+kjjRxsrynk9jh/ruZYoY0U7N9paLdH7TPj4Xccej7JbTkv1b0v2eP+RN+kZMaY8e2aozzU0QAq9Fc0bMbDpOTTqJvwJDJPCrjOijxEW4nijjN2XdfQy3ErVnUMhbJL+Q5I+TPJE0ANLZ/hksQX8ag057q7dGnBsj9Bmkxzp3d9qGekWy8BfbQP+WycAAAAMIAP+u8fNmzdrxYoVWrJkiSRp27ZtevXVV7V9+3Z997vf7UOPXT9cDo6fJREDh6T/lKSTyZ0HgEHI0lP4001IFHZOrIFSX9utIYFUf/robXusY/LAewAAAAwuAzp4a29vV11dndauXetvs1qtmjlzpmprayNe09bWpra2Nv9xU1OTJMl7zWR506zy7XqxGN6uHR6GJN9rr/99Bb4f1B7wvhTwOvR9I0JfnedZUuEhzABSkhG2Y8gSHHZYAkMPa0A4EhKcWCwyQo6vvLYGhypB/QUEKr5+Aq+zRhg/tP9u5m0EzTv0vNA5XJlnh8fQW3X/p5unTJXd4QroK0oIFjFMCv098u2QRr8Y6tq52ZHsmWAIcLvdQb8CGHqoAwAS/fd/QAdv586dk8fjUV5eXlB7Xl6eTpw4EfGa8vJybdiwIaz99dz/UkZGhinz7JOuYM6iznDPoijHXcGgpeuaK+2d4Z2lKzTs/NHPd5435Ppo/fbQHnH8rnGjjR90fed5vr6ijeN7HW384OtDxw8MMoPHD11byjDheYTmRQNm/L6a99/KUGdQYsgqw2Lt/FNisUohx/62gGP/a3UGO4HH4X0FjtF5rJDj7s69MkaMfck3Z8vADYJ8fw0T8u8O3sgDDb9e+49dSMQEAAxwVVVVyZ4CgCSjDgBDV0tLS0LHG9DBW1+sXbtWZWVl/uOmpibl5+dr1qxZysrKSuLMkCxut1tVVVUqLi6Ww+FI9nQAJAF1AIBELQBAHQAgnT9/PqHjDejg7eqrr5bNZlNDQ0NQe0NDg0aNGhXxGpfLJZfLFdbucDgorEMcfwYAUAcASNQCANQBYChL9N99a0JH6yWn06mioiJVV1f727xer6qrqzVt2rQkzgwAAAAAAADo3oDe8SZJZWVlWrRokT73uc9pypQp2rJliy5duuT/lFMAAAAAAABgIBrwwdv8+fP10Ucf6dFHH1V9fb0mTZqkffv2hX3gAgAAAAAAADCQDPjgTZJKS0tVWlqa7GkAAAAAAAAAMRvQz3gDAAAAAAAAUhXBGwAAAAAAAGCClLjVtD8Mw5AkNTU1JXkmSBa3262WlhY1NTXxkeHAEEUdACBRCwBQBwBIFy9elHQlLzLboA/efL+h+fn5SZ4JAAAAAAAABoLz588rOzvb9HEsRqIiviTxer2aOHGi6urqZLFYkj0dJEFTU5Py8/P1z3/+U1lZWcmeDpLk5ptv1ltvvZXsaSBJqAPwoRYMbdQCSNSBoY46AIk6MNQ1NjZqzJgx+vjjj5WTk2P6eIN+x5vVapXT6UxIiomBLSsri/+5DmE2m43//qAOgFoASdSCoY46AIk6MNRRByB15kUJGSchoyRZSUlJsqcAIMmoAwAkagEA6gAA6gASa9Dfago0NTUpOztbjY2N/KsGMERRBwBI1AIA1AEAia8DQ2LHG4Y2l8ul9evXy+VyJXsqAJKEOgBAohYAoA4ASHwdYMcbAAAAAAAAYAJ2vAEAAAAAAAAmIHgDAAAAAAAATEDwBgAAAAAAAJiA4A0AAAAAAAAwAcEbUkJ5ebluvvlmZWZmauTIkbrnnnt08uTJoHMuX76skpISXXXVVRo+fLjuv/9+NTQ0BJ3z7W9/W0VFRXK5XJo0aVK3Y7733nvKzMxUTk5OnFcDoC8SWQcMw9CmTZs0ceJEuVwujR49Whs3bjRraQBilMg6sH//ft1yyy3KzMxUbm6u7r//fp0+fdqklQHojXjUgr/85S9asGCB8vPzlZ6erhtuuEFPPvlk2FgHDx7U5MmT5XK59MlPflI7duwwe3kAYpCoOrBnzx4VFxcrNzdXWVlZmjZtmvbv39+ruRK8ISUcOnRIJSUl+sMf/qCqqiq53W7NmjVLly5d8p/z8MMP6+WXX1ZlZaUOHTqkf/3rX7rvvvvC+lq6dKnmz5/f7Xhut1sLFizQ7bffHve1AOibRNaBhx56SD/96U+1adMmnThxQi+99JKmTJliyroAxC5RdeDUqVO6++67NWPGDB0+fFj79+/XuXPnIvYDIPHiUQvq6uo0cuRIPf/88zp69Ki+973vae3atXrmmWf855w6dUpz587V9OnTdfjwYa1evVrLly/v9Q/dAOIvUXXgd7/7nYqLi/Xaa6+prq5O06dP15133qk///nPsU/WAFLQhx9+aEgyDh06ZBiGYVy4cMFwOBxGZWWl/5zjx48bkoza2tqw69evX28UFBRE7X/NmjXGN77xDaOiosLIzs6O9/QBxIFZdeDYsWOG3W43Tpw4YdrcAcSHWXWgsrLSsNvthsfj8be99NJLhsViMdrb2+O/EAD90t9a4LNq1Spj+vTp/uM1a9YYn/70p4POmT9/vjF79uw4rwBAf5lVByK58cYbjQ0bNsQ8N3a8ISU1NjZKkkaMGCGpM6l2u92aOXOm/5xPfepTGjNmjGpra3vVd01NjSorK7V169b4TRhA3JlVB15++WVNmDBBr7zyisaPH69x48Zp+fLl+ve//x3fBQDoN7PqQFFRkaxWqyoqKuTxeNTY2Kif//znmjlzphwOR3wXAaDf4lULGhsb/X1IUm1tbVAfkjR79uxe/3wBwHxm1YFQXq9XFy9e7PacUARvSDler1erV6/WbbfdpptuukmSVF9fL6fTGfY8try8PNXX18fc9/nz57V48WLt2LFDWVlZ8Zw2gDgysw78/e9/1z/+8Q9VVlbqueee044dO1RXV6cHHnggnksA0E9m1oHx48frN7/5jdatWyeXy6WcnBy9//772r17dzyXACAO4lUL3nzzTb344ot68MEH/W319fXKy8sL66OpqUmtra3xXQiAPjOzDoTatGmTmpub9ZWvfCXm+dljPhMYIEpKSnTkyBG98cYbce97xYoV+trXvqY77rgj7n0DiB8z64DX61VbW5uee+45TZw4UZL07LPPqqioSCdPntT1118f9zEB9J6ZdaC+vl4rVqzQokWLtGDBAl28eFGPPvqoHnjgAVVVVcliscR9TAB9E49acOTIEd19991av369Zs2aFcfZAUiERNWBnTt3asOGDdq7d69GjhwZc9/seENKKS0t1SuvvKIDBw7ouuuu87ePGjVK7e3tunDhQtD5DQ0NGjVqVMz919TUaNOmTbLb7bLb7Vq2bJkaGxtlt9u1ffv2eC0DQD+YXQeuueYa2e12f+gmSTfccIMk6cyZM/2bPIC4MLsObN26VdnZ2Xr88cdVWFioO+64Q88//7yqq6v1xz/+MV7LANBP8agFx44d0xe+8AU9+OCD+v73vx/03qhRo8I+FbmhoUFZWVlKT0+P72IA9InZdcDnhRde0PLly7V79+6wW9B7QvCGlGAYhkpLS/WrX/1KNTU1Gj9+fND7RUVFcjgcqq6u9redPHlSZ86c0bRp02Iep7a2VocPH/Z/PfbYY8rMzNThw4d17733xm09AHovUXXgtttuU0dHh/72t7/52/76179KksaOHdvPVQDoj0TVgZaWFlmtwd8m22w2SZ27YgEkV7xqwdGjRzV9+nQtWrRIGzduDBtn2rRpQX1IUlVVVa/qCQBzJKoOSNKuXbu0ZMkS7dq1S3Pnzu31XLnVFCmhpKREO3fu1N69e5WZmem/Jzs7O1vp6enKzs7WsmXLVFZWphEjRigrK0vf+ta3NG3aNN1yyy3+ft577z01Nzervr5era2tOnz4sCTpxhtvlNPp9O9q8fnTn/4kq9Xqv08cQPIkqg7MnDlTkydP1tKlS7VlyxZ5vV6VlJSouLg4aBccgMRLVB2YO3eufvKTn+ixxx7z32q6bt06jR07VoWFhclYOoAA8agFR44c0YwZMzR79myVlZX5+7DZbMrNzZUkrVy5Us8884zWrFmjpUuXqqamRrt379arr76anIUD8EtUHdi5c6cWLVqkJ598UlOnTvWf4xsjJjF//imQRJIiflVUVPjPaW1tNVatWmV84hOfMDIyMox7773XOHv2bFA/n//85yP2c+rUqYjjVlRUGNnZ2eYtDEDMElkHPvjgA+O+++4zhg8fbuTl5RmLFy82zp8/n6CVAogmkXVg165dRmFhoTFs2DAjNzfXuOuuu4zjx48naKUAuhOPWrB+/fqIfYwdOzZorAMHDhiTJk0ynE6nMWHChKAxACRPoupAtO8ZFi1aFPNcLV0TBgAAAAAAABBHPOMNAAAAAAAAMAHBGwAAAAAAAGACgjcAAAAAAADABARvAAAAAAAAgAkI3gAAAAAAAAATELwBAAAAAAAAJiB4AwAAAAAAAExA8AYAAAAAAACYgOANAAAAAAAAMAHBGwAAQApZvHixLBaLLBaLHA6H8vLyVFxcrO3bt8vr9cbcz44dO5STk2PeRAEAAEDwBgAAkGrmzJmjs2fP6vTp03r99dc1ffp0PfTQQ5o3b546OjqSPT0AAAB0IXgDAABIMS6XS6NGjdLo0aM1efJkrVu3Tnv37tXrr7+uHTt2SJI2b96sz3zmMxo2bJjy8/O1atUqNTc3S5IOHjyoJUuWqLGx0b977gc/+IEkqa2tTY888ohGjx6tYcOGaerUqTp48GByFgoAAJDiCN4AAAAGgRkzZqigoEB79uyRJFmtVj311FM6evSofvazn6mmpkZr1qyRJN16663asmWLsrKydPbsWZ09e1aPPPKIJKm0tFS1tbV64YUX9Pbbb+vLX/6y5syZo3fffTdpawMAAEhVFsMwjGRPAgAAALFZvHixLly4oF//+tdh7331q1/V22+/rWPHjoW998tf/lIrV67UuXPnJHU+42316tW6cOGC/5wzZ85owoQJOnPmjK699lp/+8yZMzVlyhT98Ic/jPt6AAAABjN7sicAAACA+DAMQxaLRZL029/+VuXl5Tpx4oSamprU0dGhy5cvq6WlRRkZGRGvf+edd+TxeDRx4sSg9ra2Nl111VWmzx8AAGCwIXgDAAAYJI4fP67x48fr9OnTmjdvnr75zW9q48aNGjFihN544w0tW7ZM7e3tUYO35uZm2Ww21dXVyWazBb03fPjwRCwBAABgUCF4AwAAGARqamr0zjvv6OGHH1ZdXZ28Xq+eeOIJWa2dj/TdvXt30PlOp1MejyeorbCwUB6PRx9++KFuv/32hM0dAABgsCJ4AwAASDFtbW2qr6+Xx+NRQ0OD9u3bp/Lycs2bN08LFy7UkSNH5Ha79fTTT+vOO+/U73//e23bti2oj3Hjxqm5uVnV1dUqKChQRkaGJk6cqK9//etauHChnnjiCRUWFuqjjz5SdXW1PvvZz2ru3LlJWjEAAEBq4lNNAQAAUsy+fft0zTXXaNy4cZozZ44OHDigp556Snv37pXNZlNBQYE2b96sH/3oR7rpppv0i1/8QuXl5UF93HrrrVq5cqXmz5+v3NxcPf7445KkiooKLVy4UN/5znd0/fXX65577tFbb72lMWPGJGOpAAAAKY1PNQUAAAAAAABMwI43AAAAAAAAwAQEbwAAAAAAAIAJCN4AAAAAAAAAExC8AQAAAAAAACYgeAMAAAAAAABMQPAGAAAAAAAAmIDgDQAAAAAAADABwRsAAAAAAABgAoI3AAAAAAAAwAQEbwAAAAAAAIAJCN4AAAAAAAAAE/w/an4tYlaOfbEAAAAASUVORK5CYII=",
"text/plain": [
"
"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"companies.ratios.get_earnings_per_share(trailing=4).T.dropna().plot(\n",
" figsize=(15, 3),\n",
" title=\"4 Year Trailing Earnings per Share for Apple, Amazon, META and Walmart\",\n",
" grid=True,\n",
" linestyle=\"-\",\n",
" linewidth=2,\n",
" xlabel=\"Date\",\n",
" ylabel=\"Earnings per Share\",\n",
")\n",
"\n",
"companies.ratios.get_earnings_per_share(trailing=4, growth=True).T.dropna().plot(\n",
" figsize=(15, 3),\n",
" title=\"4 Year Trailing Earnings per Share Growth for Apple, Amazon, META and Walmart\",\n",
" grid=True,\n",
" linestyle=\"-\",\n",
" linewidth=2,\n",
" xlabel=\"Date\",\n",
" ylabel=\"Earnings per Share Growth\",\n",
")"
]
},
{
"cell_type": "markdown",
"id": "658d7f7b",
"metadata": {},
"source": [
"It is possible to define custom ratios if the current ratio calculations are not sufficient. Define how each custom ratio needs to be calculated. This can be any of the following structures:\n",
"\n",
"- **Simple operations such as:** `'Quick Assets': 'Cash and Short Term Investments + Accounts Receivable'`\n",
"- **Working with multiple operations:** `'Cash Op Expenses':'Cost of Goods Sold + Selling, General and Administrative Expenses - Depreciation and Amortization'`,\n",
"- **Using curly brackets:** `'WC / Net Income as %': '(Working Capital / Net Income) * 100'`,\n",
"- **Defining a criteria:** `'Large Revenues': 'Revenue > 1000000000'`,\n",
"- **Using actual numbers:** `'Daily Cash Op Expenses': 'Cash Op Expenses / 365'`,\n",
"- **Combining earlier defined formulas:** `'Defensive Interval':'Quick Assets / Daily Cash Op Expenses'`\n",
"\n",
"Not that it is important you follow the NAME - FORMULA format and that you adhere to the financial statement naming. See some of the available fields you can use below, shrunken down for readability."
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "ee2da2f7",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"The following names are available to be used in the Custom Ratios calculations.\n",
"\n"
]
},
{
"data": {
"text/plain": [
"['CAPEX per Share',\n",
" 'Capital Expenditure',\n",
" 'Capital Lease Obligations',\n",
" 'Cash Beginning of Period',\n",
" 'Cash Conversion Cycle (CCC)']"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"companies.ratios.collect_custom_ratios(options=True)[10:15]"
]
},
{
"cell_type": "markdown",
"id": "19853ba6",
"metadata": {},
"source": [
"Then create your custom ratios and add them to custom ratios function."
]
},
{
"cell_type": "code",
"execution_count": 10,
"id": "1fe66edb",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"
\n",
"\n",
"
\n",
" \n",
"
\n",
"
\n",
"
\n",
"
2005
\n",
"
2006
\n",
"
2007
\n",
"
2008
\n",
"
2009
\n",
"
2010
\n",
"
2011
\n",
"
2012
\n",
"
2013
\n",
"
2014
\n",
"
2015
\n",
"
2016
\n",
"
2017
\n",
"
2018
\n",
"
2019
\n",
"
2020
\n",
"
2021
\n",
"
2022
\n",
"
2023
\n",
"
\n",
" \n",
" \n",
"
\n",
"
AAPL
\n",
"
WC / Net Income as %
\n",
"
510.5618
\n",
"
404.1227
\n",
"
362.0423
\n",
"
426.1067
\n",
"
297.7384
\n",
"
149.5468
\n",
"
65.6508
\n",
"
45.7935
\n",
"
79.9957
\n",
"
12.8651
\n",
"
16.4213
\n",
"
60.9867
\n",
"
57.5603
\n",
"
24.3117
\n",
"
103.339
\n",
"
66.7485
\n",
"
9.8807
\n",
"
-18.6137
\n",
"
-1.796
\n",
"
\n",
"
\n",
"
Large Revenues
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
\n",
"
\n",
"
Quick Assets
\n",
"
9573000000.0
\n",
"
12955000000.0
\n",
"
19415000000.0
\n",
"
26912000000.0
\n",
"
26825000000.0
\n",
"
35544000000.0
\n",
"
37669000000.0
\n",
"
47821000000.0
\n",
"
61187000000.0
\n",
"
52296000000.0
\n",
"
71944000000.0
\n",
"
96454000000.0
\n",
"
109854000000.0
\n",
"
115296000000.0
\n",
"
146361000000.0
\n",
"
128388000000.0
\n",
"
114145000000.0
\n",
"
109236000000.0
\n",
"
122540000000.0
\n",
"
\n",
"
\n",
"
Cash Op Expenses
\n",
"
11568000000.0
\n",
"
15925000000.0
\n",
"
18498000000.0
\n",
"
24622000000.0
\n",
"
26843000000.0
\n",
"
44031000000.0
\n",
"
70216000000.0
\n",
"
94609000000.0
\n",
"
110679000000.0
\n",
"
116305000000.0
\n",
"
143161000000.0
\n",
"
135065000000.0
\n",
"
146152000000.0
\n",
"
169558000000.0
\n",
"
167480000000.0
\n",
"
178419000000.0
\n",
"
223670000000.0
\n",
"
237536000000.0
\n",
"
227550000000.0
\n",
"
\n",
"
\n",
"
Daily Cash Op Expenses
\n",
"
31693150.6849
\n",
"
43630136.9863
\n",
"
50679452.0548
\n",
"
67457534.2466
\n",
"
73542465.7534
\n",
"
120632876.7123
\n",
"
192372602.7397
\n",
"
259202739.726
\n",
"
303230136.9863
\n",
"
318643835.6164
\n",
"
392221917.8082
\n",
"
370041095.8904
\n",
"
400416438.3562
\n",
"
464542465.7534
\n",
"
458849315.0685
\n",
"
488819178.0822
\n",
"
612794520.5479
\n",
"
650783561.6438
\n",
"
623424657.5342
\n",
"
\n",
"
\n",
"
Defensive Interval
\n",
"
302.0526
\n",
"
296.9278
\n",
"
383.0941
\n",
"
398.9473
\n",
"
364.7552
\n",
"
294.646
\n",
"
195.8127
\n",
"
184.4926
\n",
"
201.784
\n",
"
164.1205
\n",
"
183.4268
\n",
"
260.6575
\n",
"
274.3494
\n",
"
248.1926
\n",
"
318.974
\n",
"
262.6493
\n",
"
186.2696
\n",
"
167.853
\n",
"
196.5594
\n",
"
\n",
"
\n",
"
AMZN
\n",
"
WC / Net Income as %
\n",
"
300.3003
\n",
"
442.6316
\n",
"
304.6218
\n",
"
218.7597
\n",
"
269.7339
\n",
"
292.9688
\n",
"
411.0935
\n",
"
-5882.0513
\n",
"
600.365
\n",
"
-1343.5685
\n",
"
432.047
\n",
"
82.8764
\n",
"
76.2941
\n",
"
66.6137
\n",
"
73.5416
\n",
"
29.7595
\n",
"
57.8887
\n",
"
316.0176
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Large Revenues
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
0.0
\n",
"
\n",
"
\n",
"
Quick Assets
\n",
"
2274000000.0
\n",
"
2418000000.0
\n",
"
3817000000.0
\n",
"
4554000000.0
\n",
"
7354000000.0
\n",
"
10349000000.0
\n",
"
12147000000.0
\n",
"
14812000000.0
\n",
"
17214000000.0
\n",
"
23028000000.0
\n",
"
26231000000.0
\n",
"
34320000000.0
\n",
"
44150000000.0
\n",
"
57927000000.0
\n",
"
75837000000.0
\n",
"
108938000000.0
\n",
"
128940000000.0
\n",
"
112386000000.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Cash Op Expenses
\n",
"
7890000000.0
\n",
"
10107000000.0
\n",
"
13925000000.0
\n",
"
18061000000.0
\n",
"
22900000000.0
\n",
"
32124000000.0
\n",
"
45978000000.0
\n",
"
53862000000.0
\n",
"
64226000000.0
\n",
"
75215000000.0
\n",
"
86416000000.0
\n",
"
107433000000.0
\n",
"
139448000000.0
\n",
"
175992000000.0
\n",
"
208060000000.0
\n",
"
295320000000.0
\n",
"
354396000000.0
\n",
"
385338000000.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Daily Cash Op Expenses
\n",
"
21616438.3562
\n",
"
27690410.9589
\n",
"
38150684.9315
\n",
"
49482191.7808
\n",
"
62739726.0274
\n",
"
88010958.9041
\n",
"
125967123.2877
\n",
"
147567123.2877
\n",
"
175961643.8356
\n",
"
206068493.1507
\n",
"
236756164.3836
\n",
"
294336986.3014
\n",
"
382049315.0685
\n",
"
482169863.0137
\n",
"
570027397.2603
\n",
"
809095890.411
\n",
"
970947945.2055
\n",
"
1055720547.9452
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Defensive Interval
\n",
"
105.1977
\n",
"
87.3226
\n",
"
100.0506
\n",
"
92.0331
\n",
"
117.2144
\n",
"
117.5876
\n",
"
96.4299
\n",
"
100.3747
\n",
"
97.8281
\n",
"
111.7493
\n",
"
110.7933
\n",
"
116.601
\n",
"
115.561
\n",
"
120.1382
\n",
"
133.041
\n",
"
134.6416
\n",
"
132.7981
\n",
"
106.4543
\n",
"
NaN
\n",
"
\n",
"
\n",
"
META
\n",
"
WC / Net Income as %
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
306.4356
\n",
"
370.5
\n",
"
19273.5849
\n",
"
798.0
\n",
"
416.5306
\n",
"
534.897
\n",
"
308.5642
\n",
"
281.1786
\n",
"
196.5584
\n",
"
276.8299
\n",
"
208.2241
\n",
"
115.649
\n",
"
140.1853
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Large Revenues
\n",
"
0.0
\n",
"
0.0
\n",
"
0.0
\n",
"
0.0
\n",
"
0.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
0.0
\n",
"
\n",
"
\n",
"
Quick Assets
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
2158000000.0
\n",
"
4455000000.0
\n",
"
10796000000.0
\n",
"
12609000000.0
\n",
"
12877000000.0
\n",
"
20993000000.0
\n",
"
33442000000.0
\n",
"
47543000000.0
\n",
"
48701000000.0
\n",
"
64373000000.0
\n",
"
73289000000.0
\n",
"
62037000000.0
\n",
"
54204000000.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Cash Op Expenses
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
659000000.0
\n",
"
1244000000.0
\n",
"
2503000000.0
\n",
"
2642000000.0
\n",
"
3563000000.0
\n",
"
4942000000.0
\n",
"
6950000000.0
\n",
"
9671000000.0
\n",
"
16337000000.0
\n",
"
27370000000.0
\n",
"
27985000000.0
\n",
"
38554000000.0
\n",
"
43641000000.0
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Daily Cash Op Expenses
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
1805479.4521
\n",
"
3408219.1781
\n",
"
6857534.2466
\n",
"
7238356.1644
\n",
"
9761643.8356
\n",
"
13539726.0274
\n",
"
19041095.8904
\n",
"
26495890.411
\n",
"
44758904.1096
\n",
"
74986301.3699
\n",
"
76671232.8767
\n",
"
105627397.2603
\n",
"
119564383.5616
\n",
"
NaN
\n",
"
\n",
"
\n",
"
Defensive Interval
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
NaN
\n",
"
1195.2504
\n",
"
1307.1342
\n",
"
1574.3268
\n",
"
1741.9701
\n",
"
1319.1426
\n",
"
1550.4745
\n",
"
1756.3065
\n",
"
1794.3537
\n",
"
1088.074
\n",
"
858.4635
\n",
"
955.8865
\n",
"
587.3192
\n",
"
453.3457
\n",
"
NaN
\n",
"
\n",
"
\n",
"
WMT
\n",
"
WC / Net Income as %
\n",
"
-42.8265
\n",
"
-44.5374
\n",
"
-45.7816
\n",
"
-85.3743
\n",
"
-48.0672
\n",
"
-50.436
\n",
"
-40.216
\n",
"
-46.659
\n",
"
-69.8747
\n",
"
-50.93
\n",
"
-12.186
\n",
"
-29.8081
\n",
"
-67.7197
\n",
"
-191.2087
\n",
"
-233.5832
\n",
"
-107.4121
\n",
"
-19.0822
\n",
"
-46.142
\n",
"
-141.6353
\n",
"
\n",
"
\n",
"
Large Revenues
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
1.0
\n",
"
\n",
"
\n",
"
Quick Assets
\n",
"
7203000000.0
\n",
"
9076000000.0
\n",
"
10213000000.0
\n",
"
9223000000.0
\n",
"
11180000000.0
\n",
"
12051000000.0
\n",
"
12484000000.0
\n",
"
12487000000.0
\n",
"
14549000000.0
\n",
"
13958000000.0
\n",
"
15913000000.0
\n",
"
14329000000.0
\n",
"
12702000000.0
\n",
"
12370000000.0
\n",
"
14005000000.0
\n",
"
15749000000.0
\n",
"
24257000000.0
\n",
"
23040000000.0
\n",
"
16818000000.0
\n",
"
\n",
"
\n",
"
Cash Op Expenses
\n",
"
266493000000.0
\n",
"
292407000000.0
\n",
"
322694000000.0
\n",
"
350486000000.0
\n",
"
376070000000.0
\n",
"
377107000000.0
\n",
"
388666000000.0
\n",
"
412262000000.0
\n",
"
432860000000.0
\n",
"
440552000000.0
\n",
"
449331000000.0
\n",
"
448571000000.0
\n",
"
453029000000.0
\n",
"
469377000000.0
\n",
"
481770000000.0
\n",
"
490262000000.0
\n",
"
525120000000.0
\n",
"
538996000000.0
\n",
"
581200000000.0
\n",
"
\n",
"
\n",
"
Daily Cash Op Expenses
\n",
"
730117808.2192
\n",
"
801115068.4932
\n",
"
884093150.6849
\n",
"
960235616.4384
\n",
"
1030328767.1233
\n",
"
1033169863.0137
\n",
"
1064838356.1644
\n",
"
1129484931.5068
\n",
"
1185917808.2192
\n",
"
1206991780.8219
\n",
"
1231043835.6164
\n",
"
1228961643.8356
\n",
"
1241175342.4658
\n",
"
1285964383.5616
\n",
"
1319917808.2192
\n",
"
1343183561.6438
\n",
"
1438684931.5068
\n",
"
1476701369.863
\n",
"
1592328767.1233
\n",
"
\n",
"
\n",
"
Defensive Interval
\n",
"
9.8655
\n",
"
11.3292
\n",
"
11.552
\n",
"
9.6049
\n",
"
10.8509
\n",
"
11.6641
\n",
"
11.7238
\n",
"
11.0555
\n",
"
12.2681
\n",
"
11.5643
\n",
"
12.9264
\n",
"
11.6594
\n",
"
10.2338
\n",
"
9.6192
\n",
"
10.6105
\n",
"
11.7251
\n",
"
16.8605
\n",
"
15.6023
\n",
"
10.5619
\n",
"
\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" 2005 2006 2007 \\\n",
"AAPL WC / Net Income as % 510.5618 404.1227 362.0423 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 9573000000.0 12955000000.0 19415000000.0 \n",
" Cash Op Expenses 11568000000.0 15925000000.0 18498000000.0 \n",
" Daily Cash Op Expenses 31693150.6849 43630136.9863 50679452.0548 \n",
" Defensive Interval 302.0526 296.9278 383.0941 \n",
"AMZN WC / Net Income as % 300.3003 442.6316 304.6218 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 2274000000.0 2418000000.0 3817000000.0 \n",
" Cash Op Expenses 7890000000.0 10107000000.0 13925000000.0 \n",
" Daily Cash Op Expenses 21616438.3562 27690410.9589 38150684.9315 \n",
" Defensive Interval 105.1977 87.3226 100.0506 \n",
"META WC / Net Income as % NaN NaN NaN \n",
" Large Revenues 0.0 0.0 0.0 \n",
" Quick Assets NaN NaN NaN \n",
" Cash Op Expenses NaN NaN NaN \n",
" Daily Cash Op Expenses NaN NaN NaN \n",
" Defensive Interval NaN NaN NaN \n",
"WMT WC / Net Income as % -42.8265 -44.5374 -45.7816 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 7203000000.0 9076000000.0 10213000000.0 \n",
" Cash Op Expenses 266493000000.0 292407000000.0 322694000000.0 \n",
" Daily Cash Op Expenses 730117808.2192 801115068.4932 884093150.6849 \n",
" Defensive Interval 9.8655 11.3292 11.552 \n",
"\n",
" 2008 2009 2010 \\\n",
"AAPL WC / Net Income as % 426.1067 297.7384 149.5468 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 26912000000.0 26825000000.0 35544000000.0 \n",
" Cash Op Expenses 24622000000.0 26843000000.0 44031000000.0 \n",
" Daily Cash Op Expenses 67457534.2466 73542465.7534 120632876.7123 \n",
" Defensive Interval 398.9473 364.7552 294.646 \n",
"AMZN WC / Net Income as % 218.7597 269.7339 292.9688 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 4554000000.0 7354000000.0 10349000000.0 \n",
" Cash Op Expenses 18061000000.0 22900000000.0 32124000000.0 \n",
" Daily Cash Op Expenses 49482191.7808 62739726.0274 88010958.9041 \n",
" Defensive Interval 92.0331 117.2144 117.5876 \n",
"META WC / Net Income as % NaN NaN 306.4356 \n",
" Large Revenues 0.0 0.0 1.0 \n",
" Quick Assets NaN NaN 2158000000.0 \n",
" Cash Op Expenses NaN NaN 659000000.0 \n",
" Daily Cash Op Expenses NaN NaN 1805479.4521 \n",
" Defensive Interval NaN NaN 1195.2504 \n",
"WMT WC / Net Income as % -85.3743 -48.0672 -50.436 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 9223000000.0 11180000000.0 12051000000.0 \n",
" Cash Op Expenses 350486000000.0 376070000000.0 377107000000.0 \n",
" Daily Cash Op Expenses 960235616.4384 1030328767.1233 1033169863.0137 \n",
" Defensive Interval 9.6049 10.8509 11.6641 \n",
"\n",
" 2011 2012 2013 \\\n",
"AAPL WC / Net Income as % 65.6508 45.7935 79.9957 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 37669000000.0 47821000000.0 61187000000.0 \n",
" Cash Op Expenses 70216000000.0 94609000000.0 110679000000.0 \n",
" Daily Cash Op Expenses 192372602.7397 259202739.726 303230136.9863 \n",
" Defensive Interval 195.8127 184.4926 201.784 \n",
"AMZN WC / Net Income as % 411.0935 -5882.0513 600.365 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 12147000000.0 14812000000.0 17214000000.0 \n",
" Cash Op Expenses 45978000000.0 53862000000.0 64226000000.0 \n",
" Daily Cash Op Expenses 125967123.2877 147567123.2877 175961643.8356 \n",
" Defensive Interval 96.4299 100.3747 97.8281 \n",
"META WC / Net Income as % 370.5 19273.5849 798.0 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 4455000000.0 10796000000.0 12609000000.0 \n",
" Cash Op Expenses 1244000000.0 2503000000.0 2642000000.0 \n",
" Daily Cash Op Expenses 3408219.1781 6857534.2466 7238356.1644 \n",
" Defensive Interval 1307.1342 1574.3268 1741.9701 \n",
"WMT WC / Net Income as % -40.216 -46.659 -69.8747 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 12484000000.0 12487000000.0 14549000000.0 \n",
" Cash Op Expenses 388666000000.0 412262000000.0 432860000000.0 \n",
" Daily Cash Op Expenses 1064838356.1644 1129484931.5068 1185917808.2192 \n",
" Defensive Interval 11.7238 11.0555 12.2681 \n",
"\n",
" 2014 2015 2016 \\\n",
"AAPL WC / Net Income as % 12.8651 16.4213 60.9867 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 52296000000.0 71944000000.0 96454000000.0 \n",
" Cash Op Expenses 116305000000.0 143161000000.0 135065000000.0 \n",
" Daily Cash Op Expenses 318643835.6164 392221917.8082 370041095.8904 \n",
" Defensive Interval 164.1205 183.4268 260.6575 \n",
"AMZN WC / Net Income as % -1343.5685 432.047 82.8764 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 23028000000.0 26231000000.0 34320000000.0 \n",
" Cash Op Expenses 75215000000.0 86416000000.0 107433000000.0 \n",
" Daily Cash Op Expenses 206068493.1507 236756164.3836 294336986.3014 \n",
" Defensive Interval 111.7493 110.7933 116.601 \n",
"META WC / Net Income as % 416.5306 534.897 308.5642 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 12877000000.0 20993000000.0 33442000000.0 \n",
" Cash Op Expenses 3563000000.0 4942000000.0 6950000000.0 \n",
" Daily Cash Op Expenses 9761643.8356 13539726.0274 19041095.8904 \n",
" Defensive Interval 1319.1426 1550.4745 1756.3065 \n",
"WMT WC / Net Income as % -50.93 -12.186 -29.8081 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 13958000000.0 15913000000.0 14329000000.0 \n",
" Cash Op Expenses 440552000000.0 449331000000.0 448571000000.0 \n",
" Daily Cash Op Expenses 1206991780.8219 1231043835.6164 1228961643.8356 \n",
" Defensive Interval 11.5643 12.9264 11.6594 \n",
"\n",
" 2017 2018 2019 \\\n",
"AAPL WC / Net Income as % 57.5603 24.3117 103.339 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 109854000000.0 115296000000.0 146361000000.0 \n",
" Cash Op Expenses 146152000000.0 169558000000.0 167480000000.0 \n",
" Daily Cash Op Expenses 400416438.3562 464542465.7534 458849315.0685 \n",
" Defensive Interval 274.3494 248.1926 318.974 \n",
"AMZN WC / Net Income as % 76.2941 66.6137 73.5416 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 44150000000.0 57927000000.0 75837000000.0 \n",
" Cash Op Expenses 139448000000.0 175992000000.0 208060000000.0 \n",
" Daily Cash Op Expenses 382049315.0685 482169863.0137 570027397.2603 \n",
" Defensive Interval 115.561 120.1382 133.041 \n",
"META WC / Net Income as % 281.1786 196.5584 276.8299 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 47543000000.0 48701000000.0 64373000000.0 \n",
" Cash Op Expenses 9671000000.0 16337000000.0 27370000000.0 \n",
" Daily Cash Op Expenses 26495890.411 44758904.1096 74986301.3699 \n",
" Defensive Interval 1794.3537 1088.074 858.4635 \n",
"WMT WC / Net Income as % -67.7197 -191.2087 -233.5832 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 12702000000.0 12370000000.0 14005000000.0 \n",
" Cash Op Expenses 453029000000.0 469377000000.0 481770000000.0 \n",
" Daily Cash Op Expenses 1241175342.4658 1285964383.5616 1319917808.2192 \n",
" Defensive Interval 10.2338 9.6192 10.6105 \n",
"\n",
" 2020 2021 2022 \\\n",
"AAPL WC / Net Income as % 66.7485 9.8807 -18.6137 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 128388000000.0 114145000000.0 109236000000.0 \n",
" Cash Op Expenses 178419000000.0 223670000000.0 237536000000.0 \n",
" Daily Cash Op Expenses 488819178.0822 612794520.5479 650783561.6438 \n",
" Defensive Interval 262.6493 186.2696 167.853 \n",
"AMZN WC / Net Income as % 29.7595 57.8887 316.0176 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 108938000000.0 128940000000.0 112386000000.0 \n",
" Cash Op Expenses 295320000000.0 354396000000.0 385338000000.0 \n",
" Daily Cash Op Expenses 809095890.411 970947945.2055 1055720547.9452 \n",
" Defensive Interval 134.6416 132.7981 106.4543 \n",
"META WC / Net Income as % 208.2241 115.649 140.1853 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 73289000000.0 62037000000.0 54204000000.0 \n",
" Cash Op Expenses 27985000000.0 38554000000.0 43641000000.0 \n",
" Daily Cash Op Expenses 76671232.8767 105627397.2603 119564383.5616 \n",
" Defensive Interval 955.8865 587.3192 453.3457 \n",
"WMT WC / Net Income as % -107.4121 -19.0822 -46.142 \n",
" Large Revenues 1.0 1.0 1.0 \n",
" Quick Assets 15749000000.0 24257000000.0 23040000000.0 \n",
" Cash Op Expenses 490262000000.0 525120000000.0 538996000000.0 \n",
" Daily Cash Op Expenses 1343183561.6438 1438684931.5068 1476701369.863 \n",
" Defensive Interval 11.7251 16.8605 15.6023 \n",
"\n",
" 2023 \n",
"AAPL WC / Net Income as % -1.796 \n",
" Large Revenues 1.0 \n",
" Quick Assets 122540000000.0 \n",
" Cash Op Expenses 227550000000.0 \n",
" Daily Cash Op Expenses 623424657.5342 \n",
" Defensive Interval 196.5594 \n",
"AMZN WC / Net Income as % NaN \n",
" Large Revenues 0.0 \n",
" Quick Assets NaN \n",
" Cash Op Expenses NaN \n",
" Daily Cash Op Expenses NaN \n",
" Defensive Interval NaN \n",
"META WC / Net Income as % NaN \n",
" Large Revenues 0.0 \n",
" Quick Assets NaN \n",
" Cash Op Expenses NaN \n",
" Daily Cash Op Expenses NaN \n",
" Defensive Interval NaN \n",
"WMT WC / Net Income as % -141.6353 \n",
" Large Revenues 1.0 \n",
" Quick Assets 16818000000.0 \n",
" Cash Op Expenses 581200000000.0 \n",
" Daily Cash Op Expenses 1592328767.1233 \n",
" Defensive Interval 10.5619 "
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"custom_ratios = {\n",
" \"WC / Net Income as %\": \"(Working Capital / Net Income) * 100\",\n",
" \"Large Revenues\": \"Revenue > 1000000000\",\n",
" \"Quick Assets\": \"Cash and Short Term Investments + Accounts Receivable\",\n",
" \"Cash Op Expenses\": \"Cost of Goods Sold + Selling, General and Administrative Expenses \"\n",
" \"- Depreciation and Amortization\",\n",
" \"Daily Cash Op Expenses\": \"Cash Op Expenses / 365\",\n",
" \"Defensive Interval\": \"Quick Assets / Daily Cash Op Expenses\",\n",
"}\n",
"\n",
"companies.ratios.collect_custom_ratios(custom_ratios_dict=custom_ratios)"
]
},
{
"cell_type": "markdown",
"id": "4306cd49",
"metadata": {},
"source": [
"It is also relatively straight forward to use the actual models provided you have the data available to flow through these functions. While the `Toolkit` class itself parses data from Financial Modeling Prep, if you utilize the individual models you can provide your own data as well while reaching the same results."
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "c38bb4b6",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"