Securities Calculation

An Excel file that teaches how to perform Securities Calculation operation.

Excel Powered Securities Calculation

Nominal and market values are recorded. Coupon payments are calculated periodically. Yield rate and duration are analyzed. Sensitivity charts are created. Risk indicators are presented in the summary table.

Hope it is useful.