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

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

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

How to Calculate Operating Expenses in Excel. An Excel spreadsheet is designed to automate the task of repetitive calculations. It can be an invaluable tool for ascertaining the income, capital ...

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

The median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN function is as follows: MEDIAN ...

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.

Understand the basics of the current ratio, including its use in assessing a company's liquidity and learn how it is calculated in Microsoft Excel.

To determine the value of a bond today—for a fixed principal (par value) to be repaid in the future—we can use an Excel spreadsheet.

Excel for the web supports all three ranking functions. If you’re unfamiliar with Excel’s three ranking functions, consider reading How to calculate rank in an Excel sheet.