I know the answers, but I'm not good with excel. This assignment has to be turned in using an excel spreadsheet. Please show me how to answer problems 1,2,3 and 6 in excel.

(the first pic above is problem#1)

A stock sells for $10 per share. You purchase 100 shares for $10 a share (i.e., for $1,000), and after a year the price rises to $17.50. What will be the percentage return on your investment if you bought the stock on margin and the margin requirement was (a) 25 percent, (b) 50 percent, and (c) 75 percent? (Ignore commissions, dividends, and interest expense.) 2. Repeat Problem 1 to determine the percentage return on your investment but in this case suppose the price of the stock falls to $7.50 of the stock falls to $7.50 per share. What generalization can be inferred from your answers to Problems 1 and 2? 3. You purchase 100 shares of stock at $100 ($10,000); the margin requirement is 40 percent. What are the dollar and percentage returns if a) you sell the stock for $112 and bought the stock for cash? b) you sell the stock for $90 and bought the stock on margin? c) you sell the stock for $60 and bought the stock on margin? 6. Ms. Tejal Gandhi has decided that the stock of SmallCap Inc. is overvalued at $4 a share and wants to sell it short. Since the price is relatively low, short sales cannot be executed on margin, so Ms. Gandhi must put up the entire value of the stock when it is sold short. a) What is the percentage loss if the price of the stock rises to $8? b) What is the percentage loss if the price of the stock rises to $10? c) What is the percentage gain if the company goes bankrupt and is dissolved? d) What are the maximum percentage gain the short seller can earn and the largest percentage loss the short seller can sustain? e) From the short seller's perspective, what are the best- and worst-case scenarios