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

The Multiply Functions With Money in Excel. You can use the PRODUCT() function to multiply... How to Find the Simple Interest Rate on a TI-83 Calculator. The TI-83 scientific... "Return on assets ...

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

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.

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.

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.

Excel has a dedicated function to calculate NPV. The following article explains how to use this function in the case of a calculation of NPV with cash flows that are collected in the same periods ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Using Excel to implement the dividend discount modelOne ... which in the first row will simply equal the current dividend. For the second row, calculate the year by adding 1 to the previous ...

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 .