Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

To determine this future value of your money using Microsoft Excel, you'll need to perform some basic calculations based on the interest rate, how often the interest compounds and how long you ...

How to Measure R2 of Two Lines in Excel. In addition to basic calculation functions, Excel also provides data analysis tools that allow you to find the R2 of two lines with an Excel formula.

Learn about the factors involved in this calculation and how a P-value can influence your investment hypothesis.