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

The PMT function is an Excel Financial function that returns the periodic payment for an annuity. The formula for the PMT function is PMT(rate,nper,pv, [fv], [type]). The NPV function returns the ...

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.

They explain there are 53 different financial functions in Excel for spreadsheets. Using all of them can get confusing, so they put together a list of the most helpful ones. Here are two of my ...

Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving around the periodic interest rate ...

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

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