Find average arithmetic and geometric based on real returns

Assignment Help Finance Basics
Reference no: EM131208383

Investments

Instructions for Asset Returns Paper

Step 1 Extending Siegel (1992) graphs to 2014

This section uses the file "AssetHistoricalReturns" to replicate and extend Siegel (1992) results to 2014.

1. Create a chart that plots the value of a dollar invested in the CPI index (inflation), short-term government bonds (T-Bills), long-term investment grade corporate bonds (AA bonds), long-term high-yield corporate bonds (BBB bonds), U.S. stocks, U.S. small stocks, and real estate. Label and position the chart. Make sure the reader can easily understand the graph.

2. Create another chart similar to the above but this time adjust returns for inflation. (Obviously, for this graph you don't need to plot the inflation itslef.)

3. Comment based on the charts. Some suggestions are: Which assets had higher returns over the 1990-2014 period? Did you expect the ranking in returns between assets? Did all assets compensate investors for inflation? Note on the correlation between returns based on the graph, especially during the financial crisis of 2008. Overall, is the results consistent with Figure A of Siegel (1992)? Explain your answers.

Step 2 Compute Statistics

This section computes statistics and compare them to those of Siegel (1992).

4. Compute average arithmetic, average geometric, and standard deviation based on nominal returns. Compute average arithmetic, average geometric, and standard deviation based on real (inflation adjusted) returns. Create a table and report the annualized statistics for all measures. To annualize returns, multiply the values by 12 (there are 12 months in a year), for standard deviation, multiply the values by √12. Make sure the table is labeled and has captions.

5. Compare your statistics for inflation, U.S. stocks, and U.S. T-bills to those of Siegel. [Siegel report stock statistics in Table I, bond in Table II, and inflation (CPI) in Table III.] Based on your statistics for the 25 year period of 1990-2014 and those of Siegel, what do you think about the trends in returns of stocks and bonds? Is history repeating or are there any structural breaks?

Final Instructions

1. Please copy/paste the relevant results and include everything in ONE document. I will only grade one document. The document should be in PDF format and posted to Canvas portal.

2. Please do not include any raw data in your paper. You are preparing a report/paper similar to Siegel (1992).

3. Please make sure your paper is properly formatted (does not include any of my instructions, fonts are consistent, columns are aligned, etc). This should be a professional looking document. Format (the paper, graphs, and tables, captions) is very important.

Attachment:- Assethistoricalreturns.xlsx

Reference no: EM131208383

Questions Cloud

Current ratio before and after issuing the note : On June 30, 2014, Freeman Company’s total current assets were $496,500 and its total current liabilities were $274,500. On July 1, 2014, Freeman issued a short-term note to a bank for $39,800 cash. Compute Freeman’s working capital before and after i..
What is internal generated voltage per phase inside motor : A 4.12 kV, 60 Hz, 3000-hp 0.8-PF-leading, Δ-connected, three- phase synchronous motor has a synchronous reactance of 1.1 per unit and an armature re at rated voltage with a line current of 300 A at 0.85 PF leading, what is the internal generated v..
Design of a research study : Strategic Financial Project [PAM006] - The focus is the design of a research study. Your response to the requirement must be between 3,000 and 3,500 words. Penalties apply for exceeding the word count. No formal penalties apply for using fewer than..
Difference between a profit center and an investment center : The difference between a profit center and an investment center is
Find average arithmetic and geometric based on real returns : Compute average arithmetic, average geometric, and standard deviation based on nominal returns. Compute average arithmetic, average geometric, and standard deviation based on real (inflation adjusted) returns.
Compute the accounts receivable turnover-inventory turnover : Selected data from Komar Company follow. Balance Sheet As of December 31 2014 2013 Accounts receivable $ 404,000 $ 378,000 Allowance for doubtful accounts (20,200 ) (15,120 ) Net accounts receivable $ 383,800 $ 362,880 Inventories, lower of cost or m..
Executive and legislative shared powers : Provide a case study paper, which examines the process of the shared powers between the executive and legislative federal branches of government as it relates to this particular article. You will want to relate the case study to what you have lear..
Write the given paper assignment on the topic of humanities : Write the given paper assignment on the topic of Humanities. - Coose two people to compare and contrast for the project.
Conduct strategic analysis of this business or organization : You are required to conduct a strategic analysis of this business or organization. This should involve external and internal environmental scanning, including PESTEL, Five- forces analysis, Stakeholder analysis, internal strength-weakness and SWOT..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  You find that a small business loan in the amount of 50000

you find that a small business loan in the amount of 50000 is the amount you need to purchase the restaurant location.

  Describe the change from the current and prior years

describe the change from the current and prior years

  Describe what will happen if the stock is not in equilibrium

a. If the risk-free rate is 9 percent and the expected rate of return on an average stock is 13 percent, what are the required rates of return on Stocks C and D? b. For Stock C, suppose the current price, P0, is $25; the next expected dividend, D1, i..

  Management responsibility for the failure

In order to complete this assignment, you will need to search the Internet and Strayer databases for information related to Lehman Brothers' bankruptcy, the financial risk factors that contributed to the failure, and management's responsibility fo..

  How master in risk management help to improve the skills

How a master in Risk Management can help to improve or maintain the skills of an accounting manager that works in the financial reporting area of an insurance company?

  Bbaflex corporation has ending inventory of 426163 and

a remi inc. has sales of 15 million total assets of 9 million and total debt of 3.7 million. if the profit margin is 7

  Xyz company has a cost of capital of 98 percent the

xyz company has a cost of capital of 9.8 percent. the companys cost of equity is 15 percent and its cost of debt is 7.5

  Construct a spreadsheet model to compute free cash flow

What level of annual unit sales does it take for the investment to achieve a zero NPV? Use your spreadsheet model to answer this question

  Explain the meaning of a value-at-risk statistic in terms

Explain the meaning of a Value-at-Risk statistic in terms of a smallest expected loss and the probability of such a loss.

  Te bond pays a 10 percent annual coupon and has a

ibx has a bond issue outstanding that is callable in three years at a 5 percent call premium. the bond pays a 10

  What will your earnings per share be after the merger

Suppose you offer an exchange ratio such that, at current pre-announcement share prices for both firms, the offer represents a 20% premium to buy TargetCo, what will your earnings per share be after the merger?

  Difference between covariance and correlation

What is the difference between covariance and correlation? If the value is 0.80, interpret it in the context of correlation?

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