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.

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.

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 .

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.

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.

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 .