Formula used in this questions are:
Capital gain= (purchase price-end sell price)*No. of shares
dividend= dividend per share* No. of shares
Total dollar return on investment= capital gain+ dividend
Capital gain yield= (Capital gain/ Cost of investment)*100
Dividend yield= (Dividend/ Cost of investment)*100
Total rate of return on Investment= capital gain yield+
Dividend Yied

solve question 1&2 and question 3 please becuase it depends on 1&2 -ns 1. Calculating Returns...
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...
Calculating Returns [LO1] Suppose a stock had an initial price of $65 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $71. Compute the percentage total return. Calculating Yields [LO1] In Problem 1, what was the dividend yield? The capital gains yield?
2. Award: 7.69 points Problem 12-2 Calculating Yields (L01) Suppose a stock had an initial price of $82 per share, paid a dividend of $1.60 per share during the year, and had an ending share price of $92. What was the dividend yield and the capital gains yield? (Round the final answers to 2 decimal places.) Dividend yield Capital gains yield % References Worksheet Problem 12-2 Calculating Yields (L01) Learning Objective: 12-01 How to calculate the return on an investment
NEED EXCEL SOLUTION PLEASE: EXCEL FORMULA ONLY Calculating returns in Excel is a relatively simple matter since we only need to input basic equations. Consider the information from the Video Concepts Company: Shares: 100 Beginning price: $ 37.00 Ending price: $ 40.33 Dividend per share: $ 1.85 With this information, we can calculate the dollar returns and percentage returns as: Total dollar capital gains: Dividend income: Total dollar return: Capital gains return: Dividend yield: Total return:
Problem 1-2 Suppose you bought 200 shares of stock at an initial price of $38 per share. The stock paid a dividend of $.30 per share during the following year, and the share price at the end of the year was $41. a. What is the capital gains yield? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Omit the'%"sign in your response.) Capital gains yield b. What is the dividend yield? (Do...
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,...
Question 1 (of 3) value 30.00 points P12-1 Calculating Returns [L01] Suppose a stock had an initial price of $77 per share, paid a dividend of $1.6 per share during the year, and had an ending share price of $90. Compute the percentage total return. O 18.96 о 16.22 о 23.64 O 19.91
Suppose you bought 500 shares of stock at an initial price of $44 per share. The stock paid a dividend of $.42 per share during the following year, and the share price at the end of the year was $45. a. What is the capital gains yield? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Omit the "%" sign in your response.) Capital gains yield % b. What is the dividend yield?...
3. Paying taxes on stocks What It Means to Invest in Stocks? Common stock is considered to be one of the most popular investment vehicles for long-term wealth building. Investors earn income from common stock in the form of dividends and/or capital gains. As an investor it is important to understand the implications of investing in stocks from a tax perspective Two years ago, Clancy purchased 100 shares of a particular company's stock at a price of $136.55 per share....
Problem 12-3 Return Calculations [LO1] Suppose a stock had an initial price of $50 per share, paid a dividend of $.80 per share during the year, and had an ending share price of $38. Compute the percentage total return, dividend yield, and capital gains yield. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) Total return % Dividend yield %...