Spread the loveIntroduction: Calculating bond value is essential for investors looking to assess the true worth of their fixed income investments. Microsoft Excel offers various ways to do this. In ...

Most analysts use Excel to calculate NPV. You can input the present value formula, apply it to each year's cash flows, and then add together each year's discounted cash flows, minus expenditures ...

Run the calculation, and your spreadsheet will return a result of -$115,927.41, which is the future value of your salaries. If you need the result to be positive, enter your Present Value number ...

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 .

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 ...

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

To calculate the present value of any cash flow, you need the formula below: Present value = Expected Cash Flow ÷ (1+Discount Rate)^Number of periods Thus, for year one, the math would look like ...

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.