Business Analysis Archives

Find Financial Fraud with Benford’s Law

Discover how a peculiar concept called Benford’s Law helps detect accounting and business fraud, and get an Excel spreadsheet to help with your financial sleuthing.

Value Shares with Graham’s Formula

Discover Graham’s formula, a simple method for predicting the fair values of shares, and download a spreadsheet.

Download Finviz Data into Excel

This Excel spreadsheet downloads stock quotes for 6855 companies from Finviz.com using VBA. The stock quotes includes over 65 pieces of financial data, including PE ratios, market capitalization, EPS, moving averages, earnings dates, average true range, and much more.

Beneish M-Score

Determine if a company has manipulated earnings with the Beneish M-Score. It’s simply a mathematical formula which uses data from a company’s financial reports.

Altman Z-Score

The Altman Z-Score is an empirical model that predicts the probability of corporate bankruptcy. This article introduces this valuable predictor of financial distress, and offers a calculation spreadsheet.