Calculations and graphing cumulative returns, Financial Management

Assignment Help:

Monthly Returns: You now need to calculate the monthly "periodic" returns for all three stocks and the S&P index.  Adapting the holding period return formula (End - Beg) / Beg for each period, you need to enter the following formula in cell G4.  Note that you skip G3 because the data from the previous month has been omitted.

=(B4-B3)/B3    (B3 and B4 are cell references to the above spreadsheet).

Now copy that formula to the bottom of the data set and repeat the process (using the correct cell references) for the other stocks and the index.  Format columns G, H,I, J, and Kas percentages.

YOU WILL USE THE PERIODIC RETURNS FOR ALL PORTFOLIOS STATISTICS.

Step 2) Cumulative Returns:We will now create a "normalized" index for each stock price which will represent cumulative returns over the entire period.  You want a starting value of 1 for your index for each stock. So in cell L3, type 1.0000, and in cell L4 type

            =L3*(1+G4) = Cumulative return for t-1 times (one plus the monthly return for month t)              

Repeat for the other stocks and the index using the correct cell references. These cumulative return columns should be formatted as numbers. For each stock and the index, the row 3 cell should be 1.0000, and subsequent cells should represent the impact of the evolving monthly returns. Note that if your price declined from the 1st month to the 2nd month that your "cumulative return" will be <1.0000.This is because the cumulative return is equal to 1 plus the rate of loss for the first month in decimal form.

YOU WILL USE THE CUMULATIVE RETURNS FOR GRAPHING AND GEO-MEAN CALCULATIONS ONLY.

Step 3) Graphing: The last step is to graph the cumulative returns data for each of your stocks with the index value from step 2) on the y-axis and the "date" on the x-axis. Use a line graph, and allow the lines to cross. Choosing an option that forces the lines not to cross will result in misleading and erroneous graphs.Place this graph on the bottom of your "Monthly Data" sheet.


Related Discussions:- Calculations and graphing cumulative returns

Which currency has used in an international acquisition, Which currency has...

Which currency has to be used in an international acquisition in order to calculate the flows? It can be completed in the local currency or in the currency of the parent compan

DIVIDEND, dividend decisions has an influence on the share value and subseq...

dividend decisions has an influence on the share value and subsequently the overall company value.

Evaluate the fair value of the net assets, Treatment of PER IFRS 3 Bu...

Treatment of PER IFRS 3 Business combinations necessitate goodwill on gaining to be calculated at the date control is gained. The second gaining gives ROB a 75% holding and

Significant performance indicators, Significant Performance Indicators ...

Significant Performance Indicators   Following are the most commonly used performance indicators used to assess the financial, and general health of any company:   Gro

Operational cycle, discuss the applicability of the operational cycle in ve...

discuss the applicability of the operational cycle in vegetable growing business in uganda

Section C, Honey Well company is contemplating to liberalize its collectio...

Honey Well company is contemplating to liberalize its collection effort. It''s present sales are 1000000 and it''s average collection period is 30 days, it''s expected variable c

Foreign exchange rates, Foreign Exchange Rates The proportional va...

Foreign Exchange Rates The proportional value of one currency to other, used to exchange currency from one denomination to another.  For example, one British pound is wort

Types and causes of unemployment, Question 1: (a) Discuss the main limi...

Question 1: (a) Discuss the main limitations of using changes in national income as an index of economic welfare. (b) What are the alternatives measures and issues that sho

What do you mean by variable working capital, Q. What do you mean by Variab...

Q. What do you mean by Variable working capital? Permanent or fixed: Permanent or fixed working capital is the minimum amount which is required to ensure effective utilization

Which method should we use to valuate young companies, Which method should ...

Which method should we use to valuate young companies with high growth but uncertain futures? Two examples were Boston Chicken and Telepizza when they began. The great majo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd