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.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.

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

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.