Period | IntExp_Calc | Interest_Expense | Coupon | Carry_Calc | Carrying_Value |
---|---|---|---|---|---|
0 | 92.56M | ||||
1 | 92.56M x 6% / 2 = | 2.78M | 2.5M | 92.56M + 2.78M - 2.5M = | 92.84M |
2 | 92.84M x 6% / 2 = | 2.79M | 2.5M | 92.84M + 2.79M - 2.5M = | 93.12M |
3 | 93.12M x 6% / 2 = | 2.79M | 2.5M | 93.12M + 2.79M - 2.5M = | 93.42M |
4 | 93.42M x 6% / 2 = | 2.80M | 2.5M | 93.42M + 2.80M - 2.5M = | 93.72M |
... | ... | ... | ... | ... |