210725 Example_운영개발사업CF_1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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": 3,
   "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": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 기간 index 설정\n",
    "idx = cf.PrjtIndex(idxname=['prjt', 'cstrn', 'loan'],\n",
    "                   start=['2021-08', '2021-10', '2021-10'],\n",
    "                   periods=[24+1, 18+1, 20+1],\n",
    "                   freq='M')\n",
    "\n",
    "# 공정률 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 Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "equity = cf.Loan(idx, amt_ntnl=10_000)\n",
    "\n",
    "loan = cf.Loan(idx.loan, amt_ntnl=60_000, rate_fee=0.02, \n",
    "               rate_IR=0.06)"
   ]
  },
  {
   "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], 10_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)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Execution Cash Flow"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Make accounts : 운영현금흐름의 입출을 위한 운영계좌 개설\n",
    "acc_oprtg = cf.Account(idx)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Inflow of cash\n",
    "def inflow_cash(idxno):\n",
    "    equity.ntnl.send(idxno, equity.ntnl.sub_scdd[idxno], acc_oprtg)\n",
    "    \n",
    "    if idxno in idx.loan.index:\n",
    "        loan.ntnl.send(idxno, loan.ntnl.sub_scdd[idxno], acc_oprtg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Outflow of cash\n",
    "def outflow_cash(idxno):\n",
    "    acc_oprtg.send(idxno, cost['lnd'].add_scdd[idxno], cost['lnd'])\n",
    "    acc_oprtg.send(idxno, cost['cstrn'].add_scdd[idxno], cost['cstrn'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pay financial cost\n",
    "def pay_fnclcst(idxno):\n",
    "    if idxno in idx.loan.index:\n",
    "        acc_oprtg.send(idxno, loan.fee.add_scdd[idxno], loan.fee)\n",
    "        acc_oprtg.send(idxno, loan.IR.add_scdd[idxno], loan.IR)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Repay notional amount\n",
    "def repay_ntnl(idxno):\n",
    "    if idxno in idx.loan.index:\n",
    "        acc_oprtg.send(idxno, loan.ntnl.add_scdd[idxno], loan.ntnl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Execute cash flow\n",
    "for idxno in idx.index:\n",
    "    inflow_cash(idxno)\n",
    "    outflow_cash(idxno)\n",
    "    pay_fnclcst(idxno)\n",
    "    repay_ntnl(idxno)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge Accounts\n",
    "dct_acc = {'equity':equity,\n",
    "           'loan_ntnl':loan.ntnl,\n",
    "           'loan_fee':loan.fee,\n",
    "           'loan_IR':loan.IR,\n",
    "           'cost_lnd':cost['lnd'],\n",
    "           'cost_cstrn':cost['cstrn'],\n",
    "           'acc_oprtg':acc_oprtg}\n",
    "acc_merge = cf.Merge(dct_acc)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Print Result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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\">loan.ntnl</th>\n",
       "      <th>loan.fee</th>\n",
       "      <th>loan.IR</th>\n",
       "      <th>cost_lnd</th>\n",
       "      <th>cost_cstrn</th>\n",
       "      <th colspan=\"3\" halign=\"left\">acc_oprtg</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></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>10000.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",
       "      <td>0.000000</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10000.000000</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",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-31</th>\n",
       "      <td>0.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>13831.578947</td>\n",
       "      <td>56168.421053</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>53236.842105</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>50305.263158</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>47373.684211</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>44442.105263</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>41510.526316</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>38578.947368</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>35647.368421</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>32715.789474</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>29784.210526</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>26852.631579</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>23921.052632</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>20989.473684</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>18057.894737</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>15126.315789</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>12194.736842</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>9263.157895</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>6331.578947</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>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2631.578947</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2931.578947</td>\n",
       "      <td>3400.000000</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>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>300.000000</td>\n",
       "      <td>3100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-06-30</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60300.000000</td>\n",
       "      <td>-57200.000000</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",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-57200.000000</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",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>-57200.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           equity.ntnl loan.ntnl          loan.fee loan.IR cost_lnd  \\\n",
       "               amt_sub   amt_sub  amt_add  amt_add amt_add  amt_add   \n",
       "2021-08-31     10000.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   60000.0      0.0   1200.0     0.0  10000.0   \n",
       "2021-11-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2021-12-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-01-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-02-28         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-03-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-04-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-05-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-06-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-07-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-08-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-09-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-10-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-11-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2022-12-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-01-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-02-28         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-03-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-04-30         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-05-31         0.0       0.0      0.0      0.0   300.0      0.0   \n",
       "2023-06-30         0.0       0.0  60000.0      0.0   300.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   \n",
       "\n",
       "             cost_cstrn acc_oprtg                              \n",
       "                amt_add   amt_add       amt_sub       bal_end  \n",
       "2021-08-31     0.000000   10000.0      0.000000  10000.000000  \n",
       "2021-09-30     0.000000       0.0      0.000000  10000.000000  \n",
       "2021-10-31  2631.578947   60000.0  13831.578947  56168.421053  \n",
       "2021-11-30  2631.578947       0.0   2931.578947  53236.842105  \n",
       "2021-12-31  2631.578947       0.0   2931.578947  50305.263158  \n",
       "2022-01-31  2631.578947       0.0   2931.578947  47373.684211  \n",
       "2022-02-28  2631.578947       0.0   2931.578947  44442.105263  \n",
       "2022-03-31  2631.578947       0.0   2931.578947  41510.526316  \n",
       "2022-04-30  2631.578947       0.0   2931.578947  38578.947368  \n",
       "2022-05-31  2631.578947       0.0   2931.578947  35647.368421  \n",
       "2022-06-30  2631.578947       0.0   2931.578947  32715.789474  \n",
       "2022-07-31  2631.578947       0.0   2931.578947  29784.210526  \n",
       "2022-08-31  2631.578947       0.0   2931.578947  26852.631579  \n",
       "2022-09-30  2631.578947       0.0   2931.578947  23921.052632  \n",
       "2022-10-31  2631.578947       0.0   2931.578947  20989.473684  \n",
       "2022-11-30  2631.578947       0.0   2931.578947  18057.894737  \n",
       "2022-12-31  2631.578947       0.0   2931.578947  15126.315789  \n",
       "2023-01-31  2631.578947       0.0   2931.578947  12194.736842  \n",
       "2023-02-28  2631.578947       0.0   2931.578947   9263.157895  \n",
       "2023-03-31  2631.578947       0.0   2931.578947   6331.578947  \n",
       "2023-04-30  2631.578947       0.0   2931.578947   3400.000000  \n",
       "2023-05-31     0.000000       0.0    300.000000   3100.000000  \n",
       "2023-06-30     0.000000       0.0  60300.000000 -57200.000000  \n",
       "2023-07-31     0.000000       0.0      0.000000 -57200.000000  \n",
       "2023-08-31     0.000000       0.0      0.000000 -57200.000000  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rslt_df = DataFrame({('equity.ntnl', 'amt_sub'):equity.ntnl.amt_sub[:],\n",
    "                     ('loan.ntnl', 'amt_sub'):loan.ntnl.amt_sub[:],\n",
    "                     ('loan.ntnl', 'amt_add'):loan.ntnl.amt_add[:],\n",
    "                     ('loan.fee', 'amt_add'):loan.fee.amt_add[:],\n",
    "                     ('loan.IR', 'amt_add'):loan.IR.amt_add[:],\n",
    "                     ('cost_lnd', 'amt_add'):cost['lnd'].amt_add[:],\n",
    "                     ('cost_cstrn', 'amt_add'):cost['cstrn'].amt_add[:],\n",
    "                     ('acc_oprtg', 'amt_add'):acc_oprtg.amt_add[:],\n",
    "                     ('acc_oprtg', 'amt_sub'):acc_oprtg.amt_sub[:],\n",
    "                     ('acc_oprtg', 'bal_end'):acc_oprtg.bal_end[:]})\n",
    "rslt_df.fillna(0)"
   ]
  }
 ],
 "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
}