John works for a fixed income hedge fund. Your fund invests in $100 million in mortgage-backed-bonds (MBS) with a duration of 10. He finances these bonds with $2 million in investor capital and $98 million of overnight repurchase agreements (required haircut=2%) with an interest rate of 1%. After hours, negative news comes out on the evening news that increases yields on MBS by 25 basis points. Moreover, effective tomorrow, because of this bad news, repurchase agreement lenders will now require a haircut of 3% to lend to you via repurchase agreements with your MBS as collateral. Assuming he receives no interest payments from your MBS, how much cash does he need to not default on today’s repurchase agreement and to keep the position open for one more day tomorrow? Please provide calculations in excel.
John works for a fixed income hedge fund. Your fund invests in $100 million in mortgage-backed-bonds (MBS) with a duration of 10. He finances these bonds with $2 million in investor capital and $98 million of overnight repurchase agreements (required haircut=2%) with an interest rate of 1%.
After hours, negative news comes out on the evening news that increases yields on MBS by 25 basis points. Moreover, effective tomorrow, because of this bad news, repurchase agreement lenders will now require a haircut of 3% to lend to you via repurchase agreements with your MBS as collateral. Assuming he receives no interest payments from your MBS, how much cash does he need to not default on today’s repurchase agreement and to keep the position open for one more day tomorrow?
Please provide calculations in excel.
Step by step
Solved in 2 steps
