210903 Example_분양CF_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "import importlib\n",
    "import pandas as pd\n",
    "from pandas import Series, DataFrame\n",
    "import numpy as np\n",
    "from datetime import datetime\n",
    "from datetime import date\n",
    "from datetime import timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "import PrjtCF_module as cf"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Outline\n",
    "* 주거시설 등 개발과 동시에 분양을 하는 사업의 재무모델\n",
    "* PF대출을 통해 토지비 및 공사비 등 개발사업 자금을 조달\n",
    "* 금융비용은 PF대출금으로 충당\n",
    "* 분양대금의 일부는 사업비로, 일부는 대출금 상환재원으로 사용\n",
    "* PF대출금은 필요에 따라 한도대로 인출"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Input Index Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 기간 Index 설정\n",
    "# prjt index : 사업기간 전 기간에 대한 index로 모델의 base가 되는 index\n",
    "# cstrn index : 공사기간에 대한 index로 착공일로부터 준공일까지의 기간에 대한 index\n",
    "# loan index : 대출기간에 대한 index로 대출 실행일로부터 대출 상환일 까지의 기간에 대한 index\n",
    "# sales index : 분양기간에 대한 index로 분양개시일로부터 분양 종료일 까지의 기간 index\n",
    "idx = cf.PrjtIndex(idxname=['prjt', 'cstrn', 'loan', 'sales'],\n",
    "                   start=['2021-08', '2021-10', '2021-10', '2021-12'],\n",
    "                   periods=[24+1, 18+1, 20+1, 16+1],\n",
    "                   freq='M')\n",
    "\n",
    "# 공정률 Series 설정 : cstrn index 기간 중 적용되는 기간별 공정률 설정\n",
    "idx.prcs = Series(np.ones(len(idx.cstrn)) / len(idx.cstrn),\n",
    "                  index=idx.cstrn.index)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Input Financing Condition Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "equity = cf.Loan(idx, idx, amt_ntnl=10_000)\n",
    "\n",
    "dct_loan = {}\n",
    "tra = cf.Loan(idx, idx.loan, amt_ntnl=100_000,\n",
    "              rate_fee = 0.01,\n",
    "              rate_IR = 0.10)\n",
    "dct_loan['tra'] = tra\n",
    "\n",
    "loan = cf.Merge(dct_loan)\n",
    "loan.tra = loan.dct['tra']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Input Sales Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "dct_sales = {}\n",
    "\n",
    "#### 분양상품A ####\n",
    "# 분양매출 및 납입 일정\n",
    "slsA = cf.Account(idx)\n",
    "slsA.sls_amt = 150_000\n",
    "slsA.csh_idx = idx.sales[[0, 3, 6, 9, 12, 16]]\n",
    "slsA.csh_rate = Series([0.1, 0.1, 0.1, 0.1, 0.1, 0.5], \n",
    "                       index=slsA.csh_idx)\n",
    "# 분양매출 가정\n",
    "slsA.sls_rate = Series(np.array([0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1]),\n",
    "                       index=idx.sales[[0, 2, 4, 6, 7, 8, 9, 12, 14, 16]])\n",
    "slsA.sls_plan = slsA.sls_amt * slsA.sls_rate"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Input Cost Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "dct_cost = {}\n",
    "\n",
    "# 토지비: 최초 1회 지급\n",
    "lnd = cf.Account(idx)\n",
    "lnd.addscdd(idx.cstrn[0], 30_000)\n",
    "dct_cost['lnd'] = lnd\n",
    "\n",
    "# 공사비: 공정률에 따라 지급\n",
    "cstrn = cf.Account(idx)\n",
    "cstrn.addscdd(idx.cstrn.index, 50_000 * idx.prcs)\n",
    "dct_cost['cstrn'] = cstrn\n",
    "\n",
    "cost = cf.Merge(dct_cost)\n",
    "cost.lnd = cost.dct['lnd']\n",
    "cost.cstrn = cost.dct['cstrn']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Execution Cash Flow"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1) 사전 설정"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Make accounts\n",
    "oprtg = cf.Account(idx) # 운영현금흐름의 입출을 위한 운영계좌\n",
    "sales = cf.Account(idx) # 분양수입금의 입출을 위한 분양수입금 계좌\n",
    "rpyacc = cf.Account(idx) # 상환자금 관리를 위한 대출금 상환 계좌"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate expected cost amount and pay cost.\n",
    "class cst_mngmnt:\n",
    "    def __init__(self, idxno, cost):\n",
    "        self.idxno = idxno\n",
    "        self.cost = cost\n",
    "        \n",
    "        # 해당 인덱스 기간 중 cost계좌 상 지출이 예정되어 있는 금액\n",
    "        self.lnd = self.cost['lnd'].add_scdd[self.idxno]\n",
    "        self.cstrn = self.cost['cstrn'].add_scdd[self.idxno]\n",
    "        \n",
    "        # cost 계좌 상 예정된 지출금의 합계액\n",
    "        self.cstamt = self.cost.add_scdd[self.idxno] \n",
    "        \n",
    "        # 해당 인덱스 기간 중 loan 계좌 상 지출 필요 금액\n",
    "        self.fee_fncl = tra.fee.add_scdd[self.idxno]\n",
    "        self.IR_fncl = -tra.ntnl.bal_strt[self.idxno] * tra.IR.rate\n",
    "        \n",
    "    @property\n",
    "    def ttl_exptd(self):\n",
    "        \"\"\"전체 운영비용(cost) 및 금융비용(fee, IR)의 합을 반환\"\"\"\n",
    "        self.ttlsum = self.cstamt\n",
    "        self.ttlsum = (self.ttlsum +\n",
    "                       self.fee_fncl + \n",
    "                       self.IR_fncl)\n",
    "        return self.ttlsum\n",
    "    \n",
    "    def pay_oprtcst(self):\n",
    "        \"\"\"운영계좌에서 운영비용(cost) 지출\"\"\"\n",
    "        # 운영계좌에서 토지비 지출\n",
    "        oprtg.send(self.idxno, self.lnd, self.cost['lnd'])\n",
    "        \n",
    "        # 운영계좌에서 공사비 지출\n",
    "        oprtg.send(self.idxno, self.cstrn, self.cost['cstrn'])\n",
    "        \n",
    "    def pay_fnclcst(self):\n",
    "        \"\"\"운영계좌에서 금융비용 지출\"\"\"\n",
    "        # 운영계좌에서 대출금 수수료 지급\n",
    "        oprtg.send(self.idxno, self.fee_fncl, tra.fee)\n",
    "        \n",
    "        # 운영계좌에서 대출금 이자 지급\n",
    "        oprtg.send(self.idxno, self.IR_fncl, tra.IR)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "class cst_mngmnt_edited:\n",
    "    def __init__(self, idxno, cost, loan):\n",
    "        self.idxno = idxno\n",
    "        self.cost = cost\n",
    "        self.loan = loan\n",
    "        self.set_cst_oprtg()\n",
    "        self.set_cst_loan()\n",
    "        self.set_cst_ttl()\n",
    "        \n",
    "    def set_cst_oprtg(self):\n",
    "        # 해당 인덱스 기간 중 cost계좌 상 지출이 예정되어 있는 금액\n",
    "        ttlsum = 0\n",
    "        for key, val in self.cost.dct.items():\n",
    "            val_scdd = val.add_scdd[self.idxno]\n",
    "            setattr(self, key, val_scdd)\n",
    "            ttlsum += val_scdd\n",
    "        self.cst_oprtg = ttlsum\n",
    "        \n",
    "    def set_cst_loan(self):\n",
    "        # 해당 인덱스 기간 중 loan계좌 상 지출이 예정되어 있는 IR 및 fee\n",
    "        ttlfee = 0\n",
    "        ttlIR = 0\n",
    "        for key, val in self.loan.dct.items():\n",
    "            fee_scdd = val.fee.add_scdd[self.idxno]\n",
    "            setattr(self, \"fee_\"+key, fee_scdd)\n",
    "            ttlfee += fee_scdd\n",
    "            \n",
    "            IR_scdd = -val.ntnl.bal_strt[self.idxno] * val.IR.rate\n",
    "            setattr(self, \"IR_\"+key, IR_scdd)\n",
    "            ttlIR += IR_scdd\n",
    "        self.cst_fnclfee = ttlfee\n",
    "        self.cst_fnclIR = ttlIR\n",
    "        self.cst_fncl = ttlfee + ttlIR\n",
    "        \n",
    "    def set_cst_ttl(self):\n",
    "        self.cst_ttl = self.cst_oprtg + self.cst_fncl\n",
    "        \n",
    "    def pay_oprtcst(self):\n",
    "        \"\"\"운영계좌에서 운영비용(cost) 지출\"\"\"\n",
    "        for key, acnt in self.cost.dct.items():\n",
    "            oprtg.send(self.idxno, getattr(self, key), acnt)\n",
    "            \n",
    "    def pay_fnclcst(self):\n",
    "        \"\"\"운영계좌에서 금융비용 지출\"\"\"\n",
    "        for key, acnt in self.loan.dct.items():\n",
    "            oprtg.send(self.idxno, getattr(self, \"fee_\"+key), acnt.fee)\n",
    "            oprtg.send(self.idxno, getattr(self, \"IR_\"+key), acnt.IR)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Calculate expected repayment of loan and repay loan.\n",
    "class repay_mngmnt:\n",
    "    \"\"\"입력된 Loan instance에 대해서 \n",
    "    - 상환요구금액 계산\n",
    "    - 상환계좌로 자금 이체\n",
    "    - 상환계좌에서 loan 계좌로 상환 처리\"\"\"\n",
    "    def __init__(self, idxno, loan):\n",
    "        self.idxno = idxno\n",
    "        self.loan = loan\n",
    "        \n",
    "        # 상환요구금액 계산\n",
    "        self.exptd_rpy_cum = self.loan.ntnl.add_rsdl_cum[self.idxno]\n",
    "        self.ntnl_bal_end = -self.loan.ntnl.bal_end[self.idxno]\n",
    "        self.rpy_amt = min(self.exptd_rpy_cum, self.ntnl_bal_end)\n",
    "        \n",
    "    # Transfer repayment amount to repayment account\n",
    "    def trsf_rpy(self):\n",
    "        oprtg.send(self.idxno, self.rpy_amt, rpyacc)\n",
    "    \n",
    "    # Repay loan from repayment account\n",
    "    def rpy_ntnl(self):\n",
    "        rpyacc.send(self.idxno, self.rpy_amt, self.loan.ntnl)\n",
    "        "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2) Cash Flow 실행"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Excute cash flow\n",
    "for idxno in idx.index:\n",
    "    # If it's initial date then set loan withdrawble.\n",
    "    equity.set_wtdrbl_intldate(idxno)\n",
    "    tra.set_wtdrbl_intldate(idxno)\n",
    "        \n",
    "    #### Sales : ####\n",
    "    # 분양수입대금 sales schedule에 따라 운영계좌로 이체\n",
    "    sls = cf.sls_mngmnt(idxno, slsA)\n",
    "    sls.make_sls_plan()\n",
    "    sls.rcv_slsamt(sales) # Receive sales amount on sales account\n",
    "    # 분양수입금 분배\n",
    "    intl_bal_end = sales.bal_end[idxno]\n",
    "    amt_to_oprtg = intl_bal_end * 0.2\n",
    "    amt_to_rpy = intl_bal_end * 0.8\n",
    "    sales.send(idxno, amt_to_oprtg, oprtg)\n",
    "    sales.send(idxno, amt_to_rpy, rpyacc)\n",
    "    \n",
    "    # cost instance 생성, 필요지출금액을 인자로 받아, 조달금액 계산 후 운영계좌 입금\n",
    "    cst = cst_mngmnt(idxno, cost)\n",
    "    wtdrw = cf.wtdrw_mngmnt(idxno, cst, oprtg)\n",
    "    wtdrw.wtdrw_equity(equity)\n",
    "    wtdrw.wtdrw_loan(tra)\n",
    "    \n",
    "    # 운영계좌에서 토지비, 공사비 등 각종 비용 지출\n",
    "    cst.pay_oprtcst()\n",
    "    \n",
    "    # 운영계좌에서 각종 금융비용 지출\n",
    "    cst.pay_fnclcst()\n",
    "    \n",
    "    # 대출금 상환 프로세스 진행\n",
    "    repay = repay_mngmnt(idxno, tra) # Loan instance class 생성\n",
    "    repay.trsf_rpy() # 상환 예정 금액을 상환계좌로 이체\n",
    "    repay.rpy_ntnl() # 상환계좌에서 순서에 따라 상환금 인출\n",
    "    \n",
    "    # If it was maturity date then set back loan unwithdrawble.\n",
    "    equity.setback_wtdrbl_mtrt(idxno)\n",
    "    tra.setback_wtdrbl_mtrt(idxno)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge Accounts\n",
    "dct_acc = {'equity':equity,\n",
    "           'tra_ntnl':tra.ntnl,\n",
    "           'tra_fee':tra.fee,\n",
    "           'tra_IR':tra.IR,\n",
    "           'slsA':slsA,\n",
    "           'cost_lnd':cost['lnd'],\n",
    "           'cost_cstrn':cost['cstrn'],\n",
    "           'oprtg':oprtg,\n",
    "           'rpyacc':rpyacc}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Print Result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "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>equity.ntnl</th>\n",
       "      <th colspan=\"2\" halign=\"left\">slsA</th>\n",
       "      <th colspan=\"3\" halign=\"left\">tra.ntnl</th>\n",
       "      <th>tra.fee</th>\n",
       "      <th>tra.IR</th>\n",
       "      <th>cost_lnd</th>\n",
       "      <th>cost_cstrn</th>\n",
       "      <th colspan=\"3\" halign=\"left\">oprtg</th>\n",
       "      <th colspan=\"3\" halign=\"left\">rpyacc</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>bal_end</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>40,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40,000</td>\n",
       "      <td>0</td>\n",
       "      <td>40,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1,000</td>\n",
       "      <td>0</td>\n",
       "      <td>30,000</td>\n",
       "      <td>2,632</td>\n",
       "      <td>0</td>\n",
       "      <td>33,632</td>\n",
       "      <td>6,368</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,737</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>1,500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>300</td>\n",
       "      <td>2,632</td>\n",
       "      <td>1,405</td>\n",
       "      <td>1,200</td>\n",
       "      <td>0</td>\n",
       "      <td>1,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1,226</td>\n",
       "      <td>0</td>\n",
       "      <td>-1,226</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>1,226</td>\n",
       "      <td>2,632</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>1,500</td>\n",
       "      <td>2,342</td>\n",
       "      <td>0</td>\n",
       "      <td>-3,568</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,642</td>\n",
       "      <td>2,642</td>\n",
       "      <td>0</td>\n",
       "      <td>1,200</td>\n",
       "      <td>0</td>\n",
       "      <td>2,400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,000</td>\n",
       "      <td>2,061</td>\n",
       "      <td>0</td>\n",
       "      <td>-5,629</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,661</td>\n",
       "      <td>2,661</td>\n",
       "      <td>0</td>\n",
       "      <td>2,400</td>\n",
       "      <td>0</td>\n",
       "      <td>4,800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>3,000</td>\n",
       "      <td>2,078</td>\n",
       "      <td>0</td>\n",
       "      <td>-7,708</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,678</td>\n",
       "      <td>2,678</td>\n",
       "      <td>0</td>\n",
       "      <td>2,400</td>\n",
       "      <td>0</td>\n",
       "      <td>7,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,696</td>\n",
       "      <td>0</td>\n",
       "      <td>-10,404</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,696</td>\n",
       "      <td>2,696</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7,200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>9,000</td>\n",
       "      <td>918</td>\n",
       "      <td>0</td>\n",
       "      <td>-11,322</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,718</td>\n",
       "      <td>2,718</td>\n",
       "      <td>0</td>\n",
       "      <td>7,200</td>\n",
       "      <td>0</td>\n",
       "      <td>14,400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>4,500</td>\n",
       "      <td>1,826</td>\n",
       "      <td>0</td>\n",
       "      <td>-13,148</td>\n",
       "      <td>0</td>\n",
       "      <td>94</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,726</td>\n",
       "      <td>2,726</td>\n",
       "      <td>0</td>\n",
       "      <td>3,600</td>\n",
       "      <td>0</td>\n",
       "      <td>18,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>4,500</td>\n",
       "      <td>1,841</td>\n",
       "      <td>0</td>\n",
       "      <td>-14,989</td>\n",
       "      <td>0</td>\n",
       "      <td>110</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,741</td>\n",
       "      <td>2,741</td>\n",
       "      <td>0</td>\n",
       "      <td>3,600</td>\n",
       "      <td>0</td>\n",
       "      <td>21,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>15,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-14,989</td>\n",
       "      <td>0</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,000</td>\n",
       "      <td>2,756</td>\n",
       "      <td>244</td>\n",
       "      <td>12,000</td>\n",
       "      <td>0</td>\n",
       "      <td>33,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,513</td>\n",
       "      <td>0</td>\n",
       "      <td>-17,502</td>\n",
       "      <td>0</td>\n",
       "      <td>125</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,513</td>\n",
       "      <td>2,756</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,777</td>\n",
       "      <td>0</td>\n",
       "      <td>-20,279</td>\n",
       "      <td>0</td>\n",
       "      <td>146</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,777</td>\n",
       "      <td>2,777</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33,600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>18,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-20,279</td>\n",
       "      <td>0</td>\n",
       "      <td>169</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,600</td>\n",
       "      <td>2,801</td>\n",
       "      <td>799</td>\n",
       "      <td>14,400</td>\n",
       "      <td>0</td>\n",
       "      <td>48,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,001</td>\n",
       "      <td>0</td>\n",
       "      <td>-22,281</td>\n",
       "      <td>0</td>\n",
       "      <td>169</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,001</td>\n",
       "      <td>2,801</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>7,500</td>\n",
       "      <td>1,317</td>\n",
       "      <td>0</td>\n",
       "      <td>-23,598</td>\n",
       "      <td>0</td>\n",
       "      <td>186</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,817</td>\n",
       "      <td>2,817</td>\n",
       "      <td>0</td>\n",
       "      <td>6,000</td>\n",
       "      <td>0</td>\n",
       "      <td>54,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,828</td>\n",
       "      <td>0</td>\n",
       "      <td>-26,426</td>\n",
       "      <td>0</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,828</td>\n",
       "      <td>2,828</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>82,500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-26,426</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>16,500</td>\n",
       "      <td>2,852</td>\n",
       "      <td>13,648</td>\n",
       "      <td>66,000</td>\n",
       "      <td>0</td>\n",
       "      <td>120,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-26,426</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "      <td>13,428</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>120,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26,426</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26,646</td>\n",
       "      <td>-13,218</td>\n",
       "      <td>26,426</td>\n",
       "      <td>26,426</td>\n",
       "      <td>120,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-13,218</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>120,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-13,218</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>120,000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           equity.ntnl    slsA         tra.ntnl                  tra.fee  \\\n",
       "               amt_sub amt_add amt_sub  amt_sub amt_add  bal_end amt_add   \n",
       "2021-08-31      40,000       0       0        0       0        0       0   \n",
       "2021-09-30           0       0       0        0       0        0       0   \n",
       "2021-10-31           0       0       0        0       0        0   1,000   \n",
       "2021-11-30           0       0       0        0       0        0       0   \n",
       "2021-12-31           0  15,000   1,500        0       0        0       0   \n",
       "2022-01-31           0       0       0    1,226       0   -1,226       0   \n",
       "2022-02-28           0  15,000   1,500    2,342       0   -3,568       0   \n",
       "2022-03-31           0       0   3,000    2,061       0   -5,629       0   \n",
       "2022-04-30           0  15,000   3,000    2,078       0   -7,708       0   \n",
       "2022-05-31           0       0       0    2,696       0  -10,404       0   \n",
       "2022-06-30           0  15,000   9,000      918       0  -11,322       0   \n",
       "2022-07-31           0  15,000   4,500    1,826       0  -13,148       0   \n",
       "2022-08-31           0  15,000   4,500    1,841       0  -14,989       0   \n",
       "2022-09-30           0  15,000  15,000        0       0  -14,989       0   \n",
       "2022-10-31           0       0       0    2,513       0  -17,502       0   \n",
       "2022-11-30           0       0       0    2,777       0  -20,279       0   \n",
       "2022-12-31           0  15,000  18,000        0       0  -20,279       0   \n",
       "2023-01-31           0       0       0    2,001       0  -22,281       0   \n",
       "2023-02-28           0  15,000   7,500    1,317       0  -23,598       0   \n",
       "2023-03-31           0       0       0    2,828       0  -26,426       0   \n",
       "2023-04-30           0  15,000  82,500        0       0  -26,426       0   \n",
       "2023-05-31           0       0       0        0       0  -26,426       0   \n",
       "2023-06-30           0       0       0        0  26,426        0       0   \n",
       "2023-07-31           0       0       0        0       0        0       0   \n",
       "2023-08-31           0       0       0        0       0        0       0   \n",
       "\n",
       "            tra.IR cost_lnd cost_cstrn   oprtg                   rpyacc  \\\n",
       "           amt_add  amt_add    amt_add amt_add amt_sub  bal_end amt_add   \n",
       "2021-08-31       0        0          0  40,000       0   40,000       0   \n",
       "2021-09-30       0        0          0       0       0   40,000       0   \n",
       "2021-10-31       0   30,000      2,632       0  33,632    6,368       0   \n",
       "2021-11-30       0        0      2,632       0   2,632    3,737       0   \n",
       "2021-12-31       0        0      2,632     300   2,632    1,405   1,200   \n",
       "2022-01-31       0        0      2,632   1,226   2,632        0       0   \n",
       "2022-02-28      10        0      2,632   2,642   2,642        0   1,200   \n",
       "2022-03-31      30        0      2,632   2,661   2,661        0   2,400   \n",
       "2022-04-30      47        0      2,632   2,678   2,678        0   2,400   \n",
       "2022-05-31      64        0      2,632   2,696   2,696        0       0   \n",
       "2022-06-30      87        0      2,632   2,718   2,718        0   7,200   \n",
       "2022-07-31      94        0      2,632   2,726   2,726        0   3,600   \n",
       "2022-08-31     110        0      2,632   2,741   2,741        0   3,600   \n",
       "2022-09-30     125        0      2,632   3,000   2,756      244  12,000   \n",
       "2022-10-31     125        0      2,632   2,513   2,756        0       0   \n",
       "2022-11-30     146        0      2,632   2,777   2,777        0       0   \n",
       "2022-12-31     169        0      2,632   3,600   2,801      799  14,400   \n",
       "2023-01-31     169        0      2,632   2,001   2,801        0       0   \n",
       "2023-02-28     186        0      2,632   2,817   2,817        0   6,000   \n",
       "2023-03-31     197        0      2,632   2,828   2,828        0       0   \n",
       "2023-04-30     220        0      2,632  16,500   2,852   13,648  66,000   \n",
       "2023-05-31     220        0          0       0     220   13,428       0   \n",
       "2023-06-30     220        0          0       0  26,646  -13,218  26,426   \n",
       "2023-07-31       0        0          0       0       0  -13,218       0   \n",
       "2023-08-31       0        0          0       0       0  -13,218       0   \n",
       "\n",
       "                             \n",
       "           amt_sub  bal_end  \n",
       "2021-08-31       0        0  \n",
       "2021-09-30       0        0  \n",
       "2021-10-31       0        0  \n",
       "2021-11-30       0        0  \n",
       "2021-12-31       0    1,200  \n",
       "2022-01-31       0    1,200  \n",
       "2022-02-28       0    2,400  \n",
       "2022-03-31       0    4,800  \n",
       "2022-04-30       0    7,200  \n",
       "2022-05-31       0    7,200  \n",
       "2022-06-30       0   14,400  \n",
       "2022-07-31       0   18,000  \n",
       "2022-08-31       0   21,600  \n",
       "2022-09-30       0   33,600  \n",
       "2022-10-31       0   33,600  \n",
       "2022-11-30       0   33,600  \n",
       "2022-12-31       0   48,000  \n",
       "2023-01-31       0   48,000  \n",
       "2023-02-28       0   54,000  \n",
       "2023-03-31       0   54,000  \n",
       "2023-04-30       0  120,000  \n",
       "2023-05-31       0  120,000  \n",
       "2023-06-30  26,426  120,000  \n",
       "2023-07-31       0  120,000  \n",
       "2023-08-31       0  120,000  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 현금흐름 종합\n",
    "rslt_df = DataFrame({('equity.ntnl', 'amt_sub'):equity.ntnl.amt_sub[:],\n",
    "                     ('slsA', 'amt_add'):slsA.amt_add[:],\n",
    "                     ('slsA', 'amt_sub'):slsA.amt_sub[:],\n",
    "                     ('tra.ntnl', 'amt_sub'):tra.ntnl.amt_sub[:],\n",
    "                     ('tra.ntnl', 'amt_add'):tra.ntnl.amt_add[:],\n",
    "                     ('tra.ntnl', 'bal_end'):tra.ntnl.bal_end[:],\n",
    "                     ('tra.fee', 'amt_add'):tra.fee.amt_add[:],\n",
    "                     ('tra.IR', 'amt_add'):tra.IR.amt_add[:],\n",
    "                     ('cost_lnd', 'amt_add'):cost['lnd'].amt_add[:],\n",
    "                     ('cost_cstrn', 'amt_add'):cost['cstrn'].amt_add[:],\n",
    "                     ('oprtg', 'amt_add'):oprtg.amt_add[:],\n",
    "                     ('oprtg', 'amt_sub'):oprtg.amt_sub[:],\n",
    "                     ('oprtg', 'bal_end'):oprtg.bal_end[:],\n",
    "                     ('rpyacc', 'amt_add'):rpyacc.amt_add[:],\n",
    "                     ('rpyacc', 'amt_sub'):rpyacc.amt_sub[:],\n",
    "                     ('rpyacc', 'bal_end'):rpyacc.bal_end[:]})\n",
    "rslt_df.fillna(0).applymap(lambda x: f\"{x:,.0f}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "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>equity.ntnl</th>\n",
       "      <th colspan=\"2\" halign=\"left\">slsA</th>\n",
       "      <th colspan=\"2\" halign=\"left\">tra.ntnl</th>\n",
       "      <th>oprtg</th>\n",
       "      <th>tra.fee</th>\n",
       "      <th>tra.IR</th>\n",
       "      <th>cost_lnd</th>\n",
       "      <th>cost_cstrn</th>\n",
       "      <th colspan=\"2\" halign=\"left\">oprtg</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>10,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10,000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23,632</td>\n",
       "      <td>0</td>\n",
       "      <td>23,632</td>\n",
       "      <td>1,000</td>\n",
       "      <td>0</td>\n",
       "      <td>30,000</td>\n",
       "      <td>2,632</td>\n",
       "      <td>33,632</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,829</td>\n",
       "      <td>0</td>\n",
       "      <td>2,829</td>\n",
       "      <td>0</td>\n",
       "      <td>197</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,829</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>1,500</td>\n",
       "      <td>2,552</td>\n",
       "      <td>0</td>\n",
       "      <td>2,852</td>\n",
       "      <td>0</td>\n",
       "      <td>221</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,852</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,873</td>\n",
       "      <td>0</td>\n",
       "      <td>2,873</td>\n",
       "      <td>0</td>\n",
       "      <td>242</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,873</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>1,500</td>\n",
       "      <td>2,597</td>\n",
       "      <td>0</td>\n",
       "      <td>2,897</td>\n",
       "      <td>0</td>\n",
       "      <td>266</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,897</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,000</td>\n",
       "      <td>2,319</td>\n",
       "      <td>0</td>\n",
       "      <td>2,919</td>\n",
       "      <td>0</td>\n",
       "      <td>287</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,919</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>3,000</td>\n",
       "      <td>2,338</td>\n",
       "      <td>0</td>\n",
       "      <td>2,938</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,938</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,958</td>\n",
       "      <td>0</td>\n",
       "      <td>2,958</td>\n",
       "      <td>0</td>\n",
       "      <td>326</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,958</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>9,000</td>\n",
       "      <td>1,182</td>\n",
       "      <td>0</td>\n",
       "      <td>2,982</td>\n",
       "      <td>0</td>\n",
       "      <td>351</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,982</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>4,500</td>\n",
       "      <td>2,092</td>\n",
       "      <td>0</td>\n",
       "      <td>2,992</td>\n",
       "      <td>0</td>\n",
       "      <td>361</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,992</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>4,500</td>\n",
       "      <td>2,110</td>\n",
       "      <td>0</td>\n",
       "      <td>3,010</td>\n",
       "      <td>0</td>\n",
       "      <td>378</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,010</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>15,000</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>3,027</td>\n",
       "      <td>0</td>\n",
       "      <td>396</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,027</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,027</td>\n",
       "      <td>0</td>\n",
       "      <td>3,027</td>\n",
       "      <td>0</td>\n",
       "      <td>396</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,027</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,053</td>\n",
       "      <td>0</td>\n",
       "      <td>3,053</td>\n",
       "      <td>0</td>\n",
       "      <td>421</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,053</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>18,000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,600</td>\n",
       "      <td>0</td>\n",
       "      <td>447</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,078</td>\n",
       "      <td>522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2,556</td>\n",
       "      <td>0</td>\n",
       "      <td>2,556</td>\n",
       "      <td>0</td>\n",
       "      <td>447</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,078</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>7,500</td>\n",
       "      <td>1,599</td>\n",
       "      <td>0</td>\n",
       "      <td>3,099</td>\n",
       "      <td>0</td>\n",
       "      <td>468</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,099</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3,113</td>\n",
       "      <td>0</td>\n",
       "      <td>3,113</td>\n",
       "      <td>0</td>\n",
       "      <td>481</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,113</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>0</td>\n",
       "      <td>15,000</td>\n",
       "      <td>82,500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16,500</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,139</td>\n",
       "      <td>13,361</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>12,854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60,858</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>61,365</td>\n",
       "      <td>-48,511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-48,511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-48,511</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           equity.ntnl    slsA         tra.ntnl           oprtg tra.fee  \\\n",
       "               amt_sub amt_add amt_sub  amt_sub amt_add amt_add amt_add   \n",
       "2021-08-31      10,000       0       0        0       0  10,000       0   \n",
       "2021-09-30           0       0       0        0       0       0       0   \n",
       "2021-10-31           0       0       0   23,632       0  23,632   1,000   \n",
       "2021-11-30           0       0       0    2,829       0   2,829       0   \n",
       "2021-12-31           0  15,000   1,500    2,552       0   2,852       0   \n",
       "2022-01-31           0       0       0    2,873       0   2,873       0   \n",
       "2022-02-28           0  15,000   1,500    2,597       0   2,897       0   \n",
       "2022-03-31           0       0   3,000    2,319       0   2,919       0   \n",
       "2022-04-30           0  15,000   3,000    2,338       0   2,938       0   \n",
       "2022-05-31           0       0       0    2,958       0   2,958       0   \n",
       "2022-06-30           0  15,000   9,000    1,182       0   2,982       0   \n",
       "2022-07-31           0  15,000   4,500    2,092       0   2,992       0   \n",
       "2022-08-31           0  15,000   4,500    2,110       0   3,010       0   \n",
       "2022-09-30           0  15,000  15,000       27       0   3,027       0   \n",
       "2022-10-31           0       0       0    3,027       0   3,027       0   \n",
       "2022-11-30           0       0       0    3,053       0   3,053       0   \n",
       "2022-12-31           0  15,000  18,000        0       0   3,600       0   \n",
       "2023-01-31           0       0       0    2,556       0   2,556       0   \n",
       "2023-02-28           0  15,000   7,500    1,599       0   3,099       0   \n",
       "2023-03-31           0       0       0    3,113       0   3,113       0   \n",
       "2023-04-30           0  15,000  82,500        0       0  16,500       0   \n",
       "2023-05-31           0       0       0        0       0       0       0   \n",
       "2023-06-30           0       0       0        0  60,858       0       0   \n",
       "2023-07-31           0       0       0        0       0       0       0   \n",
       "2023-08-31           0       0       0        0       0       0       0   \n",
       "\n",
       "            tra.IR cost_lnd cost_cstrn   oprtg           \n",
       "           amt_add  amt_add    amt_add amt_sub  bal_end  \n",
       "2021-08-31       0        0          0       0   10,000  \n",
       "2021-09-30       0        0          0       0   10,000  \n",
       "2021-10-31       0   30,000      2,632  33,632        0  \n",
       "2021-11-30     197        0      2,632   2,829        0  \n",
       "2021-12-31     221        0      2,632   2,852        0  \n",
       "2022-01-31     242        0      2,632   2,873        0  \n",
       "2022-02-28     266        0      2,632   2,897        0  \n",
       "2022-03-31     287        0      2,632   2,919        0  \n",
       "2022-04-30     307        0      2,632   2,938        0  \n",
       "2022-05-31     326        0      2,632   2,958        0  \n",
       "2022-06-30     351        0      2,632   2,982        0  \n",
       "2022-07-31     361        0      2,632   2,992        0  \n",
       "2022-08-31     378        0      2,632   3,010        0  \n",
       "2022-09-30     396        0      2,632   3,027        0  \n",
       "2022-10-31     396        0      2,632   3,027        0  \n",
       "2022-11-30     421        0      2,632   3,053        0  \n",
       "2022-12-31     447        0      2,632   3,078      522  \n",
       "2023-01-31     447        0      2,632   3,078        0  \n",
       "2023-02-28     468        0      2,632   3,099        0  \n",
       "2023-03-31     481        0      2,632   3,113        0  \n",
       "2023-04-30     507        0      2,632   3,139   13,361  \n",
       "2023-05-31     507        0          0     507   12,854  \n",
       "2023-06-30     507        0          0  61,365  -48,511  \n",
       "2023-07-31       0        0          0       0  -48,511  \n",
       "2023-08-31       0        0          0       0  -48,511  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 현금흐름 요약\n",
    "rslt_df = DataFrame({('equity.ntnl', 'amt_sub'):equity.ntnl.amt_sub[:],\n",
    "                     ('slsA', 'amt_add'):slsA.amt_add[:],\n",
    "                     ('slsA', 'amt_sub'):slsA.amt_sub[:],\n",
    "                     ('tra.ntnl', 'amt_sub'):tra.ntnl.amt_sub[:],\n",
    "                     ('tra.ntnl', 'amt_add'):tra.ntnl.amt_add[:],\n",
    "                     ('oprtg', 'amt_add'):oprtg.amt_add[:],\n",
    "                     ('tra.fee', 'amt_add'):tra.fee.amt_add[:],\n",
    "                     ('tra.IR', 'amt_add'):tra.IR.amt_add[:],\n",
    "                     ('cost_lnd', 'amt_add'):cost['lnd'].amt_add[:],\n",
    "                     ('cost_cstrn', 'amt_add'):cost['cstrn'].amt_add[:],\n",
    "                     ('oprtg', 'amt_sub'):oprtg.amt_sub[:],\n",
    "                     ('oprtg', 'bal_end'):oprtg.bal_end[:]})\n",
    "rslt_df.fillna(0).applymap(lambda x: f\"{x:,.0f}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>add_scdd</th>\n",
       "      <th>sub_scdd</th>\n",
       "      <th>bal_strt</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82500.0</td>\n",
       "      <td>82500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            add_scdd  sub_scdd  bal_strt  amt_add  amt_sub  bal_end\n",
       "2021-08-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-09-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-10-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-11-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-12-31       0.0       0.0       0.0   1500.0   1500.0      0.0\n",
       "2022-01-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-02-28       0.0       0.0       0.0   1500.0   1500.0      0.0\n",
       "2022-03-31       0.0       0.0       0.0   3000.0   3000.0      0.0\n",
       "2022-04-30       0.0       0.0       0.0   3000.0   3000.0      0.0\n",
       "2022-05-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-06-30       0.0       0.0       0.0   9000.0   9000.0      0.0\n",
       "2022-07-31       0.0       0.0       0.0   4500.0   4500.0      0.0\n",
       "2022-08-31       0.0       0.0       0.0   4500.0   4500.0      0.0\n",
       "2022-09-30       0.0       0.0       0.0  15000.0  15000.0      0.0\n",
       "2022-10-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-11-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-12-31       0.0       0.0       0.0  18000.0  18000.0      0.0\n",
       "2023-01-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-02-28       0.0       0.0       0.0   7500.0   7500.0      0.0\n",
       "2023-03-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-04-30       0.0       0.0       0.0  82500.0  82500.0      0.0\n",
       "2023-05-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-06-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-07-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-08-31       0.0       0.0       0.0      0.0      0.0      0.0"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sales.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>add_scdd</th>\n",
       "      <th>sub_scdd</th>\n",
       "      <th>bal_strt</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>13500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13500.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>27000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>27000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>24000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>36000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>42000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>52500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52500.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>63000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>63000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>63000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>67500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>67500.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>82500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            add_scdd  sub_scdd  bal_strt  amt_add  amt_sub  bal_end\n",
       "2021-08-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-09-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-10-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-11-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-12-31       0.0   15000.0       0.0  15000.0   1500.0  13500.0\n",
       "2022-01-31       0.0       0.0   13500.0      0.0      0.0  13500.0\n",
       "2022-02-28       0.0       0.0   13500.0  15000.0   1500.0  27000.0\n",
       "2022-03-31       0.0   15000.0   27000.0      0.0   3000.0  24000.0\n",
       "2022-04-30       0.0       0.0   24000.0  15000.0   3000.0  36000.0\n",
       "2022-05-31       0.0       0.0   36000.0      0.0      0.0  36000.0\n",
       "2022-06-30       0.0   15000.0   36000.0  15000.0   9000.0  42000.0\n",
       "2022-07-31       0.0       0.0   42000.0  15000.0   4500.0  52500.0\n",
       "2022-08-31       0.0       0.0   52500.0  15000.0   4500.0  63000.0\n",
       "2022-09-30       0.0   15000.0   63000.0  15000.0  15000.0  63000.0\n",
       "2022-10-31       0.0       0.0   63000.0      0.0      0.0  63000.0\n",
       "2022-11-30       0.0       0.0   63000.0      0.0      0.0  63000.0\n",
       "2022-12-31       0.0   15000.0   63000.0  15000.0  18000.0  60000.0\n",
       "2023-01-31       0.0       0.0   60000.0      0.0      0.0  60000.0\n",
       "2023-02-28       0.0       0.0   60000.0  15000.0   7500.0  67500.0\n",
       "2023-03-31       0.0       0.0   67500.0      0.0      0.0  67500.0\n",
       "2023-04-30       0.0   75000.0   67500.0  15000.0  82500.0      0.0\n",
       "2023-05-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-06-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-07-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-08-31       0.0       0.0       0.0      0.0      0.0      0.0"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "slsA.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sales.bal_end[idx[5]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>add_scdd</th>\n",
       "      <th>sub_scdd</th>\n",
       "      <th>bal_strt</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>15000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82500.0</td>\n",
       "      <td>82500.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            add_scdd  sub_scdd  bal_strt  amt_add  amt_sub  bal_end\n",
       "2021-08-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-09-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-10-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-11-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2021-12-31       0.0       0.0       0.0   1500.0   1500.0      0.0\n",
       "2022-01-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-02-28       0.0       0.0       0.0   1500.0   1500.0      0.0\n",
       "2022-03-31       0.0       0.0       0.0   3000.0   3000.0      0.0\n",
       "2022-04-30       0.0       0.0       0.0   3000.0   3000.0      0.0\n",
       "2022-05-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-06-30       0.0       0.0       0.0   9000.0   9000.0      0.0\n",
       "2022-07-31       0.0       0.0       0.0   4500.0   4500.0      0.0\n",
       "2022-08-31       0.0       0.0       0.0   4500.0   4500.0      0.0\n",
       "2022-09-30       0.0       0.0       0.0  15000.0  15000.0      0.0\n",
       "2022-10-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-11-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2022-12-31       0.0       0.0       0.0  18000.0  18000.0      0.0\n",
       "2023-01-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-02-28       0.0       0.0       0.0   7500.0   7500.0      0.0\n",
       "2023-03-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-04-30       0.0       0.0       0.0  82500.0  82500.0      0.0\n",
       "2023-05-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-06-30       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-07-31       0.0       0.0       0.0      0.0      0.0      0.0\n",
       "2023-08-31       0.0       0.0       0.0      0.0      0.0      0.0"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sales.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'lnd': <PrjtCF_module.account.Account at 0x7fbc05daebd0>,\n",
       " 'cstrn': <PrjtCF_module.account.Account at 0x7fbc05cca210>}"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cost.dct"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "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 th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>add_scdd</th>\n",
       "      <th>sub_scdd</th>\n",
       "      <th>bal_strt</th>\n",
       "      <th>amt_add</th>\n",
       "      <th>amt_sub</th>\n",
       "      <th>bal_end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-08-31</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>1000.000000</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-05-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-06-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-07-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-08-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-11-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-03-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-04-30</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-05-31</th>\n",
       "      <td>833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>100833.333333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-07-31</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-08-31</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 add_scdd  sub_scdd  bal_strt  amt_add  amt_sub  bal_end\n",
       "2021-08-31       0.000000       0.0       0.0      0.0      0.0      0.0\n",
       "2021-09-30       0.000000       0.0       0.0      0.0      0.0      0.0\n",
       "2021-10-31    1000.000000  100000.0       0.0      0.0      0.0      0.0\n",
       "2021-11-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2021-12-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-01-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-02-28     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-03-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-04-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-05-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-06-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-07-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-08-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-09-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-10-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-11-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2022-12-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-01-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-02-28     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-03-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-04-30     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-05-31     833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-06-30  100833.333333       0.0       0.0      0.0      0.0      0.0\n",
       "2023-07-31       0.000000       0.0       0.0      0.0      0.0      0.0\n",
       "2023-08-31       0.000000       0.0       0.0      0.0      0.0      0.0"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "loan.df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}