Q1 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% effective monthly rate. Stock borrow fees are 0.1% effective 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 timet = 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 filling out the spreadsheet A1 Template! 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)? PLEASE PROVIDE DETAILED EXPLANATION ALONG WITH THE FORMULA'S USED IN EXCEL Q1 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% effective monthly rate. Stock borrow fees are 0.1% effective 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 timet = 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 filling out the spreadsheet A1 Template! 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)? PLEASE PROVIDE DETAILED EXPLANATION ALONG WITH THE FORMULA'S USED IN EXCEL