Spark plugs and coil change

Welcome to 2CarPros. To go from a single cylinder misfire to no compression in the engine is either a timing chain or camshaft failure. Personally I would test it myself to verify this as that engine is normally very reliable. It isn't hard to do and you can borrow the tool from many parts stores. https://www.2carpros.com/articles/how-to-test-engine-compression
If it does test low or no compression then it comes down to the rest of the vehicles condition. A used engine or a re-manufactured one are both options. However if you don't have the tools to do the swap it may cost you more than you want to spend.