Formula for F68-N72 on Value tab
Shouldn't the offset formula for Cell F68 on the Value Tab instead be: =$C68*F$9-OFFSET(IS!$F$61,F$4,Value!$A68)? This way, it will capture various CASES in the offset function. Please advise.

Distressed Debt Model
In the distressed debt model Hamilton went over, can this model be used to evaluate High Yield bonds? Or High Yield Bonds are a complete separate animal where the distressed model cannot be applied? As I understand, In distressed you are more concerned about figuring out what security to invest an... In the distressed debt model Hamilton went over, can this model be used to evaluate High Yield bonds? Or High Yield Bonds are a complete separate animal where the distressed model cannot be applied? As I understand, In distressed you are more concerned about figuring out what security to invest and to identify the fulcrum security. Where as if you were presented w/ a HY bond, the analysis would be to determine whether this bond is attractive given its risk/reward relationship? In any case, if I were to analyze a HY bond, how would I go about modeling it out? Thank you! Read More