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.

How Do I Calculate a Discounted Payback Period in Excel? The discounted payback period is the number of years it takes to pay back the initial investment after discounting cash flows.