Question: Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the Dividend column. Then calculate the

Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the "Dividend" column. Then calculate the dividend yield and place results in the "Yield" column.
a. Which stock had the highest dividend yield? Why do you think this is?

b. Which stock had the highest P/E ratio?

Microsoft Verizon Duke Energy Wells Fargo Pfizer Price Earnings Payout Dividend Yield P/E 31.392.69 38.26 2.2 21.07 1.38 30.86 2.82 21.97 1.3 0.3 0.75 0.7 0.25 0.55

Step by Step Solution

★★★★★

3.26 Rating (175 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

650-B-A-I (7262).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

Using the spreadsheet below, calculate a. Total returns for the S&P 500 for each year from 1991 through 2010. b. Cumulative wealth for the first 10 years (1991-2000) and for the second 10 years...

1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over...

The spreadsheet below contains the total returns for the S&P 500 Index for the years 2000-2009 in decimal form. This 10-year period has been called the "Lost Decade." a.Calculate the average annual...

2.3 Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the Dividend column. Then calcu- late the dividend yield and place results in...

2-3 Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the "Dividend" column. Then calculate the dividend yield and place results in...

Using the spreadsheet below, calculate the dollar dividend for each of the five companies and place your answers in the Dividend column. Then calculate the dividend yield and place results in the...

NONCONSTANT GROWTH * Please try to organize work and answers as clearly as possible. I really need the steps and answers to follow along with. This one is a serious pain need all part A-F. Thank you...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

I am wondering if anyone has corrected solutions to fnce 300 assignments 1 2 and 3. I am concered about my answers and would love to compare. Pretty sure on my answers for 1 and 2 mainly interested...

Nelson Company provides the following information for the month ended October 31, 2017: sales on credit $280,000, cash sales $95,000, sales discounts $5,000, and sales returns and allowances $11,000....

How much of the information is relevant to the decision? How do I calcukate the discounted cash flow The company spends 2.4 million on this project and we want to see if it makes economic sense. An...

Which of the following describes co - ordination? Setting targets to encourage efficient working practices Providing information for the creation of short, medium and long term plans Using...

List three types of bonds and briefly describe each of them.

Duration can be calculated using spreadsheet formulas. Data must be entered as follows: Settlement date Date is entered as DATE (year, month, day) Maturity date Date is entered as DATE (year, month,...

Calculate the duration of a bond using the cash flow approach shown in the spreadsheet below. This bond has a current price of $974.47, a coupon of 5.5 percent, and a maturity of 5 years. The YTM on...

Assume a 7 percent; 8-year bond has Macaulay duration of 5.6 years and a YTM of 6.5 percent. Calculate the approximate price change for this bond if interest rates decline 110 basis points.

24. [-70.4 Points] DETAILS HARMATHAP12 1.3.035.MI. Write the equation of the line described. Through (4, 5) and (-1,-5) Need Help? Read It Watch It Master It 24. [-70.4 Points] DETAILS HARMATHAP12...

Problem 5-11 Calculating Present Values [LO2] You have just received notification that you have won the $2 million first prize in the Centennial Lottery. However, the prize will be awarded on your...

A person discovers that his favorite uncle deposited $10,000 fifteen (15) years ago. The deposit was compounded yearly. Today, his uncle has 41, 772. What is the yearly interest rate his uncle got?...