Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

Calculating the future value of a present single sum with multiple interest rates This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

You can calculate the T-Value in Excel with the mean, standard deviation and degrees of freedom. Since the T-Value is a comparison between sample mean and population mean, both values need to be ...

Future value of your lumpsum investment can be calculated using 'Insert Function' under the Formula tab on an excel sheet. Then choose 'FV' of Future Value option. Suppose, you want to calculate ...

When planning for retirement, you need to account for the value of any annuities that you own. Trouble is, there’s not just one value of an annuity—there are two: present value and future ...

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.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

You can use an online calculator to figure the present and future value of an annuity.

One way to use Excel to show how the dividend discount model works is to set up a timeline that reflects the value of each year's dividends, going however far into the future you choose.

Learn more about the loan-to-value (LTV) ratio, what the ratio measures, and how to calculate the loan-to-value ratio using Microsoft Excel.

To calculate the expected future value based on your growth rate, add one to the rate, and raise this to a power equal to the number of years you're looking at.