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.

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.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

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.