Please answer in Excel and show steps.

Problem 2 Margin

2.A. The current market price for XYZ is $45 per share. Initial margin is 50%, maintenance margin is 35% and margin interest is 1.25% per year.

2.A.1) You believe the stock price will increase over the next year and wish to trade exactly one round lot. What trade should you make (2 points)? How much margin would you have to post to your account (4 points)? At what price would you receive a margin call (7 points)?

2.A.2) Suppose you are correct and the stock rises to $55 per share at the end of the year. What is your percentage return on equity for this trade (4 points)?

2.B. The current market price for ABC is $79 per share. Initial margin is 50%, maintenance margin is 35% and there is no margin interest.

2.B.1) You believe the stock price will decrease over the next year and wish to trade exactly one round lot. What trade should you make (2 points)? How much margin would you have to post to your account (4 points)? At what price would you receive a margin call (7 points)?

2.B.2) Suppose you are correct and the stock falls to $62 per share at the end of the year. What is your percentage return on equity for this trade (4 points)?