In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

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.

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.

No Results Q. Can you show me how to calculate depreciation in Excel using different depreciation methods? A. There are many ways to calculate depreciation in Excel, and several of the depreciation ...

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

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.

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

The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.