I have reproduced pretty much all pre-built ratios using only balance sheet items etc. This little exercise was quite insightful! However, I tried hard, but could not reproduce Pr2Sales, Pr2FrCashFl, or Pr2CashFl. They are certainly not defined in the straightforward way that I would expect, or how it’s defined in the help. You can see my attempt for Pr2SalesQ here: https://www.portfolio123.com/app/screen/summary/154309?st=0&mt=1. Make sure to look at the ‘Screen Factors’ report. All @diff columns should be zero, but they are not even close.
So how are these ratios computed exactly?
Thanks,
Peter
PS. I could not reproduce PEG, PEGInclXor, and PEGY, but I think they cannot be reproduced with another formula. That’s ok.
PPS. I also couldn’t figure out how ROI%, DbtLT2Cap, and DbtTot2Cap are defined exactly.
Peter, have you kept an inventory of all your recent data and function checks? I would be happy to contribute to a data / function / documentation audit and quality group where past and on-going work can be recorded. Perhaps a shared Google Sheet? Nothing undermines confidence like poor documentation, computation errors in functions and difficult to audit / reproduce output. D
We annualize the denominator so the Q ratios can be compared to TTM. We annualize by multiplying the denominator by the ratio of 365.25 to the number of days in the period (probably over-complicated; 4 is a good enough approximation). This makes the Q ratios more “comparable” with TTM and annual. However… I would stay clear of these ratios due to the seasonality of the results.
Not sure why the documentation re. annualization disappeared. It was there. I will add it back in all the factors that do it.
Pr2FrCashFlQ
Pr2CashFlQ
Pr2SalesQ
ROE%Q
ROA%Q
ROI%Q
SalesPerEmpQ
IncPerEmpQ
RecTurnQ , RecTurnPYQ , and RecTurn()using QTR
InvTurnQ , InvTurnPYQ , and InvTurn() using QTR
AstTurnQ , AstTurnPYQ , and AstTurn() using QTR