Macfarlanes drops out of million-pound club as PEP falls to £846,000