In the above formula, P stands for the principal value, R is the rate of interest, and n is total time. Here, we will learn to calculate compound interest using Excel.

A p-value of 0.05 or lower is generally considered statistically significant. P-value can serve as an alternative to—or in addition to—preselected confidence levels for hypothesis testing.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

To calculate your LTV ratio using Microsoft Excel for the example above, first right click on columns A, B, and C, select Column Width and change the value to 30 for each of the columns.