Home Blog Page 6
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...

Geometric Mean and Standard Deviation

The geometric mean and standard deviation should be used for investments that have a maturity horizon of one year or more because it accounts...