In the sheet named “Bills Payable” of SLS workbook, sir calculated shocked Y and then volatility portion i.e. (Y – Shocked Y). After that sir divided volatility portion into 1 day, 7 day and 14 day bucket. For that sir calculated % change in volatility portion for 1 day, 7 day and 14 day. While calculating percentage change in volatility portion for 1 day bucket sir used the formula (G14 – G13)/C13. Shouldn’t it be (G14 – G13)/G13
Share
Here we are finding the percentage change with respect to the balances. So this is correct