Please use Excel and shiw work.

At the beginning of the tax year, Liz holds a $10,000 stock basis as the sole shareholder of Randy, Inc., an s corporation. During the year, Randy, Inc. reports the following. Taxable operating income 40,000 Net short-term capital loss 14,000 Cash distributions to Liz 57,000 Determine Liz's stock basis at the end of the year and the treatment of her cash distribution