很好用的融资租赁测算表(可编辑版)

"融资租赁业务收益测算表

",,,,,,,,,单位：元（人民币）

项目名称,,,,租赁方式,,,合同编号,,

项目参数,,,,,,,,,

租赁融资额,"100,000,000.00",租赁物价格,"100,000,000.00",相关费用支付,0.00,相关税收支付,0.00,后付先付代码,0

租赁利率,5.9500%,租赁期限（年）,12,年付租次数,4,租金支付方式,后付,后付,0

期末残值,0.00,残值计入本金,否,贴现率,0.0000%,保证金存款利率,0.0000%,先付,1

保证金率,0.0000%,保证金,0.00,手续费率,2.0000%,手续费,"2,000,000.00",残值计入本金代码,是

供应商折扣率,0.0000%,供应商折扣额,0.00,管理费率,0.0000%,管理费,0.00,,否

收益测算,,,,,,,,,

每期租金,"2,929,667.61",租金总额,"140,624,045.28",收回本金,"100,000,000.00",收回利息,"40,624,045.39",净融资额现值,"98,000,000.00"

净现值NPV,"42,624,045.39",现值收益率,43.4939%,年化现值收益率,3.6245%,项目IRR（年付分次不计复利）,6.3298%,项目IRR（年付分次计算复利）,6.4817%

现金流量,,,,,,,,,

日期,租赁相关流入,利息,收回本金,尚未收回本金,其他现金流入,其他现金流出,现金流入,现金流出,净现金流

起租日,"2,000,000.00",,0.00,"100,000,000.00",0.00,"100,000,000.00","2,000,000.00","100,000,000.00","(98,000,000.00)"

第1期,"2,929,667.61","1,487,500.00","1,442,167.61","98,557,832.39",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第2期,"2,929,667.61","1,466,047.76","1,463,619.86","97,094,212.53",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第3期,"2,929,667.61","1,444,276.41","1,485,391.20","95,608,821.33",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第4期,"2,929,667.61","1,422,181.22","1,507,486.39","94,101,334.94",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第5期,"2,929,667.61","1,399,757.36","1,529,910.26","92,571,424.68",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第6期,"2,929,667.61","1,376,999.94","1,552,667.67","91,018,757.01",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第7期,"2,929,667.61","1,353,904.01","1,575,763.60","89,442,993.41",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第8期,"2,929,667.61","1,330,464.53","1,599,203.09","87,843,790.32",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第9期,"2,929,667.61","1,306,676.38","1,622,991.23","86,220,799.09",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第10期,"2,929,667.61","1,282,534.39","1,647,133.23","84,573,665.87",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第11期,"2,929,667.61","1,258,033.28","1,671,634.33","82,902,031.54",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第12期,"2,929,667.61","1,233,167.72","1,696,499.89","81,205,531.64",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第13期,"2,929,667.61","1,207,932.28","1,721,735.33","79,483,796.31",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第14期,"2,929,667.61","1,182,321.47","1,747,346.14","77,736,450.17",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第15期,"2,929,667.61","1,156,329.70","1,773,337.92","75,963,112.26",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第16期,"2,929,667.61","1,129,951.29","1,799,716.32","74,163,395.94",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第17期,"2,929,667.61","1,103,180.51","1,826,487.10","72,336,908.84",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第18期,"2,929,667.61","1,076,011.52","1,853,656.09","70,483,252.75",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第19期,"2,929,667.61","1,048,438.38","1,881,229.23","68,602,023.52",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第20期,"2,929,667.61","1,020,455.10","1,909,212.51","66,692,811.01",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第21期,"2,929,667.61","992,055.56","1,937,612.05","64,755,198.96",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第22期,"2,929,667.61","963,233.58","1,966,434.03","62,788,764.93",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第23期,"2,929,667.61","933,982.88","1,995,684.73","60,793,080.20",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第24期,"2,929,667.61","904,297.07","2,025,370.54","58,767,709.65",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第25期,"2,929,667.61","874,169.68","2,055,497.93","56,712,211.72",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第26期,"2,929,667.61","843,594.15","2,086,073.46","54,626,138.26",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第27期,"2,929,667.61","812,563.81","2,117,103.81","52,509,034.45",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第28期,"2,929,667.61","781,071.89","2,148,595.72","50,360,438.73",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第29期,"2,929,667.61","749,111.53","2,180,556.09","48,179,882.64",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第30期,"2,929,667.61","716,675.75","2,212,991.86","45,966,890.78",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第31期,"2,929,667.61","683,757.50","2,245,910.11","43,720,980.67",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第32期,"2,929,667.61","650,349.59","2,279,318.02","41,441,662.65",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第33期,"2,929,667.61","616,444.73","2,313,222.88","39,128,439.77",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第34期,"2,929,667.61","582,035.54","2,347,632.07","36,780,807.70",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第35期,"2,929,667.61","547,114.51","2,382,553.10","34,398,254.60",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第36期,"2,929,667.61","511,674.04","2,417,993.58","31,980,261.02",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第37期,"2,929,667.61","475,706.38","2,453,961.23","29,526,299.79",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第38期,"2,929,667.61","439,203.71","2,490,463.90","27,035,835.89",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第39期,"2,929,667.61","402,158.06","2,527,509.55","24,508,326.34",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第40期,"2,929,667.61","364,561.35","2,565,106.26","21,943,220.08",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第41期,"2,929,667.61","326,405.40","2,603,262.21","19,339,957.87",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第42期,"2,929,667.61","287,681.87","2,641,985.74","16,697,972.13",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第43期,"2,929,667.61","248,382.34","2,681,285.28","14,016,686.85",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第44期,"2,929,667.61","208,498.22","2,721,169.40","11,295,517.46",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第45期,"2,929,667.61","168,020.82","2,761,646.79","8,533,870.67",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第46期,"2,929,667.61","126,941.33","2,802,726.29","5,731,144.38",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第47期,"2,929,667.61","85,250.77","2,844,416.84","2,886,727.54",0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第48期,"2,929,667.61","42,940.07","2,886,727.54",(0.00),0.00,0.00,"2,929,667.61",0.00,"2,929,667.61"

第49期,0.00,0.00,0.00,0.00,0.00,0.00,0.0