1703475320
1703475321
Public Sub PrintDeal()#在Excel上列出交易的现金流
1703475322
1703475323
Public Sub PrintBond()#在Excel上列出债券的现金流
1703475324
1703475325
Private Function CalcMoreSeniorBal(period As Integer,Seniority As Integer)As Double
1703475326
1703475327
#计算比目标等级债券高级的债券的剩余面额
1703475328
1703475329
Private Function WTF_SeniorPrincipal(period As Integer,availFund As Double) As Double#用剩余现金流偿付高级债券本金
1703475330
1703475331
Private Function SetExcessSpread(period As Integer,ex As Double) As Double#计算剩余利差额
1703475332
1703475333
Private Function CalcSeniorDist(period As Integer,groupNum As Integer) As Double#计算群组的高级债券应还本金额
1703475334
1703475335
Private Function CalcGroupPercent(period As Integer,groupNum As Integer) As Double#按不同指定规则(房利美或房地美方法)计算目标群组本金百分比
1703475336
1703475337
Private Function CalcPDA(period As Integer) As Double#计算总债券应还本金额
1703475338
1703475339
Private Function CalcSeniorPDA(period As Integer) As Double#计算高级债券应还本金额
1703475340
1703475341
Public Function CalcSubPDA(period As Integer,Seniority As Integer) As Double#计算次级债券应还本金额
1703475342
1703475343
Private Function CalcAcceleration(period As Integer) As Double#计算超额抵押目标现金流
1703475344
1703475345
Private Function CalcOCBalance(period As Integer) As Double#计算超额抵押额
1703475346
1703475347
Private Function CalcOCTarget(period As Integer) As Double#计算超额抵押目标
1703475348
1703475349
Private Function CalcStepdown(period As Integer) As Boolean#计算目标月份是否进入超额抵押递减期
1703475350
1703475351
Private Function CalcExpense(period As Integer,ByRef bond As Tranche) As Double#计算债券担保费
1703475352
1703475353
Private Function PayInterest(period As Integer,ByRef bond As Tranche,availFund As Double,status As String) As Double#计算所有债券的应付利息并用现有现金流付清
1703475354
1703475355
Private Function WTF_BondCarryForward(period As Integer,availCollatInt As Double) As Double#用现有现金流付清前期所欠利息
1703475356
1703475357
Private Function GetSubTarget(Seniority As Integer) As Double#计算次级债券本金目标余额
1703475358
1703475359
Public Function CalcSubBalance(period As Integer,Seniority As Integer) As Double#计算目标月份目标等级的次级债券面额
1703475360
1703475361
Private Function CalcSubDist(period As Integer,Seniority As Integer) As Double#计算目标月份目标等级的次级债券应付本金面额
1703475362
1703475363
Private Function WTF_SubPrincipal(period As Integer,availFund As Double) As Double#计算目标月份剩余现金流偿付次级债券本金
1703475364
1703475365
Private Function WTF_Turbo(period As Integer,availFund As Double) As Double#计算目标月份剩余现金流加速偿付债券本金
1703475366
1703475367
Dim fund As Double#计算目标月份是否需要加速还款,并用剩余现金付加快还款额
1703475368
1703475369
Private Function isCall(period As Integer) As Boolean#测试目标月份是否需要回购债券
[
上一页 ]
[ :1.70347532e+09 ]
[
下一页 ]