税率更改了，看看我们少交，该交多少了

dazui · 发表于 2006-5-19 11:51:00

<TABLE cellSpacing=0 cellPadding=0 width=737 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2464" width=77>
<COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552" width=111>
<COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2048" width=64>
<COL style="WIDTH: 310pt; mso-width-source: userset; mso-width-alt: 13216" width=413>
<COL style="WIDTH: 54pt" width=72>

<TR height=16>
<TD class=xl24 width=77 height=16>　</TD>
<TD class=xl24 width=111>个人缴纳</TD>
<TD class=xl24 width=64>单位缴纳</TD>
<TD class=xl27 width=413></TD>
<TD class=xl27 width=72></TD></TR>
<TR height=16>
<TD class=xl24 height=16>养老保险金</TD>
<TD class=xl25 align=right x:num="00.08">8%</TD>
<TD class=xl26 align=right x:num="0.22500000000000001">22.50%</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl24 height=16>医疗保险金</TD>
<TD class=xl25 align=right x:num="00.02">2%</TD>
<TD class=xl25 align=right x:num="00.12">12%</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl24 height=16>失业保险金</TD>
<TD class=xl25 align=right x:num="00.01">1%</TD>
<TD class=xl25 align=right x:num="00.02">2%</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl24 height=16>住房公积金</TD>
<TD class=xl25 align=right x:num="00.07">7%</TD>
<TD class=xl25 align=right x:num="00.07">7%</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl24 height=16>合计</TD>
<TD class=xl25 align=right x:num="00.18" x:fmla="=SUM(B2:B5)">18%</TD>
<TD class=xl26 align=right x:num="0.435" x:fmla="=SUM(C2:C5)">43.50%</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl24 colSpan=3 height=16>注：上海为最低缴纳1108，最高缴纳6609</TD>
<TD class=xl27 ></TD>
<TD class=xl27 ></TD></TR>
<TR height=16>
<TD class=xl27 height=16></TD>
<TD class=xl27 ></TD>
<TD class=xl27 align=right x:num>2033.33</TD>
<TD class=xl27 align=right x:num>4000</TD>
<TD class=xl27 ></TD></TR></TABLE>

dazui · 发表于 2006-5-19 12:28:00

<TABLE cellSpacing=0 cellPadding=0 width=747 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 54pt" width=72>
<COL style="WIDTH: 168pt; mso-width-source: userset; mso-width-alt: 7168" width=224>
<COL style="WIDTH: 187pt; mso-width-source: userset; mso-width-alt: 7968" width=249>
<COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1536" width=48>
<COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2624" width=82>
<COL style="WIDTH: 54pt" width=72>

