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

Written report on company, I have a assignment of financial accounting It...

I have a assignment of financial accounting Its a report on company Assignment length 2000 words

Describe factors contributing to effective cash management, Describe the ma...

Describe the major factors contributing to effective cash management in a firm.  Why is the cash management process more difficult in a MNC? An effective cash management system s

share-appreciation mortgages (sams), High interest rates in the earl...

High interest rates in the early 1980s brought about this innovative mortgage arrangement. SAMs use inflation as a way of paying for the property. The lender agre

Cash flow yield analysis, A cash-flow yield is the discount r...

A cash-flow yield is the discount rate that makes the price of a mortgage-backed or asset-backed security equal to the present value of its ca

Define the term- earnings per share, Define the term- Earnings per share (E...

Define the term- Earnings per share (EPS) EPS = Profit available to ordinary shareholders (PAT) / Weighted average number of shares in issue(p per share) This ratio illustra

Budget classification on the basis of time, ON THE BASIS OF TIME • Lon...

ON THE BASIS OF TIME • Long term budget :  as per the National Association of Accountants, America, a long term budget is a systematic and formalized process for purposeful co

Design a digital option as a sequence of calls, An individual agent thinks ...

An individual agent thinks that there is a high probability that the Dow Jones will have a payoff (or points) between a=10000 and b=12000 at t=1. Design a digital option (see Fi

Exchange rates, Exchange Rates The prices at which one country's c...

Exchange Rates The prices at which one country's currency can be changed into that of other country. Although perceptions in the currency markets of the privacy of a count

Need help, #queThe opening balance of one of the 31-day billing cycles for ...

#queThe opening balance of one of the 31-day billing cycles for Lorenzo''s credit card was $4100, but after 15 days Lorenzo made a payment of $2300 to decrease his balance, and it

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