融资租赁租金测算表费率测算

租金计算方式：等额租金期末付项目总额2,700,000.00租期（年）3返点收入0.00首付款年费用率15.44%手续费收入120,000.00保证金270,000.00年还租次数12其他收入32,280.00资产余值0.00每期租金94,179.20残值收入月费率1.29%租前息项目租金收入利息收入回收成本未回收成本现金流量起租日2,700,000.00-2,547,720.001117,000.0034,740.0082,260.002,617,740.00117,000.002117,000.0033,975.2283,024.782,534,715.22117,000.003117,000.0033,200.5983,799.412,450,915.81117,000.004117,000.0032,416.0084,584.002,366,331.81117,000.005117,000.0031,621.3185,378.692,280,953.12117,000.006117,000.0030,816.4086,183.602,194,769.52117,000.007117,000.0030,001.1386,998.872,107,770.65117,000.008117,000.0029,175.3887,824.622,019,946.03117,000.009117,000.0028,338.9988,661.011,931,285.02117,000.0010117,000.0027,491.8589,508.151,841,776.87117,000.0011117,000.0026,633.8190,366.191,751,410.68117,000.0012117,000.0025,764.7291,235.281,660,175.40117,000.0013102,000.0024,884.4577,115.551,583,059.85102,000.0014102,000.0023,992.8678,007.141,505,052.71102,000.0015102,000.0023,089.8078,910.201,426,142.51102,000.0016102,000.0022,175.1179,824.891,346,317.63102,000.0017102,000.0021,248.6680,751.341,265,566.29102,000.0018102,000.0020,310.2981,689.711,183,876.58102,000.0019102,000.0019,359.8482,640.161,101,236.42102,000.0020102,000.0018,397.1783,602.831,017,633.59102,000.0021102,000.0017,422.1084,577.90933,055.69102,000.0022102,000.0016,434.5085,565.50847,490.19102,000.0023102,000.0015,434.1886,565.82760,924.37102,000.0024102,000.0014,421.0087,579.00673,345.36102,000.002587,000.0013,394.7773,605.23599,740.1487,000.002687,000.0012,355.3574,644.65525,095.4887,000.002787,000.0011,302.5575,697.45449,398.0387,000.002887,000.0010,236.2076,763.80372,634.2387,000.002987,000.009,156.1377,843.87294,790.3687,000.003087,000.008,062.1778,937.83215,852.5387,000.003187,000.006,954.1380,045.87135,806.6687,000.003287,000.005,831.8381,168.1754,638.5087,000.003387,000.004,695.1082,304.90-27,666.4187,000.003487,000.003,543.7483,456.26-111,122.6787,000.003520,000.002,377.5617,622.44-128,745.1120,000.003620,000.001,196.3818,803.62-147,548.7320,000.00融资租赁租金及收益测算表3,538,000.00690,451.272,847,548.73990,280.003.不同于年收益率，年化收益率只是一个短期收益的年化显示，只有在未来收益都能一直保持不变的情况下，年化收益才会等于年收益。投资者在看到某理财产品标明高年化收益率时不要太过追崇，一旦未来收益率下跌，那预期年化收益率就毫无意义了5.ROI反映的是全部投资的收益能力4.IRR反映的是存在于项目中的实际投资（即未被回收的资金）的收益能力；1.年费用率里面包含手续费和销项税和利息2.年利率是又称利息率,利息与本金的比率.690,280.00总收益总收益率690,451.2725.57%25.57%-3,000,000.00总资金占用32,280.002,700,000.00120,000.00收益率年化收益率300,000.0025.49%8.50%-2,547,720.00IRR/月序号-95.41%1-76.15%2-58.18%3-44.77%4-35.01%5-27.78%6-22.32%7-18.10%8-14.78%9-12.12%10-9.95%11-8.16%12-6.84%13-5.69%14-4.70%15-3.84%16-3.08%17-2.42%18-1.83%19-1.32%20-0.85%21-0.44%22-0.07%230.26%240.52%250.75%260.97%271.17%281.35%291.52%301.67%311.82%321.95%332.07%342.10%352.12%3637382.12%3.不同于年收益率，年化收益率只是一个短期收益的年化显示，只有在未来收益都能一直保持不变的情况下，年化收益才会等于年收益。投资者在看到某理财产品标明高年化收益率时不要太过追崇，一旦未来收益率下跌，那预期年化收益率就毫无意义了4.IRR反映的是存在于项目中的实际投资（即未被回收的资金）的收益能力；1.年费用率里面包含手续费和销项税和利息2.年利率是又称利息率,利息与本金的比率.PPMT(rate,per,nper,pv,fv,type)有关函数PPMT中参数的详细信息，请参阅函数PV。Rate为各期利率。Per用于计算其本金数额的期数，必须介于1到nper之间。Nper为总投资期，即该项投资的付款期总数。Pv为现值，即从该项投资开始计算时已经入帐的款项，或一系列未来付款当前值的累积和，也称为本金。Fv为未来值，或在最后一次付款后希望得到的现金余额，如果省略fv，则假设其值为零，也就是一笔贷款的未来值为零。Type数字0或1，用以指定各期的付款时间是在期初还是期末。Type值支付时间0或省略期末1期初IPMT(rate,per,nper,pv,[fv],[type])IPMT函数语法具有以下参数：Rate必需。各期利率。Per必需。用于计算其利息数额的期数，必须在1到nper之间。Nper必需。年金的付款总期数。Pv必需。现值，或一系列未来付款的当前值的累积和。Fv可选。未来值，或在最后一次付款后希望得到的现金余额。如果省略fv，则假定其值为0（例如，贷款的未来值是0）。Type可选。数字0或1，用以指定各期的付款时间是在期初还是期末。如果省略type，则假定其值为03.不同于年收益率，年化收益率只是一个短期收益的年化显示，只有在未来收益都能一直保持不变的情况下，年化收益才会等于年收益。投资者在看到某理财产品标明高年化收益率时不要太过追崇，一旦未来收益率下跌，那预期年化收益率就毫无意义了4.IRR反映的是存在于项目中的实际投资（即未被回收的资金）的收益能力；第1-12期117000140400012第1-12期102000122400012870008700001020000400002353800036PPMT(rate,per,nper,pv,fv,type)有关函数PPMT中参数的详细信息，请参阅函数PV。Rate为各期利率。Per用于计算其本金数额的期数，必须介于1到nper之间。Nper为总投资期，即该项投资的付款期总数。Pv为现值，即从该项投资开始计算时已经入帐的款项，或一系列未来付款当前值的累积和，也称为本金。Fv为未来值，或在最后一次付款后希望得到的现金余额，如果省略fv，则假设其值为零，也就是一笔贷款的未来值为零。Type数字0或1，用以指定各期的付款时间是在期初还是期末。Type值支付时间0或省略期末1期初IPMT(rate,per,nper,pv,[fv],[type])IPMT函数语法具有以下参数：Rate必需。各期利率。Per必需。用于计算其利息数额的期数，必须在1到nper之间。Nper必需。年金的付款总期数。Pv必需。现值，或一系列未来付款的当前值的累积和。Fv可选。未来值，或在最后一次付款后希望得到的现金余额。如果省略fv，则假定其值为0（例如，贷款的未来值是0）。Type可选。数字0或1，用以指定各期的付款时间是在期初还是期末。如果省略type，则假定其值为0租金计算方式：等额租金期末付项目总额3,000,000.00租期（年）3返点收入0.00首付款年费用率13.99%手续费收入120,000.00保证金300,000.00年还租次数12其他收入32,280.00资产余值0.00每期租金102,518.32残值收入月费率1.17%租前息项目租金收入利息收入回收成本未回收成本现金流量起租期3,000,000.00-2,547,720.001117,000.0034,975.0082,025.002,917,975.00117,000.002117,000.0034,187.5682,812.442,835,162.56117,000.003117,000.0033,390.9383,609.072,751,553.49117,000.004117,000.0032,585.0284,414.982,667,138.52117,000.005117,000.0031,769.7285,230.282,581,908.24117,000.006117,000.0030,944.9186,055.092,495,853.14117,000.007117,000.0030,110.4886,889.522,408,963.63117,000.008117,000.0029,266.3387,733.672,321,229.95117,000.009117,000.0028,412.3388,587.672,232,642.28117,000.0010117,000.0027,548.3889,451.622,143,190.66117,000.0011117,000.0026,674.3590,325.652,052,865.01117,000.0012117,000.0025,790.1491,209.861,961,655.15117,000.0013102,000.0024,895.6277,104.381,884,550.77102,000.0014102,000.0023,990.6778,009.331,806,541.44