Skip to content

Instantly share code, notes, and snippets.

@ponggung
Last active June 14, 2018 07:30
Show Gist options
  • Save ponggung/26099422722decf65980e3f7cf203f77 to your computer and use it in GitHub Desktop.
Save ponggung/26099422722decf65980e3f7cf203f77 to your computer and use it in GitHub Desktop.
asset_prediction
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 用pandas預測你的人生財務曲線"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"起始資金 = 30\n",
"每月薪水 = 3\n",
"每月開銷 = 1 # 不含房租\n",
"每月房租 = 1\n",
"退休年齡 = 65\n",
"預測時段 = range(25, 90, 1)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 每年淨額 計算\n",
"每年淨額就是每年銀行帳戶的變化值,也就是當年的**總收入** - **總支出**\n",
"* 收入的部分有:薪水\n",
"* 支出的部分有:開銷、房租\n",
"\n",
"同時必須考慮起始資金跟退休年齡!\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x114acccf8>"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXwAAAD8CAYAAAB0IB+mAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAFE5JREFUeJzt3X+sZHV5x/H3c2d27t65S4vAVXGX7UJcrWgQ7C3FWk2LUNESQSMRYw1ptZsmmKK2UYlpE5uSaGqqTeyvjdjuHypSK4FQK64I6Y8odhG0wLoFAWUF2WsRld11f92nf8y5u3d35xfMjHPPmfcrublzzpyZ8zDMfva7z3znfCMzkSRV39S4C5Ak/XwY+JI0IQx8SZoQBr4kTQgDX5ImhIEvSRPCwJekCWHgS9KEMPAlaULUx13Acqecckpu2LBh3GVIUqnceeedP8zMuV7HrajA37BhA9u2bRt3GZJUKhHx3X6Os6UjSRPCwJekCWHgS9KEMPAlaUIY+JI0IQx8SZoQBr4kTYhKBP6OH/yUj9yygyd27x93KZK0YlUi8B9ceIqP3/YAP/jxz8ZdiiStWJUI/DWrW18Y3r3/4JgrkaSVqxKBPzvdCvynfmbgS1InQwv8iKhFxF0RcXOxfXpE3BER90fEZyOiMaxzHeuEIvB/us/Al6ROhjnCvwrYvmz7w8BHM3Mj8CPg7UM811EOt3QMfEnqaCiBHxHrgN8BPlFsB3A+8LnikC3ApcM4Vzu2dCSpt2GN8D8GvBdYLLZPBp7MzKUE3gmsbffAiNgUEdsiYtvCwsIzOvlsowh8R/iS1NHAgR8RFwO7MvPO5bvbHJrtHp+ZmzNzPjPn5+Z6Xr+/rdpU0GzUDHxJ6mIYC6C8Anh9RLwOWA38Aq0R/4kRUS9G+euAR4dwro7WTNft4UtSFwOP8DPz6sxcl5kbgMuBr2TmW4HbgDcVh10B3DjoubpZM113lo4kdTHKefjvA94TEQ/Q6ulfO8JzsWa1I3xJ6maoa9pm5u3A7cXtB4Fzh/n83cw26s7SkaQuKvFNW2iN8P3QVpI6q0zgnzBt4EtSN5UJ/FkDX5K6qkzgL31om9l2ur8kTbzqBP50nQOHkn0HF3sfLEkTqFKBD15ATZI6qUzgH76AmoEvSW1VJvDXGPiS1FX1At8vX0lSW9UJfNe1laSuqhP4S8scOsKXpLYqF/j28CWpveoEvuvaSlJXlQn85qoa4Ie2ktRJZQJ/aipYM13nqX2Hxl2KJK1IlQl8gNnpGk/tOzDuMiRpRapU4LfWtXWEL0ntVC7wXddWktqrVuC7rq0kdVStwJ92XVtJ6qRSge+qV5LU2cCBHxGrI+LrEfHNiLg3Ij5Y7D89Iu6IiPsj4rMR0Ri83O5c11aSOhvGCH8fcH5mvhQ4G7goIs4DPgx8NDM3Aj8C3j6Ec3W1NMJ3mUNJOt7AgZ8tTxWbq4qfBM4HPlfs3wJcOui5elmzus6hRZc5lKR2htLDj4haRNwN7AK2At8BnszMpf7KTmBth8duiohtEbFtYWFhoDq8YqYkdTaUwM/MQ5l5NrAOOBd4UbvDOjx2c2bOZ+b83NzcQHW4rq0kdTbUWTqZ+SRwO3AecGJE1Iu71gGPDvNc7biurSR1NoxZOnMRcWJxewa4ANgO3Aa8qTjsCuDGQc/VywkGviR1VO99SE+nAlsiokbrL5DrM/PmiLgPuC4i/gK4C7h2COfqauma+H75SpKON3DgZ+a3gHPa7H+QVj//52appeO6tpJ0vEp90/YEZ+lIUkeVCnw/tJWkzioV+M1GjQinZUpSO5UK/IhgTaNuS0eS2qhU4IPXxJekTioX+F4iWZLaq1zgrzHwJamtygX+CasNfElqp3KBP9uwhy9J7VQu8Nesdl1bSWqneoFvD1+S2qps4LvMoSQdrXKBPztdZzFh74FD4y5FklaUygX+4Usk29aRpKNUL/Cna4DXxJekY1Uw8FcBsHufLR1JWq6CgV9cE3/fgTFXIkkrS2UD3xG+JB2teoF/+ENbR/iStFzlAn926UNbR/iSdJSBAz8iTouI2yJie0TcGxFXFftPioitEXF/8ftZg5fb2wnFh7bO0pGkow1jhH8Q+OPMfBFwHnBlRJwJvB+4NTM3ArcW2yO3etUUU2FLR5KONXDgZ+ZjmfmN4vZPge3AWuASYEtx2Bbg0kHP1Y+IYM103Q9tJekYQ+3hR8QG4BzgDuA5mfkYtP5SAJ49zHN1s2badW0l6VhDC/yIWAP8C/CuzPzJ03jcpojYFhHbFhYWhlKL69pK0vGGEvgRsYpW2H8qMz9f7H48Ik4t7j8V2NXusZm5OTPnM3N+bm5uGOV4iWRJamMYs3QCuBbYnpl/teyum4ArittXADcOeq5+uZC5JB1vGCP8VwBvA86PiLuLn9cBHwIujIj7gQuL7Z8L17WVpOPVB32CzPxPIDrc/epBn/+ZcF1bSTpe5b5pC65rK0ntVDPwp+s8td9lDiVpucoGfibs2e+XryRpSSUDf3baZQ4l6ViVDPwTXNdWko5TycCfbRSB7we3knRYJQN/aREUp2ZK0hHVDPzD69oa+JK0pNKB7whfko6oZuD7oa0kHaeage+0TEk6TiUDf7o+RX0qnKUjSctUMvAjwkskS9IxKhn44CIoknSsage+LR1JOqy6gb+6zu79Br4kLalu4DvCl6SjVDvw7eFL0mEDL3G4Uq2ZrvP9J/fyzk9/Y9ylSCPTqE3x7gtfwGknNcddikqgsoH/yhecwrbvPsF9j/1k3KVII7G4mDz8f3s4Z/2JvO3lG8ZdjkqgsoF/8VnP4+KznjfuMqSR2bP/IGf+2S2u7Ka+DaWHHxGfjIhdEXHPsn0nRcTWiLi/+P2sYZxLUsvqeg1wKU/1b1gf2v4TcNEx+94P3JqZG4Fbi21JQzI1FcysqrHH6cfq01ACPzP/HXjimN2XAFuK21uAS4dxLklHNBs1R/jq2yinZT4nMx8DKH4/e4TnkiZSc7rGXgNffRr7PPyI2BQR2yJi28LCwrjLkUqlucpvlKt/owz8xyPiVIDi9652B2Xm5sycz8z5ubm5EZYjVc+MLR09DaMM/JuAK4rbVwA3jvBc0kSataWjp2FY0zI/A3wVeGFE7IyItwMfAi6MiPuBC4ttSUM0s6ruCF99G8oXrzLzLR3uevUwnl9Se61ZOvbw1Z+xf2gr6ZlzWqaeDgNfKrFmo24PX30z8KUSazZq7N5/kMwcdykqAQNfKrGZRo3FhH0HF8ddikrAwJdKbLbRuoCabR31w8CXSqzZaE2023PAwFdvBr5UYjPFCH+Py3mqDwa+VGLNhtfEV/8MfKnEDrd0DHz1wcCXSuzICN+Wjnoz8KUSs6Wjp8PAl0qsOd1q6TgtU/0w8KUSa66ypaP+GfhSiS1Ny9ztCF99MPClEpuuTzEVtnTUHwNfKrGIYLbhIijqj4EvldyMi6CoTwa+VHIugqJ+GfhSyTVt6ahPBr5Ucs1Gjb0HbOmoNwNfKrmZRo3d+xzhq7eRB35EXBQROyLigYh4/6jPJ02aZqPmtEz1ZaSBHxE14G+A1wJnAm+JiDNHeU5p0sw26uyxpaM+jHqEfy7wQGY+mJn7geuAS0Z8TmmizDRq7LGloz6MOvDXAo8s295Z7JM0JE7LVL9GHfjRZl8edUDEpojYFhHbFhYWRlyOVD3NRp29Bw6xuJi9D9ZEG3Xg7wROW7a9Dnh0+QGZuTkz5zNzfm5ubsTlSNWzdE38nx10lK/uRh34/w1sjIjTI6IBXA7cNOJzShNlKfCdmqle6qN88sw8GBHvBG4BasAnM/PeUZ5TmjQzDRdBUX9GGvgAmfkF4AujPo80qWaXljl0aqZ68Ju2UsnN2NJRnwx8qeSatnTUJwNfKrmlD229Jr56MfClklsK/L0HHOGrOwNfKrmllo49fPVi4Esl15y2paP+GPhSyTVXFS0dP7RVDwa+VHL12hSN2hS7DXz1YOBLFTDTqLHXlo56MPClCpj1Esnqg4EvVcBMo8Yep2WqBwNfqoBmo86efbZ01J2BL1WAq16pHwa+VAHNRs1v2qonA1+qgGajzm5bOurBwJcqoDUt0xG+ujPwpQqYdZaO+mDgSxUw06j7oa16MvClCmg2auw/uMjBQ4vjLkUrmIEvVcDhRVBs66gLA1+qAJc5VD8GCvyIuCwi7o2IxYiYP+a+qyPigYjYERGvGaxMSd00Dy9k7tRMdVYf8PH3AG8E/mH5zog4E7gceDHwPODLEfGCzHT4IY3AzOF1bf0jps4GGuFn5vbM3NHmrkuA6zJzX2Y+BDwAnDvIuSR1NrvU0rGHry5G1cNfCzyybHtnsU/SCMzY0lEferZ0IuLLwHPb3PWBzLyx08Pa7MsOz78J2ASwfv36XuVIamOph++HtuqmZ+Bn5gXP4Hl3Aqct214HPNrh+TcDmwHm5+fb/qUgqbullo49fHUzqpbOTcDlETEdEacDG4Gvj+hc0sSbcR6++jDotMw3RMRO4OXAv0bELQCZeS9wPXAf8EXgSmfoSKNz+ItX9vDVxUDTMjPzBuCGDvddA1wzyPNL6s/MKqdlqje/aStVwNRUMLPKRVDUnYEvVUSzUXNaproy8KWKcBEU9WLgSxUx6zXx1YOBL1XEjKteqQcDX6qIZqPmtEx1ZeBLFdFs1GzpqCsDX6qIZqPutEx1ZeBLFeG0TPVi4EsV4bRM9WLgSxUx26iz58AhMr3orNoz8KWKmGnUOLSY7D+0OO5StEIZ+FJFHLlipm0dtWfgSxXR9Jr46sHAlyqiubSQ+X5n6qg9A1+qiObhhcwd4as9A1+qiMPLHDo1Ux0Y+FJFLC1kvveALR21Z+BLFdF0hK8eDHypImaclqkeDHypIpZm6exxlo46GCjwI+IvI+LbEfGtiLghIk5cdt/VEfFAROyIiNcMXqqkbpyHr14GHeFvBV6SmWcB/wtcDRARZwKXAy8GLgL+NiJqA55LUhfT9SmmwpaOOhso8DPzS5m59O/HrwHrituXANdl5r7MfAh4ADh3kHNJ6i4iaLqurboYZg//94F/K26vBR5Zdt/OYp+kEWo2ak7LVEf1XgdExJeB57a56wOZeWNxzAeAg8Cnlh7W5vi212yNiE3AJoD169f3UbKkTlzmUN30DPzMvKDb/RFxBXAx8Oo8ciHuncBpyw5bBzza4fk3A5sB5ufnvZC3NICZRt1LK6ijQWfpXAS8D3h9Zu5ZdtdNwOURMR0RpwMbga8Pci5JvdnSUTc9R/g9fByYBrZGBMDXMvMPM/PeiLgeuI9Wq+fKzHTYIY1Ys1HjKde1VQcDBX5mPr/LfdcA1wzy/JKenmajxq6f7Bt3GVqh/KatVCHNRp09tnTUgYEvVUizUWOvs3TUgYEvVYjTMtWNgS9VyEzxTdvFRWc463gGvlQhSxdQ+9lBR/k6noEvVcisi6Coi0Hn4UtaQWaKa+Jf9vdfpT7V7gonWqne/Kun8Y5XnjHScxj4UoX8xvNP4Q3nrGWfLZ3SOWXN9MjPYeBLFfLcX1zNR9989rjL0AplD1+SJoSBL0kTwsCXpAlh4EvShDDwJWlCGPiSNCEMfEmaEAa+JE2IOLLu+PhFxALw3XHX0cEpwA/HXcQAylx/mWuHctdf5tphcur/pcyc63XQigr8lSwitmXm/LjreKbKXH+Za4dy11/m2sH6j2VLR5ImhIEvSRPCwO/f5nEXMKAy11/m2qHc9Ze5drD+o9jDl6QJ4QhfkiaEgd9GRKyOiK9HxDcj4t6I+GCx//SIuCMi7o+Iz0ZEY9y1dhIRtYi4KyJuLrbLVPvDEfE/EXF3RGwr9p0UEVuL+rdGxLPGXWc7EXFiRHwuIr4dEdsj4uUlqv2FxWu+9POTiHhXiep/d/Hn9Z6I+Ezx57hM7/uritrvjYh3FfuG+tob+O3tA87PzJcCZwMXRcR5wIeBj2bmRuBHwNvHWGMvVwHbl22XqXaA38rMs5dNSXs/cGtR/63F9kr018AXM/OXgZfS+n9Qitozc0fxmp8N/AqwB7iBEtQfEWuBPwLmM/MlQA24nJK87yPiJcAfAOfSet9cHBEbGfZrn5n+dPkBmsA3gF+j9QWIerH/5cAt466vQ83rijfH+cDNQJSl9qK+h4FTjtm3Azi1uH0qsGPcdbap+xeAhyg+GytT7W3+W34b+K+y1A+sBR4BTqK1kt/NwGvK8r4HLgM+sWz7T4H3Dvu1d4TfQdESuRvYBWwFvgM8mZkHi0N20nqTrUQfo/VmWSy2T6Y8tQMk8KWIuDMiNhX7npOZjwEUv589tuo6OwNYAP6xaKd9IiJmKUftx7oc+Exxe8XXn5nfBz4CfA94DPgxcCfled/fA7wqIk6OiCbwOuA0hvzaG/gdZOahbP3Tdh2tf2a9qN1hP9+qeouIi4FdmXnn8t1tDl1xtS/zisx8GfBa4MqIeNW4C+pTHXgZ8HeZeQ6wmxXY/uil6HO/HvjncdfSr6K3fQlwOvA8YJbW++dYK/J9n5nbabWftgJfBL4JHOz6oGfAwO8hM58EbgfOA06MiKWF39cBj46rri5eAbw+Ih4GrqPV1vkY5agdgMx8tPi9i1YP+Vzg8Yg4FaD4vWt8FXa0E9iZmXcU25+j9RdAGWpf7rXANzLz8WK7DPVfADyUmQuZeQD4PPDrlOt9f21mviwzXwU8AdzPkF97A7+NiJiLiBOL2zO03kzbgduANxWHXQHcOJ4KO8vMqzNzXWZuoPXP8q9k5lspQe0AETEbEScs3abVS74HuIlW3bBC68/MHwCPRMQLi12vBu6jBLUf4y0caedAOer/HnBeRDQjIjjy2pfifQ8QEc8ufq8H3kjr/8FQX3u/eNVGRJwFbKH1Sf8UcH1m/nlEnEFr1HwScBfwu5m5b3yVdhcRvwn8SWZeXJbaizpvKDbrwKcz85qIOBm4HlhP6w/3ZZn5xJjK7CgizgY+ATSAB4Hfo3gPscJrByj6x48AZ2Tmj4t9ZXntPwi8mVYr5C7gHbR69iv+fQ8QEf9B6/O2A8B7MvPWYb/2Br4kTQhbOpI0IQx8SZoQBr4kTQgDX5ImhIEvSRPCwJekCWHgS9KEMPAlaUL8PxcZYQt1lBc7AAAAAElFTkSuQmCC\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x114a38780>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import pandas as pd\n",
"\n",
"# 每年淨額\n",
"每年淨額 = pd.Series(0, index=預測時段)\n",
"每年淨額.iloc[0] = 起始資金\n",
"每年淨額.loc[:退休年齡] += 每月薪水 * 12\n",
"每年淨額 -= (每月開銷 + 每月房租) * 12\n",
"\n",
"%matplotlib inline\n",
"每年淨額.plot()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 沒有投資的總資產變化情況"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x11800c860>"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3XlcVPX+x/HXh01ccQFcQAU3BC033KCsLMs1l5+WXjMrywW7t+3Wrdtq3W7Lbbt1XcvMFjMzLdfMzBbFDU1NFkVxARdAEVER2b6/Pzj+ft6iQGU4M8Pn+XjwmDlnzjBvaHg3njnzOWKMQSmllPvysDuAUkopx9KiV0opN6dFr5RSbk6LXiml3JwWvVJKuTkteqWUcnNa9Eop5ea06JVSys1p0SullJvzsjsAgL+/vwkJCbE7hlJKuZStW7ceN8YElLWdUxR9SEgIcXFxdsdQSimXIiIHy7Od7rpRSik3p0WvlFJuToteKaXcnBa9Ukq5OS16pZRyc1r0Sinl5rTolVLKzWnRK+ViTucVMG/TIc7lF9kdRbkIp/jAlFKqfI6eOsfdc7aQdOw0B7PO8kS/cLsjKRegr+iVchHxR04xZOp60k6eo1tofd5ft5/9x8/aHUu5AC16pVzA2qQMbpuxAU8RFk7qyX9GdcLH04MXlyfaHU25AC16pZzcxxsPMm7uFkL8a7J4cjRtG9UhsI4vk3u34tvEdH5KzrQ7onJy5Sp6ETkgIr+IyHYRibPW1ReR1SKSbF3Ws9aLiLwtIntFZKeIdHbkD6CUuyouNvxzRSJPfbmL68MCWTChJw3r+P7f7fdEh9Ksfg2eX5pAYVGxjUmVs7uUV/Q3GGM6GmMireXHgTXGmNbAGmsZoB/Q2voaD0yvqLBKVRV5BUXc/+k2Zv2YwpgezZk1pgs1q/33sRO+3p78vX84yRln+GTTIZuSKldwJbtuBgNzretzgSEXrf/QlNgI1BWRxlfwOEpVKSfOnOdP725k5a5jPDUgnOcHt8PLs/Q/1VvaNSSqZQPeWL2Hk2fzKzmpchXlLXoDfCMiW0VkvLWuoTHmKIB1GWitDwJSL7pvmrVOKVWGlMwzDJseS/yRHKb9qTP3XtsCEfnd7UWEZwZFcDqvgLe+3VOJSZUrKW/RRxtjOlOyW2ayiPT6g21Le1aa32wkMl5E4kQkLjNT30xSavP+LIZNj+VMXiGfju9Bv6vK9w/hto3qMLp7cz7edIjdx047OKVyReUqemPMEesyA1gMdAPSL+ySsS4zrM3TgKYX3T0YOFLK95xljIk0xkQGBJR5Jiyl3NpX2w9zx3ubqF/Dh0UxUXRuVu+S7v9wnzbUqubF88viMeY3r6tUFVdm0YtITRGpfeE6cDOwC1gCjLU2Gwt8ZV1fAtxpHX3TAzh1YRePUuq/GWOYunYvD8zfTsdmdVkUE0XzBjUv+fvUq+nDQze1Zv3eE6xOSHdAUuXKyjMCoSGw2NpP6AXMM8Z8LSJbgAUiMg44BIywtl8B9Af2ArnA3RWeWik3UFBUzFOLd/FZXCpDOjbhleFXU83L87K/3+geJbtvXlyRyHVhAVf0vZR7KbPojTEpQIdS1p8AbixlvQEmV0g6pdxUTl4Bkz/Zxk/Jx/lL71Y81KfNH77pWh7enh48PTCCse9vZs76A0y8rmUFpVWuTj8Zq1QlO5x9jhHTN7Bh3wleHX41D98cdsUlf8F1bQK4KTyQd9Ykk3E6r0K+p3J9WvRKVaJdh08xdOp6jmSfY+493bgtsmnZd7pETw6IIL+omFe/3l3h31u5Ji16pSrJd0np3DZzA96eHnwRE0V0K3+HPE6of03uiQ5l4dY0dqRmO+QxlGvRoleqEny04QD3zo2jZUAtFsdE0aZhbYc+3v29W+Ffy4cpS/VwS6VFr5RDFRcb/rEsgae/iqd320A+m9CDwIsGkzlKbV9vHr0ljG2Hslmy4zcfY1FVjBa9Ug5yLr+ImE+28d66/dwVFcLMMZHU8Km8k7oN79KU9kF1eHllErn5hZX2uMr5aNEr5QDHz5xn1LsbWZVwjKcHRvDcre3w9KiYI2vKy9NDeHZQO46eymPGDymV+tjKuWjRK1XB9macYei09SQdy2H66C6MuybUtixdQ+ozqEMTZv6wj7STubblUPbSoleqAm1MOcGwaes5l1/E/PE96du+kd2ReLxfW0TgpZVJdkdRNtGiV6qCLP45jTGzNxFQuxqLY6Lp2LSu3ZEACKpbnQm9WrJ851E278+yO46ygRa9UlfIGMPba5J56LMddGlej0WTomlav4bdsf7LxOta0tjPlylL4ykq1sMtqxoteqWuQH5hMY8u3Mkbq/cwrFMQH97THb8a3nbH+o3qPp480T+c+CM5LIhLLfsOyq1o0St1mU6dK+CuOZtZuDWNB29qzeu3dcDHy3n/pAZd3ZjI5vV4bdVucvIK7I6jKpHzPiuVcmJpJ3MZPj2WLQeyeG1EBx686cqnTzqaSMnhllm5+byzJtnuOKoSadErdYl2pmUzZGosx3LymHtPN4Z3CbY7UrldFezHiC7BfBB7gJTMM3bHUZVEi16pS7A6IZ3bZ26kmpcHiyZFEdXSMYPJHOmvt4RRzcuTF5cn2h1FVRIteqXKac76/Yz/KI42DWuxeHIUrR08mMxRAmv78uferViTlMH3uzPKvoNyeVr0SpWhqNgwZWk8U5YmcFN4Qz4d34PA2o4fTOZId0WHENKgBi8sS6CgqNjuOMrBtOiV+gO5+YVM/Hgrc9Yf4J7oUGbc0aVSB5M5SjUvT54aEMG+zLN8vPGg3XGUg2nRK/U7Mk+fZ9SsjXybmM6zgyJ4ZlBEpQ8mc6QbwwO5trU/b67eQ9bZfLvjKAfSoleqFMnppxk6bT170s8wa0wkd0fbN5jMUUSEpwdGcDa/iDdW62kH3ZkWvVK/ErvvOMOmx5JXUMxnE3rQJ6Kh3ZEcpk3D2ozp0Zx5mw6ReDTH7jjKQbTolbrIF1vTGPv+ZhrV8eXLyVFcHewcg8kc6cGbWlOnujfPL03Q0w66KS16pSgZTPbWt3t45PMddA2pz8JJUQTXc67BZI5St4YPj/Rpw4aUE6yKP2Z3HOUAWvSqyssvLOaRBTt469tkhncJ5oO7u+FX3fkGkznSqG7NCGtYmxdXJJJXUGR3HFXByl30IuIpIj+LyDJrOVRENolIsoh8JiI+1vpq1vJe6/YQx0RX6sqdyi1g7PubWfTzYR7u04Z/Db/aqQeTOYqXpwfPDIogNescs9fttzuOqmCX8ox+ALj4M9OvAG8aY1oDJ4Fx1vpxwEljTCvgTWs7pZxOalYu/zMjlriDWbx5ewf+cmNrpx9M5kjRrfy5OaIhU9fuJT0nz+44qgKVq+hFJBgYALxnLQvQG1hobTIXGGJdH2wtY91+o1Tlvx7llHakZjN02noyT5/no3HdGdrJdQaTOdKTA8IpLDK88rWedtCdlPcV/VvAY8CFz0o3ALKNMYXWchoQZF0PAlIBrNtPWdsr5RRWxR/j9lkbqO7jyReToujRQp+eFzRvUJNx14ayaNthfj500u44qoKUWfQiMhDIMMZsvXh1KZuactx28fcdLyJxIhKXmZlZrrBKXanZ6/Yz8eOthDWqw+KYaFoF1rI7ktOZfEMrAmpXY8rSBIr1tINuoTyv6KOBW0XkADCfkl02bwF1ReTC0I9g4Ih1PQ1oCmDd7gf85ozExphZxphIY0xkQEDAFf0QSpWlqNjw3JJ4XliWwM0RDZl/Xw/8a1WzO5ZTqlXNi7/1bcv21Gy+3H7Y7jiqApRZ9MaYJ4wxwcaYEGAk8J0xZjSwFhhubTYW+Mq6vsRaxrr9O6OfwlA2ys0vZMJHcXwQe4D7rg1l+uguVPfxtDuWUxvWKYgOwX688nUSZ88Xln0H5dSu5DiyvwEPi8heSvbBz7bWzwYaWOsfBh6/sohKXb6M03ncPnMj3yVl8MLgdjw5IAIPNxpM5igeHsIzg9qRnnOe6d/vszuOukKXNG/VGPM98L11PQXoVso2ecCICsim1BXZk36au+ds4WRuPu/eGcmN4e47s8YRujSvx9BOQcz6KYXbuzalaf2q8Ulhd1T1PhmiqoR1ycf5n2mx5BcVs2BCTy35y/S3vm3xFOGfK/S0g65Mi165nQVxqdw1ZzNN6lbny8nRtA/yszuSy2rk50vM9S1ZuesYG/adsDuOukxa9MptGGN4/ZvdPLZwJz1bNuDzST0Jqlvd7lgu775eLQiqW50pS+Mp0sMtXZIWvXIL5wuLeOiz7bzz3V5uj2zK+3d1pY5v1RpM5ii+3p48OSCcpGOnmb/lkN1x1GXQolcuLzs3nzGzN/Pl9iM8eksYL//PVXh76lO7IvVr34juofV5bdVuTuUW2B1HXSL9a1Au7dCJXIZNj2X7oWz+PbIjk29oVaUHkzmKiPDMoAiyzxXw7zXJdsdRl0iLXrmsnw+dZOi09WSdzefje7szuGNQ2XdSl61dEz9Gdm3GhxsOsDfjtN1x1CXQolcuaeUvRxk5ayM1q3nxxaQouoXWtztSlfDXm9tQ3ceTF5bp4ZauRIteuRRjDO/9lELMvG1ENKnD4pgoWgboYLLK0qBWNR64sTU/7MlkbVKG3XFUOWnRK5dRWFTMM1/F84/lifRr34hP7+tBAx1MVunu7BlCC/+avLAsgfzC4rLvoGynRa9cwtnzhYz/aCsfbTzIhF4t+M+ozvh662AyO/h4efD0wAhSjp9lbuwBu+OoctCiV04vPSeP22Zu4PvdGbwwpD1P9A/XwWQ2u6FtINeHBfD2mmSOnzlvdxxVBi165dSSjuUwZOp6Dhw/y+y7ujKmR3O7IynLUwMiOFdQxOvf7LY7iiqDFr1yWj/uyWT49A0UG8OCiT25ISzQ7kjqIq0CazE2KoT5W1LZdfiU3XHUH9CiV05p/uZD3P3BFoLrVWdxTDTtmuhgMmf0lxtbU6+GD88vS0DPL+S8tOiVUykuNrz6dRKPL/qF6Fb+fD6xJ010MJnT8qvuzV9vDmPz/ixW/HLM7jjqd2jRK6eRV1DEA59tZ9r3+xjZtSmzx0ZSWweTOb3buzYlvHEd/rkikbyCIrvjqFJo0SuncPJsPmNmb2LpjiM81jeMl4bpYDJX4ekhPDsogsPZ55j1Y4rdcVQp9C9J2e7A8bMMmx7LjrRTvDOqEzHX62AyV9OjRQP6X9WI6d/v4+ipc3bHUb+iRa9stfVgFkOnrSc7N59593ZnUIcmdkdSl+mJfuEUGcMrK5PsjqJ+RYte2Wb5zqOMencTftW9WRQTTWSIDiZzZU3r12BCrxZ8uf0IWw9m2R1HXUSLXlU6YwwzftjH5HnbuCrIj0Ux0YT617Q7lqoAk65vSaM6vkxZmkCxnnbQaWjRq0pVWFTMk1/u4uWVSQy8ujGf3Nud+jV97I6lKkgNHy/+1i+MnWmn+GJbmt1xlEWLXlWaM+cLGTc3jnmbDjHp+pa8PbKTDiZzQ4M7BNGpWV1e+Xo3p/P0tIPOQIteVYpjp/IYMWMD6/Ye56VhV/G3vm11MJmb8vAQnh3UjuNnzjN17T674yi06FUlSDhSMpgsNSuX9+/qyqhuzeyOpBysY9O6DOscxPvr9nPwxFm741R5ZRa9iPiKyGYR2SEi8SIyxVofKiKbRCRZRD4TER9rfTVrea91e4hjfwTlzL7fncGIGbEALJjQk+vaBNicSFWWv/Vti5en8I/letpBu5XnFf15oLcxpgPQEegrIj2AV4A3jTGtgZPAOGv7ccBJY0wr4E1rO1UFzdt0iHFz42jeoCZfTo4mokkduyOpStSwji+Tb2jF6oR01iUftztOlVZm0ZsSZ6xFb+vLAL2Bhdb6ucAQ6/pgaxnr9htFP+ZYpRQXG15emcTfF/9Cr9b+LJjYk0Z+vnbHUjYYd00oTetX5/ll8RQW6WkH7VKuffQi4iki24EMYDWwD8g2xhRam6QBQdb1ICAVwLr9FNCglO85XkTiRCQuMzPzyn4K5TTyCor48/yfmfHDPkZ3b8a7d0ZSq5qX3bGUTXy9PXmyfzh70s8wb/Mhu+NUWeUqemNMkTGmIxAMdAPCS9vMuizt1ftvPjlhjJlljIk0xkQGBOh+W3eQdTaf0e9tYvnOo/y9f1v+MaQ9XjqYrMq7pV0jerZowBur95Cdm293nCrpkv4KjTHZwPdAD6CuiFx4qRYMHLGupwFNAazb/QD9PLSb23/8LMOmrWfX4VNMG92Z8b1a6mAyBYCI8MygCHLOFfDWt8l2x6mSynPUTYCI1LWuVwduAhKBtcBwa7OxwFfW9SXWMtbt3xk99Yxb23Igi2HT1pOTV8i8+3rQ/6rGdkdSTia8cR3+1L0ZH208yJ7003bHqXLK84q+MbBWRHYCW4DVxphlwN+Ah0VkLyX74Gdb288GGljrHwYer/jYylks2XGE0e9uol4NHxbHRNGleT27Iykn9XCfMGr6ePKCnnaw0pX5LpkxZifQqZT1KZTsr//1+jxgRIWkU07LGMO07/fxr1W76RpSj1ljIqmnM2vUH6hf04eH+rRhytIEvk3MoE9EQ7sjVRn6Tpm6ZAVFxTyx6Bf+tWo3gzo04aNx3bXkVbnc0aM5rQJr8eLyBM4X6mkHK4sWvbokp/MKuOeDLczfksrkG1ry79s76mAyVW7enh48MzCCAydy+WD9AbvjVBla9KrcjmSfY8SMDcTuO8HLw67i0Vt0MJm6dL3aBHBTeCDvfLeXjNN5dsepErToVbnsOnyKIVPXc/jkOT64uysjdTCZugJPDojgfGERr63abXeUKkGLXpVpbVIGt83cgJeH8PmknlzbWj/gpq5MqH9N7o4O5fOtaexMy7Y7jtvTold/6KONBxk3dwuh/jVZPDmato10MJmqGPf3bkWDmj5MWaqHWzqaFr0qVXGx4Z8rEnn6y11cHxbIggk9aVhHB5OpilPH15u/3hzG1oMnWbLjSNl3UJdNi179Rl5BEZPnbWPWjymM6dGcWWO6UFMHkykHGBHZlHZN6vDyyiRy8wvLvoO6LFr06r+cOHOeUe9u5Ov4Yzw1IJznB7fTwWTKYTyt0w4ePZXHzB9S7I7jtvQvWP2ffZlnGDotloQjOUwf3Zl7r22hg8mUw3ULrc/Aqxsz44d9HM4+Z3cct6RFrwDYlHKCYdNiOXu+kPnje9C3vQ4mU5Xnif4lk89fWqGnHXQELXrFV9sPM2b2ZhrU8mFxTDSdmulgMlW5gupWZ8J1LVm28yib9+tU84qmRV+FGWP4z3fJPDB/O52a1WXRpCiaNahhdyxVRU28rgWN/XyZsjSeomI93LIiadFXUQVFxfzti5289s0ehnRswofjulG3hg4mU/ap4ePF4/3aEn8kh4VbU+2O41a06KugnLwC7p6zhQVxafyldyvevL0j1bx0MJmy360dmhDZvB7/WrWbnLwCu+O4DS36KuZw9jmGT49lY8oJ/jX8ah6+OUyPrFFOQ6TkcMsTZ/P5z3d77Y7jNrToq5ALg8mOZucx955ujIhsanckpX7jqmA/hncOZs76/ew/ftbuOG5Bi76K+DYhnREzNuDj6cEXMVFEt/K3O5JSv+vRvmH4eHrw4vIEu6O4BS36KmBu7AHGfxRHq8BaLI6Jok3D2nZHUuoPBdb25c83tubbxAx+2JNpdxyXp0XvxoqKDS8sS+DZJfH0bhvIZxN6EKiDyZSLuDs6hOYNavDCsgQKiortjuPStOjd1Ln8ImI+2crsdfu5KyqEmWMiqeGjg8mU66jm5clTAyLYm3GGjzcetDuOS9Oid0OZp88z8t2NfJOQzjMDI3ju1nZ46in/lAu6KTyQa1v78+bqPWSdzbc7jsvSonczezPOMGz6enYfy2HGHV2455pQuyMpddlEhKcHRnA2v4g3VutpBy+XFr0b2ZhygmHT1nMuv4j543tyS7tGdkdS6oq1aVibO7o3Y96mQyQezbE7jkvSoncTi39OY8zsTQTW8WVxTDQdm9a1O5JSFeahPm2oU92b5/W0g5elzKIXkaYislZEEkUkXkQesNbXF5HVIpJsXdaz1ouIvC0ie0Vkp4h0dvQPUZUZY3h7TTIPfbaDyOb1+WJiFE3r62Ay5V7q1vDh4T5t2JByglXx6XbHcTnleUVfCDxijAkHegCTRSQCeBxYY4xpDayxlgH6Aa2tr/HA9ApPrQDILyzm0YU7eWP1HoZ1DmLuPd3wq+FtdyylHOJP3ZrRpmEtXlyRQF5Bkd1xXEqZRW+MOWqM2WZdPw0kAkHAYGCutdlcYIh1fTDwoSmxEagrInoWiwp26lwBd83ZzMKtaTx0UxteH9EBHy/dE6fcl5enB88Oakdq1jlmr9tvdxyXcknNICIhQCdgE9DQGHMUSv5nAARamwUBF88YTbPWqQqSmpXL8OmxbDmQxRu3deCBm1rrYDJVJUS38qdPREOmrt1Lek6e3XFcRrmLXkRqAV8ADxpj/uit79Ia5zfvnojIeBGJE5G4zEz9iHN57UzLZui0WI7llAwmG9Y52O5ISlWqJ/uHU1hkePVrPdyyvMpV9CLiTUnJf2KMWWStTr+wS8a6zLDWpwEXj0UMBo78+nsaY2YZYyKNMZEBAQGXm79K+Sb+GLfP3IivtweLY6KIaqmDyVTVE+Jfk3uuCeWLbWlsT822O45LKM9RNwLMBhKNMW9cdNMSYKx1fSzw1UXr77SOvukBnLqwi0ddvvfX7WfCx1tp07AWi2OiaRWog8lU1XV/71b416rGc0viKdbTDpapPK/oo4ExQG8R2W599QdeBvqISDLQx1oGWAGkAHuBd4GYio9ddRQVG55bEs/zyxLoE96Q+eN7ElC7mt2xlLJVrWpePNY3jO2p2Xy147DdcZxemVOujDHrKH2/O8CNpWxvgMlXmEsBufmFPDB/O6sT0rknOpQnB4TrzBqlLMM7B/PxxoO8vDKJmyMaUbOaDu37PXo8npPKOJ3HyFkbWZOYznODInhmUISWvFIX8fAQnh0UQXrOeWb8sM/uOE5Ni94JJaefZujUWJLTzzBzTCR3RetgMqVK06V5fQZ3bMLMH1NIzcq1O47T0qJ3MrF7jzNseiz5RcUsmNCTPhEN7Y6klFN7vF9bPEV4aWWi3VGclha9E1m4NY2xczbT2M+XxTFRXBXsZ3ckpZxeY7/qTLq+JSt+OcbGlBN2x3FKWvROwBjDG6v38NfPd9AttD6fT4wiuJ4OJlOqvMb3akFQ3epMWZpAkR5u+Rta9DbLLyzmkQU7eHtNMiO6BDPnrm74VdfBZEpdCl9vT57o35bEozl8tiW17DtUMVr0NjqVW8Cd729i0c+H+evNbXh1+NU6mEypyzTgqsZ0C6nPa9/s5tS5ArvjOBVtFZukZuUybPp6th3M5q3bO3J/bx1MptSVEBGeGRTBydx83l6TbHccp6JFb4PtqdkMnbae42fy+XBcN4Z00uGeSlWE9kF+jOzalLmxB9iXecbuOE5Di76Sfb3rGCNnbaCGjxeLYqLo0aKB3ZGUciuP3BxGdW9P/rEswe4oTkOLvpIYY3jvpxQmfbKVto3qsCgmipYBteyOpZTb8a9Vjb/c2Jq1uzNZm5RR9h2qAC36SlBYVMxzS+L5x/JE+rZrxPzxPfCvpYPJlHKUsVEhhPrX5IXlCeQXFtsdx3Za9A529nwhEz7aytwNB7nv2lCm/qkzvt6edsdSyq35eHnw9MBwUjLP8uGGA3bHsZ0WvQNl5ORx+6wNrN2dwQuD2/HkgAg8dDCZUpXihrBArmsTwL/XJHPizHm749hKi95Bdh87zZCp60nJPMt7YyMZ0zPE7khKVSkiwtMDw8nNL+L11XvsjmMrLXoHWJd8nOHTYyksNiyY0JPebXUwmVJ2aBVYmzt7NufTzYeIP3LK7ji20aKvYAu2pHLXnM00qVudLydH0z5IB5MpZacHb2xD3erePL80gZLzIlU9WvQVxBjD69/s5rEvdtKzZQMWTupJk7rV7Y6lVJXnV8ObR24OY9P+LFbuOmZ3HFto0VeA84VFPPTZdt75bi8juzbl/bu6UttXB5Mp5SxGdWtG20a1+eeKRPIKiuyOU+m06K9Qdm4+Y2Zv5svtR3j0ljBeGnYV3p76a1XKmXh6lMzBSTt5jvd+SrE7TqXTRroCh07kMmx6LNsPZfPvkR2ZfEMrHUymlJOKaulPv/aNmLp2H8dO5dkdp1Jp0V+mbYdOMnTaerLO5vPxvd0Z3FEHkynl7P7eP5wiY3jl6yS7o1QqLfrLsPKXo4yatZFavl4smhRFt9D6dkdSSpVD0/o1uO/aUBb/fJhth07aHafSaNFfAmMM7/6YQsy8bbQP8mPRpCha6GAypVxKzPWtCKxdjSlLEyiuIqcd1KIvp8KiYp7+ahcvrkikf/vGfHJvdxroYDKlXE7Nal483q8tO1KzWfzzYbvjVIoyi15E3heRDBHZddG6+iKyWkSSrct61noRkbdFZK+I7BSRzo4MX1nOni/kvg/j+HjjISZe15J3RnXSwWRKubAhHYPo2LQur3ydxJnzhXbHcbjyvKL/AOj7q3WPA2uMMa2BNdYyQD+gtfU1HpheMTHtk56Tx20zN/Bj8nFeHNqex/u11cFkSrk4Dw/h2UERZJw+z7S1e+2O43BlFr0x5kcg61erBwNzretzgSEXrf/QlNgI1BWRxhUVtrIlHcthyNT1HDheMphsdPfmdkdSSlWQTs3qMaxTEO/9tJ9DJ3LtjuNQl7uPvqEx5iiAdRlorQ8CUi/aLs1a53J+3JPJ8OkbMAY+nxjFDWGBZd9JKeVSHuvbFi9P4cUV7n3awYp+M7a0fRqlvq0tIuNFJE5E4jIzMys4xpX5dPMh7v5gC8H1qrN4chQRTerYHUkp5QCN/HyZfEMrVsWnE7v3uN1xHOZyiz79wi4Z6/LCiRnTgKYXbRcMHCntGxhjZhljIo0xkQEBAZcZo2IVFxte/TqJJxb9QnQrfz6f2JPGfjqYTCl3Nu6aUILrVef5ZQkUFrnnaQcvt+iXAGOt62OBry5af6d19E0P4NSFXTzOLq+giAc+28607/cxqlszZo+N1MFkSlUBvt6ePNk/nKRjp/l0S2rZd3BB5TknzmJmAAALiklEQVS88lNgAxAmImkiMg54GegjIslAH2sZYAWQAuwF3gViHJK6gmWdzeeO9zaxdMcRHu/Xln8Oba+DyZSqQvq2b0SPFvV5/ZvdZOfm2x2nwokzDOKPjIw0cXFxtjz2geNnufuDLRzOPsfrIzowqEMTW3IopeyVcCSHge/8xJ09Q3ju1nZ2xykXEdlqjIksa7sq/bJ168Eshk5bT3ZuPvPu7a4lr1QVFtGkDqO6NeOjjQdJTj9td5wKVWWLfvnOo4x6dxN+1b1ZHBNNZIgOJlOqqnu4Txtq+njy/DL3Ou1glSt6YwwzftjH5HnbuDrIj0Ux0YT417Q7llLKCTSoVY0Hb2rDT8nH+S4po+w7uIgqVfSFRcU8+eUuXl6ZxMCrG/Pxvd2pX9PH7lhKKScypmdzWgbU5IVlCeQXusfhllWm6M+cL2Tc3DjmbTpEzPUteXukDiZTSv2Wt6cHTw+M4MCJXD6I3W93nApRJYr+6KlzjJixgXV7j/PSsKt4rK8OJlNK/b7rwwLp3TaQt9fsJfP0ebvjXDG3L/qEIzkMnRpLalYu79/VlVHdmtkdSSnlAp4aEE5eQRGvrdptd5Qr5tZFv3Z3BiNmxCICn0/syXVtnGPUglLK+bUIqMXd0SEs2JrKrsOn7I5zRdy26D/ZdJB758bRvEFNFsdEE95YB5MppS7Nn29sTf0aPkxZGu/Sh1u6XdEXFxteWpnIk4t30au1Pwsm9qSRn6/dsZRSLqiOrzeP3hLGlgMnWbbTJcZ2lcqtij6voIg/z/+ZmT+kcEePZrx7ZyS1qnnZHUsp5cJGRDYlonEdXlqRyLn8IrvjXBa3KfoTZ87zp3c3snznUf7evy0vDG6Plw4mU0pdIU/rtINHTuUx88d9dse5LG7RhCmZZxg2PZb4IzlMG92Z8b1aIqKHTyqlKkb3Fg0YcHVjZvywjyPZ5+yOc8lcvui3HMhi2PRYTucV8un4HvS/ymVPUauUcmJP9GuLMfDyyiS7o1wyly765TuPMvrdTdSv4cPimCg6N6tndySllJsKrleDCb1asGTHEbYcyLI7ziVx6aL3q+5N19B6LIqJonkDHUymlHKside3pFEdX6Ysjae42HUOt3Tpor+mtT8fj+tO3Ro6mEwp5Xg1fLx4on9bdh3OYeHWNLvjlJtLFz2gb7oqpSrVrR2a0KV5PV5dlcTpvAK745SLyxe9UkpVJpGSwy2Pn8nnP2v32h2nXLTolVLqEl0dXJcRXYJ5f91+9h8/a3ecMmnRK6XUZXi0bxg+nh68uDzR7ihl0qJXSqnLEFjbl/t7t+bbxHR+3JNpd5w/pEWvlFKX6Z5rQmjeoAYvLEugoMh5TzuoRa+UUpepmpcnT/YPJznjDPM2HbI7zu/SoldKqSvQJ6Ih17Ty543Vezh5Nt/uOKXSoldKqSsgIjw9MIIz5wt589s9dscplUOKXkT6ishuEdkrIo874jGUUspZhDWqzejuzfh440GSjuXYHec3KrzoRcQTmAr0AyKAUSISUdGPo5RSzuShm9pQ29eb55cmON1pBx3xir4bsNcYk2KMyQfmA4Md8DhKKeU06tX04eE+bYjdd4JvEtLtjvNfHFH0QUDqRctp1rr/IiLjRSROROIyM537GFSllCqP0d2b0aZhLV5cnsj5Quc57aAjir60KWO/+XeMMWaWMSbSGBMZEBDggBhKKVW5vDw9eHpgBIeycnl/3QG74/wfRxR9GtD0ouVg4IgDHkcppZzOta0DuCm8If/5LpmMnDy74wCOKfotQGsRCRURH2AksMQBj6OUUk7pqQHh5BcV8+qq3XZHARxQ9MaYQuB+YBWQCCwwxsRX9OMopZSzCvGvyT3XhLJwaxo7UrPtjuOY4+iNMSuMMW2MMS2NMS864jGUUsqZ3X9DK/xrVWPK0njbD7fUT8YqpZQD1Pb15rFbwth2KJslO+x9m1KLXimlHGR4l2CuCvLjpRVJ5OYX2pZDi14ppRzEw6PktIPHcvKY8f0++3LY9shKKVUFRIbU59YOTZj5YwppJ3NtyaBFr5RSDvZ4v7aIwEsrkmx5fC16pZRysCZ1qzPxupYs/+Uom1JOVPrja9ErpVQlmNCrJU38fJmyNIGi4so93FKLXimlKkF1H0+e6B9OwtEcFsSlln2HCqRFr5RSlWTg1Y3pGlKP11btJievoNIeV4teKaUqiYjw7KB2ZOXm886a5Ep7XC16pZSqRO2D/Lg9silz1h9gX+aZSnlMLXqllKpkj9wchq+3Jy8uT6yUx9OiV0qpShZQuxp/ubEV3yVl8P3uDIc/npfDH0EppdRv3BUVyoZ9J/DxcvzrbS16pZSygY+XB3Pu7lYpj6W7bpRSys1p0SullJvToldKKTenRa+UUm5Oi14ppdycFr1SSrk5LXqllHJzWvRKKeXmxJjKHYBfagiRTOCg3Tl+hz9w3O4QV8CV87tydnDt/K6cHVw7/6Vkb26MCShrI6coemcmInHGmEi7c1wuV87vytnBtfO7cnZw7fyOyK67bpRSys1p0SullJvToi/bLLsDXCFXzu/K2cG187tydnDt/BWeXffRK6WUm9NX9Eop5ea06C8iIr4isllEdohIvIhMsdaHisgmEUkWkc9ExMfurL9HRDxF5GcRWWYtu1L2AyLyi4hsF5E4a119EVlt5V8tIvXszlkaEakrIgtFJElEEkWkpwtlD7N+5xe+ckTkQRfK/5D197pLRD61/o5d6Xn/gJU9XkQetNZV6O9ei/6/nQd6G2M6AB2BviLSA3gFeNMY0xo4CYyzMWNZHgAuPhGlK2UHuMEY0/Giw8seB9ZY+ddYy87o38DXxpi2QAdK/hu4RHZjzG7rd94R6ALkAotxgfwiEgT8BYg0xrQHPIGRuMjzXkTaA/cB3Sh53gwUkdZU9O/eGKNfpXwBNYBtQHdKPrzgZa3vCayyO9/vZA62nhS9gWWAuEp2K98BwP9X63YDja3rjYHdducsJXcdYD/We16ulL2Un+VmYL2r5AeCgFSgPiVnzFsG3OIqz3tgBPDeRctPA49V9O9eX9H/irXrYzuQAawG9gHZxphCa5M0Sp5czugtSp4kxdZyA1wnO4ABvhGRrSIy3lrX0BhzFMC6DLQt3e9rAWQCc6zdZu+JSE1cI/uvjQQ+ta47fX5jzGHgNeAQcBQ4BWzFdZ73u4BeItJARGoA/YGmVPDvXov+V4wxRabkn7DBlPxzKry0zSo3VdlEZCCQYYzZevHqUjZ1uuwXiTbGdAb6AZNFpJfdgcrJC+gMTDfGdALO4oS7Ocpi7ce+Ffjc7izlZe27HgyEAk2AmpQ8f37NKZ/3xphESnYzrQa+BnYAhX94p8ugRf87jDHZwPdAD6CuiFw4kXowcMSuXH8gGrhVRA4A8ynZffMWrpEdAGPMEesyg5J9xN2AdBFpDGBdZtiX8HelAWnGmE3W8kJKit8Vsl+sH7DNGJNuLbtC/puA/caYTGNMAbAIiMK1nvezjTGdjTG9gCwgmQr+3WvRX0REAkSkrnW9OiVPokRgLTDc2mws8JU9CX+fMeYJY0ywMSaEkn9+f2eMGY0LZAcQkZoiUvvCdUr2Fe8CllCSG5w0vzHmGJAqImHWqhuBBFwg+6+M4v9324Br5D8E9BCRGiIi/P/v3iWe9wAiEmhdNgOGUfLfoEJ/9/qBqYuIyNXAXEreufcAFhhjnheRFpS8Sq4P/AzcYYw5b1/SPyYi1wN/NcYMdJXsVs7F1qIXMM8Y86KINAAWAM0o+aMeYYzJsinm7xKRjsB7gA+QAtyN9RzCybMDWPuHU4EWxphT1jpX+d1PAW6nZJfHz8C9lOyTd/rnPYCI/ETJ+2kFwMPGmDUV/bvXoldKKTenu26UUsrNadErpZSb06JXSik3p0WvlFJuToteKaXcnBa9Ukq5OS16pZRyc1r0Sinl5v4Xd+f2JWehtNMAAAAASUVORK5CYII=\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x10baa5470>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# 無投資總資產\n",
"\n",
"無投資總資產 = 每年淨額.cumsum()\n",
"無投資總資產.plot()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 有投資的總資產變化情況\n",
"\n",
"每年,我們都審視前年的帳戶,將資金分成兩份\n",
"* 投資金額 = 總帳戶金額 * 投資部位\n",
"* 存在帳戶裡不動錢 = 總帳戶金額 * (1 - 投資部位)\n",
"\n",
"所以今年底的帳戶餘額 = 投資金額 * 投資年利率 + 存在帳戶裡不動的錢\n",
"\n",
"於是我們可以寫一個函式代表每年的資產增加變化:"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x1181987f0>"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAD8CAYAAACRkhiPAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3XeYVPXZxvHvs/QqvW0BFhaQoiBLERVRNLYoFlSMiS0RTDTRxBRNTCRqEvNaotFIgiX2gi0iFkAEAaUtvQksLGVhqQtLWdj6vH/MICtSli1Tdu7Pde01M2fPzDw7DHPPec7vd465OyIiEpviwl2AiIiEj0JARCSGKQRERGKYQkBEJIYpBEREYphCQEQkhikERERimEJARCSGKQRERGJY9XAXcDzNmjXzdu3ahbsMEZGoMXfu3O3u3rw060Z8CLRr1460tLRwlyEiEjXMbF1p11U7SEQkhikERERimEJARCSGKQRERGKYQkBEJIYpBEREYphCQEQkhikEREQizLz1Oxk9dXVInkshICISQcYu3MSw0TN5fdZ69uUVVvrzRfyMYRGRWODuPPV5Oo9PXEnfdk349496U69W5X9EKwRERMIsr7CIe95dzPvzN3Jlr3j+dlUPalWvFpLnVgiIiIRR9r58RrySxpy1O7n7/E7ccW5HzCxkz3/cfQJm9oKZbTWzJSWWvWVmC4I/a81sQXB5OzPbX+J3/y5xn95mttjM0s3snxbKv1JEJAItz9rNZU9PZ2FmDk9d14ufD04JaQBA6bYEXgSeBl4+uMDdrz143cweA3JKrL/a3Xse4XFGAcOBmcDHwIXAJydesohI9Bu/dDO/fGsBDWpX5+0Rp3NqYqOw1HHcLQF3nwpkH+l3wW/z1wBvHOsxzKw10NDdZ7i7EwiUy0+8XBGR6ObuPDVpFSNemUtKywaMvePMsAUAlH+fwFnAFndfVWJZezObD+wG7nP3aUA8kFlinczgsiMys+EEthpISkoqZ4kiIpEhN7+Q37yziI8WZXFFr3j+dmUPatcIzQ7goylvCFzHt7cCsoAkd99hZr2B/5lZN+BITS4/2oO6+2hgNEBqaupR1xMRiRbrduxjxCtzWbllD/dc1IURA5ND3v8/kjKHgJlVB64Eeh9c5u55QF7w+lwzWw10IvDNP6HE3ROATWV9bhGRaDJ5xVbufGM+cXHGizf3ZWCnUp35MSTKM2P4POBrd/+mzWNmzc2sWvB6MpACrHH3LGCPmfUP7ke4AfigHM8tIhLxiosD/f9bXpxDQuO6fHjHmREVAFCKLQEzewMYBDQzs0zgfnd/HhjGd3cIDwQeMLNCoAi4zd0P7lT+KYGRRnUIjArSyCARqbJy9hfw67cXMnHZFq7oFc9fr+hBnZrh7f8fiQUG60Su1NRU14nmRSSaLNmYw89em8emXfv5wyUnc9OAdiHt/5vZXHdPLc26mjEsIlJB3J0xaRv44wdLaVqvJm+NOJ3ebRuHu6xjUgiIiFSA/flF/PGDJbwzN5OzUprxxLU9aVq/VrjLOi6FgIhIOa3asoc7Xp/Pyq17uHNwCr8YnEK1uPAP/ywNhYCISBm5O2+nZfKnsUuoX6s6L0XY8M/SUAiIiJTB3rxC7nt/Mf9bsIkBHZryxLU9adGwdrjLOmEKARGRE7RkYw4/f2M+63bs41fnd+L2czpGTfvncAoBEZFSKi52np22hkcnrKBpvVq8cWt/+iU3DXdZ5aIQEBEphc05B7j77QV8mb6DC7u14m9X9qBxvZrhLqvcFAIiIscxfulmfvfuIvIKivnblT0Y1icxIg7+VhEUAiIiR7HnQAEPjlvGmLRMusc35MlhvejQvH64y6pQCgERkSOYnZHNr8YsYNOu/fx0UAd+eV4nalYvzzE3I5NCQESkhLzCIh6fsJLR09aQ2LguY0acTmq7JuEuq9IoBEREgpZszOHXby/k6817uK5vIvdd0pV6tar2x2TV/utEREohv7CYpz5fxTNTVtO0Xk1euCmVc7u0DHdZIaEQEJGYVvLb/5W94rn/0m6cVLdGuMsKGYWAiMSkvMIi/vV5Os9MWU3jejV57oZUzusaG9/+S1IIiEjMmbsum9+9u5j0rXu5slc8f7q0K43qRv/Er7I47ngnM3vBzLaa2ZISy0aa2UYzWxD8ubjE7+41s3QzW2FmF5RYfmFwWbqZ3VPxf4qIyLHtzSvk/g+WMPTfM9ifX8SLN/fh8Wt7xmwAQOm2BF4EngZePmz5P9z90ZILzKwrgXMPdwPaAJ+ZWafgr/8FnA9kAnPMbKy7LytH7SIipfb511v44/+WsilnPzee3o5fX9CZ+lV85E9pHPcVcPepZtaulI83BHjT3fOADDNLB/oGf5fu7msAzOzN4LoKARGpVFt2H+DPHy7l48WbSWlRn3duGxDxp3wMpfLE4B1mdgOQBtzt7juBeGBmiXUyg8sANhy2vF85nltE5JiKip1XZqzl0QkrKSgq5jcXdObWs5Kr5Kzf8ihrCIwCHgQ8ePkYcAtwpCMqOUfe9+BHe3AzGw4MB0hKSipjiSISqxZl7uKP/1vCwswczkppxkOXd6dt03rhLisilSkE3H3Lwetm9iwwLngzE0gssWoCsCl4/WjLj/T4o4HRAKmpqUcNCxGRknbl5vPI+BW8Pns9TevV4p/X9eLSU1pXmSN+VoYyhYCZtXb3rODNK4CDI4fGAq+b2eMEdgynALMJbCGkmFl7YCOBncc/KE/hIiIHFRc778zN5OFPv2ZXbj43DWjHL8/vRMPasTPpq6yOGwJm9gYwCGhmZpnA/cAgM+tJoKWzFhgB4O5LzWwMgR2+hcDt7l4UfJw7gPFANeAFd19a4X+NiMSchRt2MfLDpcxfv4vUto15YEg/urZpGO6yooa5R3a3JTU11dPS0sJdhohEmK17DvDIpyt4e24mzerX4p6LunDVafFq/QBmNtfdU0uzrgbJikhUyS8s5sWvMvjnpHTyCosYMTCZO87tSAO1fspEISAiUcHdmbBsC3/7eDlrd+RybpcW3HfJySRXsTN9hZpCQEQi3pKNOTw4bhmzMrLp2KI+/725D+d0bhHusqoEhYCIRKysnP08On4l783PpEndmjx4eXeu65NI9Wqa8FVRFAIiEnFy9hcwaspq/vtlBu4wfGAyt5/TUUM+K4FCQEQiRl5hEa/MWMfTk9PJ2V/A5T3j+dX5nUhsUjfcpVVZCgERCbuiYuf9+Rv5x8SVbNy1n7NSmnHPRV3o1uakcJdW5SkERCRs3J3xSzfz6ISVpG/dS/f4hjx8VQ/OSmke7tJihkJARELO3Zm2ajuPTljBoswcOjSvxzPXn8ZF3VtpsleIKQREJKS+Wr2df0xcyZy1O4lvVIdHhp7CFb3iNeInTBQCIhISs9bs4PGJK5mVkU3LhrV4cEg3rumTSK3q1cJdWkxTCIhIpZq5Zgf/nLSKr1bvoHmDWtx/aVeu65tE7Rr68I8ECgERqXDuzpfpgQ//2WuzaVa/FvddcjLX92tLnZr68I8kCgERqTDuzuQVW3n683Tmrd9Fq4a1GXlpV4bpm3/EUgiISLkVFhXz0eIsRk1Zzdeb9xDfqA4PXd6dq1MT1POPcAoBESmzAwVFvDsvk/98sYb12bl0bFGfx64+lct6tqGGRvtEBYWAiJywXbn5vDpzHS9+tZbte/M5NeEk/nBJb84/uSVxcRrnH01Kc3rJF4DvA1vdvXtw2SPApUA+sBq42d13mVk7YDmwInj3me5+W/A+vYEXgTrAx8CdHumnNRORb9mQncvz0zMYk7aB3PwiBnVuzvCByZye3FSTvKJUabYEXgSeBl4usWwicK+7F5rZ34F7gd8Ff7fa3Xse4XFGAcOBmQRC4ELgkzLWLSIh4u7MW7+T56dn8OmSzVSLMy47NZ7hA5Pp3KpBuMuTcjpuCLj71OA3/JLLJpS4ORMYeqzHMLPWQEN3nxG8/TJwOQoBkYhVWFTMJ0s289z0DBZu2EXD2tUZPrADNw5oS+uT6oS7PKkgFbFP4BbgrRK325vZfGA3cJ+7TwPigcwS62QGl4lIhNmxN48352zg1ZnryMo5QPtm9XhwSDeu6p1A3ZrajVjVlOtf1Mz+ABQCrwUXZQFJ7r4juA/gf2bWDThSs/Co+wPMbDiB1hFJSUnlKVFESmnJxhxe/GotYxduIr+wmDM7NuPBId05t0sL7eytwsocAmZ2I4EdxoMP7uB19zwgL3h9rpmtBjoR+OafUOLuCcCmoz22u48GRgOkpqZq57FIJTlQUMTHi7N4deY65q3fRd2a1bg2NZEbB7SlYwv1+2NBmULAzC4ksCP4bHfPLbG8OZDt7kVmlgykAGvcPdvM9phZf2AWcAPwVPnLF5GyWL8jl9dmrWNM2gZ25haQ3Kwef/x+V4b2TuCkOjqFYywpzRDRN4BBQDMzywTuJzAaqBYwMTgs7OBQ0IHAA2ZWCBQBt7l7dvChfsqhIaKfoJ3CIiFVUFTMZ8u28Prs9UxbtZ1qccb3urbkh/3bMqCDhnjGKov0ofqpqamelpYW7jJEotb6Hbm8OWc9Y9Iy2b43j9Yn1ebaPokM65NEq5Nqh7s8qQRmNtfdU0uzrnb1i1RBBwqK+GRJFmPmZDJjzQ7iDM7t0pIf9Evk7E4tqKYdvRKkEBCpQtZs28vz0zMYu3ATew4UktikDnef34mhqQka2y9HpBAQqSIytu/jqlFfkZtfxMU9WnN1agL92zfV8E45JoWASBWwY28eN/93NmbGp3cNpH2zeuEuSaKEjvUqEuUOFBTxk5fTyMo5wLM3pCoA5IRoS0AkihUVO3e9uYAFG3bxzA9Oo3fbxuEuSaKMtgREothfP17Op0s3c98lXbmoR+twlyNRSCEgEqVemJ7B89MzuPmMdvz4zPbhLkeilEJAJAqNXbiJB8Yt48Jurbjvkq7hLkeimEJAJMpMW7WNu8csoG/7JjwxrKcmfkm5KAREosjizBxue2UuHZrX59kbUqldo1q4S5IopxAQiRLrduzj5hdn06huTV66pa+O9ikVQiEgEgW27jnAj56fTVGx8/KP+9KyoQ78JhVD8wREIlxObgE3PD+bbXvyeP3WfnRoXj/cJUkVoi0BkQi2L6+Qm1+czZpt+xh9Q296JWkymFQshYBIhMorLOK2V+eyYMMu/nldT85KaR7ukqQKUjtIJAIVFhVz5xsLmLZqO48MPYULu2s2sFQObQmIRJjiYuee9xbz6dLN/On7Xbk6NTHcJUkVVqoQMLMXzGyrmS0psayJmU00s1XBy8bB5WZm/zSzdDNbZGanlbjPjcH1V5nZjRX/54hEN3fnT2OX8M7cTO46L4VbdDgIqWSl3RJ4EbjwsGX3AJPcPQWYFLwNcBGQEvwZDoyCQGgQOEl9P6AvcP/B4BCRQAA8OG45r85cz4izk7lzcEq4S5IYUKoQcPepQPZhi4cALwWvvwRcXmL5yx4wE2hkZq2BC4CJ7p7t7juBiXw3WERikrvzyPgVvPBlBjcNaMc9F3bBTIeDkMpXnn0CLd09CyB42SK4PB7YUGK9zOCyoy0XiXlPfZ7OM1NW84N+Sdx/aVcFgIRMZewYPtK714+x/LsPYDbczNLMLG3btm0VWpxIpPn3F6t5fOJKhvZO4KEh3RUAElLlCYEtwTYPwcutweWZQMnhDAnApmMs/w53H+3uqe6e2ry5xkZL1fXvL1bz8Cdfc9mpbfj7VafopPAScuUJgbHAwRE+NwIflFh+Q3CUUH8gJ9guGg98z8waB3cIfy+4TCQmjZpyKAAev+ZUHRJawqJUk8XM7A1gENDMzDIJjPJ5GBhjZj8G1gNXB1f/GLgYSAdygZsB3D3bzB4E5gTXe8DdD9/ZLBITnpmSzv99uuKbAKheTVN2JDzM/Yht+YiRmprqaWlp4S5DpMIcDIAhPdvw2NUKAKl4ZjbX3VNLs64OGyESQv+anM4j4xUAEjkUAiIh4O48NmElT09O5/KebXhUASARQiEgUsncnb98tJznpmcwrE8if7mih3YCS8RQCIhUouJi5/6xS3ll5jpuPL0t91/aTcNAJaIoBEQqSVGxc8+7i3h7biYjBiZzz0U6FIREHoWASCXILyzml28t4KPFWfxicAq/PC9FASARSSEgUsFy8wu57dV5TF25jd9f3IXhAzuEuySRo1IIiFSgnNwCbnlpDvPX7+TvV/Xg2j5J4S5J5JgUAiIVZOueA9zw/GxWb9vL0z84jYt76JSQEvkUAiIVYP2OXG54YRZbdufxwk19dFJ4iRoKAZFyWrIxh5v+O4fC4mJe/Uk/erfVCfMkeigERMph+qrtjHgljZPq1ODN4afTsUWDcJckckIUAiJl9MGCjfz67YUkN6vPS7f0pdVJtcNdksgJUwiIlMFz09bw0EfL6du+Cc/ekMpJdWqEuySRMlEIiJyAomLnwXHLePGrtVzYrRVPDOtJ7RrVwl2WSJkpBERKKTe/kF+8sYDPlm/hx2e25/cXn6wDwUnUUwiIlMK2PXn85KU5LNqYw8hLu3LTGe3DXZJIhSjzAc3NrLOZLSjxs9vM7jKzkWa2scTyi0vc514zSzezFWZ2QcX8CSKVK33rHq545ktWbNnDf37YWwEgVUqZtwTcfQXQE8DMqgEbgfcJnFP4H+7+aMn1zawrMAzoBrQBPjOzTu5eVNYaRCrb1JXbuP31edSqHsdbw0/n1MRG4S5JpEJV1KmNBgOr3X3dMdYZArzp7nnunkHgRPR9K+j5RSrcyzPWcvOLc4hvVIf/3X6GAkCqpIoKgWHAGyVu32Fmi8zsBTM7OH0yHthQYp3M4DKRiFJYVMz9HyzhTx8sZVCn5rzz0wEkNK4b7rJEKkW5Q8DMagKXAW8HF40COhBoFWUBjx1c9Qh396M85nAzSzOztG3btpW3RJFSy9lfwC0vpfHSjHXcelZ7Rt+QSv1aGj8hVVdFvLsvAua5+xaAg5cAZvYsMC54MxNILHG/BGDTkR7Q3UcDowFSU1OPGBQiFS19616Gv5zG+uxcHr6yB8P66jDQUvVVRDvoOkq0gsys5PFzrwCWBK+PBYaZWS0zaw+kALMr4PlFym3S8i1c8a8vydlfwOu39lcASMwo15aAmdUFzgdGlFj8f2bWk0CrZ+3B37n7UjMbAywDCoHbNTJIws3deWbKah6dsIJubRrynx+lEt+oTrjLEgmZcoWAu+cCTQ9b9qNjrP8X4C/leU6RirIvr5DfvruIjxZlcdmpbfj7VadQp6YOASGxRXu8JCZlbN/HiFfSSN+6l99d2IXbzk7WieAlJikEJOZMXLaFX721gOrVjJdv6ceZKc3CXZJI2CgEJGYUFTv/mLiSpyen0yP+JEb98DSN/5eYpxCQmLBjbx53vbWAaau2c21qIn8e0k2HgBZBISAxYM7abH7++nyyc/P525U9uE7DP0W+oRCQKsvdeXbaGv7+6QoSG9fh/Z8NoFubk8JdlkhEUQhIlZSTW8Ddby/gs+Vbuah7K/4+9BQa1tYpIEUOpxCQKidtbTZ3vrmArXsOMPLSrtw4oJ2Gf4ochUJAqoyiYueZyek8MWkV8Y3q8M5tA3T4Z5HjUAhIlbBl9wHuenMBM9bsYEjPNjx0eXcaqP0jclwKAYl6ny3bwm/fXcT+/CIeGXoKQ3snqP0jUkoKAYlaufmFPPTRcl6ftZ6TWzfkqet60bFF/XCXJRJVFAISlRZn5nDnW/PJ2L6P4QOTuft7nahVXZO/RE6UQkCiSlGx85+pq3l8wkqa1a/Faz/ux4COOvaPSFkpBCRqrN2+j7vfXsjcdTu5pEdr/nJFdxrVrRnuskSimkJAIp678+rMdfz146+pUc144tqeDOnZRjt/RSqAQkAiWlbOfn77ziKmrdrOwE7N+ftVPWh9ks78JVJRFAISkdydMWkbeGjccgqLnYcu7871/ZL07V+kgpU7BMxsLbAHKAIK3T3VzJoAbwHtCJxn+Bp332mB/8FPAhcDucBN7j6vvDVI1ZK5M5d731vMtFXb6de+Cf839BTaNq0X7rIiW242ZHwBa76AOo3g9J9DvabHv5/EvIraEjjH3beXuH0PMMndHzaze4K3fwdcBKQEf/oBo4KXIhQXO6/NXs/DHy/HgQeHdOP6fm2Ji9O3/+8o2A/rZ8KaKbBmMmQtAhxqNoCCfTD7ORjwczj9dqiluRNydJXVDhoCDApefwmYQiAEhgAvu7sDM82skZm1dvesSqpDokTG9n3c+94iZq7J5syOzfjblT1IbKKzfn2juAg2Lwp86K+eHAiAojyIqwEJfeCc30PyOdCmF2SvhkkPwJS/wpxnYeBvoPfNUF0jqeS7KiIEHJhgZg78x91HAy0PfrC7e5aZtQiuGw9sKHHfzOCyb4WAmQ0HhgMkJekEIFVZQVExo6eu4clJq6hVPY6Hr+zBtX0S1fsHyM4IftOfEmj17N8ZWN6iG/T5CSQPgrYDvvtNv3lnGPYaZKbBZyPhk9/CjH/BufdB96EQFxfSP0MiW0WEwBnuvin4QT/RzL4+xrpH+p/t31kQCJLRAKmpqd/5vVQNCzbs4p53F/H15j1c3KMVIy/tRouGtcNdVvh809efEvjZuTawvEEb6Hxx4EO//dnQoGXpHi8hFW78ENInwaSR8N6t8OWTMPh+SDkfFLRCBYSAu28KXm41s/eBvsCWg20eM2sNbA2ungkklrh7ArCpvDVIdNl9oIDHJ6zk5RlradGgNqN/1JvvdWsV7rJC71t9/SmQtRBwqNUQ2p0F/W+H5LOhWaeyf2CbQcp50OFcWPoefP4gvH41tD0DzhsJiX0r7M+R6FSuEDCzekCcu+8JXv8e8AAwFrgReDh4+UHwLmOBO8zsTQI7hHO0PyB2uDsfLc7igQ+XsW1vHj/q35bfXNA5dg75XFwMmxceua+f2BcG3QsdzoE2p0G1Ct5dFxcHPYbCyZfBvJfgi/+D58+HzpfA4D9Ci5Mr9vkkalhgH20Z72yWDLwfvFkdeN3d/2JmTYExQBKwHrja3bODQ0SfBi4kMET0ZndPO9ZzpKamelraMVeRKLBuxz7++MFSpq7cRvf4hvz1ih6ckhADJ3w5al+/a2BHbvKgI/f1K1v+Ppj5DHz5T8jfC6deB4PugUbaB1cVmNlcd08t1brlCYFQUAhEt/35RYz6YjX//mI1NavF8evvdeJHp7ejWlUd9lmyr796MuxaF1jeoE3gW37yoBPr61e23GyY9hjMfhZw6HMrnHW35hhEOYWAhJ27M2HZFh74cBkbd+3nslPb8IdLTqZlVdvxW3AA1s84el8/+ezAN/5mKZG9I3bXBpjyMCx8HWrUgzN+Af1/pjkGUUohIGG1ZtteRn64jKkrt9G5ZQP+PKQb/ZOryDfLkn39NVMCff3CA4f6+smDDo3Xr+i+fihs/Tqw8/jrcVCvOQz8LfS+SXMMooxCQMIiZ38BT01axUsz1lK7ejV+eX4nfnR6W2pUi/Jx6ccar3/wm344+vqVacOcwByDddOhUVvNMYgyCgEJqaJi5605G3hswgqyc/O5pnciv76gM80b1Ap3aWVzrPH6kdjXryzugTkGn42ELYuhZXfNMYgSJxICUbi9KpHkq9XbeXDccpZn7aZPu8a8dGlfusefFO6yTszRjsPzrfH6gyK/r1/RNMcgJmhLQMokfeseHv7kaz5bvpX4RnW49+IuXNKjdXQc7uFYx+H5pq8/qHLG60ezwvxDcwz2bQ3OMfgTtOgS7srkMGoHSaXZvjePJz5byRuzN1CnRjV+dk4HbjmjPbVrRPhJ3r/p60+GjKmH9fUHBXr7bc+oWn39ynLEOQb3QqPE499XQkIhIBUuN7+QF6Zn8O8v1rC/oIjr+yVx5+AUmtaP0L7/wb7+6smBD/+S4/WTBwV6+7HQ169MmmMQsRQCUmEKiop5a84Gnpy0im178ji/a0vuuagLHZpH2Dfm4/X1kwcFPvibdoytvn4oaI5BxFEISLkVFzufLNnMoxNWkLF9H33bNeF3F3Wmd9sm4S4toFR9/Sgerx+NNMcgYigEpMzcnSkrtvHohBUs3bSbzi0b8LuLOnNO5xbh3+l7zPH6g8J3HB75Ns0xCDuFgJTJjNU7eHTCCuau20lSk7rcdV4KQ3rGh+84P8car588SH39SHZwjsGkkbBZcwxCTSEgJyRtbTb/+GwlX6bvoFXD2vx8cEeuSU0M/Uzf4x6HZ1BsjtePZsXFh+YY7FwbGIE1+H5I0qnFK5NCQEpl7rps/jFxFdPTt9Osfk1uO7sDP+zfNnTDPYuLg339yYcdh6c6JPQ9NDtX4/Wj3xHnGOg8BpVFISDHlLY2mycnrWLaqsCH/4iBHbi+fxJ1a4bgg3bn2kPDNjOmwv7swPJwH19fQiNvL8wapTkGlUwhIN/h7ny1egdPfb6KmWuyaVov8M2/0j/8j9fXP/ijvn5s2bcDpj+uOQaVRCEg33B3Jq/YylOfpzN//S5aNqzF8IEd+EHfJOrUrIS2z9HOm1uzAbQ/69C3ffX1BTTHoJKEJATMLBF4GWgFFAOj3f1JMxsJ3ApsC676e3f/OHife4EfA0XAL9x9/PGeRyFQNoVFxXy0OIt/f7GG5Vm7SWhch9vO7sDQ3gkV2/M//Pj662YcGq+f0Ed9fSmdb80xaAFn/xZOu1FzDMooVCHQGmjt7vPMrAEwF7gcuAbY6+6PHrZ+V+ANoC/QBvgM6OTuRcd6HoXAiTlQUMTbczMZPXU1G7L307FFfUYMTObyXvEVN9pn59pDk7TU15eKpDkGFSIkh5J29ywgK3h9j5ktB+KPcZchwJvungdkmFk6gUCYUdYa5JDsffm8OnMdL89Yy/a9+fRKasSfvt+NwV1aEFfecf652YEP+4OjeEr29TtdGByvPxAatCrnXyExL7EP3DQO0j+DSX+G926FL5/UHINKVCHb52bWDugFzALOAO4wsxuANOBud99JICBmlrhbJscODSmFjO37eH76Gt6Zm8mBgmLO6dyc287uQN/2Tco+w7fgAGyYeWgUz+F9/Vg9vr6EhlngA7/DYJ3HIATKHQJmVh94F7jL3Xeb2SjgQcCDl48BtwBH+rQ4Yi/KzIa4edzpAAALZElEQVQDwwGSkpLKW2KV4+7MysjmhekZTFy+hRpxcVzRK56fnNWelJYNTvwBSx6H50jj9QfdG/i2r76+hFJcHPQYCidfdmiOwfPna45BBSvX6CAzqwGMA8a7++NH+H07YJy7dw/uFMbd/xb83XhgpLsfsx2kfQKH5BUW8eHCLF6YnsGyrN00qluD6/slceOAdrRoUPvEHuyox+FRX18ilOYYlFqodgwb8BKQ7e53lVjeOri/ADP7JdDP3YeZWTfgdQ7tGJ4EpGjH8PFt2X2A12et57VZ69i+N5+UFvW55cz2XN4zvvTDPHXeXKkqNMfguEIVAmcC04DFBIaIAvweuA7oSaDVsxYYUSIU/kCgNVRIoH30yfGeJ1ZDwN2Zu24nL361lk+XbKbInUGdmnPLme05s2Oz4/f7j3t8/bMD3/jV15doVXKOQc36MOAX0P+n2npFk8Wi2r68QsYu3MQrM9axLGs3DWtX55rURH7Yvy3tmtU7+h01Xl9ilc5j8B0KgSj09ebdvDZzPe/P38jevEK6tGrAjQPaMaRnm6Mf1uFbx+HR8fUlxpWcY9C4HZxzH3S/KibnGCgEosT+/CI+WpzFm7PXk7ZuJzWrx/H9Hq25vn8SpyU1/m7LR319kWNzD8wx+OzPsGUxtOwB590PHc+LqbanQiDCLd2Uw5uzN/C/BRvZc6CQ9s3q8YO+SVzVO4Em9UpswpbqODxnQ7NOMfUGFzmu4mJY8i5MfujQeQzOGxkzcwwUAhEoJ7eAsQs38vbcTBZl5lCzehwXd2/FsL5J9Ds4sevwvv434/WD581tf7bG64uciCOex+BP0KJLuCurVAqBCFFc7Hy5ejtj0jIZv3Qz+YXFdGnVgGv7JHJFr3ga1a2p4/CIhELeXpg5Cr6KjTkGCoEwS9+6l/fmZfL+/I1k5RzgpDo1uLxnG65OTaRbo0Js7VSdN1ckHL6ZYzA6cLuKzjFQCIRB9r58xi3axLtzM1mYmUO1OGNgSjOGntqc8+uvoea6qUcZrz9IfX2RUKvicwwUAiGSm1/IxGVb+GDBJqau3EZhsdO1VX1uTdnL+bWXUX/j9O/29ZMHaby+SKSoonMMFAKVKL+wmC/TtzN24SbGL91Mbn4RpzXM4Sfx6zjTltAw66vD+vqDAr199fVFIlcVO4+BQqCCFRU7M9fs4MOFm/hkyWZsfzaDa3/NNU1Wc2r+AmrvXR9YUX19kejlDumTYNJI2LwYWnaP2vMYhOSkMlVdUbEzK2MHHy3KYvKS9bTfv5hzaixjXJ2vSfCVGA77Dvb1f67j64tEOzNIOQ86nBtT5zHQlkAJBUXFzM7I5pNFG8lYOpMeB+YxsPpSUuNWUNPz8bgamPr6IrEhiucYqB10Ag4UFDF91XZmz59HUfrn9CpcyBlxy2hsewAobn4ycR3ODYzgaXuG+voisSYK5xgoBI4jJ7eA6YtXsGn+eE7K+pJ+vpi2cVsBOFCnJdU7nkv1lHPV1xeRQ751HgOg761w5q8ico6BQuAINmzNZtnM8eSt/Jz2u+fQzdYSZ86BuHrsbXM6jbqdT/WO56qvLyLHFgVzDBQCQFFRESsXTGfLgvE0zJpO14Jl1LYCCqnGpganUD3lHFqdeiFxCb3V1xeRExfBcwxiPgT279vL/kdOpgm7AVhfvR05rc+g+akX0KrH4IhKbBGJchF4HoOYHyJap159FiReS62WKXTsdwlJzRPCXZKIVFWJfeCmcYE5Bp+NhPd+Al8+GTXnMQj5loCZXQg8CVQDnnP3h4+1fiRMFhMRKZXi4kNzDHauhbZnBucY9AlpGSeyJRDS7RUzqwb8C7gI6ApcZ2ZdQ1mDiEiliYuDHkPh9jlw8aOwfQU8fx68eX1gH0IECnXTqi+Q7u5r3D0feBMYEuIaREQqV/WagSGkv1gQ2EeQMRVGnQ7/+1lgdFEECXUIxAMlX4HM4LJvMbPhZpZmZmnbtm0LWXEiIhWqVn04+zeBMOj/M1j8Djx1Gnz6+8C8gwgQ6hA40h6S7+yUcPfR7p7q7qnNmzcPQVkiIpWoXlO44C/w87nQ4xqYNQr+2RO+eCQwIzmMQh0CmUDJudYJwKYQ1yAiEh6NEuHyf8FPZ0D7gTD5oUAYzBodOFZRGIQ6BOYAKWbW3sxqAsOAsSGuQUQkvFp0gWGvwY8/g2ad4ZPfwNOpsGhMYIRRCIU0BNy9ELgDGA8sB8a4+9JQ1iAiEjEOzjG4/t3AKWffuxX+cxasnBA4v0EIVMkZwyIiUec7cwzOgOvfgZp1T/ihYn7GsIhI1Dk4x+DkywLnMdi8qEwBcKIUAiIikeTgHIMQic6zKIuISIVQCIiIxDCFgIhIDFMIiIjEMIWAiEgMUwiIiMQwhYCISAxTCIiIxLCIP2yEmW0D1oW7jqNoBmwPdxFlFM21Q3TXH821Q3TXH821Q+nrb+vupToOf8SHQCQzs7TSHp8j0kRz7RDd9Udz7RDd9Udz7VA59asdJCISwxQCIiIxTCFQPqPDXUA5RHPtEN31R3PtEN31R3PtUAn1a5+AiEgM05aAiEgMUwiUgpnVNrPZZrbQzJaa2Z+Dy9ub2SwzW2VmbwXPmxyRzKyamc03s3HB29FU+1ozW2xmC8wsLbisiZlNDNY/0cwah7vOozGzRmb2jpl9bWbLzez0aKjfzDoHX/ODP7vN7K5oqP0gM/tl8P/sEjN7I/h/OSre+2Z2Z7DupWZ2V3BZhb/2CoHSyQPOdfdTgZ7AhWbWH/g78A93TwF2Aj8OY43HcyeB8zofFE21A5zj7j1LDI+7B5gUrH9S8HakehL41N27AKcS+HeI+PrdfUXwNe8J9AZygfeJgtoBzCwe+AWQ6u7dgWrAMKLgvW9m3YFbgb4E3jPfN7MUKuO1d3f9nMAPUBeYB/QjMGmjenD56cD4cNd3lJoTgm+Yc4FxgEVL7cH61gLNDlu2AmgdvN4aWBHuOo9Se0Mgg+D+t2irv0S93wO+jKbagXhgA9CEwFkUxwEXRMN7H7gaeK7E7T8Cv62M115bAqUUbKcsALYCE4HVwC53LwyukkngTReJniDwBioO3m5K9NQO4MAEM5trZsODy1q6exZA8LJF2Ko7tmRgG/DfYDvuOTOrR/TUf9Aw4I3g9aio3d03Ao8C64EsIAeYS3S895cAA82sqZnVBS4GEqmE114hUEruXuSBzeIEAptoJx9ptdBWdXxm9n1gq7vPLbn4CKtGXO0lnOHupwEXAbeb2cBwF3QCqgOnAaPcvRewjwhtnxxNsGd+GfB2uGs5EcF++RCgPdAGqEfgPXS4iHvvu/tyAm2ricCnwEKg8Jh3KiOFwAly913AFKA/0MjMqgd/lQBsClddx3AGcJmZrQXeJNASeoLoqB0Ad98UvNxKoCfdF9hiZq0Bgpdbw1fhMWUCme4+K3j7HQKhEC31Q+CDc567bwnejpbazwMy3H2buxcA7wEDiJL3vrs/7+6nuftAIBtYRSW89gqBUjCz5mbWKHi9DoE313JgMjA0uNqNwAfhqfDo3P1ed09w93YENuk/d/friYLaAcysnpk1OHidQG96CTCWQN0QwfW7+2Zgg5l1Di4aDCwjSuoPuo5DrSCIntrXA/3NrK6ZGYde+2h577cIXiYBVxL4N6jw116TxUrBzE4BXiIwuiAOGOPuD5hZMoFv102A+cAP3T0vfJUem5kNAn7t7t+PltqDdb4fvFkdeN3d/2JmTYExQBKB/+xXu3t2mMo8JjPrCTwH1ATWADcTfB8R4fUH+9EbgGR3zwkui6bX/s/AtQRaKfOBnxDYBxAN7/1pBPbfFQC/cvdJlfHaKwRERGKY2kEiIjFMISAiEsMUAiIiMUwhICISwxQCIiIxTCEgIhLDFAIiIjFMISAiEsP+HycM7CQh+zWcAAAAAElFTkSuQmCC\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x11817a390>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"投資部位 = 0.7\n",
"投資年利率 = 5 # 跟影片中不太一樣,影片中:1.05,改成 5% 來表示,比較好理解,也就是一年有5%的報酬率\n",
"\n",
"def compound_interest(arr, ratio, return_rate):\n",
" ret = [arr.iloc[0]]\n",
" for v in arr[1:]:\n",
" ret.append(ret[-1] * ratio * (return_rate/100+1) + ret[-1] * (1 - ratio) + v)\n",
" return pd.Series(ret, 預測時段)\n",
"\n",
"投資總資產 = compound_interest(每年淨額, 投資部位, 投資年利率)\n",
"投資總資產.plot()\n",
"無投資總資產.plot()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 考慮買房的話\n",
"* 假設買房總共要花「買房價格」\n",
"* 然後一開始,我們會付「買房頭期款」\n",
"* 在到達「買房年紀」以前,先租房;從「買房年紀」以後,就是負貸款\n",
"* 設定「貸款年數」,設定究竟想要貸款幾年\n",
"* 貸款就得付「房貸利率」(%)!"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"買房價格 = 300\n",
"買房頭期款 = 100\n",
"買房年紀 = 35\n",
"房貸利率 = 3\n",
"貸款年數 = 20"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 先計算每年的買房花費"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x11824a2b0>"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAFv9JREFUeJzt3X+wXPV53/H3s7v3CgtMBNKFYGQiDKpjj6dgoqHYynhS42mM6xqmY1o8aavx0PKPW9txOgnuTMdNpp3G04zttNN6SiGpOpPaJtQZXNfjlJHxOHZakivANaAwEpiADEaXYCC1i3bv7tM/9uzVStr7g7t7ztGu3q8Zzd4991ztw7L66Kvn+z3fE5mJJGl2NeouQJJULoNekmacQS9JM86gl6QZZ9BL0owz6CVpxhn0kjTjDHpJmnEGvSTNuFbdBQDs2LEjd+3aVXcZkjRVDh48+EJmLqx33hkR9Lt27WJxcbHuMiRpqkTEn2/kPFs3kjTjDHpJmnEGvSTNOINekmacQS9JM86gl6QZZ9BL0owz6Gv07cMv8NQLP667DEkzzqCv0a/8/sP8x289WXcZkmacQV+jVzs9Xu106y5D0owz6GvUXu7R7vbqLkPSjDPoa9Tp9mgvG/SSymXQ16TXS5Z7adBLKp1BX5NOrx/wBr2kshn0Nel0s3g06CWVy6CvSacYyTsZK6lsBn1NBgFv60ZS2Qz6mgwC3qCXVDaDviaD3rytG0llM+hrMpiMdUQvqWwGfU0c0UuqikFfEydjJVXFoK9Jx8lYSRVZN+gj4nci4lhEPDJ07MKIuC8iDhePFxTHIyL+bUQciYj/ExHXlFn8NBuM6Jd7Sa+XNVcjaZZtZET/n4H3nnLsduBAZu4GDhTPAW4Adhe/bgM+P5kyZ8/wFbH26SWVad2gz8xvAS+ecvhGYH/x9X7gpqHj/yX7/jewLSIumVSxs6S9fGIUb9BLKtNme/QXZ+ZzAMXjRcXxS4Fnhs47Whw7TUTcFhGLEbG4tLS0yTKm10kjevv0kko06cnYGHFsZAM6M+/IzD2ZuWdhYWHCZZz5hoPejc0klWmzQf/8oCVTPB4rjh8F3jh03k7g2c2XN7sc0UuqymaD/ivAvuLrfcC9Q8f/QbH65jrg5UGLRycbDneDXlKZWuudEBFfAH4B2BERR4FPAb8J3B0RtwJPAzcXp38NeB9wBPgJ8OESap4J7e6JjtZxg15SidYN+sz80Crfun7EuQl8ZNyizgYur5RUFa+MrUlnaBTfcUQvqUQGfU0c0UuqikFfk+EevZOxkspk0NfEVTeSqmLQ18TWjaSqGPQ18YIpSVUx6GvS7vaYbzZWvpakshj0Nel0k3O3NAFH9JLKZdDXpLPcY+t8/3o1NzWTVCaDvibtbo/Xn9MPekf0kspk0Nek0+3xunlbN5LKZ9DXpL3cn4ydbzU4butGUokM+pp0uj3mWw22NBuO6CWVyqCvSaebzDUbzLUaTsZKKpVBX5NOt8dcM5h3RC+pZAZ9TdrdHnNFj96gl1Qmg74mw5OxXhkrqUwGfU0Gk7FzzQbt5Vz/ByRpkwz6mgwmYx3RSyqbQV+TznK/R99fXtmtuxxJM8ygr0m722OuFU7GSiqdQV+TTrFN8VwzbN1IKpVBX4Plbo9estKj7zgZK6lEBn0NOsWNwedbDeZbTUf0kkpl0NdgEOxzzYZXxkoqnUFfg8HeNvPN/mTscYNeUonGCvqI+OWIeDQiHomIL0TEORFxeUQ8EBGHI+JLETE/qWJnReekEX24qZmkUm066CPiUuCjwJ7MfBvQBG4BPg18NjN3Az8Cbp1EobNkMPnqXjeSqjBu66YFvC4iWsBW4Dng3cA9xff3AzeN+Rozp93tXyA11/LKWEnl23TQZ+YPgN8CnqYf8C8DB4GXMnO5OO0ocOm4Rc6awd42880G880m3V7S7bnEUlI5xmndXADcCFwOvAE4F7hhxKkjEywibouIxYhYXFpa2mwZU2llMrYVzLXipGOSNGnjtG7eA3w/M5cyswN8GXgnsK1o5QDsBJ4d9cOZeUdm7snMPQsLC2OUMX06pyyvBFx5I6k04wT908B1EbE1IgK4HngMuB/4YHHOPuDe8UqcPcPr6Le0+v8LnJCVVJZxevQP0J90fRD4XvF73QH8GvCJiDgCbAfumkCdM2VwZexg1Q3ghKyk0rTWP2V1mfkp4FOnHH4SuHac33fWdZYHF0wNBb0jekkl8crYGrRXJmP7d5gCJ2Mllcegr8GJydhYmYx1RC+pLAZ9DQahPtyjd9WNpLIY9DU4eZtiR/SSymXQ12DUOnp79JLKYtDX4KQevSN6SSUz6GtwfESP3nX0kspi0NfgxI1HGq66kVQ6g74GnW6PViNoNGJlHb0jekllMehr0OnmSsC7142kshn0NWgv95hr9rcndjJWUtkM+hp0ur2VgHcyVlLZDPoa9Ef0RdA7GSupZAZ9DYZH9M1GEOEFU5LKY9DXYHgyNqK/sZkjekllMehr0O6eaN1Av0/vpmaSymLQ16DT7TFfrLqB/hJLJ2MllcWgr0HnlBH9XLOxctcpSZo0g74Gw6tuoN+6cUQvqSwGfQ3a3VxZdQM4GSupVAZ9DTqjRvQGvaSSGPQ16K+jPzEZa+tGUpkM+hqMmox1RC+pLAZ9DYYvmAKXV0oql0Ffg9MumHJEL6lEBn0N2su9lX3owclYSeUy6GvQ79GfmIydazbc1ExSacYK+ojYFhH3RMSfRcShiHhHRFwYEfdFxOHi8YJJFTsrTp2MdUQvqUzjjuh/G/h6Zv4scBVwCLgdOJCZu4EDxXMVMvO0yViXV0oq06aDPiLOB94F3AWQme3MfAm4EdhfnLYfuGncImdJp5sAp10Z6+6Vksoyzoj+TcAS8LsR8VBE3BkR5wIXZ+ZzAMXjRROoc2YMevHDPfr5lj16SeUZJ+hbwDXA5zPz7cCPeQ1tmoi4LSIWI2JxaWlpjDKmy6AXP+/ySkkVGSfojwJHM/OB4vk99IP/+Yi4BKB4PDbqhzPzjszck5l7FhYWxihjuqyM6E9ZXtlLWHZUL6kEmw76zPwh8ExEvLk4dD3wGPAVYF9xbB9w71gVzpj2Suvm5KAf/p4kTVJrzJ//J8DvRcQ88CTwYfp/edwdEbcCTwM3j/kaM2VlMvaU1g302zpb52spS9IMGyvoM/NhYM+Ib10/zu87yzojRvRzjugllcgrYys2mHQdXnWzZWhEL0mTZtBXrL3KZCwY9JLKYdBXbHAT8C1OxkqqiEFfscFk7PCIftCv7yxnLTVJmm0GfcVGTcaeGNF3a6lJ0mwz6CvWHrUFQhH67ncjqQwGfcUGI/r5USN6g15SCQz6ip1YXnnyPWOHvydJk2TQV2xlRD9qMrbrZKykyTPoK9YerLpxMlZSRQz6inVGbVNs60ZSiQz6ip3Ypvj0VTcGvaQyGPQVG7mOfhD09ugllcCgr9ggzFuNk28lCI7oJZXDoK9Ye7nHfKtBhEEvqRoGfcU63d5JE7EAzUbQbISrbiSVwqCvWKfbO2n7g4G5ZriOXlIpDPqK9YP+9Ld9vtmwdSOpFAZ9xdrLOTroW003NZNUCoO+Yp1u76TtDwa2tBzRSyqHQV+x9vLpk7HQX3njHaYklcGgr1in2zvpqtiBuWasbI8gSZNk0FesvdpkrCN6SSUx6CvmqhtJVTPoK9bp5uo9eoNeUgkM+oqtfsGUrRtJ5TDoKzbY6+ZULq+UVJaxgz4imhHxUER8tXh+eUQ8EBGHI+JLETE/fpmzw8lYSVWbxIj+Y8ChoeefBj6bmbuBHwG3TuA1ZsaoTc3AyVhJ5Rkr6CNiJ/A3gTuL5wG8G7inOGU/cNM4rzFrOqtsgTDXbKzclESSJmncEf3ngF8FBgm1HXgpM5eL50eBS8d8jZmy2gVTrrqRVJZNB31EvB84lpkHhw+POHXk3rsRcVtELEbE4tLS0mbLmDpr9ugNekklGGdEvxf4QEQ8BXyRfsvmc8C2iGgV5+wEnh31w5l5R2buycw9CwsLY5QxXVbt0bcaHLd1I6kEmw76zPxkZu7MzF3ALcA3MvOXgPuBDxan7QPuHbvKGbLq8spiMjbTm49Imqwy1tH/GvCJiDhCv2d/VwmvMZW6vaSXrDoZC7DcM+glTVZr/VPWl5nfBL5ZfP0kcO0kft9ZM1hVs1qPHvoj/lHfl6TNMlEq1F4J+tGrbgAnZCVNnEFfocF+86N69CtB74SspAkz6CvU6fb772v16B3RS5o0g75CgxAftbxyiyN6SSUx6Cu00qMf1bpxRC+pJAZ9hQarbuadjJVUIYO+QhtaXmnrRtKEGfQVWivoB8c6juglTZhBX6H28uqrbgYjeve7kTRpBn2FBm2ZkevonYyVVBKDvkKdjSyvNOglTZhBX6GVHv2IG4+s9Oht3UiaMIO+Qu0NbmomSZNk0FdosAXCajceAZdXSpo8g75CG92mWJImyaCvUHut3SubjugllcOgr1Bnrf3oXV4pqSQGfYXWmoxtNIJWIwx6SRNn0Feos8aVsdBv6Rj0kibNoK9Qp9uj2QiajdNbN1AEvT16SRNm0Feo0+2N7M8PzDUbXjAlaeIM+gq1u72Ra+gH5psNjtu6kTRhBn2F2su9kUsrB7bYo5dUAoO+Qv3WzRojeoNeUgkM+gp1urlm0Nujl1QGg75C7XUmY111I6kMBn2FOsvrtG6atm4kTd6mgz4i3hgR90fEoYh4NCI+Vhy/MCLui4jDxeMFkyt3unW6a0/G2qOXVIZxRvTLwK9k5luA64CPRMRbgduBA5m5GzhQPBcbWF7ZcnmlpMnbdNBn5nOZ+WDx9V8Ch4BLgRuB/cVp+4Gbxi1yVnSW156MnXcyVlIJJtKjj4hdwNuBB4CLM/M56P9lAFw0ideYBe1uj7n1WjcGvaQJGzvoI+I84L8BH8/MV17Dz90WEYsRsbi0tDRuGVOh0+0xv9aqGydjJZVgrKCPiDn6If97mfnl4vDzEXFJ8f1LgGOjfjYz78jMPZm5Z2FhYZwypoYXTEmqwzirbgK4CziUmZ8Z+tZXgH3F1/uAezdf3mzZ2AVTWWFFks4GrTF+di/w94HvRcTDxbF/BvwmcHdE3Ao8Ddw8XomzY729bhzRSyrDpoM+M78NrNZwvn6zv+8sa2+kddPtkZn0/8EkSePzytgKrTcZu6XlDcIlTZ5BX6H1tkAY7INjn17SJBn0Fep0c+119MVfAvbpJU2SQV+RzNxAj74JGPSSJsugr8hyr9+O2bLOqhsw6CVNlkFfkUF4r7cfPUC7262kJklnB4O+IoPNytbe1Kz/l0B72clYSZNj0FekvZGgd3mlpBIY9BUZLJlccz/6ppOxkibPoK9IZ9Cjb22gR2/QS5ogg74igx79YNQ+yokLpgx6SZNj0Ffk+GtYdePtBCVN0ji7V+o1WFl1s8Y6+sEa+3/5Px7j333jcCV1nS3e/NOv5zN/5+q6y5BqYdBXZCOTsZddeC43/9xOfvSTdlVlnRWef+U4X37wB3z8+r/CZdu31l2OVDmDviIbWkffavBvbr6qqpLOGkeO/SXv+cy3+M4TL3DZ9svqLkeqnD36ipxYR+8+81W7YuE8Lj5/C98+8kLdpUi1MOgrsrK8co0RvcoREey9Ygf/64m/oNfzqmOdfUydigxG9Gttaqby7L1yBy/+uM2hH75SdylS5UydimykR6/y7L1yBwDfsX2js5CpU5FOsVHZWssrVZ6f/qlzuPKi8/jOkb+ouxSpcqZORZyMrd/eK7bzJ99/kePLbgOts4tBX5ETWyD4ltdl75U7+H+dLg89/VLdpUiVMnUqYo++ftddsZ1GwB/bp9dZxtSpyGBHynl79LU5/5w5rnrjNtfT66xj6lSkXWyB0GrYo6/Tz1+5g+8efZlXXu3UXYpUGYO+Ip1uj/lmgwiDvk7vvGIH3V7ywJMv1l2KVBmDviKd5Z4rbs4A1/zMNs6Za7ieXmeVUoI+It4bEY9HxJGIuL2M15g2nW7PNfRngC2tJtdevt2g11ll4skTEU3g3wM3AG8FPhQRb53060ybdjddcXOG+Pkrt3P42P/l+VderbsUqRJlJM+1wJHMfDIz28AXgRtLeJ2pMujRq37vvKK/HcIfP+GoXmeHMvajvxR4Zuj5UeCvlfA63P2nz/Cf/ujJMn7rifvhy6+y/bz5ussQ8NZLzueCrXP8xn9/jP9w/xN1l6Oz3Eev383fuuoNpb5GGUE/asbxtL1hI+I24DaAyy7b3M0gtm2dY/fF523qZ6u2++LzVjbWUr0ajeCT73sL33z8WN2lSPzU6+ZKf43InOz+3BHxDuBfZOYvFs8/CZCZ/3q1n9mzZ08uLi5OtA5JmnURcTAz96x3XhlN4z8FdkfE5RExD9wCfKWE15EkbcDEWzeZuRwR/xj4Q6AJ/E5mPjrp15EkbUwpNwfPzK8BXyvj95YkvTau95OkGWfQS9KMM+glacYZ9JI04wx6SZpxE79galNFRCwBf153HavYAUzzpijTXP801w7TXf801w7TXf9rqf1nMnNhvZPOiKA/k0XE4kauPDtTTXP901w7THf901w7THf9ZdRu60aSZpxBL0kzzqBf3x11FzCmaa5/mmuH6a5/mmuH6a5/4rXbo5ekGeeIXpJmnEE/JCLOiYg/iYjvRsSjEfHrxfHLI+KBiDgcEV8qtl8+I0VEMyIeioivFs+nqfanIuJ7EfFwRCwWxy6MiPuK+u+LiAvqrnOUiNgWEfdExJ9FxKGIeMcU1f7m4j0f/HolIj4+RfX/cvHn9ZGI+ELx53iaPvcfK2p/NCI+Xhyb6Htv0J/sOPDuzLwKuBp4b0RcB3wa+Gxm7gZ+BNxaY43r+RhwaOj5NNUO8Ncz8+qh5WW3AweK+g8Uz89Evw18PTN/FriK/v+Dqag9Mx8v3vOrgZ8DfgL8AVNQf0RcCnwU2JOZb6O/NfotTMnnPiLeBvwj+vfavgp4f0TsZtLvfWb6a8QvYCvwIP373b4AtIrj7wD+sO76Vql5Z/GheDfwVfq3dZyK2ov6ngJ2nHLsceCS4utLgMfrrnNE3ecD36eY85qm2kf8t/wN4DvTUj8n7lF9If1t178K/OK0fO6Bm4E7h57/c+BXJ/3eO6I/RdH6eBg4BtwHPAG8lJnLxSlH6X+4zkSfo/8h6RXPtzM9tUP/3sL/MyIOFvcUBrg4M58DKB4vqq261b0JWAJ+t2ib3RkR5zIdtZ/qFuALxddnfP2Z+QPgt4CngeeAl4GDTM/n/hHgXRGxPSK2Au8D3siE33uD/hSZ2c3+P2F30v/n1FtGnVZtVeuLiPcDxzLz4PDhEaeecbUP2ZuZ1wA3AB+JiHfVXdAGtYBrgM9n5tuBH3MGtjnWU/SxPwD8ft21bFTRu74RuBx4A3Au/c/Pqc7Iz31mHqLfZroP+DrwXWB5zR/aBIN+FZn5EvBN4DpgW0QM7sa1E3i2rrrWsBf4QEQ8BXyRfvvmc0xH7QBk5rPF4zH6PeJrgecj4hKA4vFYfRWu6ihwNDMfKJ7fQz/4p6H2YTcAD2bm88Xzaaj/PcD3M3MpMzvAl4F3Ml2f+7sy85rMfBfwInCYCb/3Bv2QiFiIiG3F16+j/yE6BNwPfLA4bR9wbz0Vri4zP5mZOzNzF/1/fn8jM3+JKagdICLOjYjXD76m3yt+hP6N5fcVp52R9WfmD4FnIuLNxaHrgceYgtpP8SFOtG1gOup/GrguIrZGRHDivZ+Kzz1ARFxUPF4G/G36/w8m+t57wdSQiPirwH76M/cN4O7M/I2IeBP9UfKFwEPA38vM4/VVuraI+AXgn2bm+6el9qLOPyietoD/mpn/KiK2A3cDl9H/Q31zZr5YU5mrioirgTuBeeBJ4MMUnyHO8NoBiv7wM8CbMvPl4ti0vPe/Dvxd+i2Ph4B/SL8nf8Z/7gEi4o/oz6d1gE9k5oFJv/cGvSTNOFs3kjTjDHpJmnEGvSTNOINekmacQS9JM86gl6QZZ9BL0owz6CVpxv1/OfN0wcdmki8AAAAASUVORK5CYII=\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1180faa58>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"買房花費 = pd.Series(0, index=預測時段)\n",
"買房花費[買房年紀] = 買房頭期款\n",
"買房花費.loc[買房年紀:買房年紀+貸款年數-1] += (買房價格 - 買房頭期款) / 貸款年數\n",
"買房花費.plot()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 接下來計算貸款的利息"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x11824ac88>"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAD8CAYAAABXe05zAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAHWhJREFUeJzt3XtwVOeZJvDn7YsuCGRZQjIS6NZAPMYkgJG5GCRij5PYjh3vpEIGJw6JbZBSla1NdndqavLHVm22amprq7Z2MzU1u2WZgJfYGyb2TpgdMoXHZRyDbAIW5hIY8HDRBSFAksFCIKQ+3f3OH90NsixQC87pc77Tz6+KQpLb3U814uHTdzlHVBVERGSOgNsBiIhoaljcRESGYXETERmGxU1EZBgWNxGRYVjcRESGYXETERmGxU1EZBgWNxGRYUJOPOnMmTO1rq7OiacmIvKlAwcODKhqeSaPdaS46+rq0N7e7sRTExH5koh0ZfpYTpUQERmGxU1EZBgWNxGRYVjcRESGYXETERmGxU1EZBgWNxGRYVjcDvqXi0PY/S/9bscgIp9hcTvof717Chu3tmPg6qjbUYjIR1jcDhqxEhiNJbB1b8YHooiIJsXidlA0ngAA/HJvJ65H4+6GISLfYHE7yIonMD0/hMvDFt44cNbtOETkEyxuB0VjCSyoKsaSmhJs2tOBeELdjkREPsDidpAVTyA/FEBLUwTdl4ax8+gFtyMRkQ+wuB1kxRXhYABfWTALdWXT0Lr7NFQ56iaiu8PidpAVTyAcFAQDgg2NERzuGcS+jktuxyIiw7G4HRSNJRAOJt/iby2dg7KiPLTuPuNyKiIyHYvbQdF4Anmp4i4IB7F+ZR12nejDyYtDLicjIpOxuB2UnCq5+RavX1mLgnCAo24iuissbgdZcUVe6OZbfG9RHr7dUI3th87h4pURF5MRkclY3A6yYp8dcQPAhtURxBOKLe93uhOKiIzH4nZQNJ5AOCSf+VpN2TQ8ubASr+/rwtCI5VIyIjIZi9tB1pjFybGamyIYGolh234egyeiqWNxOyQWTyCh+NxUCQAsqi7B8vpSbH6/A1bqQlRERJlicTvEiidPSE5U3ADQsiaC84Mj+IfDvdmMRUQ+wOJ2SPqSrmN3lYz15S9UYH7FdLTuPsNj8EQ0JSxuh6SnQPKCMuF/DwQEG5siOHFhCLtPDmQzGhEZjsXtkHRx32qqBACeXVyFihn5aN19OluxiMgHWNwOsWK3n+MGgPxQEC+sqsf7pz7B0XOD2YpGRIbLqLhFpFNE/iAih0Sk3elQfhCNJ29VFr7FHHfad5bXYHp+iMfgiShjUxlxP6qqi1W1wbE0PhJNjbhvNceddk9hGOsersZv/3AePZeHsxGNiAzHqRKHZDLHnfbi6noIgF+0dTicioj8INPiVgD/JCIHRKTZyUB+YU2yHXCsqpJCPLOoCn/74VkMDvMYPBHdXqbFvUpVHwLwJIAfiUjT+AeISLOItItIe39/v60hTRSdwogbADY2RjAcjeO1fV1OxiIiH8ioVVS1N/V7H4DfAFg2wWNaVbVBVRvKy8vtTWmgyU5OjregqhiN82diy/udGLHiTkYjIsNN2ioiUiQiM9IfA/gqgKNOBzNdNJY+gJP5MsIP18zFwNVRbD94zqlYROQDmbTKfQDaROQwgP0AfquqO52NZb4bi5Oh2+8qGeuRuWV4sKoYrXvOIJHgMXgimtikxa2qZ1R1UerXg6r6l9kIZrqp7CpJExE0N0Vwpv8a3jnR51Q0IjIctwM65E6mSgDg61+sxOySQh6DJ6JbYnE7JL04mcl2wLFCwQBeWl2PDzsv46Puy05EIyLDsbgdcidTJWl/+nA17ikMo/U9HoMnos9jcTskPVUSnuTI+0SK8kN4fkUN3vrnC+gYuGZ3NCIyHIvbIVM9gDPe9x+pQzgQwKY9HHUT0WexuB1y80YKd/YWV8wowDcfmo03D/Rg4OqondGIyHAsbodY8QRCAUEgMPWpkrQNjRGMxhLYupfH4InoJha3Q6y43vE0Sdq8iul4/IH78Mu9nbge5TF4IkpicTskGkvc0cLkeC1rIrg8bOGNA2dtSEVEfsDidogVT0x5D/dEGmrvxZKaEmza04E4j8ETEVjcjkmOuO/+7RURtDRF0H1pGDuPXrAhGRGZjsXtECtuT3EDwFcWzEJd2TS07j4NVY66iXIdi9shycXJu5/jBoBgQPBSYwSHewaxr+OSLc9JROZicTskGk8gLxS07fnWLp2DsqI83g2eiFjcTrHiiUnv8D4VBeEg1q+sw64TfTh5cci25yUi87C4HWLnHHfa91bWoiAc4KibKMexuB1i166SsUqL8vDthmpsP3QOF6+M2PrcRGQOFrdDonFF2IZ93ONtWB1BPKHY8n6n7c9NRGZgcTvEitk7x51WUzYNTy6sxOv7unB1NGb78xOR97G4HWLXycmJNDdFMDQSw7b93Y48PxF5G4vbIU4sTqYtqi7B8vpSbG7ruHH5WCLKHSxuh9hxdcDbaVkTQe/gCHYc6XXsNYjIm1jcDhl1YFfJWF/+QgW+cN90vPzeGR6DJ8oxLG6H2H0AZ7xAQLChMYITF4aw5+SAY69DRN7D4naIk3Pcac8urkLFjHweyCHKMSxuh1jxhCP7uMfKDwXxwqp6tJ0awNFzg46+FhF5R8bNIiJBETkoIjucDOQHqgorrnd8o+Cp+M7yGhTlBfEK7wZPlDOm0iw/BnDcqSB+YsWTi4VO7eMe657CMJ5bVoMdR86j5/Kw469HRO7LqFlEZA6ArwPY5Gwcf0jvrbbretyTeXF1PQTA5rbOrLweEbkr0yHhzwH8OYBbnvYQkWYRaReR9v7+flvCmSoaSxd3dpYQqkoK8cyiKmz7sBuDw1ZWXpOI3DNps4jI0wD6VPXA7R6nqq2q2qCqDeXl5bYFNNHNEXf21n43NkYwHI3jtX1dWXtNInJHJs2yCsA3RKQTwDYAj4nIa46mMlw0VdzZWJxMW1BVjMb5M/HqB50YjcWz9rpElH2TNouq/lRV56hqHYB1AHap6vOOJzNYNhcnx2ppmov+oVFsP3guq69LRNnFfdwOcGOqBABWzSvDgspitO4+g0SCx+CJ/GpKzaKqv1PVp50K4xc3Fyezs6skTUTQsiaC0/3XsOtEX1Zfm4iyhyNuB6TnuJ0+OTmRp75YidklhTwGT+RjLG4HWLHsL06mhYMBvLi6Hvs7L+Fg9+Wsvz4ROY/F7YD04mS257jT1j1cjeKCEEfdRD7F4nZAenEy27tK0oryQ/jeylrsPHYBnQPXXMlARM5hcTsgmuUj7xP5/iN1CAcCvPgUkQ+xuB1guXAAZ7yKGQX45kOz8eaBHgxcHXUtBxHZj8XtgGxfq+RWNjRGMBpLYOteHoMn8hMWtwMsF7cDjjWvYjoef+A+/HJvJ65HeQyeyC9Y3A6I3thV4t4cd1rLmgguD1t448BZt6MQkU1Y3A5wcx/3eA2192JJTQk27elAnMfgiXzB/WbxIbe3A44lImhpiqD70jB2Hr3gdhwisoH7zeJDbl1k6la+smAW6sqmoXX3aahy1E1kOm80i8+kd5WEAu7PcQNAMCDY0BjB4Z5B7Ou45HYcIrpLLG4HRFN3eBfxRnEDwLeWzkFZUR6PwRP5AIvbAVY84YkdJWMVhINYv7IOu0704eTFIbfjENFdYHE7wIonXN/DPZHvraxFQZjH4IlM57128QErnvDEVsDxSovy8O2Gamw/2Iu+KyNuxyGiO+S9dvGBaEw9s6NkvA2rI4glEtjyQafbUYjoDnmzXQxnxROe2MM9kZqyaXhyYSVe+30Xro7G3I5DRHfAm+1iuGjMe4uTYzU3RTA0EsO2/d1uRyGiO8DidkByV4l339pF1SVYXl+KzW0dNw4LEZE5vNsuBot6vLiB5MWnegdHsONIr9tRiGiKvN0uhvLqrpKxvvyFCsyvmI6X3zvDY/BEhvF2uxjKiqtnFyfTAgHBxqYITlwYwp6TA27HIaIp8Ha7GMqLJycn8uziKlTMyOcxeCLDTFrcIlIgIvtF5LCIHBORn2UjmMmSu0q8/29ifiiIF1bVo+3UAI6eG3Q7DhFlKJN2GQXwmKouArAYwBMissLZWGaLevTI+0S+s7wGRXlBHoMnMsik7aJJV1OfhlO/uJp1GyYsTqbdUxjGc8tqsOPIefRcHnY7DhFlIKN2EZGgiBwC0AfgbVXd52wss1kxNWKOO+3F1fUQAJvbOt2OQkQZyKi4VTWuqosBzAGwTEQWjn+MiDSLSLuItPf399ud0yhePvI+kaqSQjyzqArbPuzG4LDldhwimsSU2kVVPwXwOwBPTPDfWlW1QVUbysvLbYpnJhMO4Iy3sTGC4Wgcr+3rcjsKEU0ik10l5SJSkvq4EMDjAE44Hcxk0Zg5c9xpC6qK0Th/Jl79oBOjsbjbcYjoNjJpl0oA74rIEQAfIjnHvcPZWGbz+rVKbqWlaS76h0ax/eA5t6MQ0W2EJnuAqh4BsCQLWXwhnlAk1Dt3eJ+KVfPKsKCyGK27z2Dt0moEPHKzYyL6LPPaxePSV9sLh8wrPRFBy5oITvdfw64TfW7HIaJbYHHbLJoqbtPmuNOe+mIlZpcU8hg8kYeZ2S4eZsVSxW3QdsCxwsEAXlxdj/2dl3Cw+7LbcYhoAma2i4elR9wmznGnrXu4GsUFIY66iTzK3HbxKCuWvBqAycVdlB/C8ytqsfPYBXQOXHM7DhGNY267eNTNEbd5i5Nj/WBVHcKBADa1cdRN5DUsbptZhi9OplXMKMCfLJmNN9p78MnVUbfjENEYZreLB1k+mONO29hUj9FYAlv38hg8kZeY3y4ec2PEbeiukrHmVczA4w9UYOveTlyP8hg8kVeY3y4eE/XB4uRYzU1zcXnYwpsHzrodhYhS/NEuHnLjAI6BJycn8nDdvVhcXYJNbR2IJ3j/DCIvYHHbLH0Axy8jbhFBS1MEXZ8M461jF9yOQ0RgcdvOT4uTaV99cBbqyqbh5fdOQ5WjbiK3+addPMIPJyfHCwYELzVGcLhnEPs6Lrkdhyjn+addPMKKJ0ek+T7YVTLW2qVzUFqUx2PwRB7gr3bxAD9OlQBAQTiI9StrsetEH05eHHI7DlFO81e7eEA05o8j7xNZv7IOBeEAR91ELmNx2+zmjRT899aWFuVh7dJqbD90DhevjLgdhyhn+a9dXGb6jRQms6GxHvGEYsv7nW5HIcpZ/mwXF/nhsq63U1tWhCcWzsLr+7pwdTTmdhyinOTPdnGRFU8gGBAEfXyj3eamuRgaiWHb/m63oxDlJBa3zax4wpcLk2Mtri7BsvpSbG7ruDGnT0TZw+K22Wgs4dtpkrFamiLoHRzBjiO9bkchyjn+b5gss+IJ3y5MjvXo/RWYVzEdL793hsfgibLM/w2TZcmpEv+/rYGAoLkxghMXhrDn5IDbcYhyiv8bJsusuCLsk0u6TubZJVWomJHPAzlEWTZpcYtItYi8KyLHReSYiPw4G8FMFc2RETcA5IeC+MGqOrSdGsDRc4NuxyHKGZk0TAzAf1TVBwCsAPAjEVngbCxzWbHcmONO++7yWhTlBfHKHo66ibJl0oZR1fOq+lHq4yEAxwHMdjqYqax4whf3m8zUPYVhrFtWgx1HzqPn8rDbcYhywpQaRkTqACwBsM+JMH6QS1MlaS+urgcAbG7rdDcIUY7IuGFEZDqA/wfgJ6p6ZYL/3iwi7SLS3t/fb2dGo1gx9f0BnPFmlxTimS9VYtuH3RgcttyOQ+R7GRW3iISRLO3XVfXvJnqMqraqaoOqNpSXl9uZ0Si5OOIGksfgh6NxvLavy+0oRL6Xya4SAfALAMdV9X84H8lsuXIAZ7wFVcVonD8Tr37QidFY3O04RL6WScOsAvA9AI+JyKHUr6cczmWsXFucHKu5KYL+oVFsP3jO7ShEvhaa7AGq2gYgtyZt74IV15ycKgGA1fNmYkFlMVp3n8HapdUI+PgKiURuys2GcVA0Ry4yNRERQXNTBKf7r2HXiT634xD5Vm42jIOi8QTycuTI+0S+/qVKzC4p5DF4IgexuG2WKxeZupVwMIAXVtVhf+clHOy+7HYcIl/K3YZxiJXDUyVp65bVYEZBiKNuIofkdsM4IJcXJ9Om54fw/Ipa7Dx2AZ0D19yOQ+Q7ud0wNlPV1Bw339YXHqlDOBDApjaOuonsxoaxkRVP3gkmL8eOvE+korgAf7JkNt5o78EnV0fdjkPkKyxuG6VvnJvrUyVpG5vqMRpLYOteHoMnshMbxkYs7s+aVzEDjz9Qga17O3E9ymPwRHZhw9gomi5uznHf0Nw0F5eHLbx54KzbUYh8gw1jI85xf97DdfdicXUJNrV1IJ7g3eCJ7MDitpEVS464uavkJhFBS1MEXZ8M461jF9yOQ+QLbBgbRTnHPaGvPjgLdWXT8PLuM1DlqJvobrFhbBSNsbgnEgwIXmqM4PDZT7G/45LbcYiMx4axUXpXSS7eSGEya5fOQWlRHo/BE9mADWOj9OIkR9yfVxAOYv3KWrxzog8nLw65HYfIaGwYG93cx81dJRNZv7IOBeEAXtnDUTfR3WBx2yi9OMldJRMrLcrD2qXV2H6wF31XRtyOQ2QsNoyNLC5OTmpDYz1iiQS2fNDpdhQiY7FhbMQR9+Rqy4rwxMJZeO33Xbg6GnM7DpGR2DA24rVKMtPcNBdDIzFs29/tdhQiI7FhbGTF0rtKuDh5O4urS7CsvhSb2zpu/GNHRJljcdsoyn3cGWtpiqB3cAS/PXLe7ShExmHD2IhTJZl79P4KzKuYzmPwRHeADWMji4uTGQsEBM2NERw/fwVtpwbcjkNkFDaMjXitkql5dkkVKmbk8xg80RRN2jAisllE+kTkaDYCmSwa5+LkVOSHgvjBqjrsOTmAY72DbschMkYmQ8NXATzhcA5fsOIJhIMCERZ3pr67vBZFeUG8wlE3UcYmLW5V3Q2A1+LMgBVLcJpkiu4pDGPdshr8w5HzOPfpdbfjEBnBtpYRkWYRaReR9v7+frue1ijJETeLe6peXF0PANjc1uFyEiIz2NYyqtqqqg2q2lBeXm7X0xolGlfuKLkDs0sK8cyXKrFtfzcGr1tuxyHyPLaMjaKxBA/f3KHmprm4Fo3j9X1dbkch8jy2jI3Si5M0dQuqitE4fya2vN+J0Vjc7ThEnpbJdsBfAdgL4H4R6RGRl5yPZSbOcd+dlqa56B8axd8f7HU7CpGnhSZ7gKo+l40gfsDivjur5pVhQWUxWvecwbeWzkEgwJ9eiCbClrFRNK4Ic3HyjokIWtZEcKrvKt79uM/tOESexZaxkRVLIJ8j7rvy1BcrMbukEC/zQA7RLbFlbGTFEwiH+OP93QgHA3hhVR32d1zCobOfuh2HyJNY3DaKco7bFuuW1WBGQQitu0+7HYXIk9gyNoryyLstpueH8PyKWuw8egFdn1xzOw6R57BlbGTFeQDHLi88UodQIIBNe3gMnmg8toyNrLjyAI5NKooL8G+WVOGNA2dx6VrU7ThEnsLithH3cduruSmCESuBrXs73Y5C5ClsGRtZ8QQvMmWjeRUz8Md/VIGte7twPcpj8ERpbBkbjXJx0nbNTRFcuhbFmx/1uB2FyDPYMjbiiNt+y+pLsai6BJv2nEE8wbvBEwEsbltxcdJ+IoKWpgi6PhnGW8cuuB2HyBNY3DaJJxTxhHKqxAFfe3AWasum4eXdZ6DKUTcRW8YmVjwBACxuBwQDgg2NERw++yn2d/D2p0RsGZukizufc9yOWLt0DkqL8tDKi08RsbjtEo1xxO2kgnAQ61fW4p0TfTh5ccjtOESuYsvYxIon515Z3M5Zv7IOBeEAXtnDUTflNraMTW7OcXNXiVNKi/Kwdmk1th/sRd+VEbfjELmGxW2TaKq4uY/bWRsa6xFLJLDlg063oxC5hi1jE+4qyY7asiI8sXAWXvt9F66OxtyOQ+QKtoxNrBjnuLOluWkuhkZi2La/2+0oRK5gy9gkGk9eBIlTJc5bXF2CZfWl2NzWceMnHaJcwpaxSfTGiJuLk9nQ0hRB7+AIfnvkvNtRiLKOxW2T9MiPd8DJjkfvr8C8iuk8Bk85iS1jEy5OZlcgIGhujOD4+StoOzXgdhyirMqoZUTkCRH5WEROichfOB3KRCzu7Ht2SRUqZuTzGDzlnElbRkSCAP4GwJMAFgB4TkQWOB3MNNHUycm8EOe4syU/FMQPVtVhz8kBHOsddDsOUdZkMjxcBuCUqp5R1SiAbQCedTaWeaxYeo476HKS3PLd5bUoygviFY66KYeEMnjMbABnx3zeA2C5E2Ge+es2jFhm3ltw8LoFAAhxV0lW3VMYxrplNXj1g04c673idhzKcfdOy8Ovf7jS8dfJpLgnaqLPLeOLSDOAZgCoqam5ozBzy4tuHB03UcWMAswqLnA7Rs754Zq5uHQtitGYmf/ok38UF4Sz8joy2VYqEVkJ4D+r6tdSn/8UAFT1v97q/2loaND29nY7cxIR+ZqIHFDVhkwem8kc94cA5otIvYjkAVgH4P/fTUAiIrpzk06VqGpMRP4tgLcABAFsVtVjjicjIqIJZTLHDVX9RwD/6HAWIiLKAE+LEBEZhsVNRGQYFjcRkWFY3EREhmFxExEZZtIDOHf0pCL9ALpsf2J7zARg6nVATc4OmJ3f5OyA2flNzg5knr9WVcszeUJHitvLRKQ909NJXmNydsDs/CZnB8zOb3J2wJn8nCohIjIMi5uIyDC5WNytbge4CyZnB8zOb3J2wOz8JmcHHMifc3PcRESmy8URNxGR0Xxb3CJSICL7ReSwiBwTkZ+lvl4vIvtE5KSI/G3qUrWeJCJBETkoIjtSn5uUvVNE/iAih0SkPfW1UhF5O5X/bRG51+2ctyIiJSLypoicEJHjIrLShPwicn/qPU//uiIiPzEhe5qI/PvU39mjIvKr1N9lI773ReTHqdzHROQnqa/Z/t77trgBjAJ4TFUXAVgM4AkRWQHgvwH4n6o6H8BlAC+5mHEyPwZwfMznJmUHgEdVdfGYrVB/AeCdVP53Up971V8B2KmqfwRgEZJ/Dp7Pr6ofp97zxQCWAhgG8BsYkB0ARGQ2gH8HoEFVFyJ5Kel1MOB7X0QWAtiI5H16FwF4WkTmw4n3XlV9/wvANAAfIXmvzAEAodTXVwJ4y+18t8g8J/WH/BiAHUjeQs6I7Kl8nQBmjvvaxwAqUx9XAvjY7Zy3yF4MoAOpNSDT8o/J+1UA75uUHTfvcVuK5GWndwD4mgnf+wDWAtg05vP/BODPnXjv/TziTk81HALQB+BtAKcBfKqqsdRDepD8RvGinyP5h56+CWcZzMkOJO9L+k8iciB1P1IAuE9VzwNA6vcK19LdXgRAP4AtqamqTSJSBHPyp60D8KvUx0ZkV9VzAP47gG4A5wEMAjgAM773jwJoEpEyEZkG4CkA1XDgvfd1catqXJM/Ms5B8seXByZ6WHZTTU5EngbQp6oHxn55god6LvsYq1T1IQBPAviRiDS5HWgKQgAeAvC/VXUJgGvw6NTCraTmgL8B4A23s0xFav73WQD1AKoAFCH5PTSe5773VfU4klM6bwPYCeAwgNht/6c75OviTlPVTwH8DsAKACUikr7zzxwAvW7luo1VAL4hIp0AtiE5XfJzmJEdAKCqvanf+5CcY10G4KKIVAJA6vc+9xLeVg+AHlXdl/r8TSSL3JT8QLLsPlLVi6nPTcn+OIAOVe1XVQvA3wF4BIZ876vqL1T1IVVtAnAJwEk48N77trhFpFxESlIfFyL5DXEcwLsAvpV62PcB/L07CW9NVX+qqnNUtQ7JH3d3qep3YUB2ABCRIhGZkf4YybnWo0jeZPr7qYd5Nr+qXgBwVkTuT33pjwH8MwzJn/Icbk6TAOZk7wawQkSmiYjg5ntvyvd+Rer3GgDfRPLPwPb33rcHcETkSwD+D5Kr0gEAv1bV/yIiESRHsaUADgJ4XlVH3Ut6eyLyZQB/pqpPm5I9lfM3qU9DAP6vqv6liJQB+DWAGiT/gq5V1UsuxbwtEVkMYBOAPABnALyA1PcRPJ4/Nb96FkBEVQdTXzPpvf8ZgD9FcprhIIANSM5pm/C9vwfJ9SgLwH9Q1XeceO99W9xERH7l26kSIiK/YnETERmGxU1EZBgWNxGRYVjcRESGYXETERmGxU1EZBgWNxGRYf4VgiZeektVujUAAAAASUVORK5CYII=\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1180cafd0>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"# 先計算有多少欠款\n",
"欠款 = pd.Series(0, index=預測時段)\n",
"欠款[買房年紀] = 買房價格\n",
"欠款 = 欠款.cumsum()\n",
"欠款 = 欠款 - 買房花費.cumsum()\n",
"#欠款.plot()\n",
"#\n",
"利息 = 欠款.shift().fillna(0) * 房貸利率 / 100\n",
"利息.plot()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# 計算繳房租"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x118330588>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD8CAYAAABn919SAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAEiFJREFUeJzt3X+MZeVdx/HP5557bmGRhl9DQ6HrgiFgg+WHI0JJsIVWl0rAEJpCxJAW3T/8UagahBjT1ESjsVGaaNAN0BKt0IqQNqShbLbFqqHUWX7YhYWCQGELZQcRqjSyO7Nf/zjnzm7HXXaYe57nzDnzfiWbuffsmTlf7t798Oz3eZ57HBECAHTfoO0CAADNINABoCcIdADoCQIdAHqCQAeAniDQAaAnCHQA6AkCHQB6gkAHgJ4Y5rzYUUcdFevWrct5SQDovC1btrwcEVMHOi9roK9bt04zMzM5LwkAnWf7u0s5j5YLAPQEgQ4APUGgA0BPEOgA0BMEOgD0xAED3fYttnfY3rrXsT+z/bjtf7d9l+3D0pYJADiQpYzQPydp/aJjmySdEhHvkfQdSdc3XBcA4C064Dr0iPiG7XWLjt2719NvSrq02bJ+1OZtL+mR519NeYlGvf/ko3X62sPbLgPAKtPExqKPSfrC/n7T9gZJGyRp7dq1y7rAP31nVn/7zSWtq29dhPTI9td068fObLsUAKuMl3KT6HqEfndEnLLo+O9LmpZ0SSzhB01PT0ffd4p+5G/uly3dvuHstksB0BO2t0TE9IHOW/YI3faVki6UdP5Swny1GA0Hev2NubbLALAKLSvQba+X9HuSfi4ifthsSd1WFgPtmuf/bwDyW8qyxdsk3S/pJNvbbV8l6S8lHSppk+2Hbf914jo7oyysXfO72y4DwCq0lFUul+/j8M0JaumFshhoJ4EOoAXsFG3YqBgwQgfQCgK9YaPhQLvm6KEDyI9AbxgtFwBtIdAbVhYD7Zoj0AHkR6A3rByaETqAVhDoDWNSFEBbCPSGlcVAu0Oa383EKIC8CPSGlUX1kjJKB5Abgd6w0bB6SemjA8iNQG/YqLAkaScrXQBkRqA3jJYLgLYQ6A1bCHR2iwLIjEBvWEkPHUBLCPSGjXvotFwA5EagN2y8yoVAB5Abgd6wcQ+dVS4AciPQG7YQ6IzQAWRGoDdsz7JFVrkAyItAb9hoYdkiI3QAeRHoDSuHrHIB0A4CvWEjeugAWkKgN4xVLgDaQqA3bM86dCZFAeRFoDeMD+cC0JYDBrrtW2zvsL11r2NH2N5k+8n66+Fpy+yOkq3/AFqylBH65yStX3TsOkmbI+JESZvr5xAbiwC054CBHhHfkPTKosMXS7q1fnyrpF9quK7OGvHxuQBastwe+jsi4kVJqr8evb8TbW+wPWN7ZnZ2dpmX647BwBoOrJ3z822XAmCVST4pGhEbI2I6IqanpqZSX25FKIsBq1wAZLfcQH/J9jGSVH/d0VxJ3VcWZh06gOyWG+hflnRl/fhKSV9qppx+GA0HrHIBkN1Sli3eJul+SSfZ3m77Kkl/IumDtp+U9MH6OWpVy4VAB5DX8EAnRMTl+/mt8xuupTfooQNoAztFExgNB6xDB5AdgZ5AWQyYFAWQHYGewKgwPXQA2RHoCTApCqANBHoCZTFg6z+A7Aj0BEomRQG0gEBPYETLBUALCPQERkO2/gPIj0BPgElRAG0g0BNgpyiANhDoCZQFk6IA8iPQE2BjEYA2EOgJjIYD7WJSFEBmBHoCtFwAtIFAT2A8KRrBxCiAfAj0BEbD6mVlpQuAnAj0BMrCksTEKICsCPQEymI8QifQAeRDoCcwDnQmRgHkRKAnQA8dQBsI9ARG4xE6a9EBZESgJ0APHUAbCPQExqtcGKEDyGmiQLf9CduP2t5q+zbbBzVVWJeVQ0boAPJbdqDbPlbSxyVNR8QpkgpJlzVVWJeNCiZFAeQ3actlKOlg20NJayS9MHlJ3TdihA6gBcsO9Ij4nqRPS3pO0ouSXouIe5sqrMtKVrkAaMEkLZfDJV0s6XhJ75R0iO0r9nHeBtsztmdmZ2eXX2mHLEyKMkIHkNEkLZcPSHomImYjYpekOyW9d/FJEbExIqYjYnpqamqCy3XHiGWLAFowSaA/J+ks22tsW9L5krY1U1a3sQ4dQBsm6aE/IOkOSQ9K+nb9szY2VFenLSxbnGOVC4B8hpN8c0R8UtInG6qlN0Z8OBeAFrBTNAE+ywVAGwj0BMohN7gAkB+BngCTogDaQKAnMByM16EzKQogHwI9AdsaFQNG6ACyItATKQtrF5OiADIi0BMZDQcsWwSQFYGeSEnLBUBmBHoiZTHQTnaKAsiIQE9kNGSEDiAvAj2RsjCBDiArAj0ReugAciPQE6lWudBDB5APgZ5INSk633YZAFYRAj2RaqcoI3QA+RDoiTApCiA3Aj2RquVCoAPIh0BPpGQdOoDMCPRE3kYPHUBmBHoitFwA5EagJ1IOmRQFkBeBnkhZ8PG5APIi0BPhjkUAciPQEymZFAWQ2USBbvsw23fYftz2NttnN1VY142GA83vDs3vJtQB5DGc8Ps/I+meiLjU9kjSmgZq6oWyqP5fuWt+t4pB0XI1AFaDZY/Qbb9d0rmSbpakiNgZEa82VVjXlYUliYlRANlM0nI5QdKspM/afsj2TbYPaaiuzhsN6xE6a9EBZDJJoA8lnSHpxog4XdLrkq5bfJLtDbZnbM/Mzs5OcLlu2dNyoYcOII9JAn27pO0R8UD9/A5VAf8jImJjRExHxPTU1NQEl+uWvXvoAJDDsgM9Ir4v6XnbJ9WHzpf0WCNV9QA9dAC5TbrK5bckfb5e4fK0pI9OXlI/vK3uofN5LgBymSjQI+JhSdMN1dIrtFwA5MZO0UQIdAC5EeiJjAN95xyrXADkQaAnMhpWk6KM0AHkQqAnQssFQG4EeiILO0UJdACZEOiJjEfob7BsEUAmBHoiI7b+A8iMQE+EHjqA3Aj0RMZb/wl0ALkQ6ImUbP0HkBmBngg9dAC5EeiJ7NkpyggdQB4EeiLFwCoGpocOIBsCPaGyINAB5EOgJ1QWA25wASAbAj2hUTFghA4gGwI9obIYaBcfnwsgEwI9odGQlguAfAj0hMrCBDqAbAj0hKqWC4EOIA8CPaHRkElRAPkQ6AmVxYCt/wCyIdAToocOICcCPaHRsKDlAiCbiQPddmH7Idt3N1FQn4wK8+FcALJpYoR+taRtDfyc3inZKQogo4kC3fZxkn5R0k3NlNMvTIoCyGnSEfoNkq6VxDB0H8piQMsFQDbLDnTbF0raERFbDnDeBtsztmdmZ2eXe7lOGg35+FwA+UwyQj9H0kW2n5V0u6TzbP/d4pMiYmNETEfE9NTU1ASX6x4+bRFATssO9Ii4PiKOi4h1ki6T9LWIuKKxynqAlguAnFiHnlA5ZFIUQD7DJn5IRNwn6b4mflafjO9YFBGy3XY5AHqOEXpCo6IK8bndjNIBpEegJ1QW1cvLxCiAHAj0hEbDOtC5DR2ADAj0hMYj9Dfm51uuBMBqQKAnNFpouTBCB5AegZ5QOawmRbkNHYAcCPSEmBQFkBOBntA40LlrEYAcCPSE6KEDyIlAT2i8bJHPcwGQA4GeED10ADkR6AmV9dZ/eugAciDQE1oYodNyAZABgZ7QwtZ/JkUBZECgJ0QPHUBOBHpCC6tcCHQAGRDoCS1MitJDB5ABgZ7QiJYLgIwI9ITooQPIiUBPqGTrP4CMCPSE6KEDyIlAT8i2RsWAlguALAj0xMrCjNABZEGgJ1YOGaEDyGPZgW77Xba/bnub7UdtX91kYX1RFgPtZFIUQAbDCb53TtLvRMSDtg+VtMX2poh4rKHaeoEeOoBclj1Cj4gXI+LB+vF/S9om6dimCuuLsjCBDiCLRnrottdJOl3SA038vD4pGaEDyGTiQLf9Y5L+UdI1EfGDffz+BtsztmdmZ2cnvVznjIYDVrkAyGKiQLddqgrzz0fEnfs6JyI2RsR0RExPTU1NcrlOYlIUQC6TrHKxpJslbYuIP2+upH4ZFQPuWAQgi0lG6OdI+hVJ59l+uP71oYbq6o1yyKQogDyWvWwxIv5FkhuspZfKYqD/+d+5tssAsAqwUzQxeugAciHQExux9R9AJgR6YqOCZYsA8iDQE2OnKIBcCPTE2CkKIBcCPbGSlguATAj0xKpJUVa5AEiPQE+Mj88FkAuBnlhZDDS3O7R7N6N0AGkR6ImVw2oz7U5G6QASI9ATGxXVS0zbBUBqBHpi5UKg03IBkBaBnljJCB1AJgR6YqNh9RKzFh1AagR6YmXBpCiAPAj0xJgUBZALgZ7YQg99jklRAGkR6ImV4x46I3QAiRHoiY176LRcAKRGoCdGDx1ALgR6YixbBJALgZ4YG4sA5EKgJzYO9J1s/QeQGIGe2EIPnZYLgMQmCnTb620/Yfsp29c1VVSfjD8+l5YLgNSWHei2C0l/JekCSe+WdLntdzdVWF/QQweQyyQj9DMlPRURT0fETkm3S7q4mbL6Y2GVCz10AIkNJ/jeYyU9v9fz7ZJ+drJy+mfcQ7/xvqd0+7eea7kaAG3540t+Sj+z7oik15gk0L2PY/9vGGp7g6QNkrR27doJLtdNB5WFfv19P6Fn//P1tksB0KKDyyL5NSYJ9O2S3rXX8+MkvbD4pIjYKGmjJE1PT6/KvsO1609uuwQAq8AkPfR/k3Si7eNtjyRdJunLzZQFAHirlj1Cj4g5278p6auSCkm3RMSjjVUGAHhLJmm5KCK+IukrDdUCAJgAO0UBoCcIdADoCQIdAHqCQAeAniDQAaAnHJFvr4/tWUnfzXbBt+YoSS+3XcQEulx/l2uXul1/l2uXul3/W6n9xyNi6kAnZQ30lcz2TERMt13HcnW5/i7XLnW7/i7XLnW7/hS103IBgJ4g0AGgJwj0PTa2XcCEulx/l2uXul1/l2uXul1/47XTQweAnmCEDgA9seoC3fZBtr9l+xHbj9r+VH38eNsP2H7S9hfqjwResWwXth+yfXf9vDP1237W9rdtP2x7pj52hO1Ndf2bbB/edp37Yvsw23fYftz2Nttnd6j2k+rXfPzrB7av6VD9n6j/zm61fVv9d7lL7/ur69oftX1NfazR137VBbqkNySdFxGnSjpN0nrbZ0n6U0l/EREnSvovSVe1WONSXC1p217Pu1b/+yPitL2WbV0naXNd/+b6+Ur0GUn3RMTJkk5V9WfQidoj4on6NT9N0k9L+qGku9SB+m0fK+njkqYj4hRVH9l9mTryvrd9iqRfU3Uv5lMlXWj7RDX92kfEqv0laY2kB1XdC/VlScP6+NmSvtp2fW9S93H1H/55ku5WdTvALtX/rKSjFh17QtIx9eNjJD3Rdp37qPvtkp5RPffUpdr38d/y85L+tSv1a889jI9Q9bHfd0v6ha687yV9WNJNez3/A0nXNv3ar8YR+rhd8bCkHZI2SfoPSa9GxFx9ynZVb6CV6gZVb4bd9fMj1a36Q9K9trfU95yVpHdExIuSVH89urXq9u8ESbOSPlu3u26yfYi6Uftil0m6rX684uuPiO9J+rSk5yS9KOk1SVvUnff9Vknn2j7S9hpJH1J1C89GX/tVGegRMR/VPzuPU/VPoJ/c12l5q1oa2xdK2hERW/Y+vI9TV2T9tXMi4gxJF0j6Ddvntl3QEg0lnSHpxog4XdLrWoHtiQOp+8wXSfqHtmtZqrq3fLGk4yW9U9Ihqt4/i63I931EbFPVHtok6R5Jj0iae9NvWoZVGehjEfGqpPsknSXpMNvjOzjt84bXK8Q5ki6y/ayk21W1XW5Qd+pXRLxQf92hqod7pqSXbB8jSfXXHe1VuF/bJW2PiAfq53eoCvgu1L63CyQ9GBEv1c+7UP8HJD0TEbMRsUvSnZLeq26972+OiDMi4lxJr0h6Ug2/9qsu0G1P2T6sfnywqjfKNklfl3RpfdqVkr7UToVvLiKuj4jjImKdqn82fy0iflkdqd/2IbYPHT9W1cvdquoG41fWp63I+iPi+5Ket31Sfeh8SY+pA7Uvcrn2tFukbtT/nKSzbK+xbe157Tvxvpck20fXX9dKukTVn0Gjr/2q21hk+z2SblU1Sz6Q9MWI+EPbJ6ga8R4h6SFJV0TEG+1VemC23yfpdyPiwq7UX9d5V/10KOnvI+KPbB8p6YuS1qr6y/vhiHilpTL3y/Zpkm6SNJL0tKSPqn4faYXXLkl1//Z5SSdExGv1sa689p+S9BFVrYqHJP2qqp75in/fS5Ltf1Y137VL0m9HxOamX/tVF+gA0FerruUCAH1FoANATxDoANATBDoA9ASBDgA9QaADQE8Q6ADQEwQ6APTE/wFFXZ6k+UBfFAAAAABJRU5ErkJggg==\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x11816a940>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"房租年繳 = pd.Series(每月房租*12, index=預測時段)\n",
"房租年繳.loc[買房年紀:] = 0\n",
"房租年繳.plot()"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x1184ae2b0>"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAD8CAYAAAB5Pm/hAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzt3Xd4VHXaxvHvk0JCAiQkBAQSOqLSIUAsi3XtK1YEURERLPjaV1333XUtu69lXQQ7igoIKBYU64oB7EBC7yS0EHpHQUoyv/ePOexmWTABkpyZyf25rlyZOXOS3AmTmye/OXPGnHOIiEjkivI7gIiIVCwVvYhIhFPRi4hEOBW9iEiEU9GLiEQ4Fb2ISIRT0YuIRDgVvYhIhFPRi4hEuBi/AwDUqVPHNWnSxO8YIiJhZcaMGZudc2ml7RcSRd+kSRNyc3P9jiEiElbMbFVZ9tPSjYhIhFPRi4hEOBW9iEiEU9GLiEQ4Fb2ISIRT0YuIRDgVvYhIhFPRi4SZvUXFjMtZzc49+/2OImFCRS8SZkb+sIr735/L9cOn85PKXspARS8SRn7ZV8wr3yyjWZ1E5q/ZQd/XVfZSOhW9SBgZPW0Vm3/exxNXtOP5azoxt3AHN7yRw897i/yOJiFMRS8SJvbsL+aVb5ZzcrNUujZN4fw2x/Fc747MXr2dG16frrKXw1LRi4SJMdMK2PTTXu48p+W/tl3Qtj5De3Vk1urt3PhGDrtU9nIIKnqRMLBnfzEvf72Mbk1TyGqW+h+3XdSuPkN6dWBGwTZufDOH3ftU9vKfVPQiYeDt6QVsPGiaL+nidg0YfHUHclZu5cY3c/hlX3ElJ5RQpqIXCXF79hfz0tfL6NokhZMPmuZLuqR9sOynr9hK/xEqe/k3Fb1IiBuXu5oNO4PTvJn96r49OjTkHz07MHX5Fm4amcOe/Sp7UdGLhLS9RcW8NGUZmY1rc0rzw0/zJV3asSF/v6o9Pyzbwk0jclX2oqIXCWXjcgtZt2NPmab5ki7vlM7fr2zP98s2M2Ckyr6qK1PRm9lKM5tnZrPNLNfblmJmE80sz3tf29tuZjbUzPLNbK6ZdarIb0AkUu0tKualyfl0apTMaS3qHPHHX9E5naeuaMd3+ZsZOGqGyr4KO5KJ/kznXAfnXKZ3/UEg2znXEsj2rgNcALT03gYCL5VXWJGq5L0ZhazdsYc7zzn+iKb5kq7KzODJy9vxzdJN3Kyyr7KOZemmBzDCuzwCuLTE9pEuaCqQbGb1j+HriFQ5+4oCvDh5GR0ykune8sin+ZJ6dsngicvb8vXSTdz61gz2Fqnsq5qyFr0DvjSzGWY20NtWzzm3DsB7X9fb3hBYXeJjC71tIlJG788sZM32X454bf5wenVtxN8ua8vkJZu49a2ZKvsqpqxFf6pzrhPBZZlBZtb9V/Y91L3S/ddOZgPNLNfMcjdt2lTGGCKRb39xgBcm59M+I5kzjk8rt897TbdG/PWyNkxavJHbVPZVSpmK3jm31nu/ERgPdAU2HFiS8d5v9HYvBDJKfHg6sPYQn3OYcy7TOZeZllZ+d2aRcPfBzEIKt/3CXWeXzzRfUp9ujXns0jZkL97IoNGz2FcUKNfPL6Gp1KI3s0Qzq3ngMnAuMB+YAPT1dusLfORdngBc7x19kwXsOLDEIyK/bn9xgOcn59MuPYkzWlXMAHRdVmMe7dGarxZt4PYxM9lfrLKPdDFl2KceMN6bLGKAMc65L8wsBxhnZv2BAuAqb//PgAuBfGA30K/cU4tEqPGz1rB66y/85Xety32aL+n6k5sQCDj+8vFCbh8zk+ev6URstJ5WE6lKLXrn3HKg/SG2bwHOPsR2Bwwql3QiVUhRcYDnJ+XTpmEtzjqhbukfcIxuOLUpDnjk44XcMXYWQ3t3VNlHKP2rioSID2evpWDrbu48++iPmz9S/U5typ8uPonP56/nrrdnaxknQpVl6UZEKlhwms+jdYNanHNixU/zJfU/rSnOOR7/dBEYDLm6AzGa7COKil4kBEyYs5aVW3bzynWdK22aL+mm3zTDOfjrZ4uIMmNwz/Yq+wiiohfxWXHA8fykfE6sX4tzT6rnW44B3ZsRcI7/+3wxBvxDZR8xVPQiPvt4zlqWb97Fy9d28mWaL+nm05sTcPDkF4uJMnimZweio/zNJMdORS/io+KAY+ikPE44ribnnnSc33EAuPWM5gSc4+l/LiHKjKevaq+yD3MqehEffTJ3Lcs37eLFPp2ICqEyHXRmC5xz/P3LpWDw9JUq+3CmohfxSXHA8dykfFrVq8n5rUNjmi/p9rNaEnDwj4lLiTLjqSvahdR/RlJ2KnoRn3w2bx35G3/m+Ws6hmyB3nF2SwLO8exXeUQZPHG5yj4cqehFfBAIOJ6blEfLujW4sE1ov1zDXeccT8DB0Ow8osz422VtVfZhRkUv4oPP569n6YafGdo7dKf5ku4+pyXOBZeazOCvl6rsw4mKXqSSBQKOodl5NE9L5KK2oT3NH2Bm3PPb4wk4xwuTl2FmPN6jjco+TKjoRSrZFwvWs2TDTwzpFV7HqJsZ953bioCDl6YsI8rgsR5tfD/2X0qnohepRAem+WZpiVzcroHfcY6YmXH/ea0IOMcrXy8nyoxHLqnYUyrLsVPRi1SiLxeuZ/H6nxh8dfgel25mPHj+CTgHw74Jlv3DvztJZR/CVPQilSQQcAzJzqdpnUR+F4bTfElmxh8uOIFAwPHadyswgz9frLIPVSp6kUoycdEGFq3byTNXRcbJwsyMP150IgEHr3+/AsP408UnquxDkIpepBI4F1ybb5KaQI8O4T3Nl2QWLHeH4/XvVxBl8MeLVPahRkUvUgm+WrSRBWt38vSV7SJimi/JzPjzxSfhHLz23QqiooLLOir70KGiF6lgzjmGZC+lUUoCl3Vs6HecCmHeA7LOOYZ9sxwzePB8lX2oUNGLVLBJizcyf81Onroi8qb5ksyMv1zSmuISh17ef14rlX0IUNGLVKDgNJ9HRkp1LusUmdN8SWbGo5e0wZV4UtV956rs/aaiF6lAU5ZsYm7hDp64vC2xETzNlxQVZTzWow0BR/B0CRj3nnu8yt5HKnqRCuKc49nsPBomV+fyTul+x6lUUVHGXy9tg3OO5yfnExUVPFeO+ENFL1JBvl66iTmrt/O3y9pSLaZqTPMlRUUFT2kc8A4tjbLgKY+l8qnoRSrAgbX5hsnVubJz1ZrmS4qKMp64vB0BB89+lYdh3HlOS79jVTkqepEK8G3eZmYVbOfxS9tUyWm+pKgo48kr2uEcDP5qKVEG/3O2yr4yqehFytmBab5+UjxXZVbdab6k6CjjqSvb4ZzjmYlLiYoyBp3Zwu9YVYaKXqScfZ+/hRmrtvFYj9bExUT7HSdkREcZT1/VnoBzPP3PJZjBbWeo7CuDil6kHB14Fmz9pHh6dsnwO07IiY4ynunZAQc89cUSosy45fTmfseKeCp6kXL047It5KzcxqOa5g8rOsp45qr2BBw88fliogwGdlfZV6QyP0pkZtFmNsvMPvGuNzWzaWaWZ2bvmFk1b3ucdz3fu71JxUQXCT3PZudRr1YcPTM1zf+amOgoBvdsz0Xt6vO3zxbz2rfL/Y4U0Y7kcIA7gUUlrj8JDHbOtQS2Af297f2Bbc65FsBgbz+RiPfjsi1MX7GVW09vTnyspvnSxERHMeTqDlzUtj6Pf7qI4d+t8DtSxCpT0ZtZOnAR8Jp33YCzgPe8XUYAl3qXe3jX8W4/2/TcZ6kChmQvpW7NOHp1beR3lLAREx3Fs706cGHb43jsk4W88b3KviKUdY3+WeB+oKZ3PRXY7pwr8q4XAgfO2NQQWA3gnCsysx3e/pvLJbFICJq2fAtTl2/lzxefpGn+CMVGRzGkV0cCgVk88vFCoszoe0oTv2NFlFInejO7GNjonJtRcvMhdnVluK3k5x1oZrlmlrtp06YyhRUJVUOy80irGcc13TTNH43Y6Cieu6Yj57Wux8MTFjDyx5V+R4ooZVm6ORW4xMxWAm8TXLJ5Fkg2swN/EaQDa73LhUAGgHd7ErD14E/qnBvmnMt0zmWmpaUd0zch4qeclVv5YdkWbu7eTNP8MYiNjuK53p347Un1+PNHCxg1dZXfkSJGqUXvnPuDcy7dOdcE6AVMcs71ASYDV3q79QU+8i5P8K7j3T7JOfdfE71IpBjyVR51asTRp1tjv6OEvWoxUbxwTSfOObEuf/pwPqOnqezLw7GchOMB4B4zyye4Bj/c2z4cSPW23wM8eGwRRULXjFVb+S5/Mzd3b0b1aprmy0O1mChe6NOJs0+oyx/Hz2fMtAK/I4W9I3rClHNuCjDFu7wc6HqIffYAV5VDNpGQ9+xXeaQmVqNPltbmy1NcTDQvXtuJW0bN4KHx84gydDTTMajap9UTOQYzVm3j27zNDOzejIRqepJ5eYuLiealaztzRqs0HvxgHuNyVvsdKWyp6EWO0pDsPFISq3HdyVqbryjxsdG8fG1nuh+fxgMfzGVcrsr+aKjoRY7CrIJtfLN0EwN+o2m+osXHRjPsus6c1qIOD7w/l/dmFPodKeyo6EWOwpDsPGonxHK9pvlKER8bzavXZ3Jq8zr8/r05fDBTZX8kVPQiR2j26u1MWbKJm37TjMQ4TfOV5UDZn9I8lXvfncP4WSr7slLRixyhodl5JCfE6mn6PqheLZrXru9CVtNU7h03h49mr/E7UlhQ0YscgXmFO5i0eCM3ndaUGprmfVG9WjTDb8ika9MU7n5nNhPmrC39g6o4Fb3IERiSvZSk6prm/ZZQLYbXb+hClyYp3PX2LD5W2f8qFb1IGc1fs4OvFm2k/2lNqRkf63ecKu9A2Wc2TuGud2bz6dx1fkcKWSp6kTIakp1HrfgYbji1id9RxJMYF8Mb/brQqVEyd7w9i8/nqewPRUUvUgYL1u5g4sIN3HhaU2ppmg8pwbLvSseMZP5n7Cy+mK+yP5iKXqQMhmbnUTM+hn6nNvU7ihxCjbgY3ryxK+0zkrl9zCy+mL/e70ghRUUvUopF63byzwUb6HdqU5Kqa5oPVTXiYnizXxfapidx+5iZfLlAZX+Ail6kFEOz86gZF0N/TfMhr2Z8LCNu7EqbhkkMGjOTiQs3+B0pJKjoRX7F4vU7+Xz+em44tQlJCZrmw0Gt+FhG9u/KSQ2SuG30DLIXqexV9CK/4rnsfGrExdD/NE3z4aRWfCwjb+zKifVrcetbM5m0uGqXvYpe5DCWbviJz+avo+8pjUlOqOZ3HDlCSdVjGXVjN1odV5NbRs1k8pKNfkfyjYpe5DCGZueREBtN/9Oa+R1FjlJSQixv9e/G8cfV4OZRM5hSRcteRS9yCHkbfuLTeeu4/pQmpCRqmg9nB8q+RVoNBo6awTdLN/kdqdKp6EUO4blJ+VSPjWbAbzTNR4LkhGqMvqkbzdNqMGBkLt/mVa2yV9GLHCR/4898PHct153cWNN8BKmdGCz7pnUSuWlELt/nb/Y7UqVR0Ysc5PlJecTHRDNQ03zESUmsxpgBWTStk0j/ETn8UEXKXkUvUsLyTT8zYU5wmk+tEed3HKkAKd5k3zglkRtH5PDjsi1+R6pwKnqREp6flE+1mCitzUe41BpxjB7QjYzaCdz4Zg5Tl0d22avoRTwrNu/iw9lruLZbY9JqapqPdHVqxDFmQBYNa1en3xs5TIvgslfRi3ien5RPbHQUA0/XNF9VpNWMY8yAbjRIjqffmznkrNzqd6QKoaIXAVZtCU7zfbo1pm7NeL/jSCWqWzOesQOyOC4pnhten05uBJa9il6E4DQfE2Xcomm+SqpbK563B2RRr1Y8fV+fzoxVkVX2Knqp8gq27OaDWWvo3bURdWtpmq+q6taKZ+zALOrWiqfv6znMWLXN70jlRkUvVd4Lk/OJjjJuPaO531HEZ/VqBZdx6tSoRt/XpzOzIDLKXkUvVdrqrbt5f2YhvbtkUE/TvADHJQUn+9Qa1eg7fDqzV2/3O9IxK7XozSzezKab2RwzW2Bmj3jbm5rZNDPLM7N3zKyatz3Ou57v3d6kYr8FkaP34pR8osy4RdO8lFA/qTpjB2RRO7Ea1w2fxpwwL/uyTPR7gbOcc+2BDsD5ZpYFPAkMds61BLYB/b39+wPbnHMtgMHefiIhp3Dbbt7NLeTqLhnUT6rudxwJMQ2SqzN2YBbJCbFcN3wa8wp3+B3pqJVa9C7oZ+9qrPfmgLOA97ztI4BLvcs9vOt4t59tZlZuiUXKyYtTlmGG1ublsBomByf7WtVjuXb4NOavCc+yL9MavZlFm9lsYCMwEVgGbHfOFXm7FAINvcsNgdUA3u07gNTyDC1yrNZs/4V3c1fTMzODBsma5uXw0msnMHZAFjXiYujzWniWfZmK3jlX7JzrAKQDXYETD7Wb9/5Q07s7eIOZDTSzXDPL3bSpap0bWvz30pR8AG47s4XPSSQcZKQk8PbAYNlfO3waC9fu9DvSETmio26cc9uBKUAWkGxmMd5N6cBa73IhkAHg3Z4E/NezD5xzw5xzmc65zLS0tKNLL3IU1u34hXE5hVzZOYOGmualjDJSgpN9Qmw0fV6bGlZlX5ajbtLMLNm7XB04B1gETAau9HbrC3zkXZ7gXce7fZJz7r8mehG/vDRlGQHnGHSm1ublyDRKTWDswCzivbJftC48yr4sE319YLKZzQVygInOuU+AB4B7zCyf4Br8cG//4UCqt/0e4MHyjy1ydNbv2MPb01dzVWY66bUT/I4jYahxaiJjB2QRFxNNn9emsWT9T35HKpWFwrCdmZnpcnNz/Y4hVcBfJizgramrmHzfGWSkqOjl6K3YvItew36kqNgxdmAWx9erWekZzGyGcy6ztP30zFipMjbs3MOY6QVc0SldJS/HrGmd4GQfHWVc8+pU8jaE7mSvopcq46UpyygOOAbpSBspJ83SajB2YBZRZvR+dRr5G0Oz7FX0UiVs3LmHsdMLuLxjQxqlapqX8tM8rQZjBmQB0GvYNPI3/lzKR1Q+Fb1UCS9/vZyigOP2szTNS/lrUbcGbw/sBjh6vzqVZZtCq+xV9BLxNv60h9HTVnFph4Y0Tk30O45EqBZ1azJ2QBaBgKP3sKksD6GyV9FLRHPO8fgni9hfHNA0LxWuZb2ajBmQRXEgONmv2LzL70iAil4i3D8mLmXCnLXce24rmtbRNC8Vr9VxwbLfXxyc7FeGQNmr6CVijctZzXOT8unVJYPbdIZKqUStjqvJ6Ju6sbeomN6vTmXVFn/LXkUvEenbvE08NH4ev2lZh8cubYPOlC2V7cT6tRh9Uxa/7C+m97CpFGzZ7VsWFb1EnMXrd3LrWzNpUbcGL/bpRGy07ubij5Ma1GL0Td3YtS842a/e6k/Z6zdAIsr6HXvo90YOiXHRvNGvCzXjY/2OJFVc6wZJjL6pGz/vLaLXsKkUbqv8slfRS8TYuWc/N7wxnZ2/7Of1G7ro5QElZLRpGCz7n/bs96XsVfQSEfYVBbhl1AzyN/7My9d1pnWDJL8jifyHYNlnsfOX/fR+dSprtv9SaV9bRS9hLxBw/P69OfywbAtPXdmO37TUC9lIaGqbnsSo/t3Yvns/vYdNZW0llb2KXsLek18s5qPZa7n//FZc3ind7zgiv6p9RjKj+ndj26599H51Kut2VHzZq+glrL3x/Qpe+WY515/cmFtP17HyEh46ZCQzsn9Xtv68j+xFGyv868WUvotIaPpk7loe/WQh57Wux8O/a61j5SWsdGxUm+x7T6durfgK/1qa6CUsfZe3mbvfmU2XxikM6dWR6CiVvISfyih5UNFLGJpXuIObR+XSPK0Gr/bNJD422u9IIiFNRS9hZcXmXdzwxnSSE6ox4sauJFXXE6JESqOil7Cxcecerhs+DQeM6t+VepX0Z69IuFPRS1jYsXs/178+na279vHGDV1ollbD70giYUNFLyFv974ibhyRw/JNu3jlus60z0j2O5JIWFHRS0jbVxTglrdmMqtgG0N7d9CzXkWOgo6jl5BVHHDcPW423yzdxFNXtOP8NvX9jiQSljTRS0hyzvG/H87n07nr+OOFJ9KzS4bfkUTClopeQo5zjie+WMzY6QUMOrM5A7o38zuSSFhT0UvIeX5SPq98vZzrshpz37mt/I4jEvZU9BJSXvt2Oc9MXMoVndJ55BKdv0akPKjoJWSMmVbA458u4sK2x/HkFW2J0vlrRMqFil5Cwoez1vDHD+dxZqs0nr26IzF6QW+RclPqb5OZZZjZZDNbZGYLzOxOb3uKmU00szzvfW1vu5nZUDPLN7O5Ztapor8JCW9fzF/Hve/OIatpKi9d25lqMSp5kfJUlt+oIuBe59yJQBYwyMxOAh4Esp1zLYFs7zrABUBL720g8FK5p5aI8dXCDdw+Zhbt05N4TWeiFKkQpRa9c26dc26md/knYBHQEOgBjPB2GwFc6l3uAYx0QVOBZDPTM13kv0xespHbRs+kdYNavHljVxLj9Pw9kYpwRH8jm1kToCMwDajnnFsHwf8MgLrebg2B1SU+rNDbJvIv3+Vt5uZRM2hZrwYjb+xGrXidblikopS56M2sBvA+cJdzbuev7XqIbe4Qn2+gmeWaWe6mTZvKGkMiwI/LtnDTyBya1Unkrf7dSEpQyYtUpDIVvZnFEiz50c65D7zNGw4syXjvD7zCbSFQ8vnq6cDagz+nc26Ycy7TOZeZlqYTVVUV05Zvof+IHDJqJ/DWTd2onVjN70giEa8sR90YMBxY5Jz7R4mbJgB9vct9gY9KbL/eO/omC9hxYIlHqrZpy7fQ780c6ifFM3pAN+rUiPM7kkiVUJZHv04FrgPmmdlsb9tDwBPAODPrDxQAV3m3fQZcCOQDu4F+5ZpYwlLJkh87MIu6NfXqUCKVpdSid859x6HX3QHOPsT+Dhh0jLkkgkxbvoUb3sihQbJKXsQPemaKVCiVvIj/VPRSYb7P36ySFwkBKnqpEF8v3cSNb+bQKCWBtweerJIX8ZGeiijlLnvRBm59ayYt6tbgrZu6kaJDKEV8pYleytUX89dzy1szOKF+TcYMUMmLhAJN9FJuPpm7ljvfnk279CRG3NhVpzUQCRGa6KVcjMtZzR1jZ9G5UW1G9de5a0RCiSZ6OWZvfL+CRz5eSPfj03jl2s5Ur6ZTDYuEEhW9HDXnHC9MzufvXy7l/NbHMaR3B+JiVPIioUZFL0fFOceTXyzh5a+XcXnHhjx1ZTu9/J9IiFLRyxErDjj+9NF8xkwr4NqsRjx6SRu9kLdICFPRyxHZVxTg7nGz+XTuOm49ozn3n9eK4AlORSRUqeilzHbtLeKWt2bwbd5mHrrwBAZ2b+53JBEpAxW9lMn23fvo92YOc1Zv56kr29EzM6P0DxKRkKCirwT7iwM88P5c9hYFeOGaTn7HOWLrdvxC39ens3Lzbl7s05nz2xzndyQROQIq+gpWVBzgrneCa9qJ1aJxzoXVmnbehp+4/vXp/LSniDf7deGUFnX8jiQiR0jHw1WgouIAd4+bw6dz19EuPYld+4rZsmuf37HKLHflVq58+UeKAo53bs5SyYuEKRV9BSkqDnDPuDl8PGctf7jgBO4+53gAVm3Z5XOysvlywXr6vDaNlMRqfHDrKbRukOR3JBE5Sir6ClAccNz77hwmzFnLA+efwM2nN6dRagIAq7bs9jld6cZMK/DOQFmL9245mYyUBL8jicgx0Bp9OSsOOO57dw4fzV7L789rxa1nBA9BTK9dHTNYGcJF75zj718u4YXJyzijVRov9ulEQjXdRUTCnX6Ly1FxwPH79+YwftYa7jv3eAad2eJft8XFRNMgqToFIbp0s7eomPvfm8tHs9fSu2sGj/Voo1MaiEQIFX05CQQcD7w/lw9mruGe3x7P7We1/K99GqcmhOREv2P3fgaOymXaiq38/rxW3HZG87A6MkhEfp2KvhwEAo4HP5jLezMKueucltxx9n+XPEDj1ET+uWB9Jaf7dau37qbfmzkUbNnNkF4d6NGhod+RRKScqeiPUSDgeGj8PMblFnLH2S25yzu65lAapyawddc+du7ZHxIvzDGzYBsDR+ayryjAyP5dyWqW6nckEakAWoQ9BoGA448fzuPtnNXcfmYL7j7n0JP8AU28I28KQmD5ZsKctfQaNpWEajF8cNupKnmRCKaiP0qBgON/P5rP2OmrGXRmc+499/hS17UbpSQC/h5i6ZxjaHYed4ydRfv0JD4cdCot6tbwLY+IVDwt3RwF5xx/nhA8H/utZzTnvnPLdqrext5Ev9KnI2/2FhXz4PvzGD9rDZd3bMj/XdFWrwglUgWo6I+Qc46HJyzgrakF3HL6kZ2PPTEuhjo14nxZutn40x5uHjWDWQXb/3Xop46sEakaVPRHwDnHIx8vZOSPq7i5ezMeOP/IX3QjeIhl5U7089fsYMDIXLbv3s+LfTpxYdv6lfr1RcRfWqMvI+ccj36ykDd/WMlNpzXlwQtOOKqJuHFqAgVbK2+i/3jOWq58+QcMeO/Wk1XyIlWQir4MnHM89ski3vh+Jf1Pa8ofLzrxqJc9Gqcksm7HHvbsLy7nlP8pEHA88+US/mfsLNo0SOKj20/TiclEqqhSi97MXjezjWY2v8S2FDObaGZ53vva3nYzs6Fmlm9mc80s/F5l4yDOOR7/dBGvf7+Cfqc24X+PoeQBmtQJPiC7ugKn+p179jNgZC7PTcqnZ2Y6owd0I61mXIV9PREJbWWZ6N8Ezj9o24NAtnOuJZDtXQe4AGjpvQ0EXiqfmP5wzvG3zxYx/LsV3HBKE/588UnH/ABmo5QDR95UTNHnbfiJS5//nq+XbuLRHq158op2OrJGpIorteidc98AWw/a3AMY4V0eAVxaYvtIFzQVSDazsFwUds7xxOeLefXbFVx/cmMe/t2xlzxAk9QDx9KX/wOyX8xfz6UvfM/OPfsZMyCL609uoiNrROSoj7qp55xbB+CcW2dmdb3tDYHVJfYr9LatO/qIlc85x5NfLOGVb5ZzbVYjHrmkdbkVZnJCLDXjY8r1SVPFAcfgiUt5fnI+7TOSefnaTtRPql5un19Ewlt5H155qDZ0h9zRbCDB5R0aNWpVY41bAAAJI0lEQVRUzjGOnnOOp/+5hJe/Xkafbo149JI25ToVmxmNUxNYVU5r9Ft+3std78zm27zNXJ2ZwSM9WhMfq6UaEfm3oy36DWZW35vm6wMbve2FQEaJ/dKBtYf6BM65YcAwgMzMzEP+Z1DZnHM88+VSXpyyjN5dG/FYjzZERZX/0kfj1EQWrNlxzJ9nZsE2Bo2eyZZd+3jyirZc3SV0/sMUkdBxtIdXTgD6epf7Ah+V2H69d/RNFrDjwBJPOBj8VR7PT86nV5cM/nppxZQ8QOOUBAq3/UJRceCoPt45x8gfV3L1Kz8SE218cOspKnkROaxSJ3ozGwucAdQxs0LgYeAJYJyZ9QcKgKu83T8DLgTygd1AvwrIXCGe/WopQ7Pz6JmZzt8ua1thJQ/BB2SLAo612/f867Vky+qnPft5aPx8Pp6zlrNOqMvgnh1ISvD/lMciErpKLXrnXO/D3HT2IfZ1wKBjDVXZhnyVx7Nf5XFl53SeuLxdhZY88K9yX7ll1xEV/fw1O7h9zEwKtu4Ovh7t6c0rPKuIhL8qf66b57LzGPzVUq7olM6TV1R8yUOJQyzL+ICsc463phXw2CcLqZ0Qy9gBWXTT+eNFpIyqdNG/MDmfZyYu5fKODXnqynZEV9J0XLdmHHExUazaXPqx9Dv37OcPH8zj07nrOP34NP7Rsz2pNfQsVxEpuypb9C9Oyefpfy7h0g4NePqq9pVW8gBRUWU7xHJmwTbufHsWa7fv4YHzT+Dm7s20VCMiR6xKFv3LXy/jqS+W0KNDA57p2aFSS/6ARimJh312bHHA8dKUfAZ/lUf9pHjG3XwynRvXruSEIhIpqlzRD/tmGU98vpjftW/AM5U8yZfUODWB7/I3EQi4/5jS1+34hbvens20FVv5XfsG/PWyNiHxQuIiEr6qVNG/9u1y/vbZYi5qV5/BPdsTE+3fWZqbpCawZ3+AjT/t5bikeAA+nbuOh8bPY39xgL9f1Z4rOjXUuWpE5JhVmaIf/t0KHv90ERe1rc+Qqzv4WvIAjUqc3CwhLpqHP1rA+FlraJ+exOCrO9AsTS/YLSLlo0oU/Rvfr+CxTxZyYdvjeLaX/yUPwYke4MPZa7hn3BzW79zDnWe35PazWhAbAvlEJHJEfNGP+GElj3y8kPNbH8eQXh1DpkQbJFcnOsoYO301Tesk8t4tJ9OxkR5wFZHyF9FFP/LHlTw8YQHnta7Hc9eETskDxEZH0TMzg7iYKO4/vxUJ1SL6n0JEfBSx7TJq6ir+/NECfntSPZ7r3SmkSv6A/7u8rd8RRKQKCL32Kwejp63iTx/O55wT6/LCNZ2oFhOR36aISJlEXAOOmVbAH8fP5+wT6vJCH5W8iEhEteDb0wt4aPw8zmyVxovXdtKLYouIEEFFPy5nNQ9+MI8zWqXx0rWdVfIiIp6IKPp3c1fzwAdz6X58Gi9f21mvmSoiUkLYF/37Mwq5//25nNaiDsOuU8mLiBwsrIv+w1lruO+9OZzavA6vXp+pkhcROYSwLvqGtavz2xPrqeRFRH5FWD9hqkuTFLo0SfE7hohISAvriV5EREqnohcRiXAqehGRCKeiFxGJcCp6EZEIp6IXEYlwKnoRkQinohcRiXDmnPM7A2a2CVjld47DqANs9jvEMQjn/OGcHcI7fzhnh/DOfyTZGzvn0krbKSSKPpSZWa5zLtPvHEcrnPOHc3YI7/zhnB3CO39FZNfSjYhIhFPRi4hEOBV96Yb5HeAYhXP+cM4O4Z0/nLNDeOcv9+xaoxcRiXCa6EVEIpyKvgQzizez6WY2x8wWmNkj3vamZjbNzPLM7B0zq+Z31sMxs2gzm2Vmn3jXwyn7SjObZ2azzSzX25ZiZhO9/BPNrLbfOQ/FzJLN7D0zW2xmi8zs5DDK3sr7mR9422lmd4VR/ru939f5ZjbW+z0Op/v9nV72BWZ2l7etXH/2Kvr/tBc4yznXHugAnG9mWcCTwGDnXEtgG9Dfx4yluRNYVOJ6OGUHONM516HE4WUPAtle/mzveigaAnzhnDsBaE/w3yAssjvnlng/8w5AZ2A3MJ4wyG9mDYE7gEznXBsgGuhFmNzvzawNMADoSvB+c7GZtaS8f/bOOb0d4g1IAGYC3Qg+eSHG234y8E+/8x0mc7p3pzgL+ASwcMnu5VsJ1Dlo2xKgvne5PrDE75yHyF0LWIH3mFc4ZT/E93Iu8H245AcaAquBFIKvmPcJcF643O+Bq4DXSlz/E3B/ef/sNdEfxFv6mA1sBCYCy4Dtzrkib5dCgneuUPQswTtJwLueSvhkB3DAl2Y2w8wGetvqOefWAXjv6/qW7vCaAZuAN7xls9fMLJHwyH6wXsBY73LI53fOrQH+DhQA64AdwAzC534/H+huZqlmlgBcCGRQzj97Ff1BnHPFLvgnbDrBP6dOPNRulZuqdGZ2MbDROTej5OZD7Bpy2Us41TnXCbgAGGRm3f0OVEYxQCfgJedcR2AXIbjMURpvHfsS4F2/s5SVt3bdA2gKNAASCd5/DhaS93vn3CKCy0wTgS+AOUDRr37QUVDRH4ZzbjswBcgCks3swAuppwNr/cr1K04FLjGzlcDbBJdvniU8sgPgnFvrvd9IcI24K7DBzOoDeO83+pfwsAqBQufcNO/6ewSLPxyyl3QBMNM5t8G7Hg75zwFWOOc2Oef2Ax8ApxBe9/vhzrlOzrnuwFYgj3L+2avoSzCzNDNL9i5XJ3gnWgRMBq70dusLfORPwsNzzv3BOZfunGtC8M/vSc65PoRBdgAzSzSzmgcuE1wrng9MIJgbQjS/c249sNrMWnmbzgYWEgbZD9Kbfy/bQHjkLwCyzCzBzIx//+zD4n4PYGZ1vfeNgMsJ/huU689eT5gqwczaASMIPnIfBYxzzj1qZs0ITskpwCzgWufcXv+S/jozOwO4zzl3cbhk93KO967GAGOcc381s1RgHNCI4C/1Vc65rT7FPCwz6wC8BlQDlgP98O5DhHh2AG99eDXQzDm3w9sWLj/7R4CrCS55zAJuIrgmH/L3ewAz+5bg42n7gXucc9nl/bNX0YuIRDgt3YiIRDgVvYhIhFPRi4hEOBW9iEiEU9GLiEQ4Fb2ISIRT0YuIRDgVvYhIhPt/57RzdTp+nXkAAAAASUVORK5CYII=\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x109f60b70>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"每年淨額_買房 = pd.Series(0, index=預測時段)\n",
"每年淨額_買房.iloc[0] = 起始資金\n",
"每年淨額_買房.loc[:退休年齡] += 每月薪水 * 12\n",
"每年淨額_買房 -= (每月開銷*12 + 房租年繳 + 利息 + 買房花費)\n",
"每年淨額_買房.cumsum().plot()\n",
"#每年淨額_買房.plot()"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x1185322b0>"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAD8CAYAAACRkhiPAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvNQv5yAAAIABJREFUeJzs3XV8VfUbwPHPdxuM7hREGiQkJSQkJEQEFCQEaRFBCdEfmICUIhKKEtIiJSEg3d1d0h0yOgYb231+f3zvYCqxuLGx5/163Rfbueee82zcneeebzxfIyIopZSKm3y8HYBSSinv0SSglFJxmCYBpZSKwzQJKKVUHKZJQCml4jBNAkopFYdpElBKqThMk4BSSsVhmgSUUioO8/N2AE+SJk0ayZo1q7fDUEqpWGPbtm2XRCRtRPaN8Ukga9asbN261dthKKVUrGGMORnRfbU5SCml4jBNAkopFYdpElBKqThMk4BSSsVhmgSUUioO0ySglFJxmCYBpZSKwzQJKKVUDLN+PXz/PXhi9V9NAkopFYMcOAA1a8KIEXD7tvvPp0lAKaViiHPnoHp1iB8fFi2CJEncf84YXzZCKaXiguvX4dVX4coVWL0asmXzzHk1CSillJcFBUGdOrB/P8yfD0WKeO7cmgSUUsqLHA5o2hRWroSJE6FKFc+eX/sElFLKS0SgY0eYNg3694fGje32afum0fbPtogHhgdpElBKKS/p0QOGDoUuXeDjj8EhDr5a8RUNpjdgz8U93L7n/uFB2hyklFJe8MMP8PXX0LIlfPcd3L53i6azmjLrr1m0KNyCYa8Nw9/P3+1xaBJQSikP+/VX2wz0xht2PsCp6yepNaUWey/uZWDVgXQq1QljjEdieWISMMaMAWoCF0WkgHPbVCCPc5cUwDURKWyMyQocAA46n9soIm2drykGjAMSAvOBjuKJBi+llIpB5s6FFi2gcmWYNAk2nF1D3Wl1CQoNYt7b86ies7pH44lIn8A44B9RiUgDESksIoWBGcDMcE8fDXsuLAE4DQPaALmcD8/+pEop5WXLl0P9+lC0KMycKYzaPZRKEyqRIkEKNrXe5PEEABFIAiKyGrjysOeMvV+pD0x+3DGMMRmBZCKywfnpfwJQJ/LhKqVU7LRuHdSqBTlzwsw5d/hweXM+XPAh1XNWZ8u7W8ibJq9X4oru6KBywN8icjjctmzGmB3GmFXGmHLObZmAM+H2OePcppRST72tW6FGDciUCcbOOEPtOWWZsGsC3V/uzuyGs0meILnXYotux3Aj/nkXcB7IIiKXnX0Afxhj8gMP6+F4ZH+AMaYNtumILFmyRDNEpZTynt27oWpVSJ0aeoxZw6uz3yQ4NJjZDWdTK08tb4cX9TsBY4wf8CYwNWybiASJyGXn19uAo0Bu7Cf/zOFenhk496hji8hIESkuIsXTpk0b1RCVUsqr/vrLzgBOlEio0/dHGi99mXSJ07G59eYYkQAges1BrwB/icj9Zh5jTFpjjK/z6+zYDuBjInIeuGmMKeXsR2gKzI7GuZVSKkY7fNiOABJxkL1jGwYd7ECjgo3Y1HoTedLkefIBPOSJScAYMxnYAOQxxpwxxrRyPtWQ/3YIlwd2G2N2AdOBtiIS1qn8PjAKOIK9Q1jggviVUirGOXIEKlaEwLv38GtRnY13x/NzjZ+Z+MZEksT3QH3oSHhin4CINHrE9uYP2TYDO2T0YftvBQpEMj6llIpVjh6FihWFa7fuEtSkDMkyXmbtW2spkamEt0N7KJ0xrJRSLnL0KJR/OZRL128T3KQsNcs8x7jaS0idKLW3Q3skTQJKKeUCx49DmfJBBFwLxKd5FQY2aeHR8g9RpUlAKaWi6dBhByXK3uL6zRAytm/CH51+jrHNP/+mSUAppaJh9baLVHnFh+BgoXKPb5jeYRIpEqTwdlgRpusJKKVUFP0wZzkVKkBwSCg9x61myScDYlUCAL0TUEqpSAu8F0izYYOZ3q0N8eI7mL3wNq+WquvtsKJEk4BSSkXC1nNbqTvwW079NJKkSWHj6qTky5vO22FFmSYBpZSKgBBHCH3X9KXnuNXI5D/IkM6XDasTkjWrtyOLHk0CSin1BIcuH6LprKZsWp4Wn+nzyZPTl2VLfXnmGW9HFn3aMayUUo/gEAc/bvqRIiOKsHdZAXx/n03RQvFZs/rpSACgdwJKKfVQx64eo+Xslqw6uYp8J4dwYOqHlC9vmDMHkiXzdnSuo0lAKaXCcYiD4VuH878l/8PH+PJmwBZmji3Oa6/B779DwoTejtC1NAkopZTT0StHafNnG5YfX84rWauSef10xo1MSpMmMHo0xI/v7QhdT/sElFJxXqgjlIEbBlJwWEG2nN3C0Kq/kHrBQsaNTMpHH8H48U9nAgC9E1BKxXF7L+6l1ZxWbD67mZq5a/Jd+eF82DwTS5fCt9/CJ59ADK8BFy2aBJRScdLdkLv0XdOXb9Z+Q/IEyZlcdzIvp25AzZqGXbtg7Fho3tzbUbqfJgGlVJyz/Phy2v7ZlsNXDtO4YGMGVx9MwMk0lC4NAQEweza89pq3o/SMiCwvOcYYc9EYszfcth7GmLPGmJ3OR41wz31qjDlijDlojKkWbnt157Yjxphurv9RlFLq8QJuB9Dsj2ZUnlAZhzhY3GQxE9+cyP6taShTBu7cgVWr4k4CgIh1DI8Dqj9k+yARKex8zAcwxuTDrj2c3/man40xvs7F538CXgXyAY2c+yqllNs5xMHo7aN5/qfnmbRnEp+V/Yw97++hSo4qTJkCVapAunSwcSMUL+7taD0rImsMrzbGZI3g8WoDU0QkCDhujDkChK2scEREjgEYY6Y4990f6YiVUioSdl7YSbt57dhwZgNlni3DiJojyJ8uPyLQvz907Qply9omoFSpvB2t50VniOgHxpjdzuailM5tmYDT4fY549z2qO1KKeUW1+9ep8OCDhQbWYwjV44wrvY41rRYQ/50+QkOhtatbQKoXx+WLImbCQCingSGATmAwsB54Hvn9ocNpJLHbH8oY0wbY8xWY8zWgICAKIaolIqLHOJg3M5x5Bmah6Gbh9K2WFsOfnCQZoWbYYzhyhWoXh3GjIEvvoDJkyFBAm9H7T1RGh0kIn+HfW2M+QX40/ntGeDZcLtmBs45v37U9ocdfyQwEqB48eKPTBZKKRXe5rOb+XDBh2w+u5lSmUsx7+15FHum2P3nDx+GmjXhxAmYMAHeecd7scYUUUoCxpiMInLe+e0bQNjIoTnAJGPMQOAZIBewGXsnkMsYkw04i+08fjs6gSulVJgLty7w6bJPGbdzHBmSZGBCnQk0fqExPuZBY8fKlVC3rp34tWyZ7QdQEUgCxpjJQAUgjTHmDNAdqGCMKYxt0jkBvAcgIvuMMdOwHb4hQHsRCXUe5wNgEeALjBGRfS7/aZRSccqde3cYvHEwfdf2JSgkiK5luvJ5uc9J6p/0H/v9/DN06AC5c8PcuZAjh5cCjoGMSMxubSlevLhs3brV22EopWIQEWHqvql0W9qNk9dPUjtPbfpX6U/u1Ln/sV9wsL34jxhhx/5PmvR0lYF+FGPMNhGJ0GBXnTGslIpVNpzewEeLP2LjmY0USl+IMbXHUClbpf/sFxBgm3/WrIFu3aB3b/D19ULAMZwmAaVUrHDo8iE+W/YZMw7MIEOSDIyuNZpmhZrh6/PfK/uOHfDGG/D33/Dbb/C29kA+kiYBpVSM9vetv/l61deM3D4Sf19/erzcgy4vdSFJ/CQP3f/XX6FNG0iTxt4FxLUZwJGlSUApFSPdCLrBwA0D+X7D99y5d4c2xdrw1ctfkSFJhofuHxwMXbrA0KFQoQJMnWpLQajH0ySglIpR7obc5ectP9N3TV8u37nMm8+/Sd9KfcmTJs8jX3PhArz1FqxdCx99ZNcB8NOrW4Tor0kpFSPcC73H+F3j6bmqJ2dunOGV7K/Qt1JfXsz04mNft3o1NGwI16/b2b8NG3oo4KeEJgGllFeFOkKZtGcSPVf15OjVo5TIVILxdcY/dMRPeCLw3Xfw2WeQPTssWgQFC3oo6KeIJgGllFc4xMG0fdPosbIHBy8fpFD6QsxuOJvXc7+OecJ6jlev2lW/5syBevXsIvBxYfy/O2gSUEp5VKgjlN/3/07v1b3ZF7CPAukKMKP+DOrkrfOPMg+Psm2bbf8/fRqGDIEPP3y61wB2N00CSimPCHGEMGXvFHqv7s3BywfJlzYfU+pO4a38b0Xo4i8CP/4IH38M6dPbvoDSpT0Q+FNOk4BSyq2CQ4P5bfdv9Fvbj8NXDvNC+hf4/a3fefP5NyN08Qe4cgVatrQLv9SsCePGQerU7o07rtAkoJRyi8B7gYzePprv1n/H6RunKZKhCLMazKJWnloRvvgDrFsHjRrZYaCDBkHHjtr840qaBJRSLnXt7jWGbRnGoI2DCAgMoFyWcox8fSTVclR7YodveKGh0K8f9OgBzz0H69fr7F930CSglHKJMzfOMHjjYEZsG8Gt4FvUyFWDT8t+StkskS/cf/KkXfBlzRp7FzBsGCRP7oaglSYBpVT07Pl7DwM2DGDSnkmICA0LNOTjlz6mcIbCUTrelCnQti04HLYOUJMmLg5Y/YMmAaVUpIkIi44uYtDGQSw+uphE8RLR/sX2dC7VmedSPBelY964YWv/jx9vR/1MnGgngSn30iSglIqwO/fuMHH3RAZvGsz+gP1kTJKRPpX60LZ4W1IlTBXl465aBc2a2bH/X30FX36ptX88JSLLS44BagIXRaSAc9t3wOtAMHAUaCEi14wxWYEDwEHnyzeKSFvna4oB44CEwHygo8T0Zc2UUoBt7x+2ZRgjt4/kUuAlCmcozIQ6E2hQoAHxfeNH+bh378IXX8DAgZAzpx0JVKqUCwNXTxSRXDsOGApMCLdtCfCpiIQYY74FPgW6Op87KiIPawwcBrQBNmKTQHVgQRTjVkq5mYiw7vQ6ftj0AzMPzEQQauWpRYcSHaiQtUKkRvo8zI4dtvN33z5o1w7694fEiV0UvIqwJyYBEVnt/IQfftvicN9uBOo97hjGmIxAMhHZ4Px+AlAHTQJKxTi3g28zac8kft76Mzsv7CRFghR0LtWZdi+2I1vKbNE+fnAw9O0LffrYev8LF0K1ai4IXEWJK1rdWgJTw32fzRizA7gBfCEia4BMwJlw+5xxbnsoY0wb7F0DWbJkcUGISqknOXjpID9v+Znxu8ZzPeg6BdMVZPhrw2nyQhMSx3fNR/SdO23ht1277F3A4MGQKupdCcoFopUEjDGfAyHAb85N54EsInLZ2QfwhzEmP/Cw+8ZH9geIyEhgJEDx4sW130ApNwkKCWLWX7MYuW0kK06sIJ5PPOrlq0f7F9vz0rMvRbvJJ0xwsP3k37evXfZxzhx4/XWXHFpFU5STgDGmGbbDuHJYB6+IBAFBzq+3GWOOArmxn/wzh3t5ZuBcVM+tlIqew5cP88v2Xxi7cyyXAi+RNUVW+lTqQ6sirUifJL1Lz7VlC7RqBXv26Kf/mChKScAYUx3bEfyyiASG254WuCIiocaY7EAu4JiIXDHG3DTGlAI2AU2BH6MfvlIqogLvBTJj/wxG7xjNqpOr8DW+1M5bmzZF21AlR5VI1fOJiNu37VDPIUMgY0b99B9TRWSI6GSgApDGGHMG6I4dDeQPLHHeLoYNBS0PfG2MCQFCgbYicsV5qPd5MER0AdoprJTbiQjbzm9j9PbRTNo7iRtBN8iZKid9K/WleeHmZEya0S3nXbIE3nsPjh+3s3+/+UbLPsRUERkd1Oghm0c/Yt8ZwIxHPLcVKBCp6JRSUXL+5nkm7p7IuF3j2B+wn4R+CamXrx6tirSi/HPlXdbW/28BAdCliy33kDu3nQRWvrxbTqVcROfkKfUUWXNyDf3W9mPR0UU4xEHpzKUZ/tpwGhRoQIoEKdx2XocDxo6FTz6BW7fg88/tJLAECdx2SuUimgSUekqsO7WOqhOrkiphKrqV6UbTQk3JkyaP28+7b59t8lm7FsqVg+HDIV8+t59WuYgmAaWeAvsu7uP1ya+TJXkW1rVcR5pEadx+zlu3oFcvW/IhWTK72Hvz5uDj2v5l5WaaBJSK5U5fP03136rj7+fPoiaL3J4ARGD6dOjcGc6ehRYt4NtvIW1at55WuYnmbKVisat3rlL9t+rcCLrBwsYLyZoiq1vP99dfULUq1K9vSz6sXw9jxmgCiM00CSgVS925d4daU2px5MoR/mjwB4UyFHLbua5ft6N+ChaErVvhp5/sJLDSpd12SuUh2hykVCx0L/QeDaY3YN2pdUypN4WK2Sq65TyhoTBuHHz2mR3+2arVg8Jv6umgSUCpWMYhDlrOacncQ3P5qcZP1M9f3y3nWbsWOnaE7duhTBlYsACKFnXLqZQXaXOQUrGIiNBpYScm7p5I74q9afdiO5ef4+hReOstO9zz779h0iS74LsmgKeTJgGlYpEeK3vw4+Yf+ajUR3xW7jOXHvvqVfj4Y3j+eZg/H3r2hIMHoVEjcNMEYxUDaHOQUrHE4I2D+Xr117Qs3JIBVQe4rPRDUJCd4NWrF1y5Yod89uoFzzzjksOrGE7vBJSKBcbsGEPnRZ158/k3GfH6CJckAIfDNvU8/zx06gSFC9slH0eP1gQQl2gSUCqG+233b7Se05pqOaox6c1J+PlE/wZ+6VJ48UVo3NhW91y0yG4r5L5RpiqG0iSgVAw2Y/8Mmv3RjJezvszMBjPx9/OP1vE2bYJXXoEqVWzTz8SJsG2bnQCm4iZNAkrFUPMOzaPRjEaUzFySuY3mkiheoigfa88eqFMHSpWC3bth0CA7+7dxY631E9dpx7BSMdDSY0upO60uhTIUYv7b80kSP0mUjnPoEHz9tW37T5YMeve2Y/+TRO1w6ikUoc8AxpgxxpiLxpi94balMsYsMcYcdv6b0rndGGN+MMYcMcbsNsYUDfeaZs79DzvXKFZK/cuK4yuoNbkWedLkYVGTRSRPEPkluY4cgWbNbKfvrFnwv//BsWO2zr8mABVeRG8ExwHV/7WtG7BMRHIBy5zfA7yKXVs4F9AGGAY2aWCXpiwJlAC6hyUOpZS14vgKXpv0GtlTZmfJO0tIlTByK7KfPm1LO+TNC9Om2Uqfx4/b5R11cXf1MBFqDhKR1caYrP/aXBu79jDAeGAldvH52sAEERFgozEmhTEmo3PfJWFrDhtjlmATy+Ro/QRKPSVWnlh5PwEsb7acdIkjV6Dn4kVb3uHiRfjwQ+jaFTJkcFOw6qkRnT6B9CJyHkBEzhtjwt6xmYDT4fY749z2qO1KxXkrT6ykxm81yJYyW5QSQHAw1KsHly7Z8s5a4kFFlDvGBTxsFos8Zvt/D2BMG2PMVmPM1oCAAJcGp1RME3YHkC1lNlY0WxHpBAB2steaNXailyYAFRnRSQJ/O5t5cP570bn9DPBsuP0yA+ces/0/RGSkiBQXkeJpdbUK9RRbemwpNX6rQdYUWVneNPJ3AAC//ALDhtlF3hs1ckOQ6qkWnSQwBwgb4dMMmB1ue1PnKKFSwHVns9EioKoxJqWzQ7iqc5tScdL8w/OpOakmuVLnYkWzFaRPkj7Sx1i/Htq3h2rVoF8/NwSpnnoR6hMwxkzGduymMcacwY7y+QaYZoxpBZwC3nLuPh+oARwBAoEWACJyxRjTC9ji3O/rsE5ipeKaWQdm0WB6A15I/wKLmiwidaLUkT7G2bNQty489xxMngy+vm4IVD31Ijo66FE3mZUfsq8A7R9xnDHAmAhHp9RTaOreqTSe2ZgSmUowv/F8UiRIEeljBAZC7dpw65at+ZNSB1urKNIZw0p50Pid42k5pyVls5Tlz0Z/ktQ/aaSP4XBA8+Z2xa85cyB/ftfHqeIOrRqilIcM2TiE5rObUzlbZRY0XhClBAC2DMTvv0P//lCzpouDVHGOJgGl3ExE6LmyJ50WdeLN59+MVjG4KVPsil8tWkCXLi4OVMVJ2hyklBs5xEGXRV0YvGkwLQq3YOTrI6O8HsDmzfbiX66cHRKqSz4qV9AkoJSbhDhCaDO3DWN3jqVTyU58X+17fEzUbr5Pn7YdwRkywIwZ4B+9ZQWUuk+TgFJucOfeHRrOaMicg3PoWaEnX5b/MspLQt64Aa+9ZkcELVkCOn9SuZImAaVc7MqdK9SaXIv1p9fzU42faPdiuygf6949qF8fDhyA+fOhQAEXBqoUmgSUcqkzN85QbWI1jlw5wrS3plEvX70oH0vEzgZetAhGjbJLQirlapoElHKRAwEHqDaxGteDrrOw8UIqZqsYreP172/rAn32mV0jQCl30CSglAusObmG2lNq4+/nz6rmqyicoXC0jjdtGnTrBg0bQq9eLgpSqYfQeQJKRdPUvVN55ddXSJc4Hetarot2AlizBpo2tQvEjB2rC8Er99K3l1JRJCL0X9efhjMaUjJTSda3Wk/2lNmjdcy9e6FWLciaFWbPhgQJXBOrUo+izUFKRUGII4QOCzowbOswGhZoyNjaY0ngF70r9unTUL06JExoO4NTR76wqFKRpklAqUi6GXSTRjMaMe/wPLqW6Urfyn2jPAkszNWrNgHcvAmrV9vy0Ep5giYBpSLh5LWTvD75dfYH7GfYa8NoW7xttI95966dDXz4MCxcCIUKuSBQpSJIk4BSEbTxzEZqT6lNUEgQCxovoEqO6A/cDwmBt9+2ncFTpkClSi4IVKlI0I5hpSJgyt4pVBhXgSTxk7Ch1QaXJAAReO89mDULBg+GBg1cEKhSkRTlJGCMyWOM2RnuccMY08kY08MYczbc9hrhXvOpMeaIMeagMaaaa34EpdzHIQ66r+hOoxmNKJGpBJtab+L5tM9H+7gi8L//wZgx8OWX0LGjC4JVKgqi3BwkIgeBwgDGGF/gLDALu6bwIBEZEH5/Y0w+oCGQH3gGWGqMyS0ioVGNQSl3uhl0k2Z/NGPWX7NoXrg5w18bjr+fa8p3fvstDBhgy0L07OmSQyoVJa7qE6gMHBWRk4+plFgbmCIiQcBxY8wRoASwwUUxKOUyx64eo/aU2uwP2M+gaoPoWLJjlKuA/tvIkfDpp9CoEfzwg64LoLzLVX0CDYHJ4b7/wBiz2xgzxhgTtgR2JuB0uH3OOLf9hzGmjTFmqzFma0BAgItCVCpilh9fzou/vMjZG2dZ1GQRnUp1clkCmDYN2raFV1+F8eN1NrDyvmi/BY0x8YFawO/OTcOAHNimovPA92G7PuTl8rBjishIESkuIsXTavF05SEiwuCNg6n6a1UyJMnA5nc380r2V1x2/LlzoXFjWw5i+nSIF89lh1YqylzRHPQqsF1E/gYI+xfAGPML8Kfz2zPAs+Felxk454LzKxVtt4Nv8+7cd5m8dzJ18tZhfJ3xJPNP5rLjL1kC9epBkSIwbx4kitoSw0q5nCtuRhsRrinIGJMx3HNvAHudX88BGhpj/I0x2YBcwGYXnF+paDly5QilR5dm6r6p9Kvcj5n1Z7o0AaxZYyeD5c1rJ4Mlc92hlYq2aN0JGGMSAVWA98Jt7m+MKYxt6jkR9pyI7DPGTAP2AyFAex0ZpLxt3qF5NJ7ZGF8fXxY2XuiS8f/hbd5sl4bMksXeDaRK5dLDKxVt0UoCIhIIpP7Xtnces38foE90zqmUK4Q4Qui+ojt91/alaMaizKg/g6wpsrr0HDt32npAadPCsmWQLp1LD6+US2jZCBXnnL95nrdnvs3KEytpXaQ1P7z6AwnjJXTpOXbtgsqVIUkSWLoUMj10HJxS3qdJQMUpK0+spOH0htwIusH4OuNpWqipy8+xe7dNAIkSwcqVkC2by0+hlMvoKGUVJ4Q6Qumzug+VJ1QmRYIUbH53s1sSwJ49NgEkSGATQPborTGjlNvpnYB66l24dYEmM5uw7PgyGhZoyMiaI0nqn9Tl59m711YBjR/fJoAcOVx+CqVcTpOAeqotOrKIpn805WbQTUa9PoqWRVq6bPZveGF3APHi2QSQM6fLT6GUW2hzkHoq3Qu9R9clXan+W3XSJU7H1jZbaVW0lVsSwI4dULHigwSQK5fLT6GU2+idgHrqHL58mMYzG7Pl3BbeK/Yeg6oNcvnonzBbtkDVqnYC2PLl2gSkYh9NAuqpISKM2TGGjgs7Et83Pr+/9Tv18tVz2/nWr7eF4FKnhhUrdF1gFTtpElBPhcuBl2nzZxtmHphJxawVmfDGBDIny+y2861ebWcCZ8xo7wAyu+9USrmVJgEV6y05uoQWs1tw8fZF+r/Sny4vdcHHuK+7a+FCePNNyJrVzgTOmPGJL1EqxtKOYRVr3Q6+zQfzP6DqxKok9U/KxtYb+aTMJ25NANOnQ61athjcqlWaAFTsp3cCKlbacHoDTf9oypErR+hcqjN9KvVxW+dvmLFjoXVrKF0a/vwTUqRw6+mU8gi9E1CxSlBIEJ8v+5yyY8tyL/QeK5qtYGC1gW5PAEOGQMuW8MorsGiRJgD19NA7ARVrbD23leZ/NGdfwD5aFG7B4OqDXVr3/2FE7ELwPXvafoBJk8DfNWvNKxUjaBJQMV5QSBA9V/Wk/7r+ZEiSgXlvz6NGrhpuP29oKHzwAQwfDs2bwy+/gJ/+xainjL6lVYy2+exmWsxuwf6A/bQs3JLvq31PigTub4u5e9euBzxzJnTtCv36gRsmG7uWiO2tvngRXn4Z0qf3dkQqFoh2EjDGnABuAqFAiIgUN8akAqYCWbGri9UXkavGztkfAtQAAoHmIrI9ujGop8+t4Ft8ufxLftj8A88kfYYFjRdQPWd1j5z7+nWoU8eWgBg4EDp39shpo2fNGvjiCzuBIUz+/LagUaVKNiloR4Z6CFfdCVQUkUvhvu8GLBORb4wx3Zzfd8UuSp/L+SgJDHP+q9R9C48spO2fbTl5/STtirej3yv93N72H+b8eahRw1YEnTjR3g3EaFu2cPvTT1m7bBnLEydmxXPPkSJ9er4qWpSyx47ZNqwffgAfHyha1CaEypWhTBlInNjb0asYwF3NQbWBCs6vxwMrsUmgNjBBRATYaIxJYYzJKCLn3RSHikUuBV6i86LOTNw9kbxp8rKmxRrKZinrsfMfOGDLQAQEwNznOkIdAAAgAElEQVS5dmnImCgoKIhNkyax/NtvWXbwIJuAe0C84GBKZcnCnsOHKbd5M9WqVaP30qUUDwmx05qXL4dBg6B/f1vtrlSpB0mhZElbA1vFPSISrQdwHNgObAPaOLdd+9c+V53//gmUDbd9GVD8cccvVqyYqKdbqCNURm8fLam+TSXxvo4nXy3/Su7eu+vRGFatEkmRQiR9epGtWz166icKCQmRzZs3S79+/aRKmTKS0NdXAPEBeTFTJunWubMsXrxYbt++LSIit2/flv79+0uqVKkEkDp16siePXvswW7dElm4UOSTT0SKFxcxRgREEiUSqVpV5JtvRLZsEQkJ8eJPrKIL2CoRvYZHdMdHHgCecf6bDtgFlH9MEpj3kCRQ7CHHbANsBbZmyZLFrb8s5V17/94r5caUE3ogZceUlb1/7/V4DJMni8SPL5I3r8ixYx4//X84HA7Zs2ePDB48WGrVqiXJkycXQAApCNLRz09m16sn144ff+xxrl+/Lj179pRkyZKJMUYaNWokhw4d+udOV66IzJol8uGHIvny2UsCiCRPLlK7tsiQISJ79og4HO77gZXLeTQJyD8v3j2Aj4GDQEbntozAQefXI4BG4fa/v9+jHnon8HS6HXxbPl36qfh97Sepvk0lo7ePllBHqEdjCA0V6dfP/hWUKydy+bJHT3+fw+GQw4cPy4gRI6RBgwaSLl26+xf9HFmzSpt8+WSKr69ciB9fpFMnkQsXInX8y5cvS7du3SRRokTi6+srLVu2lBMnTjx85/PnRSZNEmndWiRbtgdJIV06kYYNRUaOFDlyRJNCDOexJAAkBpKG+3o9UB34Dujm3N4N6O/8+jVgAWCAUsDmJ51Dk8DTxeFwyIz9MyTLoCxCD6TZrGZy8dZFj8exf79I2bL2L6B+fZE7dzx7/jNnzsiECROkefPmkiVLlvsX/YwZM0qTJk1k9ODBcuLdd0USJBDx8xN57z2R06ejdc4LFy5Ip06dxN/fX+LFiyft27eXc+fOPf5Fx4+LjB4t0rixSMaMD5LCc8+JtGgh8uuvImfPRisu5XqeTALZnU1Au4B9wOfO7amdTT2Hnf+mcm43wE/AUWDPk/oDRJPAU+XgpYNS9deqQg+k4M8FZdWJVR6P4e5dkR49bPNPypQiY8Z45kNtQECA/P777/L+++9Lnjx57l/0U6VKJXXr1pWhQ4fKgQMHxHHlisiXX4okSSLi4yPStKnI0aMujeXUqVPSpk0b8fPzkwQJEsjHH38sAQEBT36hw2Gz59ChIm++aX+BYUkhb16Rdu1Epk8XuXTJpfGqyPNac5A7HpoEYr+bQTfl06WfSryv40myfslk8IbBci/0nsfjWLNG5Pnn7bu+UaNIt6pEyvXr1+XPP/+Ujz76SAoXLnz/op8kSRJ59dVXZcCAAbJ9+3YJDXU2gd26JdK374ML61tv2QuuGx05ckTeeecdMcZIkiRJ5Msvv5SrV69G/AChoSLbt4t8953Iq6+KJE5sYzdGpEgRkS5dRObNE7lxw30/hHooTQIqRgh1hMqEnRMk44CMQg+k6aymcv7meY/H8fffIs2ayf1WjPnzXX+OO3fuyLJly+Tzzz+X0qVLi69zBI+/v79UrFhRevXqJevXr5fg4OB/v1Bk0CDb5g4ir71mL6wetG/fPqlXr54AkjJlSunbt6/cunUr8gcKDhZZt06kVy+RChXs7RbY5qyXXhL54guR5cs93/YWB2kSUF638fRGKflLSaEHUuKXErLh9AaPxxASIvLTT3boZ7x4It262Q/crnDv3j1Zv3699O7dWypVqiT+/v4CiK+vr5QqVUo+++wzWbZsmQQGBj78AMHBIsOHi2TKZP8MK1USWb/eNcFF0fbt26VmzZoCSLp06WTQoEFyJzoX7MBAkaVLRT77TKRkSdu8Bbafo3JlkT59RDZsELnn+bvCp50mAeU1p6+flqazmgo9kAwDMsj4neM9PupHRGTjRpFixR5cX6PbshIaGio7duyQ77//Xl577TVJmjTp/SaeQoUKSefOnWXu3Lly/fr1xx8oJERk/HiR7NltcKVLiyxbFr3gXGz9+vVSuXJlASRTpkwyfPhwCQoKiv6Br10TmTvXjnB64QW535+QNKm9Axo4UGTnTtvMpKJFk4DyuBt3b8gXy76QhL0Tin8vf+m2pJvcuOv5tuCzZ21fKtjBLJMnR63j1+FwyF9//SU///yz1KtXT1KnTn3/op87d255//33Zdq0aRHrUBWxF7Zp02wHKtg283nzYvRQy+XLl8tLL70kgGTLlk3Gjx8vIa6cRHbxov2dtG0rkivXg6SQOrVIvXoiw4aJHDwYo39HMZUmAeUx90LvyYitIyT9d+mFHkij6Y3k+NXjHo/jzh075j9xYtsU3a1b5PsjT548KWPHjpV33nlHMmXKdP+i/+yzz0qzZs1kwoQJcjqywzQdDvvpt3Bh++eWL5/I77/Hmk+7DodD5s2bJ0WKFBFA8ubNK1OnTn3Qoe1Kp06JjBtnO3AyZ36QFDJlEnnnHfvcqVOuP+9TSJOAcjuHwyGz/5ot+X7KJ/RAyowuIxtPb/RCHHZUYljrSu3aIocPR+y1f//9t0yZMkXeffddyZEjx/2Lftq0aaVBgwYyYsQIOXz4sDii+kl06VKRUqVsYNmz2zH1sbQcg8PhkBkzZki+fPkEkMKFC8vcuXOj/rt58glFDh2y/SZvvSWSJs2DpJAzp0ibNiJTpthef/UfmgSUW607tU7Kjikr9EBy/5hbpu+b7r6LwWNs2GAHnYBI/vwiixc/fv+rV6/K7NmzpUOHDlKgQIH7F/1kyZJJrVq1ZPDgwbJ79+7of8pdt06kYkUbWObMdpbtv0cFxVIhISHy66+/Svbs2QWQUqVKydKlS91/4tBQkV277EiqmjVFkiV7kBQKFhTp2FFk9mzb76A0CSj32Pv3Xqkzpc79Tt/hW4ZLcIjnL25HjtgPhyCSIYPIL788fIDJ7du3ZfHixdK1a1d58cUXxcfHRwBJmDChVKlSRfr16ycbN26Ue64anbJtmx0vD7YS3ZAhT+1wyODgYBk5cqRkzpxZAKlYsaKsW7fOcwHcu2d7//v2FXnlFTviCOwIpBIlbHvg4sUizqJ6cY0mAeVSR68clXdmviOmh5GkfZNK71W95VaQi8ZaRsL58yLt29vhnokSiXTvLnLz5oPng4KCZPXq1dKjRw8pX768xI8fXwDx8/OTsmXLyldffSUrVqyQu3ddXKF0716RunXtn1PKlLYSp6vGosZwd+7ckcGDB9+vd1SjRg3Ztm2bNwIRWbHCzrYuU8bOTQDbQfTyyyI9e9rZgq4Y5RQLaBJQLnHm+hlpO7et+H3tJwl6J5BPFn8il257viTA1at2qHmiRCK+vraMztmztmliy5Yt8u2330q1atUkUaJEAogxRooVKyYff/yxLFiwQG6GzxSudPiwraljjB3m2L17nG2OuHXrlvTr109SpkwpgNStW1f27vV8Rdj7bt60swI//likaNEHJbMTJxapXl2kf3975xZL+2ieRJOAipZzN85JxwUdxb+Xv8T7Op60+7OdnL3h+SJhN2/aD9VhlRQaNHDIvHl75YcffpA6depIihQp7rfrP//88/LBBx/IzJkz5cqVK+4N7ORJW2XT11ckYUKR//1P6+U4Xbt2Tb766itJmjSpGGOkSZMmcjiiPfXudPmyyMyZ9lYyrHZI2J3bm2/aekj79z81w1E1CagoOX/zvHRa0EkS9E4gvj19pcUfLeTYFc8X2L91y5ajsQNCjkqBAr9I9eqNJH369Pcv+tmyZZNWrVrJpEmT5Px5D5WiOH/e1t2PH98+PvzQblP/ERAQIP/73/8kYcKE4uvrK++++66ciknDO8+dE/ntN5GWLW0tkbCkkDGjvbsbPdpWUI2lNAmoSDl345x8tPAjSdg7ofj09JFms5rJ4cue//R2+7bIV1+dlWTJJgq0lAQJst6/6GfIkEHefvttGTVqlBzz9Movly7ZT/sJE9pP/+++a+8G1BOdO3dOPvzwQ4kfP77Ejx9fOnTo4LmkHRnHjomMGmUrC6ZP/yApZMtm7/omTYpVCV+TgIqQU9dOSft57cW/l7/49PSRd2a+I4cuHXryC13o8uXL8uuvM6RUqfbi65v3/kU/adKU8sYbb8jQoUNl3759XhmCKteu2Xb+pEltm3KTJhGfhKD+4eTJk9K6dWvx9fWVRIkSSdeuXeVSTG1CczhE9u0T+fFHkTp1bPGpsKSQL5+9A5w1y67KFkNpElCPdeTyEWk9u7XE+zqe+H3tJ61mt5Ijl4945Nw3b96U+fPny8cffywFCxYRMM4Lf2JJk6a6vP9+f9m2bZtryxNE1q1btjMiVSr7J1K3rh0BpKLt8OHD0rhxYzHGSNKkSaV79+5PrrfkbSEhdt3l/v1tp3KiRHK/ZHaxYvYuceHCGDUiTJOAeqid53dKw+kNxaenj8TvFV/a/dlOTlw94dZz3rlzR1asWCFffvmlvPTSS+Ln5+esthlffHxeFvhaypVbK+vXx4Che3fv2rH9Yc0BNWrEvFXnnxJ79+6VN9988/7COt9++23Uyld7Q1CQHW7ao4cdfhpWMjtePLtcXffuIqtW2feTl2gSUPc5HA5ZfWK1vDrxVaEHkqRvEvlk8SduG+1z79492bRpk/Tt21deeeUVSZAggQDi4+MjBQqUkPz5PxUfnyXi43NbGje2a5h7XXCwndX77LP2T6JCBZG1a70dVZywdetWefXVVwWQ9OnTyw8//OD6eRzudvu2nZjWtavIiy8+KJmdMKFIlSq2qNXmzR4djuqRJAA8C6wADjiXluzo3N4DOAvsdD5qhHvNp8AR5wLz1SJyHk0CURMSGiLT902XUqNKCT2QtP3TSp/VfeRKoGvbMR0Oh+zevVsGDx4sr7/+uiRLlux+u/4LL7wgHTt2ku7d50jFitfuD9Pu3DmG9KtevWrXl8yRw/4plCxp6/08JcMEY5O1a9dKhQoV7hfs++WXX/67AE9scfWqLWHRsaNIgQJyvz8heXKRWrVEBg+2n37c+D7zVBLICBR1fp0UOATkcyaBjx+yfz7nWsT+QDbnOsO+TzqPJoHIuR18W37a/JPkGJJD6IHkGJJDhm4aKreDXTN93uFwyOHDh2XEiBFSv359SZs27f2Lfq5cueS9996TqVOnyrFjf8uwYQ8qJ2fIYGf4e7UvLWyN3P797W28r68NrlAhW+lTL/5e5XA4ZMmSJVKyZEkBJGfOnDJx4kTv9g+5woULttjdu+8++MABdjW5Bg1ERoywAw5c+P7zSnMQMBuo8pgk8CnwabjvFwGln3RcTQIRc/bGWfl82eeS+tvUQg+k5C8lZfq+6RISGv0/oNOnT8v48eOlWbNm8uyzz96/6GfKlEmaNm0qY8eOlZPOj/bHjtl+srAJXsWK2eKZXputHxhoZ462b2+H+4X9Ab7wgp2GvG5drCnrHFc4HA6ZO3euFCpUSADJly+fTJ/unSKFbnHihL0DbdLEzksIe09mySLSvLnIhAkiZ85E6xQeTwJAVuAUkMyZBE4Au4ExQErnPkOBJuFeMxqo96RjaxJ4vC1nt0jjGY3F72s/MT2M1JlSR9aeXButP5iAgACZNm2atG3bVnLnzn3/op8mTRqpV6+eDBs2TA4ePHj/HKGhdn2U116zAyZ8fe2AmrVrvfTh+vBhO7yvRo0HhcUSJbLVJ3/+OYa0RaknCQ0NlalTp0revHbocNGiRWXevHlPTzIQsX8gf/1l10GtW/fBiDSwTUlRvAvyaBIAkgDbgDed36cHfAEfoA8wxrn9p4ckgbqPOGYbYCuwNUuWLFH6JTzNgkOCZcqeKVJmdBmhB5K0b1LptKCTHL1yNErHu379usydO1c6d+58/9OXHaufVGrWrCkDBw6UnTt3/qfE8oULdiRlWC3/9Olt/a7IrrsSbTdv2uac9u3/ebudM6dtl1206Kmt5hkX3Lt3T8aPHy/ZsmUTQF566SVZvny5t8Nyj9BQkR07RL7/XuSTT6J8GI8lASCes1nno0c8nxXYK9oc5BLnb56Xnit7SsYBGYUeSPYh2WXg+oFy/W7kxlkHBgbK0qVL5bPPPpNSpUqJr6+vAJIgQQKpXLmy9OnT55EllkND7ZDounUfFGosV842eXqsySc0VGT7dpuBKla0Q/PCf9ofOtTWm1ZPlaCgIBk+fPj9Vd8qV64sGzZs8HZYMZKnOoYNMAEY/K/tGcN93RmY4vw6/786ho9px/CThQ3xbDS9kcT7Op7QA6k+sbr8efDPCC/gHhwcLOvWrZNevXpJxYoVxd/fX3CWWH7ppZfkiy++kBUrVsidx3xaPn7cVuPNmtW+a1KnFunSReTAARf9oE9y5ozI2LEib79tO9TCt+1/8onIkiX6aT+OCAwMlEGDBt0flFCzZk3ZsWOHt8OKUTyVBMo6mw12E244KPArsMe5fc6/ksLnzlFBB4FXI3KeuJoErt+9LkM3DZX8P+UXeiDJ+yWXDvM7yMFLB5/42tDQUNm+fbsMGDBAatSoIUmSJBGcJZaLFCkiXbp0kXnz5smNJyzCe+uWyPjxDxbJMkakcmX7qd/tQ7mvXbPD7Dp0+GfVx/TpbYGv8eNtETAVZ928eVP69u17v5rsW2+9Jfv37/d2WDFCZJKAsfvHXMWLF5etW7d6OwyPEBG2nNvCL9t+YfLeydy+d5tiGYvxfvH3aVigIYnjJ37k6w4ePMjy5ctZtmwZK1eu5MqVKwDkzZuXSpUqUbFiRSpWrEjq1KkfG0NICCxbBr/9BjNnwu3bkCMHNG8OTZtCliyu/qmd7t6FDRvsyZctgy1bIDQUEiaEcuWgShWoWhUKFgRj3BSEio2uXbvGwIEDGTRoEIGBgTRp0oTu3buTPXt2b4fmNcaYbSJSPEL7ahLwvmt3r/Hb7t8YuX0ku//eTaJ4iWiYvyFti7flxUwvPvQ1J0+evH/RX758OefPnwcgS5YsVKpUicqVK1OpUiWeeeaZJ55fBLZutRf+KVPg778heXKoVw+aNYOyZd1w3b13z17oly+3j/XrISgIfH2hRAmoXNk+SpcGf38Xn1w9jQICAujfvz9Dhw4lJCSEVq1a8cUXX5A5c2Zvh+ZxkUkC0eoY9sTjaW0OuhcSKgMmbpdsL68REl4S3q4hRUcUlWFbhj20o/fChQsyefJkad269f1FvgFJly6dNGzYUEaOHClHjhyJ8PA5h8P2rXbt+mD4fPz4dn2NGTPc0LweHCyyfr2dMVa16j+LcBUuLPLRRyJ//ikS04uJqRjv7Nmz0r59e4kXL574+/tLp06d5MKFC94Oy6PQ5qCYa8Pes3wx6DCrZ2cn5HIWSHCdRImElEkScuSgPwkS2P2uXbvGqlWr7n/S37dvHwDJkyenQoUKVKpUiUqVKpE/f35MBD+mi8D27baZ5/ff4fBh+8H7lVegQQOoUwdSpnTRD3r3LmzeDKtWwerV9pN+YKB9rmBBqFABXn7Z/vuEJiqlouLEiRP06tWL8ePH4+/vT4cOHfjkk09IlSqVt0NzO70TiGHOX74prXuukRTPbxcIFRBJlX+rtP9mrVy+HijLlonALWnWbJF07dpVihcvLj4+PgJIwoQJpWrVqvLNN9/Ipk2bHjps83FCQkRWrxbp1MlOSAQ7matyZVszLSDART/ktWt2Zu5nn9kxo/7+Dz7pFyok8sEH9hbDZSdUKmIOHjwojRo1EmOMJEuWTHr27Bnzy1dHE1pF1PuCgkPk2wnbJHuFNUL8mwIifmlOSMUWK2TNrtMSdPOmrP7xR+n+8stSLlUq8THxBJB48eJJuXLl5KuvvpJVq1ZFqaLizZv2etu8edgSjbapp2ZNO1vdJWt5nDolMnmynaBVuPCDyol+fiIlStjxo3Pm2LVdlYoBdu/eLXXq1BFAUqdOLf3795fbt11TUyum0STgJaGhDpm4cL8Ue3OF+CQ7b0c1+l+TvFVXyU+Tt8imcePkm+rVpWrq1JLI2aZvQIoZI52fzSbx4i2Ut96KWk31I0dspYTq1R+UN0+Rwg6rnzIlmk3twcF2UY0ffhBp2PBByeWwsqCVK9va6kuXxqiFNZR6mC1btki1atUE57KlP/74Y+wrX/0EmgQ8bPGm41Kp5QqJn+GIvTb6Bkn6ouulc4tvpH+t2lI7QwZJ7rzoA5LP318+fOEFmdWtm1w5dsxOEQcZ3XiZgF2v4klu37Yzdzt1Esmd+8E1OWdOW6p5xQp77Y6Sc+fs8nldu4qUL2/rooedIFMmkfr1bULYtk0kks1TSsUUq1evlvLlywsgWbJkkVGjRkW6uTWmikwS0I7hKNq07xy9hh1ixdx0BJ7KBzjIk2ksJVJOI/DqftacO8tF5+82u58flXLkoFKVKlR8910yvPDCPw929y7kyUNomnRk+3sTadL5sGWL7bQN43DA7t2weLF9rF1rR1T6+0PFivDqq/aRK1ckf5DAQNixAzZtso+NG+HUKftcvHhQpAi89JIdqlm6NDz7bJR/Z0rFNCLC0qVL+fzzz9myZQu5cuWiR48eNGzYEB8fH2+HF2XaMewmG/eeldodVkiSHLttOXC2Sfkk9aVa8kySxVl/B5CMPj7SOGtWGd28uRyPyMd6ETsDFmRth6kCtsT4gQO2uGC9erZMQ/jigh99JLJggb0jiLDgYJGdO0V++UWkTRvblh9WUx9sM0/9+iIDB9rhnFqGQcURDodD/vjjDylYsKAAUqBAAZk5c2asrViK3gm4ztrdZxgw+gjL5qXG72gC8jASf7/ZnHUc56gjBICUxlAxY0YqlSlD5ebNyVO9OiaynyJCQ6FIESQwkEoZDrByXbz7Tz37LFSqZB+vvAIRmP9lp/4ePAjbttnHli32E//du/b5FCngxRftxKwSJezXGTNGLmalnjIOh4Np06bRvXt3Dh06RPHixenduzdVq1aN8FDsmEBnDEfTgo3HGDTmFDvmwXPnVpGYuVxkHwe5iwCJgfJp01K5ZEkqvf02hd56Cx8/v+ifeP58eO01/v7qJ744146SJW1TT/bsT5ixGxwM+/bZi/yOHfaiv3Mn3Lljn0+cGIoWheLF7cW+eHFbCyIW3+4q5U4hISH8+uuv9OzZk5MnT1KuXDl69+5N+fLlvR1ahGgSiKSQUAe/LjjA2HHHubNoPYlvreEyOznALUKB+MBLKVJQuVgxKr31Fi++8w7xEiVyfSAi9qp/4AAcPQpJkvx3n2vXYNcue5Hftcte9Pfts2UYwL6mSBEoVsxe+IsVgzx5/tnBoJSKkODgYEaNGkXv3r05f/48VatWpVevXpQoUcLboT2WJoEIuHbrLoMnbGHdz3O599cmboTuYT9XCcKuhlM0USKqFi5MpTp1eKlVKxJ6apbhpk1QqhR8+SW8/bbtDd6zx/67axecPPlg37Rp7QU//CNnTv2Er5SLBQYGMmzYML755hsuXbpErVq16NWrFy/8e5BHDKFJ4BF2HjzHz5//wslly7h67S/+IoCbzuee94tPhbx5qPFGHcq1bk1yt5XLjIB69WDGjAff+/raT/MFC0LhwvZRqBBkyKAVNZXyoJs3bzJkyBAGDBjA9evXadCgAT179iRPnjzeDu0fNAk43bsXwvB+Y1g1birnTu3jUOhFLmN/3qzGj6IZMlOn7utUb/c+aZ9/3pVhR8+ZMzB8uB3v+cIL8Pzz3C8qpJTyuqtXrzJgwACGDBnCnTt3aNq0Kd27dydr1qzeDg3QJMCZk+dokvdFDt69wAUcAGTEh/xJ01O6bBlafdmF50qXcke4Sqk45OLFi3zzzTf8/PPPOBwOWrduzeeff06mTJm8GlecTwKhIaG8ED8pqeIlJffzhXj7kzZUavRm5IdtKqVUBJw9e5bevXszatQo/Pz8aNeuHd26dSNt2rReiSdGJwFjTHVgCOALjBKRbx63v7fnCSilVEQdP36cnj178uuvv5IwYUI6depEly5dSOmyGu0RE5kk4NGPxsYYX+An4FUgH9DIGJPPkzEopZS7ZMuWjXHjxrFv3z5q1qxJnz59yJ49O3369OHWrVveDu+hPN0+UgI4IiLHRCQYmALU9nAMSinlVnnz5mXKlCns3LmT8uXL88UXX5AtWzYGDhzInbBJnDGEp5NAJuB0uO/POLf9gzGmjTFmqzFma0BAgMeCU0opVypUqBCzZ89m48aNFClShC5dupAzZ06GDRtGcHCwt8MDPJ8EHjao/T+dEiIyUkSKi0hxb3WsKKWUq5QsWZLFixezcuVKsmXLRrt27ciTJw/jxo0jJCTEq7F5OgmcAcLXIs4MnPNwDEop5RUvv/wya9asYcGCBaROnZoWLVpQoEABpk6disPh8EpMnk4CW4Bcxphsxpj4QENgjodjUEoprzHGUL16dbZs2cLMmTPx8/OjYcOGFClShDlz5uDpEZseTQIiEgJ8ACwCDgDTRGSfJ2NQSqmYwBjDG2+8wa5du/jtt98IDAykdu3alCpViiVLlngsGXh89pSIzBeR3CKSQ0T6ePr8SikVk/j6+vL222+zf/9+Ro0axYULF6hatSoVKlTwyEginUKrlFIxQLx48WjVqhWHDh3ixx9/JHfu3CRMmNDt53XBSihKKaVcxd/fnw8++MBj59M7AaWUisM0CSilVBymSUAppeIwTQJKKRWHaRJQSqk4TJOAUkrFYZoElFIqDtMkoJRScViMX2PYGBMAnPR2HI+QBrjk7SCiKDbHDrE7/tgcO8Tu+GNz7BDx+J8TkQjV4Y/xSSAmM8Zsjeg6njFNbI4dYnf8sTl2iN3xx+bYwT3xa3OQUkrFYZoElFIqDtMkED0jvR1ANMTm2CF2xx+bY4fYHX9sjh3cEL/2CSilVBymdwJKKRWHaRKIAGNMAmPMZmPMLmPMPmNMT/YXq5IAAAQZSURBVOf2bMaYTcaYw8aYqc51k2MkY4yvMWaHMeZP5/exKfYTxpg9xpidxpitzm2pjDFLnPEvMcak9Hacj2KMSWGMmW6M+csYc8AYUzo2xG+MyeP8nYc9bhhjOsWG2MMYYzo7/2b3GmMmO/+WY8V73xjT0Rn3PmNMJ+c2l//uNQlETBBQSUQKAYWB6saYUsC3wCARyQVcBVp5McYn6Yhd1zlMbIodoKKIFA43PK4bsMwZ/zLn9zHVEGChiOQFCmH/H2J8/CJy0Pk7LwwUAwKBWcSC2AGMMZmADkBxESkA+AINiQXvfWNMAeBdoAT2PVPTGJMLd/zuRUQfkXgAiYDtQEnspA0/5/bSwCJvx/eImDM73zCVgD8BE1tid8Z3Akjzr20HgYzOrzMCB70d5yNiTwYcx9n/FtviDxdvVWBdbIodyAScBlJhV1H8E6gWG977wFvAqHDffwn8zx2/e70TiCBnc8pO4CKwBDgKXBOREOcuZ7BvuphoMPYN5HB+n5rYEzuAAIuNMduMMW2c29KLyHkA57/pvBbd42UHAoCxzua4UcaYxMSe+MM0BCY7v44VsYvIWWAAcAo4D1wHthE73vt7gfLGmNTGmERADeBZ3PC71yQQQSISKva2ODP2Fu35h+3m2aiezBhTE7goItvCb37IrjEu9nDKiEhR4FWgvTGmvLcDigQ/oCgwTESKALeJoc0nj+JsM68F/O7tWCLD2V5eG8gGPAMkxr6H/i3GvfdF5AC22WoJsBDYBYQ89kVRpEkgkkTkGrASKAWkMMb4OZ/KDJzzVlyPUQaoZYw5AUzBNgkN/n/7duxSZRSHcfz7RAQmQhQFQUi4tEU0SDiEYGNTFBIGEvQXREtjQf9FDS4NIoXu2dDUkovkEBSoRBoIjeHwNJwTTl0ckuvhPJ/lvOflDg/nnvf93ft776WN7ADY/l7HXUpPehLYkXQRoI67w0s40DawbftjnS9RikIr+aHcOD/Z3qnzVrLfAr7Z/ml7H3gDTNHI3rf9yvZ12zeBPeALR7D2KQKHIOm8pDP1eISyuTaA98Dd+rJ5YHk4Cf/N9lPbl2xfpnylX7U9RwPZASSNShr7e0zpTa8DK5TccIzz2/4BbEm6Uk/NAJ9pJH91n4NWELSTfRO4Iem0JHGw9q3s/Qt1HAfuUN6D/772+bPYIUi6CixQfl1wAli0/VzSBOXT9VlgDXhg+/fwkg4maRp4Yvt2K9lrzrd1ehJ4bfuFpHPAIjBOudjv2d4bUsyBJF0DXgKngK/AQ+o+4pjnr/3oLWDC9q96rqW1fwbMUlopa8AjyjOAFvb+B8rzu33gse13R7H2KQIRER1LOygiomMpAhERHUsRiIjoWIpARETHUgQiIjqWIhAR0bEUgYiIjqUIRER07A8qBAaH5xkzVwAAAABJRU5ErkJggg==\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x118561cf8>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"投資_買房_總資產 = compound_interest(每年淨額_買房, 投資部位, 投資年利率)\n",
"#\n",
"投資總資產.plot(color='green')\n",
"投資_買房_總資產.plot(color='blue')\n",
"每年淨額_買房.cumsum().plot(color='red')\n",
"無投資總資產.plot(color='black')"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"application/vnd.jupyter.widget-view+json": {
"model_id": "8dff092f5e654deb9a7e12823b6f95d2",
"version_major": 2,
"version_minor": 0
},
"text/html": [
"<p>Failed to display Jupyter Widget of type <code>interactive</code>.</p>\n",
"<p>\n",
" If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean\n",
" that the widgets JavaScript is still loading. If this message persists, it\n",
" likely means that the widgets JavaScript library is either not installed or\n",
" not enabled. See the <a href=\"https://ipywidgets.readthedocs.io/en/stable/user_install.html\">Jupyter\n",
" Widgets Documentation</a> for setup instructions.\n",
"</p>\n",
"<p>\n",
" If you're reading this message in another frontend (for example, a static\n",
" rendering on GitHub or <a href=\"https://nbviewer.jupyter.org/\">NBViewer</a>),\n",
" it may mean that your frontend doesn't currently support widgets.\n",
"</p>\n"
],
"text/plain": [
"interactive(children=(FloatSlider(value=20.0, description='起始資金', step=10.0), IntSlider(value=30, description='起始年紀'), FloatSlider(value=3.0, description='每月薪水', max=20.0), FloatSlider(value=1.0, description='每月開銷', max=20.0, step=0.2), FloatSlider(value=1.0, description='每月房租', max=20.0, step=0.5), IntSlider(value=60, description='退休年齡'), FloatSlider(value=0.7, description='投資部位', max=1.0), FloatSlider(value=5.0, description='投資年利率', max=20.0, step=0.5), IntSlider(value=300, description='買房價格', max=2000, min=100, step=50), IntSlider(value=100, description='買房頭期款', max=2000, min=100, step=50), IntSlider(value=40, description='買房年紀', min=20), FloatSlider(value=2.4, description='房貸利率', max=5.0, min=1.0), IntSlider(value=20, description='貸款年數', max=40), Output()), _dom_classes=('widget-interact',))"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/plain": [
"<function __main__.asset_prediction>"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"import random\n",
"%matplotlib inline\n",
"def asset_prediction(起始資金 ,起始年紀,\n",
" 每月薪水 ,\n",
" 每月開銷 ,\n",
" 每月房租 ,\n",
" 退休年齡 ,\n",
" 投資部位,\n",
" 投資年利率,\n",
" 買房價格,\n",
" 買房頭期款,\n",
" 買房年紀,\n",
" 房貸利率,\n",
" 貸款年數,):\n",
"\n",
" 預測時段 = range(起始年紀, 100)\n",
" 每年淨額 = pd.Series(0, index=預測時段)\n",
" 每年淨額.iloc[0] = 起始資金\n",
" 每年淨額.loc[:退休年齡] += 每月薪水 * 12\n",
" 每年淨額 -= (每月開銷 + 每月房租) * 12\n",
" \n",
" \n",
" def compound_interest(arr, ratio, return_rate):\n",
" ret = [arr.iloc[0]]\n",
" for v in arr[1:]:\n",
" ret.append(ret[-1] * ratio * (return_rate/100 + 1) + ret[-1] * (1 - ratio) + v)\n",
" return pd.Series(ret, 預測時段)\n",
" \n",
" 買房花費 = pd.Series(0, index=預測時段)\n",
" 買房花費[買房年紀] = 買房頭期款\n",
" 買房花費.loc[買房年紀:買房年紀+貸款年數-1] += (買房價格 - 買房頭期款) / 貸款年數\n",
" \n",
" 欠款 = pd.Series(0, index=預測時段)\n",
" 欠款[買房年紀] = 買房價格\n",
" 欠款 = 欠款.cumsum()\n",
" 欠款 = 欠款 - 買房花費.cumsum()\n",
" 利息 = 欠款.shift().fillna(0) * 房貸利率 / 100\n",
"\n",
"\n",
" 房租年繳 = pd.Series(每月房租*12, index=預測時段)\n",
" 房租年繳.loc[買房年紀:] = 0\n",
" \n",
" 每年淨額_買房 = pd.Series(0, index=預測時段)\n",
" 每年淨額_買房.iloc[0] = 起始資金\n",
" 每年淨額_買房.loc[:退休年齡] += 每月薪水 * 12\n",
" 每年淨額_買房 -= (每月開銷*12 + 房租年繳 + 利息 + 買房花費)\n",
" \n",
" \n",
" \n",
" pd.DataFrame({\n",
" 'no invest, no house': 每年淨額.cumsum(),\n",
" 'invest, no house': compound_interest(每年淨額, 投資部位, 投資年利率),\n",
" 'no invest, house': 每年淨額_買房.cumsum(),\n",
" 'invest, house': compound_interest(每年淨額_買房, 投資部位, 投資年利率),\n",
" \n",
" }).plot()\n",
"\n",
" \n",
" import matplotlib.pylab as plt\n",
" plt.ylim(0, None)\n",
" \n",
" print('月繳房貸', (買房價格 - 買房頭期款) / 貸款年數 / 12)\n",
" print('利息', 利息.sum() / 貸款年數)\n",
" print('')\n",
"\n",
"import ipywidgets as widgets\n",
"widgets.interact(asset_prediction, \n",
" 起始資金=widgets.FloatSlider(min=0, max=100, step=10, value=20),\n",
" 起始年紀=widgets.IntSlider(min=0, max=100, step=1, value=30),\n",
" 每月薪水=widgets.FloatSlider(min=0, max=20, step=0.1, value=3),\n",
" 每月開銷=widgets.FloatSlider(min=0, max=20, step=0.2, value=1),\n",
" 每月房租=widgets.FloatSlider(min=0, max=20, step=0.5, value=1),\n",
" 退休年齡=widgets.IntSlider(min=0, max=100, step=1, value=60),\n",
" 投資部位=widgets.FloatSlider(min=0, max=1, step=0.1, value=0.7),\n",
" 投資年利率=widgets.FloatSlider(min=0, max=20, step=0.5, value=5),\n",
" 買房價格=widgets.IntSlider(min=100, max=2000, step=50, value=300),\n",
" 買房頭期款=widgets.IntSlider(min=100, max=2000, step=50, value=100),\n",
" 買房年紀=widgets.IntSlider(min=20, max=100, step=1, value=40),\n",
" 房貸利率=widgets.FloatSlider(min=1, max=5, step=0.1, value=2.4),\n",
" 貸款年數=widgets.IntSlider(min=0, max=40, step=1, value=20)\n",
")"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### 結論\n",
"\n",
"1. 絕對要開始投資,讓資產報酬率在每年5%就差很多了!\n",
"2. 買不買房差很大!\n",
"3. 投資部位很重要"
]
}
],
"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.6.4"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment