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.

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.

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.

Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

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.

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.

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

Calculating the future value of a present single sum with multiple interest rates This example shows how to use the ­FVSCHEDULE function in Excel to calculate the future value of a present single sum ...

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