Question: Please show the calculation, if using Excel, please show the formulas. Practice Question: What is your annual return in dollars for this investment: owned 100

Please show the calculation, if using Excel, please show the formulas.

Practice Question:

What is your annual return in dollars for this investment: owned 100 shares at $25/share on January 1, owned 115 shares at $26.50 on December 31 and received annual dividends of $110?

* Would you use the fomula: R = (End Price Beg Price / Beg Price) + (Income / Beg Price), the use the answer to to calculate the dollar figure ?

Alternate methods are OK, I have not done an example like this.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please show the calculation, if using Excel, please show the formulas. Practice Question: What is your expected annual rate of return for this portfolio: - stock A 1000 shares at $22/share expected...

Please show the calculation, if using Excel, please show the formulas. Practice question: Part a : What annual rate of return should an investor expect for a stock that has a beta of .8 when the...

Please show all work. If using excel please show all formulas and calculations Down Under Boomerang, Inc., is considering a new 3-year expansion project that requires an initial fixed asset...

Please show all work. If using excel please show formulas. Down Under Boomerang, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.31 million....

Please help with this accounting case. You have just come back from your meeting with Hector and Sophia Perez, owners of Scenic View Winery, and are organizing your notes. As the new accountant for...

You have just come back from your meeting with Hector and Sophia Perez, owners of Scenic View Winery, and are organizing your notes. As the new accountant for the winery, the meeting was to bring you...

make a spreadsheet to show work. Assignment This assignment is a capital budgeting case with an extra twist in which you also need to figure out the firm's cost of capital. This involves a...

# 4 Answer Instructions #1 Answer #2 Answer #3 Answer #5 Answer Week 6 Case Study Instructions You should use the Excel Template provided to answer the five questions in this case. Each question...

please show how todo this in excel please elaborate how you filled in the formulas. (no need to show 2b) excel ia still a little confusing to me and im really tryign to figure out excel instead of a...

Assignment 3 For the following questions, please show your work in an Excel worksheet. Provide clarifying comments when necessary. Please upload the Excel workbook to Blackboard when you are done....

A mobile phone service provider randomly samples customers each year to measure current satisfaction with the service provided. The following table summarizes a portion of the survey, with 100...

How can the four (4) most common types of system errors in electronic information systems be avoided?

Question 3 1 You just opened a brokerage account, depositing $ 3 , 5 0 0 . You expect the account to earn an interest rate of 9 . 6 5 2 % . You also plan on depositing $ 4 , 5 0 0 at the end of years...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".