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.

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory ...

Calculating inflation-adjusted prices by hand involves collecting two pieces of data from the CPI-U. The tables below show how the buying power of $2.50 for a slice of pizza has changed from one ...

Step-by-Step Process: Using Apple as an example, learn how to: Find cash flow using GuruFocus. Calculate growth rates based on historical data. Determine the terminal value and apply a discount rate.

While a relatively simple calculation, when using a large amount of data, a software package like Excel can make it easier and quicker to compute. Here, we show how to calculate marginal return in ...

For example, if you want to see values in increments of 5 up to 20, insert "5" in cell B1, "10" in cell C1, "15" in D1 and "20" in E1. Starting in cell A2, work downward and insert the various ...

Example of Calculating the Current Ratio in Excel Let's say that a small business owner wants to expand and needs to determine his ability to take on more debt.

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row ...

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

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 .