face_statements.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "1917c9d8",
   "metadata": {},
   "source": [
    "# As-Reported Face Statements\n",
    "## Income statement, balance sheet, statement of cash flows.\n",
    "## The data behind https://www.calcbench.com/detail\n",
    "## https://calcbench.github.io/python_api_client/html/face-statements.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "28978ef4",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: calcbench-api-client[Pandas] in c:\\users\\andre\\repos\\python_api_client (13.1.1)\n",
      "Requirement already satisfied: requests in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from calcbench-api-client[Pandas]) (2.31.0)\n",
      "Requirement already satisfied: pydantic>=2.0.0 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from calcbench-api-client[Pandas]) (2.5.3)\n",
      "Requirement already satisfied: Pandas>=1.0.0 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from calcbench-api-client[Pandas]) (2.2.0)\n",
      "Requirement already satisfied: numpy<2,>=1.23.2 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from Pandas>=1.0.0->calcbench-api-client[Pandas]) (1.23.5)\n",
      "Requirement already satisfied: python-dateutil>=2.8.2 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from Pandas>=1.0.0->calcbench-api-client[Pandas]) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2020.1 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from Pandas>=1.0.0->calcbench-api-client[Pandas]) (2023.3.post1)\n",
      "Requirement already satisfied: tzdata>=2022.7 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from Pandas>=1.0.0->calcbench-api-client[Pandas]) (2023.4)\n",
      "Requirement already satisfied: annotated-types>=0.4.0 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from pydantic>=2.0.0->calcbench-api-client[Pandas]) (0.6.0)\n",
      "Requirement already satisfied: pydantic-core==2.14.6 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from pydantic>=2.0.0->calcbench-api-client[Pandas]) (2.14.6)\n",
      "Requirement already satisfied: typing-extensions>=4.6.1 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from pydantic>=2.0.0->calcbench-api-client[Pandas]) (4.9.0)\n",
      "Requirement already satisfied: charset-normalizer<4,>=2 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from requests->calcbench-api-client[Pandas]) (3.3.2)\n",
      "Requirement already satisfied: idna<4,>=2.5 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from requests->calcbench-api-client[Pandas]) (3.6)\n",
      "Requirement already satisfied: urllib3<3,>=1.21.1 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from requests->calcbench-api-client[Pandas]) (2.1.0)\n",
      "Requirement already satisfied: certifi>=2017.4.17 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from requests->calcbench-api-client[Pandas]) (2023.11.17)\n",
      "Requirement already satisfied: six>=1.5 in c:\\users\\andre\\appdata\\local\\programs\\python\\python311\\lib\\site-packages (from python-dateutil>=2.8.2->Pandas>=1.0.0->calcbench-api-client[Pandas]) (1.16.0)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n",
      "[notice] A new release of pip is available: 24.0 -> 24.2\n",
      "[notice] To update, run: python.exe -m pip install --upgrade pip\n"
     ]
    }
   ],
   "source": [
    "%pip install calcbench-api-client[Pandas]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ba200a6b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import calcbench as cb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "504df840",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = cb.face_statements.face_statement(\n",
    "    company_identifier=\"MSFT\",\n",
    "    statement_type=\"income\",\n",
    "    period_type=\"annual\",\n",
    "    all_history=True,\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "35e03a30",
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"17\" halign=\"left\">Microsoft Corp</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"17\" halign=\"left\">INCOME STATEMENTS</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Y 2008</th>\n",
       "      <th>Y 2009</th>\n",
       "      <th>Y 2010</th>\n",
       "      <th>Y 2011</th>\n",
       "      <th>Y 2012</th>\n",
       "      <th>Y 2013</th>\n",
       "      <th>Y 2014</th>\n",
       "      <th>Y 2015</th>\n",
       "      <th>Y 2016</th>\n",
       "      <th>Y 2017</th>\n",
       "      <th>Y 2018</th>\n",
       "      <th>Y 2019</th>\n",
       "      <th>Y 2020</th>\n",
       "      <th>Y 2021</th>\n",
       "      <th>Y 2022</th>\n",
       "      <th>Y 2023</th>\n",
       "      <th>Y 2024</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Product</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>67336000000.0</td>\n",
       "      <td>63811000000.0</td>\n",
       "      <td>64497000000.0</td>\n",
       "      <td>66069000000.0</td>\n",
       "      <td>68041000000.0</td>\n",
       "      <td>71074000000.0</td>\n",
       "      <td>72732000000.0</td>\n",
       "      <td>64699000000.0</td>\n",
       "      <td>64773000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service and other</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>17624000000.0</td>\n",
       "      <td>23818000000.0</td>\n",
       "      <td>32760000000.0</td>\n",
       "      <td>45863000000.0</td>\n",
       "      <td>59774000000.0</td>\n",
       "      <td>74974000000.0</td>\n",
       "      <td>97014000000.0</td>\n",
       "      <td>125538000000.0</td>\n",
       "      <td>147216000000.0</td>\n",
       "      <td>180349000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue</th>\n",
       "      <td>60420000000.0</td>\n",
       "      <td>58437000000.0</td>\n",
       "      <td>62484000000.0</td>\n",
       "      <td>69943000000.0</td>\n",
       "      <td>73723000000.0</td>\n",
       "      <td>77849000000.0</td>\n",
       "      <td>86833000000.0</td>\n",
       "      <td>93580000000.0</td>\n",
       "      <td>91154000000.0</td>\n",
       "      <td>96571000000.0</td>\n",
       "      <td>110360000000.0</td>\n",
       "      <td>125843000000.0</td>\n",
       "      <td>143015000000.0</td>\n",
       "      <td>168088000000.0</td>\n",
       "      <td>198270000000.0</td>\n",
       "      <td>211915000000.0</td>\n",
       "      <td>245122000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Product</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>21410000000.0</td>\n",
       "      <td>17880000000.0</td>\n",
       "      <td>15175000000.0</td>\n",
       "      <td>15420000000.0</td>\n",
       "      <td>16273000000.0</td>\n",
       "      <td>16017000000.0</td>\n",
       "      <td>18219000000.0</td>\n",
       "      <td>19064000000.0</td>\n",
       "      <td>17804000000.0</td>\n",
       "      <td>15272000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Service and other</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>11628000000.0</td>\n",
       "      <td>14900000000.0</td>\n",
       "      <td>19086000000.0</td>\n",
       "      <td>22933000000.0</td>\n",
       "      <td>26637000000.0</td>\n",
       "      <td>30061000000.0</td>\n",
       "      <td>34013000000.0</td>\n",
       "      <td>43586000000.0</td>\n",
       "      <td>48059000000.0</td>\n",
       "      <td>58842000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cost of revenue</th>\n",
       "      <td>11598000000.0</td>\n",
       "      <td>12155000000.0</td>\n",
       "      <td>12395000000.0</td>\n",
       "      <td>15577000000.0</td>\n",
       "      <td>17530000000.0</td>\n",
       "      <td>20385000000.0</td>\n",
       "      <td>27078000000.0</td>\n",
       "      <td>33038000000.0</td>\n",
       "      <td>32780000000.0</td>\n",
       "      <td>34261000000.0</td>\n",
       "      <td>38353000000.0</td>\n",
       "      <td>42910000000.0</td>\n",
       "      <td>46078000000.0</td>\n",
       "      <td>52232000000.0</td>\n",
       "      <td>62650000000.0</td>\n",
       "      <td>65863000000.0</td>\n",
       "      <td>74114000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gross margin</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>54366000000.0</td>\n",
       "      <td>56193000000.0</td>\n",
       "      <td>57464000000.0</td>\n",
       "      <td>59755000000.0</td>\n",
       "      <td>60542000000.0</td>\n",
       "      <td>58374000000.0</td>\n",
       "      <td>62310000000.0</td>\n",
       "      <td>72007000000.0</td>\n",
       "      <td>82933000000.0</td>\n",
       "      <td>96937000000.0</td>\n",
       "      <td>115856000000.0</td>\n",
       "      <td>135620000000.0</td>\n",
       "      <td>146052000000.0</td>\n",
       "      <td>171008000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Research and development</th>\n",
       "      <td>8164000000.0</td>\n",
       "      <td>9010000000.0</td>\n",
       "      <td>8714000000.0</td>\n",
       "      <td>9043000000.0</td>\n",
       "      <td>9811000000.0</td>\n",
       "      <td>10411000000.0</td>\n",
       "      <td>11381000000.0</td>\n",
       "      <td>12046000000.0</td>\n",
       "      <td>11988000000.0</td>\n",
       "      <td>13037000000.0</td>\n",
       "      <td>14726000000.0</td>\n",
       "      <td>16876000000.0</td>\n",
       "      <td>19269000000.0</td>\n",
       "      <td>20716000000.0</td>\n",
       "      <td>24512000000.0</td>\n",
       "      <td>27195000000.0</td>\n",
       "      <td>29510000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales and marketing</th>\n",
       "      <td>13260000000.0</td>\n",
       "      <td>12879000000.0</td>\n",
       "      <td>13214000000.0</td>\n",
       "      <td>13940000000.0</td>\n",
       "      <td>13857000000.0</td>\n",
       "      <td>15276000000.0</td>\n",
       "      <td>15811000000.0</td>\n",
       "      <td>15713000000.0</td>\n",
       "      <td>14635000000.0</td>\n",
       "      <td>15461000000.0</td>\n",
       "      <td>17469000000.0</td>\n",
       "      <td>18213000000.0</td>\n",
       "      <td>19598000000.0</td>\n",
       "      <td>20117000000.0</td>\n",
       "      <td>21825000000.0</td>\n",
       "      <td>22759000000.0</td>\n",
       "      <td>24456000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>General and administrative</th>\n",
       "      <td>5127000000.0</td>\n",
       "      <td>4030000000.0</td>\n",
       "      <td>4063000000.0</td>\n",
       "      <td>4222000000.0</td>\n",
       "      <td>4569000000.0</td>\n",
       "      <td>5013000000.0</td>\n",
       "      <td>4677000000.0</td>\n",
       "      <td>4611000000.0</td>\n",
       "      <td>4563000000.0</td>\n",
       "      <td>4481000000.0</td>\n",
       "      <td>4754000000.0</td>\n",
       "      <td>4885000000.0</td>\n",
       "      <td>5111000000.0</td>\n",
       "      <td>5107000000.0</td>\n",
       "      <td>5900000000.0</td>\n",
       "      <td>7575000000.0</td>\n",
       "      <td>7609000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Employee severance</th>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Goodwill impairment</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6193000000.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total operating expenses</th>\n",
       "      <td>38149000000.0</td>\n",
       "      <td>38074000000.0</td>\n",
       "      <td>38386000000.0</td>\n",
       "      <td>27205000000.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Integration and restructuring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Impairment, integration, and restructuring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.0</td>\n",
       "      <td>127000000.0</td>\n",
       "      <td>10011000000.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Impairment and restructuring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1110000000.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Restructuring</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>306000000.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operating income</th>\n",
       "      <td>22271000000.0</td>\n",
       "      <td>20363000000.0</td>\n",
       "      <td>24098000000.0</td>\n",
       "      <td>27161000000.0</td>\n",
       "      <td>21763000000.0</td>\n",
       "      <td>26764000000.0</td>\n",
       "      <td>27759000000.0</td>\n",
       "      <td>18161000000.0</td>\n",
       "      <td>26078000000.0</td>\n",
       "      <td>29025000000.0</td>\n",
       "      <td>35058000000.0</td>\n",
       "      <td>42959000000.0</td>\n",
       "      <td>52959000000.0</td>\n",
       "      <td>69916000000.0</td>\n",
       "      <td>83383000000.0</td>\n",
       "      <td>88523000000.0</td>\n",
       "      <td>109433000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other income (expense), net</th>\n",
       "      <td>1543000000.0</td>\n",
       "      <td>-542000000.0</td>\n",
       "      <td>915000000.0</td>\n",
       "      <td>910000000.0</td>\n",
       "      <td>504000000.0</td>\n",
       "      <td>288000000.0</td>\n",
       "      <td>61000000.0</td>\n",
       "      <td>346000000.0</td>\n",
       "      <td>-439000000.0</td>\n",
       "      <td>876000000.0</td>\n",
       "      <td>1416000000.0</td>\n",
       "      <td>729000000.0</td>\n",
       "      <td>77000000.0</td>\n",
       "      <td>1186000000.0</td>\n",
       "      <td>333000000.0</td>\n",
       "      <td>788000000.0</td>\n",
       "      <td>-1646000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Income before income taxes</th>\n",
       "      <td>23814000000.0</td>\n",
       "      <td>19821000000.0</td>\n",
       "      <td>25013000000.0</td>\n",
       "      <td>28071000000.0</td>\n",
       "      <td>22267000000.0</td>\n",
       "      <td>27052000000.0</td>\n",
       "      <td>27820000000.0</td>\n",
       "      <td>18507000000.0</td>\n",
       "      <td>25639000000.0</td>\n",
       "      <td>29901000000.0</td>\n",
       "      <td>36474000000.0</td>\n",
       "      <td>43688000000.0</td>\n",
       "      <td>53036000000.0</td>\n",
       "      <td>71102000000.0</td>\n",
       "      <td>83716000000.0</td>\n",
       "      <td>89311000000.0</td>\n",
       "      <td>107787000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Provision for income taxes</th>\n",
       "      <td>6133000000.0</td>\n",
       "      <td>5252000000.0</td>\n",
       "      <td>6253000000.0</td>\n",
       "      <td>4921000000.0</td>\n",
       "      <td>5289000000.0</td>\n",
       "      <td>5189000000.0</td>\n",
       "      <td>5746000000.0</td>\n",
       "      <td>6314000000.0</td>\n",
       "      <td>5100000000.0</td>\n",
       "      <td>4412000000.0</td>\n",
       "      <td>19903000000.0</td>\n",
       "      <td>4448000000.0</td>\n",
       "      <td>8755000000.0</td>\n",
       "      <td>9831000000.0</td>\n",
       "      <td>10978000000.0</td>\n",
       "      <td>16950000000.0</td>\n",
       "      <td>19651000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Net income</th>\n",
       "      <td>17681000000.0</td>\n",
       "      <td>14569000000.0</td>\n",
       "      <td>18760000000.0</td>\n",
       "      <td>23150000000.0</td>\n",
       "      <td>16978000000.0</td>\n",
       "      <td>21863000000.0</td>\n",
       "      <td>22074000000.0</td>\n",
       "      <td>12193000000.0</td>\n",
       "      <td>20539000000.0</td>\n",
       "      <td>25489000000.0</td>\n",
       "      <td>16571000000.0</td>\n",
       "      <td>39240000000.0</td>\n",
       "      <td>44281000000.0</td>\n",
       "      <td>61271000000.0</td>\n",
       "      <td>72738000000.0</td>\n",
       "      <td>72361000000.0</td>\n",
       "      <td>88136000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Earnings per share:</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Basic</th>\n",
       "      <td>1.9</td>\n",
       "      <td>1.63</td>\n",
       "      <td>2.13</td>\n",
       "      <td>2.73</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2.61</td>\n",
       "      <td>2.66</td>\n",
       "      <td>1.49</td>\n",
       "      <td>2.59</td>\n",
       "      <td>3.29</td>\n",
       "      <td>2.15</td>\n",
       "      <td>5.11</td>\n",
       "      <td>5.82</td>\n",
       "      <td>8.12</td>\n",
       "      <td>9.7</td>\n",
       "      <td>9.72</td>\n",
       "      <td>11.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Diluted</th>\n",
       "      <td>1.87</td>\n",
       "      <td>1.62</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2.69</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.58</td>\n",
       "      <td>2.63</td>\n",
       "      <td>1.48</td>\n",
       "      <td>2.56</td>\n",
       "      <td>3.25</td>\n",
       "      <td>2.13</td>\n",
       "      <td>5.06</td>\n",
       "      <td>5.76</td>\n",
       "      <td>8.05</td>\n",
       "      <td>9.65</td>\n",
       "      <td>9.68</td>\n",
       "      <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Weighted average shares outstanding:</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Basic</th>\n",
       "      <td>9328000000.0</td>\n",
       "      <td>8945000000.0</td>\n",
       "      <td>8813000000.0</td>\n",
       "      <td>8490000000.0</td>\n",
       "      <td>8396000000.0</td>\n",
       "      <td>8375000000.0</td>\n",
       "      <td>8299000000.0</td>\n",
       "      <td>8177000000.0</td>\n",
       "      <td>7925000000.0</td>\n",
       "      <td>7746000000.0</td>\n",
       "      <td>7700000000.0</td>\n",
       "      <td>7673000000.0</td>\n",
       "      <td>7610000000.0</td>\n",
       "      <td>7547000000.0</td>\n",
       "      <td>7496000000.0</td>\n",
       "      <td>7446000000.0</td>\n",
       "      <td>7431000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Diluted</th>\n",
       "      <td>9470000000.0</td>\n",
       "      <td>8996000000.0</td>\n",
       "      <td>8927000000.0</td>\n",
       "      <td>8593000000.0</td>\n",
       "      <td>8506000000.0</td>\n",
       "      <td>8470000000.0</td>\n",
       "      <td>8399000000.0</td>\n",
       "      <td>8254000000.0</td>\n",
       "      <td>8013000000.0</td>\n",
       "      <td>7832000000.0</td>\n",
       "      <td>7794000000.0</td>\n",
       "      <td>7753000000.0</td>\n",
       "      <td>7683000000.0</td>\n",
       "      <td>7608000000.0</td>\n",
       "      <td>7540000000.0</td>\n",
       "      <td>7472000000.0</td>\n",
       "      <td>7469000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cash dividends declared per common share</th>\n",
       "      <td>0.44</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.92</td>\n",
       "      <td>1.12</td>\n",
       "      <td>1.24</td>\n",
       "      <td>1.44</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              Microsoft Corp                 \\\n",
       "                                           INCOME STATEMENTS                  \n",
       "                                                      Y 2008         Y 2009   \n",
       "Product                                                 None           None   \n",
       "Service and other                                       None           None   \n",
       "Revenue                                        60420000000.0  58437000000.0   \n",
       "Product                                                 None           None   \n",
       "Service and other                                       None           None   \n",
       "Cost of revenue                                11598000000.0  12155000000.0   \n",
       "Gross margin                                            None           None   \n",
       "Research and development                        8164000000.0   9010000000.0   \n",
       "Sales and marketing                            13260000000.0  12879000000.0   \n",
       "General and administrative                      5127000000.0   4030000000.0   \n",
       "Employee severance                                       0.0           None   \n",
       "Goodwill impairment                                     None           None   \n",
       "Total operating expenses                       38149000000.0  38074000000.0   \n",
       "Integration and restructuring                           None           None   \n",
       "Impairment, integration, and restructuring              None           None   \n",
       "Impairment and restructuring                            None           None   \n",
       "Restructuring                                           None           None   \n",
       "Operating income                               22271000000.0  20363000000.0   \n",
       "Other income (expense), net                     1543000000.0   -542000000.0   \n",
       "Income before income taxes                     23814000000.0  19821000000.0   \n",
       "Provision for income taxes                      6133000000.0   5252000000.0   \n",
       "Net income                                     17681000000.0  14569000000.0   \n",
       "Earnings per share:                                     None           None   \n",
       "Basic                                                    1.9           1.63   \n",
       "Diluted                                                 1.87           1.62   \n",
       "Weighted average shares outstanding:                    None           None   \n",
       "Basic                                           9328000000.0   8945000000.0   \n",
       "Diluted                                         9470000000.0   8996000000.0   \n",
       "Cash dividends declared per common share                0.44           0.52   \n",
       "\n",
       "                                                                          \\\n",
       "                                                                           \n",
       "                                                   Y 2010         Y 2011   \n",
       "Product                                              None           None   \n",
       "Service and other                                    None           None   \n",
       "Revenue                                     62484000000.0  69943000000.0   \n",
       "Product                                              None           None   \n",
       "Service and other                                    None           None   \n",
       "Cost of revenue                             12395000000.0  15577000000.0   \n",
       "Gross margin                                         None  54366000000.0   \n",
       "Research and development                     8714000000.0   9043000000.0   \n",
       "Sales and marketing                         13214000000.0  13940000000.0   \n",
       "General and administrative                   4063000000.0   4222000000.0   \n",
       "Employee severance                                   None           None   \n",
       "Goodwill impairment                                   0.0            0.0   \n",
       "Total operating expenses                    38386000000.0  27205000000.0   \n",
       "Integration and restructuring                        None           None   \n",
       "Impairment, integration, and restructuring           None           None   \n",
       "Impairment and restructuring                         None           None   \n",
       "Restructuring                                        None           None   \n",
       "Operating income                            24098000000.0  27161000000.0   \n",
       "Other income (expense), net                   915000000.0    910000000.0   \n",
       "Income before income taxes                  25013000000.0  28071000000.0   \n",
       "Provision for income taxes                   6253000000.0   4921000000.0   \n",
       "Net income                                  18760000000.0  23150000000.0   \n",
       "Earnings per share:                                  None           None   \n",
       "Basic                                                2.13           2.73   \n",
       "Diluted                                               2.1           2.69   \n",
       "Weighted average shares outstanding:                 None           None   \n",
       "Basic                                        8813000000.0   8490000000.0   \n",
       "Diluted                                      8927000000.0   8593000000.0   \n",
       "Cash dividends declared per common share             0.52           0.64   \n",
       "\n",
       "                                                                          \\\n",
       "                                                                           \n",
       "                                                   Y 2012         Y 2013   \n",
       "Product                                              None           None   \n",
       "Service and other                                    None           None   \n",
       "Revenue                                     73723000000.0  77849000000.0   \n",
       "Product                                              None           None   \n",
       "Service and other                                    None           None   \n",
       "Cost of revenue                             17530000000.0  20385000000.0   \n",
       "Gross margin                                56193000000.0  57464000000.0   \n",
       "Research and development                     9811000000.0  10411000000.0   \n",
       "Sales and marketing                         13857000000.0  15276000000.0   \n",
       "General and administrative                   4569000000.0   5013000000.0   \n",
       "Employee severance                                   None           None   \n",
       "Goodwill impairment                          6193000000.0           None   \n",
       "Total operating expenses                             None           None   \n",
       "Integration and restructuring                         0.0           None   \n",
       "Impairment, integration, and restructuring           None            0.0   \n",
       "Impairment and restructuring                         None           None   \n",
       "Restructuring                                        None           None   \n",
       "Operating income                            21763000000.0  26764000000.0   \n",
       "Other income (expense), net                   504000000.0    288000000.0   \n",
       "Income before income taxes                  22267000000.0  27052000000.0   \n",
       "Provision for income taxes                   5289000000.0   5189000000.0   \n",
       "Net income                                  16978000000.0  21863000000.0   \n",
       "Earnings per share:                                  None           None   \n",
       "Basic                                                2.02           2.61   \n",
       "Diluted                                               2.0           2.58   \n",
       "Weighted average shares outstanding:                 None           None   \n",
       "Basic                                        8396000000.0   8375000000.0   \n",
       "Diluted                                      8506000000.0   8470000000.0   \n",
       "Cash dividends declared per common share              0.8           0.92   \n",
       "\n",
       "                                                                          \\\n",
       "                                                                           \n",
       "                                                   Y 2014         Y 2015   \n",
       "Product                                              None           None   \n",
       "Service and other                                    None  17624000000.0   \n",
       "Revenue                                     86833000000.0  93580000000.0   \n",
       "Product                                              None  21410000000.0   \n",
       "Service and other                                    None  11628000000.0   \n",
       "Cost of revenue                             27078000000.0  33038000000.0   \n",
       "Gross margin                                59755000000.0  60542000000.0   \n",
       "Research and development                    11381000000.0  12046000000.0   \n",
       "Sales and marketing                         15811000000.0  15713000000.0   \n",
       "General and administrative                   4677000000.0   4611000000.0   \n",
       "Employee severance                                   None           None   \n",
       "Goodwill impairment                                  None           None   \n",
       "Total operating expenses                             None           None   \n",
       "Integration and restructuring                        None           None   \n",
       "Impairment, integration, and restructuring    127000000.0  10011000000.0   \n",
       "Impairment and restructuring                         None           None   \n",
       "Restructuring                                        None           None   \n",
       "Operating income                            27759000000.0  18161000000.0   \n",
       "Other income (expense), net                    61000000.0    346000000.0   \n",
       "Income before income taxes                  27820000000.0  18507000000.0   \n",
       "Provision for income taxes                   5746000000.0   6314000000.0   \n",
       "Net income                                  22074000000.0  12193000000.0   \n",
       "Earnings per share:                                  None           None   \n",
       "Basic                                                2.66           1.49   \n",
       "Diluted                                              2.63           1.48   \n",
       "Weighted average shares outstanding:                 None           None   \n",
       "Basic                                        8299000000.0   8177000000.0   \n",
       "Diluted                                      8399000000.0   8254000000.0   \n",
       "Cash dividends declared per common share             1.12           1.24   \n",
       "\n",
       "                                                                          \\\n",
       "                                                                           \n",
       "                                                   Y 2016         Y 2017   \n",
       "Product                                     67336000000.0  63811000000.0   \n",
       "Service and other                           23818000000.0  32760000000.0   \n",
       "Revenue                                     91154000000.0  96571000000.0   \n",
       "Product                                     17880000000.0  15175000000.0   \n",
       "Service and other                           14900000000.0  19086000000.0   \n",
       "Cost of revenue                             32780000000.0  34261000000.0   \n",
       "Gross margin                                58374000000.0  62310000000.0   \n",
       "Research and development                    11988000000.0  13037000000.0   \n",
       "Sales and marketing                         14635000000.0  15461000000.0   \n",
       "General and administrative                   4563000000.0   4481000000.0   \n",
       "Employee severance                                   None           None   \n",
       "Goodwill impairment                                  None           None   \n",
       "Total operating expenses                             None           None   \n",
       "Integration and restructuring                        None           None   \n",
       "Impairment, integration, and restructuring           None           None   \n",
       "Impairment and restructuring                 1110000000.0           None   \n",
       "Restructuring                                        None    306000000.0   \n",
       "Operating income                            26078000000.0  29025000000.0   \n",
       "Other income (expense), net                  -439000000.0    876000000.0   \n",
       "Income before income taxes                  25639000000.0  29901000000.0   \n",
       "Provision for income taxes                   5100000000.0   4412000000.0   \n",
       "Net income                                  20539000000.0  25489000000.0   \n",
       "Earnings per share:                                  None           None   \n",
       "Basic                                                2.59           3.29   \n",
       "Diluted                                              2.56           3.25   \n",
       "Weighted average shares outstanding:                 None           None   \n",
       "Basic                                        7925000000.0   7746000000.0   \n",
       "Diluted                                      8013000000.0   7832000000.0   \n",
       "Cash dividends declared per common share             1.44           None   \n",
       "\n",
       "                                                                            \\\n",
       "                                                                             \n",
       "                                                    Y 2018          Y 2019   \n",
       "Product                                      64497000000.0   66069000000.0   \n",
       "Service and other                            45863000000.0   59774000000.0   \n",
       "Revenue                                     110360000000.0  125843000000.0   \n",
       "Product                                      15420000000.0   16273000000.0   \n",
       "Service and other                            22933000000.0   26637000000.0   \n",
       "Cost of revenue                              38353000000.0   42910000000.0   \n",
       "Gross margin                                 72007000000.0   82933000000.0   \n",
       "Research and development                     14726000000.0   16876000000.0   \n",
       "Sales and marketing                          17469000000.0   18213000000.0   \n",
       "General and administrative                    4754000000.0    4885000000.0   \n",
       "Employee severance                                    None            None   \n",
       "Goodwill impairment                                   None            None   \n",
       "Total operating expenses                              None            None   \n",
       "Integration and restructuring                         None            None   \n",
       "Impairment, integration, and restructuring            None            None   \n",
       "Impairment and restructuring                          None            None   \n",
       "Restructuring                                         None            None   \n",
       "Operating income                             35058000000.0   42959000000.0   \n",
       "Other income (expense), net                   1416000000.0     729000000.0   \n",
       "Income before income taxes                   36474000000.0   43688000000.0   \n",
       "Provision for income taxes                   19903000000.0    4448000000.0   \n",
       "Net income                                   16571000000.0   39240000000.0   \n",
       "Earnings per share:                                   None            None   \n",
       "Basic                                                 2.15            5.11   \n",
       "Diluted                                               2.13            5.06   \n",
       "Weighted average shares outstanding:                  None            None   \n",
       "Basic                                         7700000000.0    7673000000.0   \n",
       "Diluted                                       7794000000.0    7753000000.0   \n",
       "Cash dividends declared per common share              None            None   \n",
       "\n",
       "                                                                            \\\n",
       "                                                                             \n",
       "                                                    Y 2020          Y 2021   \n",
       "Product                                      68041000000.0   71074000000.0   \n",
       "Service and other                            74974000000.0   97014000000.0   \n",
       "Revenue                                     143015000000.0  168088000000.0   \n",
       "Product                                      16017000000.0   18219000000.0   \n",
       "Service and other                            30061000000.0   34013000000.0   \n",
       "Cost of revenue                              46078000000.0   52232000000.0   \n",
       "Gross margin                                 96937000000.0  115856000000.0   \n",
       "Research and development                     19269000000.0   20716000000.0   \n",
       "Sales and marketing                          19598000000.0   20117000000.0   \n",
       "General and administrative                    5111000000.0    5107000000.0   \n",
       "Employee severance                                    None            None   \n",
       "Goodwill impairment                                   None            None   \n",
       "Total operating expenses                              None            None   \n",
       "Integration and restructuring                         None            None   \n",
       "Impairment, integration, and restructuring            None            None   \n",
       "Impairment and restructuring                          None            None   \n",
       "Restructuring                                         None            None   \n",
       "Operating income                             52959000000.0   69916000000.0   \n",
       "Other income (expense), net                     77000000.0    1186000000.0   \n",
       "Income before income taxes                   53036000000.0   71102000000.0   \n",
       "Provision for income taxes                    8755000000.0    9831000000.0   \n",
       "Net income                                   44281000000.0   61271000000.0   \n",
       "Earnings per share:                                   None            None   \n",
       "Basic                                                 5.82            8.12   \n",
       "Diluted                                               5.76            8.05   \n",
       "Weighted average shares outstanding:                  None            None   \n",
       "Basic                                         7610000000.0    7547000000.0   \n",
       "Diluted                                       7683000000.0    7608000000.0   \n",
       "Cash dividends declared per common share              None            None   \n",
       "\n",
       "                                                                            \\\n",
       "                                                                             \n",
       "                                                    Y 2022          Y 2023   \n",
       "Product                                      72732000000.0   64699000000.0   \n",
       "Service and other                           125538000000.0  147216000000.0   \n",
       "Revenue                                     198270000000.0  211915000000.0   \n",
       "Product                                      19064000000.0   17804000000.0   \n",
       "Service and other                            43586000000.0   48059000000.0   \n",
       "Cost of revenue                              62650000000.0   65863000000.0   \n",
       "Gross margin                                135620000000.0  146052000000.0   \n",
       "Research and development                     24512000000.0   27195000000.0   \n",
       "Sales and marketing                          21825000000.0   22759000000.0   \n",
       "General and administrative                    5900000000.0    7575000000.0   \n",
       "Employee severance                                    None            None   \n",
       "Goodwill impairment                                   None            None   \n",
       "Total operating expenses                              None            None   \n",
       "Integration and restructuring                         None            None   \n",
       "Impairment, integration, and restructuring            None            None   \n",
       "Impairment and restructuring                          None            None   \n",
       "Restructuring                                         None            None   \n",
       "Operating income                             83383000000.0   88523000000.0   \n",
       "Other income (expense), net                    333000000.0     788000000.0   \n",
       "Income before income taxes                   83716000000.0   89311000000.0   \n",
       "Provision for income taxes                   10978000000.0   16950000000.0   \n",
       "Net income                                   72738000000.0   72361000000.0   \n",
       "Earnings per share:                                   None            None   \n",
       "Basic                                                  9.7            9.72   \n",
       "Diluted                                               9.65            9.68   \n",
       "Weighted average shares outstanding:                  None            None   \n",
       "Basic                                         7496000000.0    7446000000.0   \n",
       "Diluted                                       7540000000.0    7472000000.0   \n",
       "Cash dividends declared per common share              None            None   \n",
       "\n",
       "                                                            \n",
       "                                                            \n",
       "                                                    Y 2024  \n",
       "Product                                      64773000000.0  \n",
       "Service and other                           180349000000.0  \n",
       "Revenue                                     245122000000.0  \n",
       "Product                                      15272000000.0  \n",
       "Service and other                            58842000000.0  \n",
       "Cost of revenue                              74114000000.0  \n",
       "Gross margin                                171008000000.0  \n",
       "Research and development                     29510000000.0  \n",
       "Sales and marketing                          24456000000.0  \n",
       "General and administrative                    7609000000.0  \n",
       "Employee severance                                    None  \n",
       "Goodwill impairment                                   None  \n",
       "Total operating expenses                              None  \n",
       "Integration and restructuring                         None  \n",
       "Impairment, integration, and restructuring            None  \n",
       "Impairment and restructuring                          None  \n",
       "Restructuring                                         None  \n",
       "Operating income                            109433000000.0  \n",
       "Other income (expense), net                  -1646000000.0  \n",
       "Income before income taxes                  107787000000.0  \n",
       "Provision for income taxes                   19651000000.0  \n",
       "Net income                                   88136000000.0  \n",
       "Earnings per share:                                   None  \n",
       "Basic                                                11.86  \n",
       "Diluted                                               11.8  \n",
       "Weighted average shares outstanding:                  None  \n",
       "Basic                                         7431000000.0  \n",
       "Diluted                                       7469000000.0  \n",
       "Cash dividends declared per common share              None  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.as_dataframe()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}