There are two stocks: Totally Fake Stock (TFS) and Imaginary Industries

Inc. (III). Both stocks are trading at $100 / share.

Alicia and Bashir each have $10,000 in their respective margin accounts.

Minimum margin is 30%. Interest on cash balances (positive or negative) is

0.5% eective monthly rate. Stock borrow fees are 0.1% eective monthly

rate. Interest is calculated based on the balance at the start of each month

and credited/charged at the end of each month.

Alicia and Bashir both think that TFS will go up and III will go down.

Alicia buys 100 shares of TFS and Bashir shorts 100 shares of III at time t

= 0 (time measured in months).

They are both correct about what happens with the two stocks: TFS in-

creases in value by 1% each month and III decreases in value by 1% each

month for the next 6 months.

a) Neglecting interest rates (on both cash balances and stock loans) and

commissions, guess who's account is worth more at the end of 6 months.

Verify your guess by computing the net mark to market for each of them.

Present your answers by lling out the spreadsheet A1Template!

b) This time taking into account interest rates on both cash balances and

stock loans (but still not commissions), guess who's account is worth more

at the end of 6 months. Verify your guess by computing the net mark to

market for each of them.

c) This time Alicia uses as much leverage as possible by buying on margin.

The minimum margin requirement is 30%. How many shares can she buy

(to the nearest 100 shares)? How much is her margin loan? How much

is her account worth at the end of 6 months (including interest but not

commissions)?

H I J L n N o P Q R s T u 1 2 3 4 5 6 7 Month Bashir 8 9 Total Loan Number of Value of Interest on Interest on Total Loan (Cash + Stock] Margin Ratio Net mtm Shares ||| Share Price shares Stock Loan Cash Cash (Cash + Stock] Margin Ratio Net mtm 10 $0.00 1.0m $10,000.00 0 4510,0woo $20,000.00 momm 1.00 $10,000.00 12 1 13 2 14 3 15 4 16 5 17 6