Hello Dear Friends! Does anyone have a working model to do the following task: Model a debt tranche on a monthly basis and have the flexibility for the excel formulas to recognize when a new tranche is issued, calculate accrued interest, cash interest on each payment date, partial redemptions (as well as accrued interest and cash interest on the partial redemption and ultimately, if possible gain / loss on redemption assuming you refi at a discount? I have something but I am finding it very dificult to model these on a monthly basis with all the above criterias. I can send you a version of what I have so far. Your help is really appreciate it. Bless you all!