If you wish to calculate CPI in Excel and create its graph, please read through this article. ... To find the CPI percentage, simply select the cell with the CPI ratio and hit the percentage symbol.

How to find your Sharpe ratio. I use Interactive Brokers and Etrade for trading. ... This is the case for most brokers, but you can easily export Etrade's results to Microsoft Excel to calculate.

Launch Excel. Type "Investment Amount" in cell A1. Widen column A until it is slightly larger than the text in cell A1. Type "Money Gained from Investment" into cell B1.

Use Microsoft Excel to calculate EBITDA (earnings before interest, tax, depreciation, ... (D&A) by taking historical D&A, then dividing it by historical revenue, and applying that ratio forward.