融资决策分析模型

116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
-3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14
372171.05 370413.59 368648.59 366876.03 365095.87 363308.07 361512.61 359709.45 357898.57 356079.91 354253.46 352419.18 ቤተ መጻሕፍቲ ባይዱ50577.03 348726.99 346869.01 345003.07 343129.12 341247.15 339357.10 337458.95 335552.66 333638.20 331715.53 329784.62 327845.43 325897.92 323942.06 321977.82 320005.16 318024.04 316034.42 314036.27 312029.56 310014.24 307990.29 305957.65 303916.30 301866.20 299807.31 297739.59 295663.00 293577.51 291483.08
2112.43 2121.49 2130.58 2139.72 2148.89 2158.10 2167.36 2176.65 2185.98 2195.35 2204.77 2214.22 2223.71 2233.25 2242.82 2252.44 2262.10 2271.79 2281.53 2291.32 2301.14 2311.01 2320.92 2330.87 2340.86 2350.90 2360.98 2371.10 2381.26 2391.47 2401.73 2412.02 2422.37 2432.75 2443.18 2453.66 2464.18 2474.74 2485.35 2496.01 2506.71 2517.46 2528.25
2539.09 2549.98 2560.91 2571.89 2582.92 2593.99 2605.11 2616.28 2627.50 2638.77 2650.08 2661.44 2672.85 2684.31 2695.82 2707.38 2718.99 2730.65 2742.35 2754.11 2765.92 2777.78 2789.69 2801.65 2813.66 2825.72 2837.84 2850.01 2862.23 2874.50 2886.82 2899.20 2911.63 2924.11 2936.65 2949.24 2961.89 2974.59 2987.34 3000.15 3013.01 3025.93 3038.90
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 合计
长期借款分期等额还款模型
借款金额 银行基准利率 借款期限 上浮或打折比例 实际利率 每年还款期数 还款总期数 分期等额还款金额 需支付本息总额 利息合计 420000 4.90% 15 1.05 5.1450% 12 180 3,353.14 603,565.86 183,565.86
单位：元
等额还款筹资决策分析表
期限 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 等额还款金额 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 偿还本金 1552.39 1559.05 1565.73 1572.45 1579.19 1585.96 1592.76 1599.59 1606.45 1613.33 1620.25 1627.20 1634.17 1641.18 1648.22 1655.28 1662.38 1669.51 1676.67 1683.86 1691.08 1698.33 1705.61 1712.92 1720.26 1727.64 1735.05 1742.49 1749.96 当期期初尚欠本金 420000.00 418447.61 416888.56 415322.82 413750.38 412171.19 410585.23 408992.47 407392.88 405786.43 404173.10 402552.85 400925.65 399291.47 397650.29 396002.07 394346.79 392684.41 391014.90 389338.23 387654.37 385963.30 384264.97 382559.37 380846.45 379126.18 377398.54 375663.49 373921.01
1757.46 1765.00 1772.56 1780.16 1787.80 1795.46 1803.16 1810.89 1818.65 1826.45 1834.28 1842.15 1850.04 1857.98 1865.94 1873.94 1881.98 1890.05 1898.15 1906.29 1914.46 1922.67 1930.91 1939.19 1947.51 1955.86 1964.24 1972.66 1981.12 1989.62 1998.15 2006.71 2015.32 2023.96 2032.64 2041.35 2050.10 2058.89 2067.72 2076.59 2085.49 2094.43 2103.41
73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
-3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14
189866.27 187327.18 184777.20 182216.29 179644.40 177061.48 174467.49 171862.37 169246.09 166618.59 163979.82 161329.74 158668.30 155995.45 153311.13 150615.31 147907.93 145188.94 142458.30 139715.94 136961.83 134195.91 131418.13 128628.44 125826.79 123013.13 120187.41 117349.57 114499.56 111637.33 108762.83 105876.01 102976.81 100065.18 97141.07 94204.42 91255.17 88293.29 85318.70 82331.36 79331.21 76318.20 73292.27
-3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14 -3353.14
289379.67 287267.24 285145.76 283015.18 280875.46 278726.57 276568.47 274401.11 272224.46 270038.48 267843.13 265638.36 263424.14 261200.43 258967.18 256724.36 254471.92 252209.83 249938.03 247656.50 245365.18 243064.04 240753.04 238432.12 236101.25 233760.39 231409.50 229048.52 226677.43 224296.16 221904.69 219502.96 217090.94 214668.57 212235.82 209792.63 207338.98 204874.80 202400.06 199914.70 197418.69 194911.98 192394.52