CALCULATING VAR AND CVAR USING EXCEL
Var is the extent of possible financial losses over a specific time period whereas CVar is the expected financial loss of the worst case scenarios. In other words Var gives us a range of potential losses and Cvar give us an average expected loss. We can use these answers to help us decide wether or no to invest in any publicly traded company on the stock market. Below is my worksheet where you can follow along step by step and see how I calculated the VAR and CVAR of Target and my slideshow to teach you about VAR and CVAR
|