Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Again, use cell references so that if the data changes, your final payment information will also change. Now that your input area is finished you can use the information to calculate the issue price ...

Excel's Goal Seek feature helps with reverse calculations in financial planning, like CVP analysis. Goal Seek can assist in NPV analysis by determining selling prices to reach certain targets.

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code.