Question

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 riwas (a) 25 percent, (b) 50 percent, and (c) 75 percent? (Ignore commissions, dividends, and interest expense.)

2. Repeat Problem 1 to determine the percentage return on your investment but in this case suppose the price of the stock fal

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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

­SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASEW ? vu 03:12 ENG 09-03-207022 X fix - DF DG DH DID DK DL DM DN D O DP DQ o 001175 - 1173 1174 1175 1176 WITH MARGIN PURCHASE

Add a comment
Know the answer?
Add Answer to:
I included problem one for reference. I only need problem two solved. Please use excel to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. A stock sells for $10 per share. You purchase 100 shares for $10 a share...

    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.

  • You purchase 120 shares for $70 a share ($8,400), and after a year the price rises...

    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.   %

  • You purchase 100 shares for $60 a share ($6,000), and after a year the price rises...

    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 retu...

    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.   %

  • problem solving

    You purchase 70 shares for $60 a share ($4,200), and after a year the price falls to $50. 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):

  • Question 1- 4 are cobsidered one problem. please answer accordingly. Thanks, Basic (Questions 1-12) 1. Calculating...

    Question 1- 4 are cobsidered one problem. please answer accordingly. Thanks, Basic (Questions 1-12) 1. Calculating Returns (LO1) Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. Compute the percentage total return. In Problem 1, what was the dividend yield? The capital gains 2. Calculating Yields (L01) yield? 3. Return Calculations (LO1) Rework Problems 1 and 2 assuming the ending...

  • PLEASE SHOW EXCEL FORMULAS USED TO SOLVE Suppose a stock had an initial price of $79...

    PLEASE SHOW EXCEL FORMULAS USED TO SOLVE Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. What was the dividend yield? The capital gains yield? nitial price Dividend paid Ending share prices Complete the following analysis. Do not hard code values in your calculations. Dividend yield Capital gains yield Suppose a stock had an initial price of $79 per share,...

  • all blanks need to be solved--crossed out my answers bc they are prob wrong **** to...

    all blanks need to be solved--crossed out my answers bc they are prob wrong **** to make image clear right click and press open image in new tab** Marlene Bellamy purchased 300 shares of Writeline Communications stock at $55.46 per share using the prevailing minimum initial margin requirement of 53%. She held the stock for exactly 5 months and sold it without any brokerage costs at the end of that period. During the 5-month holding period, the stock paid $1.69...

  • You purchase 170 shares for $60 a share ($10,200), and after a year the price falls to $55. Calculate the percentage ret...

    You purchase 170 shares for $60 a share ($10,200), and after a year the price falls to $55. 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. Use a minus sign to enter the amount as a negative value. Round your answer to one decimal place. % 70 percent. Use a minus sign to enter the amount as a negative value. Round...

  • You purchase 120 shares for $40 a share ($4,800), and after a year the price falls...

    You purchase 120 shares for $40 a share ($4,800), and after a year the price falls to $35. 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. Use a minus sign to enter the amount as a negative value. Round your answer to one decimal place. 55 percent. Use a minus sign to enter the amount as a negative value. Round your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT