Finding VaR in Excel Below is the process of calculating VaR using a different method called the variance-covariance approach. Import relevant historical financial data into Excel.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

If you are entering an investment amount, type it as a negative number, because it represents money you are currently spending. If this is the variable you wish to calculate, omit this step.