Having trouble? Click to reload

Current, Average and Trend

What are the three columns beside every metric?

Every metric is drawn three ways at once. Current is the newest twelve months. Average is the mean of the last 20 quarterly readings, which is five years. Trend is the slope of a line through those same 20. A toggle beside them swaps each figure for its rating, a place from 0 to 100 against our main comparison pool.

The three columns

Current is the newest twelve months the company has reported, taken from its latest filing.

Average is the mean of the last 20 quarterly readings. Half of every DCA rule is judged on this column.

Trend is the slope of a straight line through those same 20 quarters: one question, one answer, rising or falling and how steeply.

The Score and Value toggle

Each of the three can be read two ways. Value is the figure itself, straight from the accounts. Score is its rating, a place from 0 to 100 against our main comparison pool, where 100 is the best reading anyone has.

So there are six readings behind one metric, and the toggle picks which three you are looking at. Percentile, Rating and the Industry Median is the next page, and it is about that rating.

Twenty quarters, per metric, or nothing

The window is all or nothing, and it is decided metric by metric. A metric needs a real reading in every one of its 20 slots before it gets an Average or a Trend.

So one row on a page can show all three columns while the row under it shows a Current and two blanks. That is one metric with a gap in its history, not a verdict on the company.

What the three mean on the balance sheet

Sales, profit and cash movements are a trailing year in the Current column. What a company owns and owes has no twelve-month version, so a balance sheet Current is the amount standing on the day the quarter closed.

Its Average is then the mean of 20 such closing days, and its Trend is the line through them.

MarginX is a software research tool and data publisher, not an investment adviser. Contact: support@marginx.biz