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
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP
PLEASE
I included problem one for reference. I only need problem two solved. Please use excel to...
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 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 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 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 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 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 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 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 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...