Please enable JavaScript.

Coggle requires JavaScript to display documents.

S & P CDO Monitor Test - Coggle Diagram

- - - - S&P CDO Monitor Formula Election Period = Y :check:
    - - =ROUND(K32(Aggregate.RampUp.Par.Amount/Model!K33)+((K33-Aggregate.RampUp.Par.Amount)/(K33(1-K43))),4)
        
        Aggregate.RampUp.Par.Amount
        
        Target Initial Par Amount = 360000000 :check:
        
        K33
        
        =S_P_Collateral_Principal_Amount
        
        =SUM('Profile Calcs'!$EQ$8:$EQ$3000)+Principal.Proceeds+RampUp.Acct+SUM('Profile Calcs'!$ER$8:$ER$3000)
        
        ER :check:
        
        Principal Proceeds (trade) = -5409421.54 :check:
        
        EQ :check:
        
        Ramp-Up Principal Subaccount = -770441.13 :check:
        
        K32
        
        =0.096269+(4.341799K42)+(0.925909K43)
        
        K42
        
        ='Profile Calcs'!W3
        
        =IF(SUM(Par.Float.)=0,0,(Agg.Spread+Agg.Unfund.Spread)/SUM(Par.Float.))
        
        3 more items...
        
        K43
        
        K43
        
        =Workpaper!M80/Workpaper!N80
        
        =IF('Profile Calcs'!BT1>15%,"Fix me",SUMPRODUCT(SP.Rec.Rates.A1,Par.ND))
        
        SP.Rates.A1
        
        =IF($A8="","",IF(T8="Equity",0%,IF($BN8<>"",VLOOKUP(($BN8*100),Table.1,VLOOKUP($BS$1,Model!$F$118:$I$140,4,0),FALSE),VLOOKUP($BR8,Table.2,VLOOKUP($BS$1,Model!$F$118:$I$140,4,0),FALSE))))
        
        BT1
        
        =SUMIF(SP.Category,"Second Lien Loan",Par.ND)/CPA.CL
        
        Par.ND
        
        =SUM(Par.ND)
        
        =SUM('Profile Calcs'!$H$8:$H$3000)
        
        H