ADVANCED INVESTMENTS

*CALCULATE THE HOLDING PERIOD RETURN*

USE THE COMBINED COLUMN TO CALCULATE THE HOLDING PERIOD RETURN. IGNORE "TOTAL RETURN %"

THIS REQUIRES "REVERSE ENGINEERING" THE BLOOMBERG CALCULATION.

THIS EXCEL SPREADSHEET IS FROM BLOOMBERG FIXED INCOME HORIZON ANALYSIS: CASHFLOW

IS THE YELLOW NUMBER CORRECT? I GOT (D14+(-D6-D11))/(D11)

CASHFLOWS TABLE 1 2 3 4 5 9 Settlement Date Price/Yield Principal Accrued interest NPV at Settlement Horizon Date Price/Yield Principal Accrued Interest Coupon Payments Reinvestement Income Net Future Value Bank of America Healtsouth Combined 11/12/19 11/12/2019 103.148000/2.386226 109.586/3.00322 -1,031,480 -1,095,860 -2,127,340 -5,625 -26,764 -32,389 -1,037,105 -1,122,624 -2,159,729 11/12/20 11/12/20 102.228947/2.386226 106.982762/3.00322 1,022,289 1,069,828 2,092,117 5,625 26,764 32,389 33,750 58,750 92,500 258 761 1,019 1,061,922 1,156,102 2,218,024 10 11 15 16 17 Net Profit & Loss HPR% Total Return 24,817 2.393 2.379 33,478 2.982 2.96 1.732% 19 20