<TR height=16>
<TD class=xl27 width=72 height=16>级数</TD>
<TD class=xl28 width=224>全月应纳税所得额(含税所得额)</TD>
<TD class=xl28 width=249>全月应纳税所得额 (不含税所得额)</TD>
<TD class=xl27 width=48>税率%</TD>
<TD class=xl27 width=82>速算扣除数</TD>
<TD class=xl29 align=right width=72 x:num>0</TD></TR>
<TR height=16>
<TD class=xl27 height=16>　</TD>
<TD class=xl28 >　</TD>
<TD class=xl28 >　</TD>
<TD class=xl27 x:num>0</TD>
<TD class=xl27 >　</TD>
<TD class=xl29 align=right x:num>0</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>1</TD>
<TD class=xl26 >不超过500元的</TD>
<TD class=xl26 >不超过475元的</TD>
<TD class=xl25 x:num>5</TD>
<TD class=xl25 x:num>0</TD>
<TD class=xl24 align=right x:num>0</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>2</TD>
<TD class=xl26 >超过500元至2000元的部分</TD>
<TD class=xl26 >超过475元至1825元的部分</TD>
<TD class=xl25 x:num>10</TD>
<TD class=xl25 x:num>25</TD>
<TD class=xl24 align=right x:num>500</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>3</TD>
<TD class=xl26 >超过2000元至5000元的部分</TD>
<TD class=xl26 >超过1825元至4375元的部分</TD>
<TD class=xl25 x:num>15</TD>
<TD class=xl25 x:num>125</TD>
<TD class=xl24 align=right x:num>2000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>4</TD>
<TD class=xl26 >超过5000元至20000元的部分</TD>
<TD class=xl26 >超过4375元至16375元的部分</TD>
<TD class=xl25 x:num>20</TD>
<TD class=xl25 x:num>375</TD>
<TD class=xl24 align=right x:num>5000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>5</TD>
<TD class=xl26 >超过20000元至40000元的部分</TD>
<TD class=xl26 >超过16375元至31375元的部分</TD>
<TD class=xl25 x:num>25</TD>
<TD class=xl25 x:num>1375</TD>
<TD class=xl24 align=right x:num>20000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>6</TD>
<TD class=xl26 >超过40000元至60000元的部分</TD>
<TD class=xl26 >超过31375元至45375元的部分</TD>
<TD class=xl25 x:num>30</TD>
<TD class=xl25 x:num>3375</TD>
<TD class=xl24 align=right x:num>40000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>7</TD>
<TD class=xl26 >超过60000元至80000元的部分</TD>
<TD class=xl26 >超过45375元至58375元的部分</TD>
<TD class=xl25 x:num>35</TD>
<TD class=xl25 x:num>6375</TD>
<TD class=xl24 align=right x:num>60000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>8</TD>
<TD class=xl26 >超过80000元至100000元的部分</TD>
<TD class=xl26 >超过58375元至70375元的部分</TD>
<TD class=xl25 x:num>40</TD>
<TD class=xl25 x:num>10375</TD>
<TD class=xl24 align=right x:num>80000</TD></TR>
<TR height=16>
<TD class=xl25 height=16 x:num>9</TD>
<TD class=xl26 >超过100000元的部分</TD>
<TD class=xl26 >超过70375元的部分</TD>
<TD class=xl25 x:num>45</TD>
<TD class=xl25 x:num>15375</TD>
<TD class=xl24 align=right x:num>100000</TD></TR>
<TR height=16>
<TD class=xl24 height=16></TD>
<TD class=xl24 ></TD>
<TD class=xl24 ></TD>
<TD class=xl24 ></TD>
<TD class=xl24 ></TD>
<TD class=xl24 align=right x:num>1000000</TD></TR>
<TR height=16>
<TD class=xl30 height=16>(注)：1、</TD>
<TD class=xl31 colSpan=4>应纳税所得额是指依照税法第六条规定,以每月收入额减除费用。</TD>
<TD class=xl24 ></TD></TR>
<TR height=16>
<TD class=xl30 height=16>2、</TD>
<TD class=xl31 colSpan=4>1300元(外籍个人4000元)后的余额或者减除附加费用后的余额。</TD>
<TD class=xl24 ></TD></TR>
<TR height=16>
<TD class=xl31 height=16>　</TD>
<TD class=xl31 colSpan=4>不含税所得额是指他人(单位)代税款的工资,薪金所得。</TD>
<TD class=xl24 ></TD></TR>
<TR height=16>
<TD class=xl30 height=16>3、</TD>
<TD class=xl31 colSpan=4>应交个人所得税的计算公式:应交个人所得税=应纳税所得额X适用税率-速算扣除数</TD>
<TD class=xl24 ></TD></TR></TABLE>

dazui · 发表于 2006-5-19 12:31:00

<TABLE cellSpacing=0 cellPadding=0 width=936 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 54pt" span=13 width=72>

