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.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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

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.

Contents What Is Inflation-Adjusted Pricing? How to Calculate Inflation-Adjusted Prices What Is Inflation-Adjusted Pricing? Inflation can erode the purchasing power of money, but adjusting prices ...

Marginal returns may be calculated using Excel to help determine if additional production would result in prohibitive expense.

Thanks -- and Fool on! 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 .