210903 Example_분양CF_2-1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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": 2,
   "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": 3,
   "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": 4,
   "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": 5,
   "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": 6,
   "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": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Make accounts\n",
    "oprtg = cf.Account(idx) # 운영현금흐름의 입출을 위한 운영계좌\n",
    "sales = cf.Account(idx) # 분양수입금의 입출을 위한 분양수입금 계좌\n",
    "rpyacc = cf.Account(idx) # 상환자금 관리를 위한 대출금 상환 계좌"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2) Cash Flow 실행"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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 = cf.cst_mngmnt(idxno, cost, loan)\n",
    "    wtdrw = cf.wtdrw_mngmnt(idxno, cst, oprtg)\n",
    "    wtdrw.wtdrw_equity(equity)\n",
    "    wtdrw.wtdrw_loan(tra)\n",
    "    \n",
    "    # 운영계좌에서 토지비, 공사비 등 각종 비용 지출\n",
    "    cst.pay_oprtcst(oprtg)\n",
    "    \n",
    "    # 운영계좌에서 각종 금융비용 지출\n",
    "    cst.pay_fnclcst(oprtg)\n",
    "    \n",
    "    # 대출금 상환 프로세스 진행\n",
    "    repay = cf.repay_mngmnt(idxno, tra) # Loan instance class 생성\n",
    "    repay.trsf_rpy(oprtg, rpyacc) # 상환 예정 금액을 상환계좌로 이체\n",
    "    repay.rpy_ntnl(rpyacc) # 상환계좌에서 순서에 따라 상환금 인출\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": 10,
   "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": 11,
   "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>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>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>10,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>10,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>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>23,632</td>\n",
       "      <td>33,632</td>\n",
       "      <td>0</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>2,829</td>\n",
       "      <td>0</td>\n",
       "      <td>-26,460</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>2,829</td>\n",
       "      <td>0</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>2,552</td>\n",
       "      <td>0</td>\n",
       "      <td>-29,012</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>2,852</td>\n",
       "      <td>0</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>2,873</td>\n",
       "      <td>0</td>\n",
       "      <td>-31,886</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>2,873</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,597</td>\n",
       "      <td>0</td>\n",
       "      <td>-34,483</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>2,897</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,319</td>\n",
       "      <td>0</td>\n",
       "      <td>-36,802</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>2,919</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,338</td>\n",
       "      <td>0</td>\n",
       "      <td>-39,140</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>2,938</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,958</td>\n",
       "      <td>0</td>\n",
       "      <td>-42,098</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>2,958</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>1,182</td>\n",
       "      <td>0</td>\n",
       "      <td>-43,280</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>2,982</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>2,092</td>\n",
       "      <td>0</td>\n",
       "      <td>-45,372</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>2,992</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>2,110</td>\n",
       "      <td>0</td>\n",
       "      <td>-47,482</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>3,010</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>27</td>\n",
       "      <td>0</td>\n",
       "      <td>-47,509</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>3,027</td>\n",
       "      <td>0</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>3,027</td>\n",
       "      <td>0</td>\n",
       "      <td>-50,537</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>3,027</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>3,053</td>\n",
       "      <td>0</td>\n",
       "      <td>-53,590</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>3,053</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>-53,590</td>\n",
       "      <td>0</td>\n",
       "      <td>447</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>3,600</td>\n",
       "      <td>3,078</td>\n",
       "      <td>522</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,556</td>\n",
       "      <td>0</td>\n",
       "      <td>-56,146</td>\n",
       "      <td>0</td>\n",
       "      <td>447</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>2,556</td>\n",
       "      <td>3,078</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,599</td>\n",
       "      <td>0</td>\n",
       "      <td>-57,745</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>3,099</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>3,113</td>\n",
       "      <td>0</td>\n",
       "      <td>-60,858</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>3,113</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>-60,858</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>2,632</td>\n",
       "      <td>16,500</td>\n",
       "      <td>3,139</td>\n",
       "      <td>13,361</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>-60,858</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>507</td>\n",
       "      <td>12,854</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>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>0</td>\n",
       "      <td>61,365</td>\n",
       "      <td>-48,511</td>\n",
       "      <td>60,858</td>\n",
       "      <td>60,858</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>-48,511</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>-48,511</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      10,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   23,632       0  -23,632   1,000   \n",
       "2021-11-30           0       0       0    2,829       0  -26,460       0   \n",
       "2021-12-31           0  15,000   1,500    2,552       0  -29,012       0   \n",
       "2022-01-31           0       0       0    2,873       0  -31,886       0   \n",
       "2022-02-28           0  15,000   1,500    2,597       0  -34,483       0   \n",
       "2022-03-31           0       0   3,000    2,319       0  -36,802       0   \n",
       "2022-04-30           0  15,000   3,000    2,338       0  -39,140       0   \n",
       "2022-05-31           0       0       0    2,958       0  -42,098       0   \n",
       "2022-06-30           0  15,000   9,000    1,182       0  -43,280       0   \n",
       "2022-07-31           0  15,000   4,500    2,092       0  -45,372       0   \n",
       "2022-08-31           0  15,000   4,500    2,110       0  -47,482       0   \n",
       "2022-09-30           0  15,000  15,000       27       0  -47,509       0   \n",
       "2022-10-31           0       0       0    3,027       0  -50,537       0   \n",
       "2022-11-30           0       0       0    3,053       0  -53,590       0   \n",
       "2022-12-31           0  15,000  18,000        0       0  -53,590       0   \n",
       "2023-01-31           0       0       0    2,556       0  -56,146       0   \n",
       "2023-02-28           0  15,000   7,500    1,599       0  -57,745       0   \n",
       "2023-03-31           0       0       0    3,113       0  -60,858       0   \n",
       "2023-04-30           0  15,000  82,500        0       0  -60,858       0   \n",
       "2023-05-31           0       0       0        0       0  -60,858       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                   rpyacc  \\\n",
       "           amt_add  amt_add    amt_add amt_add amt_sub  bal_end amt_add   \n",
       "2021-08-31       0        0          0  10,000       0   10,000       0   \n",
       "2021-09-30       0        0          0       0       0   10,000       0   \n",
       "2021-10-31       0   30,000      2,632  23,632  33,632        0       0   \n",
       "2021-11-30     197        0      2,632   2,829   2,829        0       0   \n",
       "2021-12-31     221        0      2,632   2,852   2,852        0   1,200   \n",
       "2022-01-31     242        0      2,632   2,873   2,873        0       0   \n",
       "2022-02-28     266        0      2,632   2,897   2,897        0   1,200   \n",
       "2022-03-31     287        0      2,632   2,919   2,919        0   2,400   \n",
       "2022-04-30     307        0      2,632   2,938   2,938        0   2,400   \n",
       "2022-05-31     326        0      2,632   2,958   2,958        0       0   \n",
       "2022-06-30     351        0      2,632   2,982   2,982        0   7,200   \n",
       "2022-07-31     361        0      2,632   2,992   2,992        0   3,600   \n",
       "2022-08-31     378        0      2,632   3,010   3,010        0   3,600   \n",
       "2022-09-30     396        0      2,632   3,027   3,027        0  12,000   \n",
       "2022-10-31     396        0      2,632   3,027   3,027        0       0   \n",
       "2022-11-30     421        0      2,632   3,053   3,053        0       0   \n",
       "2022-12-31     447        0      2,632   3,600   3,078      522  14,400   \n",
       "2023-01-31     447        0      2,632   2,556   3,078        0       0   \n",
       "2023-02-28     468        0      2,632   3,099   3,099        0   6,000   \n",
       "2023-03-31     481        0      2,632   3,113   3,113        0       0   \n",
       "2023-04-30     507        0      2,632  16,500   3,139   13,361  66,000   \n",
       "2023-05-31     507        0          0       0     507   12,854       0   \n",
       "2023-06-30     507        0          0       0  61,365  -48,511  60,858   \n",
       "2023-07-31       0        0          0       0       0  -48,511       0   \n",
       "2023-08-31       0        0          0       0       0  -48,511       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  60,858  120,000  \n",
       "2023-07-31       0  120,000  \n",
       "2023-08-31       0  120,000  "
      ]
     },
     "execution_count": 11,
     "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": 12,
   "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": 12,
     "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": 14,
   "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": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "slsA.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": 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
}