<TR height=45>
<TD class=xl47 width=72 height=45>税前工资</TD>
<TD class=xl34 width=72>四金基数</TD>
<TD class=xl35 width=72>养老保险</TD>
<TD class=xl35 width=72>医疗保险</TD>
<TD class=xl35 width=72>失业保险</TD>
<TD class=xl35 width=72>公积金</TD>
<TD class=xl35 width=72>四金总和</TD>
<TD class=xl35 width=72>扣除四金后所得</TD>
<TD class=xl35 width=72>全月应纳税所得额(含税)</TD>
<TD class=xl36 width=72>个税税率</TD>
<TD class=xl36 width=72>每月应交税款</TD>
<TD class=xl37 width=72>每月到手余额</TD>
<TD class=xl38 width=72>实际到手比例</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="500">￥500.0</TD>
<TD class=xl24 align=right x:num="1219.9979999999998">￥1,220.0</TD>
<TD class=xl25 align=right x:num="97.599839999999986" x:fmla="=B2*0.08">￥97.6 </TD>
<TD class=xl25 align=right x:num="24.399959999999997" x:fmla="=B2*2%">￥24.4 </TD>
<TD class=xl25 align=right x:num="12.199979999999998" x:fmla="=B2*1%">￥12.2 </TD>
<TD class=xl25 align=right x:num="85.39985999999999" x:fmla="=B2*7%">￥85.4 </TD>
<TD class=xl25 align=right x:num="219.59963999999997" x:fmla="=SUM(C2:F2)">￥219.6 </TD>
<TD class=xl25 align=right x:num="280.40036000000003" x:fmla="=A2-G2">￥280.4 </TD>
<TD class=xl25 align=right x:num="0" x:fmla="=IF(H2>1000,H2-1000,0)">￥0.0 </TD>
<TD class=xl26 align=right x:num="00.05">5%</TD>
<TD class=xl24 align=right x:num="0">￥0.0</TD>
<TD class=xl27 align=right x:num="280.40036000000003" x:fmla="=H2-K2">￥280.40</TD>
<TD class=xl39 align=right x:num="0.56080072000000003" x:fmla="=L2/A2">56.08%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="1000">￥1,000.0</TD>
<TD class=xl24 align=right x:num="1219.9979999999998">￥1,220.0</TD>
<TD class=xl25 align=right x:num="97.599839999999986" x:fmla="=B3*0.08">￥97.6 </TD>
<TD class=xl25 align=right x:num="24.399959999999997" x:fmla="=B3*2%">￥24.4 </TD>
<TD class=xl25 align=right x:num="12.199979999999998" x:fmla="=B3*1%">￥12.2 </TD>
<TD class=xl25 align=right x:num="85.39985999999999" x:fmla="=B3*7%">￥85.4 </TD>
<TD class=xl25 align=right x:num="219.59963999999997" x:fmla="=SUM(C3:F3)">￥219.6 </TD>
<TD class=xl25 align=right x:num="780.40036000000009" x:fmla="=A3-G3">￥780.4 </TD>
<TD class=xl25 align=right x:num="0" x:fmla="=IF(H3>1000,H3-1000,0)">￥0.0 </TD>
<TD class=xl26 align=right x:num="00.05">5%</TD>
<TD class=xl24 align=right x:num="0">￥0.0</TD>
<TD class=xl27 align=right x:num="780.40036000000009" x:fmla="=H3-K3">￥780.40</TD>
<TD class=xl39 align=right x:num="0.78040036000000013" x:fmla="=L3/A3">78.04%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="1500">￥1,500.0</TD>
<TD class=xl28 align=right x:num="1500">￥1,500.0</TD>
<TD class=xl29 align=right x:num="120" x:fmla="=B4*0.08">￥120.0 </TD>
<TD class=xl29 align=right x:num="30" x:fmla="=B4*2%">￥30.0 </TD>
<TD class=xl29 align=right x:num="15" x:fmla="=B4*1%">￥15.0 </TD>
<TD class=xl29 align=right x:num="105" x:fmla="=B4*7%">￥105.0 </TD>
<TD class=xl29 align=right x:num="270" x:fmla="=SUM(C4:F4)">￥270.0 </TD>
<TD class=xl29 align=right x:num="1230" x:fmla="=A4-G4">￥1,230.0 </TD>
<TD class=xl29 align=right x:num="230" x:fmla="=IF(H4>1000,H4-1000,0)">￥230.0 </TD>
<TD class=xl30 align=right x:num="00.05">5%</TD>
<TD class=xl28 align=right x:num="11.5">￥11.5</TD>
<TD class=xl27 align=right x:num="1218.5" x:fmla="=H4-K4">￥1,218.50</TD>
<TD class=xl40 align=right x:num="0.81233333333333335" x:fmla="=L4/A4">81.23%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="2000">￥2,000.0</TD>
<TD class=xl24 align=right x:num="2000">￥2,000.0</TD>
<TD class=xl25 align=right x:num="160" x:fmla="=B5*0.08">￥160.0 </TD>
<TD class=xl25 align=right x:num="40" x:fmla="=B5*2%">￥40.0 </TD>
<TD class=xl25 align=right x:num="20" x:fmla="=B5*1%">￥20.0 </TD>
<TD class=xl25 align=right x:num="140" x:fmla="=B5*7%">￥140.0 </TD>
<TD class=xl25 align=right x:num="360" x:fmla="=SUM(C5:F5)">￥360.0 </TD>
<TD class=xl25 align=right x:num="1640" x:fmla="=A5-G5">￥1,640.0 </TD>
<TD class=xl25 align=right x:num="640" x:fmla="=IF(H5>1000,H5-1000,0)">￥640.0 </TD>
<TD class=xl26 align=right x:num="00.1">10%</TD>
<TD class=xl24 align=right x:num="39">￥39.0</TD>
<TD class=xl27 align=right x:num="1601" x:fmla="=H5-K5">￥1,601.00</TD>
<TD class=xl39 align=right x:num="0.80049999999999999" x:fmla="=L5/A5">80.05%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="2500">￥2,500.0</TD>
<TD class=xl24 align=right x:num="2500">￥2,500.0</TD>
<TD class=xl25 align=right x:num="200" x:fmla="=B6*0.08">￥200.0 </TD>
<TD class=xl25 align=right x:num="50" x:fmla="=B6*2%">￥50.0 </TD>
<TD class=xl25 align=right x:num="25" x:fmla="=B6*1%">￥25.0 </TD>
<TD class=xl25 align=right x:num="175" x:fmla="=B6*7%">￥175.0 </TD>
<TD class=xl25 align=right x:num="450" x:fmla="=SUM(C6:F6)">￥450.0 </TD>
<TD class=xl25 align=right x:num="2050" x:fmla="=A6-G6">￥2,050.0 </TD>
<TD class=xl25 align=right x:num="1050" x:fmla="=IF(H6>1000,H6-1000,0)">￥1,050.0 </TD>
<TD class=xl26 align=right x:num="00.1">10%</TD>
<TD class=xl24 align=right x:num="80">￥80.0</TD>
<TD class=xl27 align=right x:num="1970" x:fmla="=H6-K6">￥1,970.00</TD>
<TD class=xl39 align=right x:num="0.78800000000000003" x:fmla="=L6/A6">78.80%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="3000">￥3,000.0</TD>
<TD class=xl24 align=right x:num="3000">￥3,000.0</TD>
<TD class=xl25 align=right x:num="240" x:fmla="=B7*0.08">￥240.0 </TD>
<TD class=xl25 align=right x:num="60" x:fmla="=B7*2%">￥60.0 </TD>
<TD class=xl25 align=right x:num="30" x:fmla="=B7*1%">￥30.0 </TD>
<TD class=xl25 align=right x:num="210" x:fmla="=B7*7%">￥210.0 </TD>
<TD class=xl25 align=right x:num="540" x:fmla="=SUM(C7:F7)">￥540.0 </TD>
<TD class=xl25 align=right x:num="2460" x:fmla="=A7-G7">￥2,460.0 </TD>
<TD class=xl25 align=right x:num="1460" x:fmla="=IF(H7>1000,H7-1000,0)">￥1,460.0 </TD>
<TD class=xl26 align=right x:num="00.1">10%</TD>
<TD class=xl24 align=right x:num="121">￥121.0</TD>
<TD class=xl27 align=right x:num="2339" x:fmla="=H7-K7">￥2,339.00</TD>
<TD class=xl39 align=right x:num="0.77966666666666662" x:fmla="=L7/A7">77.97%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="3500">￥3,500.0</TD>
<TD class=xl31 align=right x:num="3500">￥3,500.0</TD>
<TD class=xl32 align=right x:num="280" x:fmla="=B8*0.08">￥280.0 </TD>
<TD class=xl32 align=right x:num="70" x:fmla="=B8*2%">￥70.0 </TD>
<TD class=xl32 align=right x:num="35" x:fmla="=B8*1%">￥35.0 </TD>
<TD class=xl32 align=right x:num="245" x:fmla="=B8*7%">￥245.0 </TD>
<TD class=xl32 align=right x:num="630" x:fmla="=SUM(C8:F8)">￥630.0 </TD>
<TD class=xl32 align=right x:num="2870" x:fmla="=A8-G8">￥2,870.0 </TD>
<TD class=xl32 align=right x:num="1870" x:fmla="=IF(H8>1000,H8-1000,0)">￥1,870.0 </TD>
<TD class=xl33 align=right x:num="00.1">10%</TD>
<TD class=xl31 align=right x:num="162">￥162.0</TD>
<TD class=xl27 align=right x:num="2708" x:fmla="=H8-K8">￥2,708.00</TD>
<TD class=xl41 align=right x:num="0.77371428571428569" x:fmla="=L8/A8">77.37%</TD></TR>
<TR height=19>
<TD class=xl49 height=19 x:num="4000">￥4,000.0</TD>
<TD class=xl24 align=right x:num="4000">￥4,000.0</TD>
<TD class=xl25 align=right x:num="320" x:fmla="=B9*0.08">￥320.0 </TD>
<TD class=xl25 align=right x:num="80" x:fmla="=B9*2%">￥80.0 </TD>
<TD class=xl25 align=right x:num="40" x:fmla="=B9*1%">￥40.0 </TD>
<TD class=xl25 align=right x:num="280" x:fmla="=B9*7%">￥280.0 </TD>
<TD class=xl25 align=right x:num="720" x:fmla="=SUM(C9:F9)">￥720.0 </TD>
<TD class=xl25 align=right x:num="3280" x:fmla="=A9-G9">￥3,280.0 </TD>
<TD class=xl25 align=right x:num="2280" x:fmla="=IF(H9>1000,H9-1000,0)">￥2,280.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="217">￥217.0</TD>
<TD class=xl27 align=right x:num="3063" x:fmla="=H9-K9">￥3,063.00</TD>
<TD class=xl39 align=right x:num="0.76575000000000004" x:fmla="=L9/A9">76.58%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="4500">￥4,500.0</TD>
<TD class=xl24 align=right x:num="4500">￥4,500.0</TD>
<TD class=xl25 align=right x:num="360" x:fmla="=B10*0.08">￥360.0 </TD>
<TD class=xl25 align=right x:num="90" x:fmla="=B10*2%">￥90.0 </TD>
<TD class=xl25 align=right x:num="45" x:fmla="=B10*1%">￥45.0 </TD>
<TD class=xl25 align=right x:num="315" x:fmla="=B10*7%">￥315.0 </TD>
<TD class=xl25 align=right x:num="810" x:fmla="=SUM(C10:F10)">￥810.0 </TD>
<TD class=xl25 align=right x:num="3690" x:fmla="=A10-G10">￥3,690.0 </TD>
<TD class=xl25 align=right x:num="2690" x:fmla="=IF(H10>1000,H10-1000,0)">￥2,690.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="278.5">￥278.5</TD>
<TD class=xl27 align=right x:num="3411.5" x:fmla="=H10-K10">￥3,411.50</TD>
<TD class=xl39 align=right x:num="0.75811111111111107" x:fmla="=L10/A10">75.81%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="5000">￥5,000.0</TD>
<TD class=xl24 align=right x:num="5000">￥5,000.0</TD>
<TD class=xl25 align=right x:num="400" x:fmla="=B11*0.08">￥400.0 </TD>
<TD class=xl25 align=right x:num="100" x:fmla="=B11*2%">￥100.0 </TD>
<TD class=xl25 align=right x:num="50" x:fmla="=B11*1%">￥50.0 </TD>
<TD class=xl25 align=right x:num="350" x:fmla="=B11*7%">￥350.0 </TD>
<TD class=xl25 align=right x:num="900" x:fmla="=SUM(C11:F11)">￥900.0 </TD>
<TD class=xl25 align=right x:num="4100" x:fmla="=A11-G11">￥4,100.0 </TD>
<TD class=xl25 align=right x:num="3100" x:fmla="=IF(H11>1000,H11-1000,0)">￥3,100.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="340">￥340.0</TD>
<TD class=xl27 align=right x:num="3760" x:fmla="=H11-K11">￥3,760.00</TD>
<TD class=xl39 align=right x:num="0.752" x:fmla="=L11/A11">75.20%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="5500">￥5,500.0</TD>
<TD class=xl24 align=right x:num="5500">￥5,500.0</TD>
<TD class=xl25 align=right x:num="440" x:fmla="=B12*0.08">￥440.0 </TD>
<TD class=xl25 align=right x:num="110" x:fmla="=B12*2%">￥110.0 </TD>
<TD class=xl25 align=right x:num="55" x:fmla="=B12*1%">￥55.0 </TD>
<TD class=xl25 align=right x:num="385" x:fmla="=B12*7%">￥385.0 </TD>
<TD class=xl25 align=right x:num="990" x:fmla="=SUM(C12:F12)">￥990.0 </TD>
<TD class=xl25 align=right x:num="4510" x:fmla="=A12-G12">￥4,510.0 </TD>
<TD class=xl25 align=right x:num="3510" x:fmla="=IF(H12>1000,H12-1000,0)">￥3,510.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="401.5">￥401.5</TD>
<TD class=xl27 align=right x:num="4108.5" x:fmla="=H12-K12">￥4,108.50</TD>
<TD class=xl39 align=right x:num="0.747" x:fmla="=L12/A12">74.70%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="6000">￥6,000.0</TD>
<TD class=xl24 align=right x:num="6000">￥6,000.0</TD>
<TD class=xl25 align=right x:num="480" x:fmla="=B13*0.08">￥480.0 </TD>
<TD class=xl25 align=right x:num="120" x:fmla="=B13*2%">￥120.0 </TD>
<TD class=xl25 align=right x:num="60" x:fmla="=B13*1%">￥60.0 </TD>
<TD class=xl25 align=right x:num="420" x:fmla="=B13*7%">￥420.0 </TD>
<TD class=xl25 align=right x:num="1080" x:fmla="=SUM(C13:F13)">￥1,080.0 </TD>
<TD class=xl25 align=right x:num="4920" x:fmla="=A13-G13">￥4,920.0 </TD>
<TD class=xl25 align=right x:num="3920" x:fmla="=IF(H13>1000,H13-1000,0)">￥3,920.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="463">￥463.0</TD>
<TD class=xl27 align=right x:num="4457" x:fmla="=H13-K13">￥4,457.00</TD>
<TD class=xl39 align=right x:num="0.74283333333333335" x:fmla="=L13/A13">74.28%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="6500">￥6,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B14*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B14*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B14*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B14*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C14:F14)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="5402.0018" x:fmla="=A14-G14">￥5,402.0 </TD>
<TD class=xl25 align=right x:num="4402.0018" x:fmla="=IF(H14>1000,H14-1000,0)">￥4,402.0 </TD>
<TD class=xl26 align=right x:num="00.15">15%</TD>
<TD class=xl24 align=right x:num="535.30026999999995">￥535.3</TD>
<TD class=xl27 align=right x:num="4866.7015300000003" x:fmla="=H14-K14">￥4,866.70</TD>
<TD class=xl39 align=right x:num="0.7487233123076924" x:fmla="=L14/A14">74.87%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="7000">￥7,000.0</TD>
<TD class=xl28 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl29 align=right x:num="487.99919999999997" x:fmla="=B15*0.08">￥488.0 </TD>
<TD class=xl29 align=right x:num="121.99979999999999" x:fmla="=B15*2%">￥122.0 </TD>
<TD class=xl29 align=right x:num="60.999899999999997" x:fmla="=B15*1%">￥61.0 </TD>
<TD class=xl29 align=right x:num="426.99930000000001" x:fmla="=B15*7%">￥427.0 </TD>
<TD class=xl29 align=right x:num="1097.9982" x:fmla="=SUM(C15:F15)">￥1,098.0 </TD>
<TD class=xl29 align=right x:num="5902.0018" x:fmla="=A15-G15">￥5,902.0 </TD>
<TD class=xl29 align=right x:num="4902.0018" x:fmla="=IF(H15>1000,H15-1000,0)">￥4,902.0 </TD>
<TD class=xl30 align=right x:num="00.15">15%</TD>
<TD class=xl28 align=right x:num="610.30026999999995">￥610.3</TD>
<TD class=xl27 align=right x:num="5291.7015300000003" x:fmla="=H15-K15">￥5,291.70</TD>
<TD class=xl40 align=right x:num="0.75595736142857151" x:fmla="=L15/A15">75.60%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="7500">￥7,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B16*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B16*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B16*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B16*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C16:F16)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="6402.0018" x:fmla="=A16-G16">￥6,402.0 </TD>
<TD class=xl25 align=right x:num="5402.0018" x:fmla="=IF(H16>1000,H16-1000,0)">￥5,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="705.40036000000009">￥705.4</TD>
<TD class=xl27 align=right x:num="5696.6014400000004" x:fmla="=H16-K16">￥5,696.60</TD>
<TD class=xl39 align=right x:num="0.75954685866666671" x:fmla="=L16/A16">75.95%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="8000">￥8,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B17*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B17*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B17*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B17*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C17:F17)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="6902.0018" x:fmla="=A17-G17">￥6,902.0 </TD>
<TD class=xl25 align=right x:num="5902.0018" x:fmla="=IF(H17>1000,H17-1000,0)">￥5,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="805.40036000000009">￥805.4</TD>
<TD class=xl27 align=right x:num="6096.6014400000004" x:fmla="=H17-K17">￥6,096.60</TD>
<TD class=xl39 align=right x:num="0.76207518000000007" x:fmla="=L17/A17">76.21%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="8500">￥8,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B18*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B18*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B18*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B18*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C18:F18)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="7402.0018" x:fmla="=A18-G18">￥7,402.0 </TD>
<TD class=xl25 align=right x:num="6402.0018" x:fmla="=IF(H18>1000,H18-1000,0)">￥6,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="905.40036000000009">￥905.4</TD>
<TD class=xl27 align=right x:num="6496.6014400000004" x:fmla="=H18-K18">￥6,496.60</TD>
<TD class=xl39 align=right x:num="0.7643060517647059" x:fmla="=L18/A18">76.43%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="9000">￥9,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B19*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B19*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B19*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B19*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C19:F19)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="7902.0018" x:fmla="=A19-G19">￥7,902.0 </TD>
<TD class=xl25 align=right x:num="6902.0018" x:fmla="=IF(H19>1000,H19-1000,0)">￥6,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1005.4003600000001">￥1,005.4</TD>
<TD class=xl27 align=right x:num="6896.6014400000004" x:fmla="=H19-K19">￥6,896.60</TD>
<TD class=xl39 align=right x:num="0.76628904888888894" x:fmla="=L19/A19">76.63%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="9500">￥9,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B20*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B20*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B20*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B20*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C20:F20)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="8402.0018" x:fmla="=A20-G20">￥8,402.0 </TD>
<TD class=xl25 align=right x:num="7402.0018" x:fmla="=IF(H20>1000,H20-1000,0)">￥7,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1105.4003600000001">￥1,105.4</TD>
<TD class=xl27 align=right x:num="7296.6014400000004" x:fmla="=H20-K20">￥7,296.60</TD>
<TD class=xl39 align=right x:num="0.76806330947368429" x:fmla="=L20/A20">76.81%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="10000">￥10,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B21*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B21*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B21*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B21*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C21:F21)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="8902.0018" x:fmla="=A21-G21">￥8,902.0 </TD>
<TD class=xl25 align=right x:num="7902.0018" x:fmla="=IF(H21>1000,H21-1000,0)">￥7,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1205.4003600000001">￥1,205.4</TD>
<TD class=xl27 align=right x:num="7696.6014400000004" x:fmla="=H21-K21">￥7,696.60</TD>
<TD class=xl39 align=right x:num="0.76966014400000005" x:fmla="=L21/A21">76.97%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="10500">￥10,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B22*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B22*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B22*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B22*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C22:F22)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="9402.0018" x:fmla="=A22-G22">￥9,402.0 </TD>
<TD class=xl25 align=right x:num="8402.0018" x:fmla="=IF(H22>1000,H22-1000,0)">￥8,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1305.4003600000001">￥1,305.4</TD>
<TD class=xl27 align=right x:num="8096.6014400000004" x:fmla="=H22-K22">￥8,096.60</TD>
<TD class=xl39 align=right x:num="0.77110489904761903" x:fmla="=L22/A22">77.11%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="11000">￥11,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B23*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B23*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B23*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B23*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C23:F23)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="9902.0018" x:fmla="=A23-G23">￥9,902.0 </TD>
<TD class=xl25 align=right x:num="8902.0018" x:fmla="=IF(H23>1000,H23-1000,0)">￥8,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1405.4003600000001">￥1,405.4</TD>
<TD class=xl27 align=right x:num="8496.6014400000004" x:fmla="=H23-K23">￥8,496.60</TD>
<TD class=xl39 align=right x:num="0.77241831272727279" x:fmla="=L23/A23">77.24%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="11500">￥11,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B24*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B24*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B24*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B24*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C24:F24)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="10402.0018" x:fmla="=A24-G24">￥10,402.0 </TD>
<TD class=xl25 align=right x:num="9402.0018" x:fmla="=IF(H24>1000,H24-1000,0)">￥9,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1505.4003600000001" x:fmla="=I24*J24-375">￥1,505.4</TD>
<TD class=xl27 align=right x:num="8896.6014400000004" x:fmla="=H24-K24">￥8,896.60</TD>
<TD class=xl39 align=right x:num="0.77361751652173916" x:fmla="=L24/A24">77.36%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="12000">￥12,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B25*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B25*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B25*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B25*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C25:F25)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="10902.0018" x:fmla="=A25-G25">￥10,902.0 </TD>
<TD class=xl25 align=right x:num="9902.0018" x:fmla="=IF(H25>1000,H25-1000,0)">￥9,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1605.4003600000001">￥1,605.4</TD>
<TD class=xl27 align=right x:num="9296.6014400000004" x:fmla="=H25-K25">￥9,296.60</TD>
<TD class=xl39 align=right x:num="0.77471678666666666" x:fmla="=L25/A25">77.47%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="12500">￥12,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B26*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B26*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B26*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B26*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C26:F26)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="11402.0018" x:fmla="=A26-G26">￥11,402.0 </TD>
<TD class=xl25 align=right x:num="10402.0018" x:fmla="=IF(H26>1000,H26-1000,0)">￥10,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1705.4003600000001">￥1,705.4</TD>
<TD class=xl27 align=right x:num="9696.6014400000004" x:fmla="=H26-K26">￥9,696.60</TD>
<TD class=xl39 align=right x:num="0.77572811520000007" x:fmla="=L26/A26">77.57%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="13000">￥13,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B27*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B27*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B27*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B27*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C27:F27)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="11902.0018" x:fmla="=A27-G27">￥11,902.0 </TD>
<TD class=xl25 align=right x:num="10902.0018" x:fmla="=IF(H27>1000,H27-1000,0)">￥10,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1805.4003600000001">￥1,805.4</TD>
<TD class=xl27 align=right x:num="10096.60144" x:fmla="=H27-K27">￥10,096.60</TD>
<TD class=xl39 align=right x:num="0.7766616492307693" x:fmla="=L27/A27">77.67%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="13500">￥13,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B28*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B28*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B28*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B28*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C28:F28)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="12402.0018" x:fmla="=A28-G28">￥12,402.0 </TD>
<TD class=xl25 align=right x:num="11402.0018" x:fmla="=IF(H28>1000,H28-1000,0)">￥11,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="1905.4003600000001">￥1,905.4</TD>
<TD class=xl27 align=right x:num="10496.60144" x:fmla="=H28-K28">￥10,496.60</TD>
<TD class=xl39 align=right x:num="0.77752603259259256" x:fmla="=L28/A28">77.75%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="14000">￥14,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B29*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B29*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B29*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B29*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C29:F29)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="12902.0018" x:fmla="=A29-G29">￥12,902.0 </TD>
<TD class=xl25 align=right x:num="11902.0018" x:fmla="=IF(H29>1000,H29-1000,0)">￥11,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="2005.4003600000001">￥2,005.4</TD>
<TD class=xl27 align=right x:num="10896.60144" x:fmla="=H29-K29">￥10,896.60</TD>
<TD class=xl39 align=right x:num="0.77832867428571428" x:fmla="=L29/A29">77.83%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="14500">￥14,500.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B30*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B30*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B30*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B30*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C30:F30)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="13402.0018" x:fmla="=A30-G30">￥13,402.0 </TD>
<TD class=xl25 align=right x:num="12402.0018" x:fmla="=IF(H30>1000,H30-1000,0)">￥12,402.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="2105.4003600000001">￥2,105.4</TD>
<TD class=xl27 align=right x:num="11296.60144" x:fmla="=H30-K30">￥11,296.60</TD>
<TD class=xl39 align=right x:num="0.77907596137931034" x:fmla="=L30/A30">77.91%</TD></TR>
<TR height=19>
<TD class=xl48 align=right height=19 x:num="15000">￥15,000.0</TD>
<TD class=xl24 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl25 align=right x:num="487.99919999999997" x:fmla="=B31*0.08">￥488.0 </TD>
<TD class=xl25 align=right x:num="121.99979999999999" x:fmla="=B31*2%">￥122.0 </TD>
<TD class=xl25 align=right x:num="60.999899999999997" x:fmla="=B31*1%">￥61.0 </TD>
<TD class=xl25 align=right x:num="426.99930000000001" x:fmla="=B31*7%">￥427.0 </TD>
<TD class=xl25 align=right x:num="1097.9982" x:fmla="=SUM(C31:F31)">￥1,098.0 </TD>
<TD class=xl25 align=right x:num="13902.0018" x:fmla="=A31-G31">￥13,902.0 </TD>
<TD class=xl25 align=right x:num="12902.0018" x:fmla="=IF(H31>1000,H31-1000,0)">￥12,902.0 </TD>
<TD class=xl26 align=right x:num="00.2">20%</TD>
<TD class=xl24 align=right x:num="2205.4003600000001">￥2,205.4</TD>
<TD class=xl27 align=right x:num="11696.60144" x:fmla="=H31-K31">￥11,696.60</TD>
<TD class=xl39 align=right x:num="0.77977342933333338" x:fmla="=L31/A31">77.98%</TD></TR>
<TR height=20>
<TD class=xl50 align=right height=20 x:num="20000">￥20,000.0</TD>
<TD class=xl42 align=right x:num="6099.99">￥6,100.0</TD>
<TD class=xl43 align=right x:num="487.99919999999997" x:fmla="=B32*0.08">￥488.0 </TD>
<TD class=xl43 align=right x:num="121.99979999999999" x:fmla="=B32*2%">￥122.0 </TD>
<TD class=xl43 align=right x:num="60.999899999999997" x:fmla="=B32*1%">￥61.0 </TD>
<TD class=xl43 align=right x:num="426.99930000000001" x:fmla="=B32*7%">￥427.0 </TD>
<TD class=xl43 align=right x:num="1097.9982" x:fmla="=SUM(C32:F32)">￥1,098.0 </TD>
<TD class=xl43 align=right x:num="18902.001799999998" x:fmla="=A32-G32">￥18,902.0 </TD>
<TD class=xl43 align=right x:num="17902.001799999998" x:fmla="=IF(H32>1000,H32-1000,0)">￥17,902.0 </TD>
<TD class=xl44 align=right x:num="00.2">20%</TD>
<TD class=xl42 align=right x:num="3205.4003599999996">￥3,205.4</TD>
<TD class=xl45 align=right x:num="15696.601439999999" x:fmla="=H32-K32">￥15,696.60</TD>
<TD class=xl46 align=right x:num="0.78483007199999988" x:fmla="=L32/A32">78.48%</TD></TR></TABLE>

dazui · 发表于 2006-5-19 12:32:00

hualinpan · 发表于 2006-5-22 21:32:00

感谢楼主！！

laylay · 发表于 2006-6-26 09:44:00

大家都看看吧

		自动登录	找回密码
密码			注册