To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

To calculate a price-weighted average, sum the stock prices and divide by the number of stocks. This average reflects changes in higher-priced stocks more than lower-priced ones. Use price-weighted ...

Use market cap and share price to find shares outstanding by dividing the former by the latter. Balance sheets show issued shares by listing par values multiplied by shares issued. Issued but not ...