In: Finance
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Flat Price (clean price) is a price of bond on last dividend bond it does not include any accrued interest rate.
Full Price (dirty price) is sum of Flat price and Accrued interest. Accrued interest for last coupon date to settlement date.