XIRR測算公式本金(模板)

1、租租金金支支付付測測算算表表項目總額60,000,000.00 租期（年）2.50XIRR8.93% 資金成本XIRR手續(xù)費(fèi)1,951,000.00 投放利率7.000000%EBIT1,946,713.95 銀行手續(xù)費(fèi)收入保證金0.00 年還租次數(shù)4租金計息天數(shù)907 銀行收息天數(shù)租期投放金額利息收入本金收入未回收租賃本金租金支付日租金現(xiàn)金流銀行收息日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計息天數(shù)差異0.00銀行還款現(xiàn)金流銀行利息收益當(dāng)期息差（含手續(xù)費(fèi)）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,