A stock sells for $10 per share. You purchase 100 shares for $10 a share (i.e.,...
1. A stock sells for $10 per share. You purchase 100 shares for $10 a share (i.e., for $1,000), and after a year the price rises to $17.50. What will be the percentage return on your investment if you bought the stock on margin and the margin requirement was (a) 25 percent, (b) 50 percent, and (c) 75 percent? (Ignore commissions, dividends, and interest expense.) Please show how to solve in Excel Step-by-Step.
An investor sells a stock short for $36 a share. A year later, the investor covers the position at $30 a share. If the margin requirement is 60 percent, what is the percentage return earned on the investment? Redo the calculations, assuming the price of the stock is $42 when the investor closes the position. Please show how to solve within Excel step by step
I included problem one for reference. I only need problem two
solved.
Please use excel to solve. The problem and the data provided
must be clearly laid out in the spreadsheet and cell referencing
must be used
1. A stock sells for $10 per share. You purchase 100 shares for $10 a share (i.e., for $1,000), and after a year the price rises to $17.50. What will be the percentage return on your investment if you bought the stock on...
You purchase 100 shares for $60 a share ($6,000), and after a year the price rises to $70. Calculate the percentage return on your investment if you bought the stock on margin and the margin requirement was (ignore commissions, dividends, and interest expense): 25 percent. Round your answer to one decimal place. % 65 percent. Round your answer to one decimal place. % 75 percent. Round your answer to one decimal place. %
You purchase 100 shares for $60 a share ($6,000), and after a year the price rises to $70. Calculate the percentage return on your investment if you bought the stock on margin and the margin requirement was (ignore commissions, dividends, and interest expense): 25 percent. Round your answer to one decimal place. % 65 percent. Round your answer to one decimal place. % 75 percent. Round your answer to one decimal place. %
You purchase 120 shares for $70 a share ($8,400), and after a year the price rises to $80. Calculate the percentage return on your investment if you bought the stock on margin and the margin requirement was (ignore commissions, dividends, and interest expense): 15 percent. Round your answer to one decimal place. % 55 percent. Round your answer to one decimal place. % 80 percent. Round your answer to one decimal place. %
An investor short sells 400 shares of a stock for $ 20.62 per share. The initial margin is 50 %, and the maintenance margin is 29 %. The price of the stock rises to $ 29.95 per share. What is the margin, and will there be a margin call? The margin in the account is _______________%. (Round to the nearest percent.)
An investor short sells 200 shares of a stock for $20.31 per share. The initial margin is 51%, and the maintenance margin is 26%. The price of the stock rises to $28.68 per share. Wha is the margin, and will there be a margin call? The margin in the account is 1%. Round to the nearest percent.)
P2.19 (similar to) An investor short sells 400 shares of a stock for $20.09 per share. The initial margin is 55%, and the maintenance margin is 28%. The price of the stock rises to $28.46 per share. What is the margin, and will there be a margin call? The margin in the account is。% (Round to the nearest percent)
3. CL shares are selling at $71.40. An investor sells 1000 shares of CL short. The initial margin requirement is 35 percent, maintenance margin is 20%, and the commission is $4.95 per trade. After 180 days, the price goes down to $69.75 and the investor closes out the short position. While the investor is in the short position, CL pays $0.85 per share dividends. What is a. the annualized rate of return? b. the price at which there will be...