Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

problem#1

image text in transcribed

problem#2

image text in transcribed

prolem#3

image text in transcribed

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 scenarios

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Stock Market Investing For Beginners

Authors: George Graham

1st Edition

1914346432, 978-1914346439

More Books

Students also viewed these Finance questions