The discount rate is the interest rate used to calculate net present value (NPV). It represents the time value of money. NPV can help companies determine whether a proposed project may be profitable.

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 .

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, ... The choice of a discount rate is usually linked to the level of risk for the project.

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

How to add a condition to rank using a PivotTable in Excel. A simple rank is easy to calculate, but sometimes you’ll want to accommodate a condition. For instance, ...

Excel 2010 includes a built-in function for computing the trimmed mean. Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1," and enter the first number in the data set you want to get ...

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

This is all about how to calculate weighted average in Excel with percentages. I hope you find this helpful. Also Read: How to use MIN, Max, and AVERAGE Functions of Excel.

The discount rate is the interest rate used to calculate net present value (NPV). It represents the time value of money. NPV can help companies determine whether a proposed project may be profitable.

In Excel, rank is a value that represents the position of one value within a group of values. You’ll want to rank all kinds of data: student GPAs, sport statistics, product sales and so 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 .