An investor sells a stock short for $36 a share. A year later, the investor covers the position at $30 a share. If the margin requirement is 60 percent, what is the percentage return earned on the investment? Redo the calculations, assuming the price of the stock is $42 when the investor closes the position.

Please show how to solve within Excel step by step