標題:
此文章來自奇摩知識+如有不便請留言告知
請問怎樣做一個租購利息計算表 ?
發問:
請問怎樣做一個租購利息計算表 ? 此計算表可清楚列明 , 每期之供款本金及利息 . 本人是用來入帳的 , 亦曾嘗試用 EXCEL 之貨款計算表 , 但得出之結果好像不對勁 , 希望各方有識之士 , 幫忙解答 , 謝謝 !
最佳解答:
以下呢個網站有類似租購利息計算器, 試下得唔得: http://calculators.interest.com/content/calculators/new/autoloan.asp Auto Financing Results Your auto financing of $18,500.00 has a monthly payment of $460.37. This is for $18,500.00 in auto financing at 9.00% for 48 months. The total for all of your payments** would be $22,097.76. Auto Financing Summary Interest rate: 9.00% Term in months: 48 Total purchase price (before tax): $20,000.00 Taxable fees: $0.00 Sales tax*: $0.00 *Sales tax was calculated as 0.00% times your vehicle price of $20,000.00 minus your trade-in allowance of $0.00. Currently California, the District of Columbia, Hawaii, Maryland and Michigan allow no deductions for trade-ins when calculating sales tax. If you live in one of these states make sure to check the box 'No sales tax deduction for trade-in' on the main calculator page. Non-taxable fees: $0.00 Total sales price (after tax): $20,000.00 Total down payment**: $1,500.00 **Your total down payment is calculated as your cash down payment of $1,500.00 plus your trade-in allowance of $0.00 minus the $0.00 balance outstanding on your trade-in vehicle. Amount financed: $18,500.00 Monthly payment: $460.37 Total payments***: $22,097.76 Total interest paid***: $3,597.76 ***This assumes that you do not refinance and that all payments are made on time with no prepayments. Payment schedule Months Payment Principal Interest Balance $18,500.00 1 $460.37 $321.62 $138.75 $18,178.38 2 $460.37 $324.03 $136.34 $17,854.35 3 $460.37 $326.46 $133.91 $17,527.89 4 $460.37 $328.91 $131.46 $17,198.98 5 $460.37 $331.38 $128.99 $16,867.60 6 $460.37 $333.86 $126.51 $16,533.74 7 $460.37 $336.37 $124.00 $16,197.37 8 $460.37 $338.89 $121.48 $15,858.48 9 $460.37 $341.43 $118.94 $15,517.05 10 $460.37 $343.99 $116.38 $15,173.06 11 $460.37 $346.57 $113.80 $14,826.49 12 $460.37 $349.17 $111.20 $14,477.32 13 $460.37 $351.79 $108.58 $14,125.53 14 $460.37 $354.43 $105.94 $13,771.10 15 $460.37 $357.09 $103.28 $13,414.01 16 $460.37 $359.76 $100.61 $13,054.25 17 $460.37 $362.46 $97.91 $12,691.79 18 $460.37 $365.18 $95.19 $12,326.61 19 $460.37 $367.92 $92.45 $11,958.69 20 $460.37 $370.68 $89.69 $11,588.01 21 $460.37 $373.46 $86.91 $11,214.55 22 $460.37 $376.26 $84.11 $10,838.29 23 $460.37 $379.08 $81.29 $10,459.21 24 $460.37 $381.93 $78.44 $10,077.28 25 $460.37 $384.79 $75.58 $9,692.49 26 $460.37 $387.68 $72.69 $9,304.81 27 $460.37 $390.58 $69.79 $8,914.23 28 $460.37 $393.51 $66.86 $8,520.72 29 $460.37 $396.46 $63.91 $8,124.26 30 $460.37 $399.44 $60.93 $7,724.82 31 $460.37 $402.43 $57.94 $7,322.39 32 $460.37 $405.45 $54.92 $6,916.94 33 $460.37 $408.49 $51.88 $6,508.45 34 $460.37 $411.56 $48.81 $6,096.89 35 $460.37 $414.64 $45.73 $5,682.25 36 $460.37 $417.75 $42.62 $5,264.50 37 $460.37 $420.89 $39.48 $4,843.61 38 $460.37 $424.04 $36.33 $4,419.57 39 $460.37 $427.22 $33.15 $3,992.35 40 $460.37 $430.43 $29.94 $3,561.92 41 $460.37 $433.66 $26.71 $3,128.26 42 $460.37 $436.91 $23.46 $2,691.35 43 $460.37 $440.18 $20.19 $2,251.17 44 $460.37 $443.49 $16.88 $1,807.68 45 $460.37 $446.81 $13.56 $1,360.87 46 $460.37 $450.16 $10.21 $910.71 47 $460.37 $453.54 $6.83 $457.17 48 $460.60 $457.17 $3.43
其他解答:
留言列表
