Cheque Note Average Maturity Calculation

Date 24 January 2017
Author exceldepo
Category Macros
Type XLSM

An Excel file that teaches how to perform Cheque Note Average Maturity Calculation operation.

Excel Format: Cheque Note Average Maturity Calculation

Weights are determined consistently. Day differences are calculated using standard formulas. The deferral effect is shown separately. The result is reported as a single date. Sensitivity tables are presented with scenarios.

Hope it is useful.

ADVERTISEMENT AREA

Related Files