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.

To calculate the sum of squares using Microsoft Excel, you need to input a specific formula into the formula bar of the cell you're working with.

Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

You can use Microsoft Excel to calculate the loan-to-value ratio if you have the mortgage amount and appraised value of the property.

Key Points Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.