请问？分期付款的月还款？

malemalemale

请问，假设买一套150K的房子，80%贷款，20年还。
月还款700中，其中有多少是来付给银行利息？多少是用来还房子贷款呢？
请高手指教！！！谢谢！！！

逍遥居士

取决于你贷款的利率

good99

变化的。一开始，你还的基本上都是利息，然后利息开始减少，开始慢慢还本金。所以，不要贷的太长。

NetRobber

<table 501pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="1002">
<tr 23pt;">
  <td 0cm; height: 23pt;">
  <p left;" align="left">Year<o:p></o:p></p>
  </td>
  <td 0cm; width: 66.8pt; height: 23pt;" width="134">
  <p left;" align="left">Interest Rate (%)<o:p></o:p></p>
  </td>
  <td 0cm; width: 91.85pt; height: 23pt;" width="184">
  <p left;" align="left">Outstanding Principal<o:p></o:p></p>
  </td>
  <td 0cm; width: 83.5pt; height: 23pt;" width="167">
  <p left;" align="left">Monthly Instalment<o:p></o:p></p>
  </td>
  <td 0cm; width: 66.8pt; height: 23pt;" width="134">
  <p left;" align="left">Payment twds Interest<o:p></o:p></p>
  </td>
  <td 0cm; width: 75.15pt; height: 23pt;" width="150">
  <p left;" align="left">Payment twds Principal<o:p></o:p></p>
  </td>
  <td 0cm; width: 83.5pt; height: 23pt;" width="167">
  <p left;" align="left">Principal at end of month<o:p></o:p></p>
  </td>
</tr>
<tr 8.5pt;">
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">1<o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">3.750<o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$120,000.00 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$711.47 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$375.00 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$336.47 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">119,663.53<o:p></o:p></p>
  </td>
</tr>
<tr 8.5pt;">
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">2<o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">4.000<o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$115,892.28 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$726.49 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$386.31 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">$340.19 <o:p></o:p></p>
  </td>
  <td 0cm; height: 8.5pt;">
  <p left;" align="left">115,552.10<o:p></o:p></p>
  </td>
</tr>
</table>

lamesoul

對的，所以買房子作投資基本上是有錢人的專利。除非買給自己的，不然不要貸款太長。 目前有一個很好的房屋貸款計劃，可以幫您降低很多的貸款利率，可以聯絡我來跟你詳談。 在論壇裏發短信給我吧

tanr

<TABLE 523pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=695 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3488" width=109>
<COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3360" width=105>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752" width=86>
<COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136" width=98>
<COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" width=84>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392" width=106>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3424" width=107>

<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=109 height=19>第 15 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 79pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=105 x:num="126384.07683895914">126,384 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=86 x:num="1689.424056953706">1,689 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 74pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=98 x:num="6736.1810656435691">6,736 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 63pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=84 x:num="40192.264960848268">40,192 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=106 x:num="46576.341799807378">46,576 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=107 x:num="79807.735039151754">79,808 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 16 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="134809.6819615564">134,810 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1446.9215385905375">1,447 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6978.6835840067379">6,979 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="33213.581376841532">33,214 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C2+F1" x:num="48023.263338397919">48,023 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G1+D2" x:num="86786.41862315849">86,786 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 17 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="143235.28708415368">143,235 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1195.688929566295">1,196 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="7229.9161930309801">7,230 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="25983.665183810554">25,984 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C3+F2" x:num="49218.95226796421">49,219 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G2+D3" x:num="94016.334816189468">94,016 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 18 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="151660.89220675096">151,661 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="935.41194661717986">935 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="7490.1931759800955">7,490 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="18493.47200783046">18,493 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C4+F3" x:num="50154.364214581394">50,154 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G3+D4" x:num="101506.52799216956">101,507 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 19 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="160086.49732934823">160,086 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="665.76499228189653">666 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="7759.8401303153787">7,760 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="10733.631877515081">10,734 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C5+F4" x:num="50820.12920686329">50,820 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G4+D5" x:num="109266.36812248494">109,266 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 20 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="168512.10245194551">168,512 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="386.41074759054288">386 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="8039.1943750067321">8,039 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2694.4375025083491">2,694 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C6+F5" x:num="51206.53995445383">51,207 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G5+D6" x:num="117305.56249749167">117,306 </TD></TR></TABLE>

