How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

2 Ways to Calculate NPV in Excel There are two methods to calculate NPV in Excel. You can use the basic formula, calculate the present value of each component for each year individually, and then ...

Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3. It will turn ...

Here are the steps to calculate forward P/E in Excel. #1 Format Your Worksheet In Microsoft Excel, first, increase the widths of columns A, B, and C by highlighting the entire sheet.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

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

Setting up an Excel spreadsheet to calculate time worked. Follow these steps: In A1, enter Time In. In B1, enter Time Out. In C1, enter Hours Worked.

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 .

How to use Excel’s RANK.AVG() function In almost every way, Excel’s RANK.AVG() function performs as RANK(), except in one way: RANK.AGE() returns an average rank if a number occurs more than once.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .