Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function to calculate the straight line -- a ...

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, you must consider the present value of all cash receipts and all cash disbursements related to ...

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

Calculating correlation can be time-consuming but software like Excel makes it much easier. You can use several methods to calculate correlation in Excel. Understanding Correlation ...

The article Using Excel to Calculate Your Annual Salary With Increases originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

If you are using monthly periods, rather than annual periods, you may enter "=RATE(A2,A4,A3)*12" to calculate the annual interest rate. Advertisement Article continues below this ad ...