|
老贵,我的计算对不对?其中税款随每月付,当月付款包括在计息本金中。
Loan=Caps($21000)+Taxs(14.5%: $3045.00 ) = $24045, Months=36
Rate/Year=2.8%, Rate/Month=0.2333333%
Install/Month=667.92 , Last Month=667.80
-------------------------------------------------------------------------------------
Month= 1, Cap_paid=667.92 , Cap_for_Int=24045.00, Int=56.11
Month= 2, Cap_paid=1335.84 , Cap_for_Int=23377.08, Int=54.55
Month= 3, Cap_paid=2003.76 , Cap_for_Int=22709.16, Int=52.99
Month= 4, Cap_paid=2671.68 , Cap_for_Int=22041.24, Int=51.43
Month= 5, Cap_paid=3339.60 , Cap_for_Int=21373.32, Int=49.87
Month= 6, Cap_paid=4007.52 , Cap_for_Int=20705.40, Int=48.31
Month= 7, Cap_paid=4675.44 , Cap_for_Int=20037.48, Int=46.75
Month= 8, Cap_paid=5343.36 , Cap_for_Int=19369.56, Int=45.20
Month= 9, Cap_paid=6011.28 , Cap_for_Int=18701.64, Int=43.64
Month= 10, Cap_paid=6679.20 , Cap_for_Int=18033.72, Int=42.08
Month= 11, Cap_paid=7347.12 , Cap_for_Int=17365.80, Int=40.52
Month= 12, Cap_paid=8015.04 , Cap_for_Int=16697.88, Int=38.96
Month= 13, Cap_paid=8682.96 , Cap_for_Int=16029.96, Int=37.40
Month= 14, Cap_paid=9350.88 , Cap_for_Int=15362.04, Int=35.84
Month= 15, Cap_paid=10018.80, Cap_for_Int=14694.12, Int=34.29
Month= 16, Cap_paid=10686.72, Cap_for_Int=14026.20, Int=32.73
Month= 17, Cap_paid=11354.64, Cap_for_Int=13358.28, Int=31.17
Month= 18, Cap_paid=12022.56, Cap_for_Int=12690.36, Int=29.61
Month= 19, Cap_paid=12690.48, Cap_for_Int=12022.44, Int=28.05
Month= 20, Cap_paid=13358.40, Cap_for_Int=11354.52, Int=26.49
Month= 21, Cap_paid=14026.32, Cap_for_Int=10686.60, Int=24.94
Month= 22, Cap_paid=14694.24, Cap_for_Int=10018.68, Int=23.38
Month= 23, Cap_paid=15362.16, Cap_for_Int=9350.76 , Int=21.82
Month= 24, Cap_paid=16030.08, Cap_for_Int=8682.84 , Int=20.26
Month= 25, Cap_paid=16698.00, Cap_for_Int=8014.92 , Int=18.70
Month= 26, Cap_paid=17365.92, Cap_for_Int=7347.00 , Int=17.14
Month= 27, Cap_paid=18033.84, Cap_for_Int=6679.08 , Int=15.58
Month= 28, Cap_paid=18701.76, Cap_for_Int=6011.16 , Int=14.03
Month= 29, Cap_paid=19369.68, Cap_for_Int=5343.24 , Int=12.47
Month= 30, Cap_paid=20037.60, Cap_for_Int=4675.32 , Int=10.91
Month= 31, Cap_paid=20705.52, Cap_for_Int=4007.40 , Int=9.35
Month= 32, Cap_paid=21373.44, Cap_for_Int=3339.48 , Int=7.79
Month= 33, Cap_paid=22041.36, Cap_for_Int=2671.56 , Int=6.23
Month= 34, Cap_paid=22709.28, Cap_for_Int=2003.64 , Int=4.68
Month= 35, Cap_paid=23377.20, Cap_for_Int=1335.72 , Int=3.12
Month= 36, Cap_paid=24045.00, Cap_for_Int=667.80 , Int=1.56
-------------------------------------------------------------------------------------
Summary: Loan=$24045, Rate/Year=2.8%, Months= 36
-------------Payment: Capital=$24045, Interests=$1037.95, Total=$25082.95
**************************************************************
Loan=Caps($8700)+Taxs(14.5%: $1261.50)=$9961.50 , Months=36
Rate/Year=6.9%, Rate/Month=0.575%
Install/Month=276.71, Last Month=276.65
--------------------------------------------------------------------------------------
Month= 1, Cap_paid=276.71 , Cap_for_Int=9961.50 , Int=57.28
Month= 2, Cap_paid=553.42 , Cap_for_Int=9684.79 , Int=55.69
Month= 3, Cap_paid=830.13 , Cap_for_Int=9408.08 , Int=54.10
Month= 4, Cap_paid=1106.84 , Cap_for_Int=9131.37 , Int=52.51
Month= 5, Cap_paid=1383.55 , Cap_for_Int=8854.66 , Int=50.91
Month= 6, Cap_paid=1660.26 , Cap_for_Int=8577.95 , Int=49.32
Month= 7, Cap_paid=1936.97 , Cap_for_Int=8301.24 , Int=47.73
Month= 8, Cap_paid=2213.68 , Cap_for_Int=8024.53 , Int=46.14
Month= 9, Cap_paid=2490.39 , Cap_for_Int=7747.82 , Int=44.55
Month= 10, Cap_paid=2767.10 , Cap_for_Int=7471.11 , Int=42.96
Month= 11, Cap_paid=3043.81 , Cap_for_Int=7194.40 , Int=41.37
Month= 12, Cap_paid=3320.52 , Cap_for_Int=6917.69 , Int=39.78
Month= 13, Cap_paid=3597.23 , Cap_for_Int=6640.98 , Int=38.19
Month= 14, Cap_paid=3873.94 , Cap_for_Int=6364.27 , Int=36.59
Month= 15, Cap_paid=4150.65 , Cap_for_Int=6087.56 , Int=35.00
Month= 16, Cap_paid=4427.36 , Cap_for_Int=5810.85 , Int=33.41
Month= 17, Cap_paid=4704.07 , Cap_for_Int=5534.14 , Int=31.82
Month= 18, Cap_paid=4980.78 , Cap_for_Int=5257.43 , Int=30.23
Month= 19, Cap_paid=5257.49 , Cap_for_Int=4980.72 , Int=28.64
Month= 20, Cap_paid=5534.20 , Cap_for_Int=4704.01 , Int=27.05
Month= 21, Cap_paid=5810.91 , Cap_for_Int=4427.30 , Int=25.46
Month= 22, Cap_paid=6087.62 , Cap_for_Int=4150.59 , Int=23.87
Month= 23, Cap_paid=6364.33 , Cap_for_Int=3873.88 , Int=22.27
Month= 24, Cap_paid=6641.04 , Cap_for_Int=3597.17 , Int=20.68
Month= 25, Cap_paid=6917.75 , Cap_for_Int=3320.46 , Int=19.09
Month= 26, Cap_paid=7194.46 , Cap_for_Int=3043.75 , Int=17.50
Month= 27, Cap_paid=7471.17 , Cap_for_Int=2767.04 , Int=15.91
Month= 28, Cap_paid=7747.88 , Cap_for_Int=2490.33 , Int=14.32
Month= 29, Cap_paid=8024.59 , Cap_for_Int=2213.62 , Int=12.73
Month= 30, Cap_paid=8301.30 , Cap_for_Int=1936.91 , Int=11.14
Month= 31, Cap_paid=8578.01 , Cap_for_Int=1660.20 , Int=9.55
Month= 32, Cap_paid=8854.72 , Cap_for_Int=1383.49 , Int=7.96
Month= 33, Cap_paid=9131.43 , Cap_for_Int=1106.78 , Int=6.36
Month= 34, Cap_paid=9408.14 , Cap_for_Int=830.07 , Int=4.77
Month= 35, Cap_paid=9684.85 , Cap_for_Int=553.36 , Int=3.18
Month= 36, Cap_paid=9961.50 , Cap_for_Int=276.65 , Int=1.59
--------------------------------------------------------------------------------------
Summary: Loan=$9961.50 , Rate/Year=6.9%, Months= 36
-------------Payment: Capital=$9961.50 , Interests=$1059.65 , Total=$11021.15 |
|