List/Grid Business Analysis in Excel Subscribe RSS feed of category Business Analysis in Excel
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…
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.
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.