XIRR测算公式本金(模板)

1、租租金金支支付付测测算算表表项目总额60,000,000.00 租期（年）2.50XIRR8.93% 资金成本XIRR手续费1,951,000.00 投放利率7.000000%EBIT1,946,713.95 银行手续费收入保证金0.00 年还租次数4租金计息天数907 银行收息天数租期投放金额利息收入本金收入未回收租赁本金租金支付日租金现金流银行收息日2019/1/1560,000,000.00 60,000,000.002019/1/15-58,049,000.002019/1/142019/3/2160,000,000.00758,333.330.0060,000,000.002019/

2、3/15758,333.332019/3/212019/6/2160,000,000.001,073,333.33600,000.0059,400,000.002019/6/151,673,333.332019/6/212019/9/2159,400,000.001,062,600.000.0059,400,000.002019/9/151,062,600.002019/9/212019/12/2159,400,000.001,051,050.00600,000.0058,800,000.002019/12/151,651,050.002019/12/212020/3/2158,800,000

3、.001,040,433.330.0058,800,000.002020/3/151,040,433.332020/3/212020/6/2158,800,000.001,051,866.67600,000.0058,200,000.002020/6/151,651,866.672020/6/212020/9/2158,200,000.001,041,133.330.0058,200,000.002020/9/151,041,133.332020/9/212020/12/2158,200,000.001,029,816.67600,000.0057,600,000.002020/12/151,

4、629,816.672020/12/212021/3/2157,600,000.001,008,000.000.0057,600,000.002021/3/151,008,000.002021/3/212021/6/2157,600,000.001,030,400.00600,000.0057,000,000.002021/6/151,630,400.002021/6/212021/7/1057,000,000.00210,583.3357,000,000.000.002021/7/657,210,583.332021/7/9合合计计10,357,550.0060,000,000.007 70

5、 0, ,3 35 57 7, ,5 55 50 0. .0 00 0合合计计7.31%收益率XIRR1.62%201,000.00融资利率6.866667%907计息天数差异0.00银行还款现金流银行利息收益当期息差（含手续费）59,799,000.00（本金投放）1,750,000.00-755,333.37755,333.372,999.96-1,652,888.941,052,888.9420,444.39-1,042,360.051,042,360.0520,239.95-1,631,030.051,031,030.0520,019.95-1,020,615.611,020,615.6119,817.72-1,631,831.161,031,831.1620,035.51-1,021,302.271,021,302.2719,831.06-1,610,201.161,010,201.1619,615.51-988,800.05988,800.0519,199.95-1,610,773.381,010,773.3819,626.62-57,195,