Learn how to calculate Value at Risk (VaR) to effectively assess financial risks in portfolios, using historical, variance-covariance, and Monte Carlo methods.

NPV vs. PV Formula in Excel While you can calculate PV in Excel, you can also calculate net present value (NPV). Present value is discounted future cash flows.

This will be one value for your two-stock portfolio, and we can call it C12. Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks.

How to Calculate the Regression of 2 Stocks Using Excel April 06, 2016 — 11:21 am EDT Written by The Motley Fool -> ...