Use Excel Functions Please

1. As a keen and insightful investor, you decide to short-sell Atlas Corporation because you believe that its shares are about to take a dive. Atlas is currently selling for $50 per share. Determine your profit or loss if you sell 500 shares of Atlas short at $50 per share and the price of Atlas:

a. falls to $40.00.

b. falls to $ 0.25.

c. rises to $1,000.00.

2. American Graffiti Corporation has 5 million shares outstanding and debt with interest payments of $1.3 million. How much cash flow would the firm need to earn in order to provide a $3.00 cash flow per share to equity?