Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show me how to answer these in excel. I have to use an excel spreadsheet. Problems: 1,2,3 and 6 please. problem#1 problem#2 prolem#3 prolem#6
Please show me how to answer these in excel. I have to use an excel spreadsheet. Problems: 1,2,3 and 6 please.
problem#1
problem#2
prolem#3
prolem#6
please just answer problem #2 and #3
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.) Repeat Problem to determine the percentage return on your investment but in this case suppose the price of the stock falls to $7.50 per share. What generalization can be inferred from your answers to Problems 1 and 2? Problem 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.) 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? Ms. Tejal Gandhi has decided that the stock of SmallCap Inc is overvalued at $4 a share and wants to sell it short. Since the price is relatively low, short sales cannot be executed on margin, so Ms. Gandhi must put up the entire value of the stock when it is sold short. a) What is the percentage loss if the price of the stock rises to $8? b) What is the percentage loss if the price of the stock rises to $10? c) What is the percentage gain if the company goes bankrupt and is dissolved? d) What are the maximum percentage gain the short seller can earn and the largest percentage loss the short seller can sustain? e) From the short seller?s perspective, what are the best and worst case scenariosStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started