<P>有什么计算问题,就来问我</P>

tanr

<P>
<TABLE 523pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=695 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3488" width=109>
<COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3360" width=105>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752" width=86>
<COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136" width=98>
<COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" width=84>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392" width=106>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3424" width=107>

<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=109 height=19>归还年数</TD>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 79pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=105>归还金额</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=86>归还利息</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 74pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=98>归还贷款</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 63pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=84>剩余贷款</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=106>归还利息总额</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=107>归还贷款总额</TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 1 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="8425.6051225972751">8,426 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4320">4,320 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4105.6051225972751">4,106 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="115894.39487740272">115,894 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C2" x:num="4320">4,320 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=D2" x:num="4105.6051225972751">4,106 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 2 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="16851.21024519455">16,851 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4172.198215586498">4,172 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4253.4069070107771">4,253 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="111640.98797039194">111,641 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C3+F2" x:num="8492.1982155864971">8,492 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G2+D3" x:num="8359.0120296080531">8,359 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 3 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="25276.815367791824">25,277 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4019.0755669341097">4,019 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4406.5295556631654">4,407 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="107234.45841472878">107,234 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C4+F3" x:num="12511.273782520606">12,511 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G3+D4" x:num="12765.541585271218">12,766 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 4 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="33702.4204903891">33,702 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="3860.4405029302357">3,860 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4565.164619667039">4,565 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="102669.29379506175">102,669 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C5+F4" x:num="16371.714285450842">16,372 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G4+D5" x:num="17330.706204938258">17,331 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 5 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="42128.025612986377">42,128 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="3696.0945766222226">3,696 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4729.5105459750521">4,730 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="97939.7832490867">97,940 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C6+F5" x:num="20067.808862073063">20,068 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G5+D6" x:num="22060.216750913311">22,060 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 6 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="50553.630735583654">50,554 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="3525.832196967121">3,526 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4899.7729256301536">4,900 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="93040.010323456547">93,040 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C7+F6" x:num="23593.641059040183">23,594 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G6+D7" x:num="26959.989676543464">26,960 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 7 年</TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="58979.235858180931">58,979 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="3349.4403716444353">3,349 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="5076.1647509528393">5,076 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="87963.845572503706">87,964 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C8+F7" x:num="26943.081430684619">26,943 </TD>
<TD class=xl26 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G7+D8" x:num="32036.154427496302">32,036 </TD></TR></TABLE></P>

tanr

<TABLE 523pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=695 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3488" width=109>
<COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3360" width=105>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752" width=86>
<COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136" width=98>
<COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" width=84>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392" width=106>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3424" width=107>

<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=109 height=19>第 8 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 79pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=105 x:num="67404.840980778201">67,405 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 65pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=86 x:num="3166.6984406101333">3,167 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 74pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=98 x:num="5258.9066819871423">5,259 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 63pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=84 x:num="82704.938890516569">82,705 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=106 x:num="30109.779871294752">30,110 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 80pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=107 x:num="37295.061109483446">37,295 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 9 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="75830.446103375478">75,830 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2977.3778000585962">2,977 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="5448.2273225386789">5,448 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="77256.711567977894">77,257 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C2+F1" x:num="33087.15767135335">33,087 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G1+D2" x:num="42743.288432022127">42,743 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 10 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="84256.051225972755">84,256 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2781.2416164472038">2,781 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="5644.3635061500718">5,644 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="71612.348061827826">71,612 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C3+F2" x:num="35868.399287800552">35,868 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G2+D3" x:num="48387.651938172203">48,388 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 11 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="92681.656348570032">92,682 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2578.0445302258017">2,578 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="5847.5605923714738">5,848 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="65764.787469456351">65,765 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C4+F3" x:num="38446.443818026353">38,446 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G3+D4" x:num="54235.212530543678">54,235 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 12 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="101107.26147116731">101,107 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2367.5323489004286">2,368 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6058.0727736968465">6,058 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="59706.714695759503">59,707 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C5+F4" x:num="40813.976166926783">40,814 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G4+D5" x:num="60293.285304240526">60,293 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 13 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="109532.86659376459">109,533 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2149.4417290473421">2,149 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6276.1633935499331">6,276 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="53430.551302209569">53,431 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C6+F5" x:num="42963.417895974126">42,963 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G5+D6" x:num="66569.44869779046">66,569 </TD></TR>
<TR 14.25pt" height=19>
<TD class=xl24 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>第 14 年</TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="117958.47171636186">117,958 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1923.4998468795443">1,923 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6502.1052757177313">6,502 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="46928.446026491838">46,928 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=C7+F6" x:num="44886.917742853671">44,887 </TD>
<TD class=xl25 windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=G6+D7" x:num="73071.553973508184">73,072 </TD></TR></TABLE>

