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

Calculate sporadic totals in Excel easily using this technique. Having intermittent cells and blank cells in Excel makes calculating the sum of intermittent cells tedious.

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.

How to Calculate the Percent of Total Sales in Excel. Monitoring sales revenue allows you to track your business' profit, but equally important is understanding where those revenues are derived ...

Running totals are used to update totals within a series in Microsoft Excel. For instance, you might use a running total to track an account balance, enrolling students, or even inventory. Usually ...

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

To calculate this ratio in Excel, locate the total debt and total shareholder equity on the company's balance sheet. Input both figures into two adjacent cells, say B2 and B3.

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

Once you determine your asset and liability totals, calculating the current ratio in Excel is very straightforward, even without a template.

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.