Question

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?

Please provide step-by step on how to solve in Excel

Answer 1

Margin amount = Purchase Price * Margin rate

= $ 10000 * 40%

= $ 4000

Amount Invested is $ 4000 not $ 10000

Part A:

% Return = [ Sale Price - Purchase Price ] / Amount Invested

= [ $ 11200 - $ 10000 ] / $ 4000

= $ 1200 / $ 4000

= 0.3 i.e 30%

Part B:

% Return = [ Sale Price - Purchase Price ] / Amount Invested

= [ $ 9000 - $ 10000 ] / $ 4000

= - $ 1000 / $ 4000

= -0.25 i.e -25%

Part C:

% Return = [ Sale Price - Purchase Price ] / Amount Invested

= [ $ 6000 - $ 10000 ] / $ 4000

= - $ 4000 / $ 4000

= -0.1 i.e -100%

Answer 2

Purchase 100 shares of the stock at $3530.11.  Sold for $ 3203.87.

What is the amount of the capital loss ?

What is the percent return?