tanr

<P>这是我自己编的公式,看能不能解决你的问题</P>
<P>
<TABLE 523pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=695 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3488" width=109>
<COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3360" width=105>
<COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 2752" width=86>
<COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136" width=98>
<COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" width=84>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392" width=106>
<COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3424" width=107>

<TR 14.25pt" height=19>
<TD class=xl24 #ece9d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" width=109 height=19>贷款总数：A＝</TD>
<TD class=xl37 #ece9d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 79pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=105 x:fmla="=E2-E3" x:num="120000">120,000 </TD>
<TD class=xl35 #ece9d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 65pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=86>　</TD>
<TD class=xl35 #ece9d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 74pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=98>房屋售价：</TD>
<TD class=xl28 windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; WIDTH: 63pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=84 x:num="150000"><FONT color=#ff0000>150,000 </FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 80pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=106><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 80pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=107><FONT color=#ff0000></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD class=xl25 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>还款年限：N＝</TD>
<TD class=xl38 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num><FONT color=#ff0000>20</FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">估价：</TD>
<TD class=xl39 windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num="150000"><FONT color=#ff0000>150,000 </FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD class=xl25 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>利息：    i＝</TD>
<TD class=xl40 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num="3.5999999999999997E-2"><FONT color=#ff0000>3.60%</FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">CPF首付：</TD>
<TD class=xl39 windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:num="30000"><FONT color=#ff0000>30,000 </FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD class=xl26 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19>　</TD>
<TD class=xl41 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD>
<TD class=xl36 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">　</TD>
<TD class=xl36 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">现金首付：</TD>
<TD class=xl42 windowtext 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:fmla="=E1-E2" x:num="0"><FONT color=#ff0000>0 </FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19><FONT color=#ff0000></FONT></TD>
<TD #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl30 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT color=#ff0000></FONT></TD></TR>
<TR 11.25pt" height=15>
<TD class=xl32 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" height=15><FONT size=2><STRONG>注：<FONT color=#ff0000>红色</FONT><FONT>为变量，</FONT></STRONG></FONT></TD>
<TD class=xl32 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent; mso-ignore: colspan" colSpan=2><FONT size=2><STRONG>黑色字体为计算量</STRONG></FONT></TD>
<TD class=xl33 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl34 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl33 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl33 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19><FONT size=2><STRONG></STRONG></FONT></TD>
<TD #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"><FONT size=2><STRONG></STRONG></FONT></TD></TR>
<TR 14.25pt" height=19>
<TD class=xl31 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent" height=19><STRONG>每月分期付款：</STRONG></TD>
<TD class=xl27 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" x:fmla="=(POWER(1+B3/12,B2*12)*B3/12)/(POWER(1+B3/12,B2*12)-1)*B1" x:num="702.13376021643955"><STRONG>702 </STRONG></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD>
<TD class=xl29 #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TABLE></P>

逍遥居士

此坛子里能人高手热心人士还是多哦，顶一个