Home Blog Page 5

PEG – Price/Earnings to Growth Ratio

The PEG ratio is another way to try and identify undervalued high growth stocks through a technical screen.  It should not be used alone...
video

F9 Partial Formula Analysis in Excel

This post demonstrates how to calculate the partial value of a formula in Excel by selecting it in the formula bar, and hitting the...
video

Data Tables in Excel

This post demonstrates how to use data tables in Excel. These are very helpful in conducting automated scenario analysis on a model, and have...

Capital Asset Pricing Model (CAPM Equation)

Financial literature is riddled with support for β, as well as doubt surrounding its validity, due to it nearly being impossible to prove or...

Arithmetic Mean and Standard Deviation

The arithmetic mean (AM) and arithmetic standard deviation (ASD) should only be used for short-term investments that have a maturity of one year or...