Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Capitalize First Letter of Every Word in a Cell - PROPER Function
Tutorial: In Excel you can use a function to capitalize the first letter of every word in a cell.  ...
Nest IF Statements in Excel
Tutorial: How to nest IF statements inside of each other in Excel so that you can make more complex...



Excel Finance Trick 14: NPV function Capital Invest Decision


You can use the NPV function when the cash flows are of different amounts but the time periods between cash flows is the same.

When an asset DOES NOT have an annuity cash flow pattern, you can use the NPV function for Capital Investment Decision.

Asset Valuation with Discounting Cash Flow Analysis.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Excel Formula





Got a Question? Ask it Here in the Forum.