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

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

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

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

The formula for calculating the discount rate in Excel is =RATE (nper, pmt, pv, [fv], [type], [guess]). What Does the Discount Rate Indicate? The discount rate represents an interest rate.

The difference is your overall profit, in this example the formula result would be $17. Input a formula in the final column to calculate the profit margin on the sale.

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.

A. There are many ways to calculate depreciation in Excel, and several of the depreciation methods already have a built-in function included in the software. The table below includes all the built-in ...

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

It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel.

How to use Excel’s RANK.AVG () function Figure D Figure D Word’s RANK.AVG () better accommodates duplicates. Figure E Figure E The average rank increase with every duplicate.