← Back to Templates


Beneish M Score
Description

Computes the Beneish M-Score, the eight ratio model built to flag earnings manipulation by comparing this year's receivables, margins, asset quality, sales growth, depreciation, overheads, leverage and accruals against last year's.
Revenue, cost of sales, depreciation, selling and administrative expense and income from continuing operations are pulled for both periods, and all eight indices stay visible next to the combined score. A high reading is a reason to read the filings, not proof of anything. Sector and industry labels help, since the model behaves differently across business types.
Template Screenshots

Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work? Watch Demo
Similar Templates
No similar templates found