Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...

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.

Find out more about the return on assets (ROA) ratio and the formula for calculating a company's return on assets in Excel.

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

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

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 .

Reviewed by Thomas Brock Fact checked by Suzanne Kvilhaug CAPM: An Overview Many investors use the capital asset pricing model (CAPM) as a way to estimate the potential return of a stock or other ...

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

Learn what the payout ratio is, what dividends per share and earnings per share are, and how the payout ratio is calculated in Microsoft Excel.