Purchase Solution

Use of formula to generate annual return percentages

Not what you're looking for?

Ask Custom Question

CALCULATE THE ARITHMETIC AND GEOMETRIC RETURNS OF THESE NUMBERS:

year price dividend
1 $ 44.97 ---
2 47.37 $0.55
3 52.24 0.61
4 47.89 0.57
5 60.00 0.74
6 55.38 0.68

I want to used this formula:

[(1+R1) x(1+R2)x(1+R3)x(1+R4)x(1+R5)x(1+R6)] 1/t -1 t=years

I do not know how to get the annual return. What I did was to add the price and dividend but I think that is wrong.

Same question for this set of numbers:

year price dividend
1 $46.28 ---
2 49.29 .56
3 50.37 .55
4 44.26 .48
5 69.88 .82
6 63.98 .71

Purchase this Solution
Solution Summary

The solution includes a narrative statement to explain the use of the formula, and then calculates the answers in Excel.

Solution Preview

You need a raise the product to the power 1/t
The formula is [(1+R1) ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • Google and Yahoo ROE

    For example, some people use Shareholder's equity at the end of the year to calculate ROE wherein some use Average equity throughout the year to calculate ROE.

  • Calculating rate of return with Excel

    Create a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places. c. Calculate the total return for the entire holding period. What is the compound average annual rate of return?

  • Most important number; which percentages are required

    ANSWERS NOTE: IN the OTA's own words in accordance with BM rules Question 1 Few of the ratios or percentages that should be required as part of a company's annual report include return on equity, asset turnover, net profit margin and asset multiplier

  • Stock Portfolio

    This means that the additional investment of $250,000 will have to generate an annual return of $86,250 - $53,750 = $32,500 or a return of $32,500/$250,000 = 13%.

  • Balancing a Portfolio of Risky vs. Risky Free Assets

    C) What is the slope of the Capital Allocation Line formed with the risky asset and the risk-free asset? -I am having trouble looking in the book and figuring out exactly what formula to use.

  • Financial Analysis using Excel

    b) Create a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places. c) Calculate the total return for the entire holding period. What is the compound average annual rate of return?

  • Calculating IRR and YTM

    46475 I would like to know how to calculate a internal rate of return and yield to maturity I am having difficulty finding the correct formula for calculating the yield to maturity and internal rate of return.

  • Cost Functions

    147348 Cost Functions Percentages The annual cost in dollars for removing p% of the toxic chemicals from a town's water supply is given by the following formula: C(p) = 500,000/ 100 - P a.

  • ROE

    The net cash flow represents the difference between the annual costs of the BI environment and the annual costs of the existing reporting environment. r = The internal rate of return.

View More Related Solutions