*please show with excel formulas and calculations*

Suppose that Intel currently is selling at $60 per share. You buy 400 shares using $15,000 of your own money, borrowing the remainder of the purchase price from your broker. The rate on the margin loan is 8%.

a. What is the percentage increase in the net worth of your brokerage account if the price of Intel immediately changes to: (i) $63.90; (ii) $56.10?

b. If the maintenance margin is 25%, how low can Intels price fall before you get a margin call?

c. How would your answer to (b) change if you had financed the initial purchase with only $12,000 of your own money?

d. What is the rate of return on your margined position (assuming again that you invest $15,000 of your own money) if Intel is selling after 1 year at: (i) $63.90; (iii) $56.10?

e. Continue to assume that a year has passed. How low can Intels price fall before you get a margin call?