Calculate real prices from the obtained nominal prices

Assignment Help Managerial Accounting
Reference no: EM131243583

For this project, you should work with the monthly time series of the assigned commodity prices, spanning from January of 1995 to December of 2015.

The project consists of a set of time series estimation and forecasting exercises, pre-sented in a list of assignments below. You should address all these items. You should submit a hard copy of the report, and also send me an R file, containing all the coding for your project.

1. Calculate real prices from the obtained nominal prices. using U.S. producer price index as a deflator, and transform these real prices to the natural logarithm. From here forward, work with these transformed time series of commodity prices, denoted by p1.

2. Plot the time series.

3. Plot the autocorrelogram for up to 24 lap.

4. Based on your observations from 2-3, discuss any apparent features of the time series.

5. Divide the series into the in-sample estimation environment (observations up to and including Dec 2009) and the out-of-sample forecasting environ¬ment (observations beginning from Jan 2010 and onwards).

6. Using in-sample observations to obtain parameter estimates, calculate and plot point forecasts (for the duration equivalent to the out-of-sample window size) and the associated 95% interval forecasts using the following models:

(a) random walk:

(b) linear (deterministic) trend model:

(c) linear (deterministic) trend model with seasonal component;

(d) autoregressive models of orders 1 through 6.

7. Based on your observations from 6, discuss any (additional) characteristics of the time series, particularly in terms of their apparent dynamics.

8. Using in-sample observations (again), estimate vector autoregressive model of orders 1 through 6, where the vector of variables is given by x, = (p,,r,)', and where r, is natural logarithm of the real crude oil prices.

9. Test for in-sample Granger causality between the crude oil prices and the commodity prices in the considered vector autoregressive models.

10. Within the rolling forecasting environment, generate one-step-ahead fore-casts throughout the out-of-sample set using the following models:

(a) random walk;
(b) linear (deterministic) trend model with seasonal component;
(c) autoregressive model of order p, where the optimal p is selected based on AIC (or BIC);
(d) vector autoregressive model of order p. where the optimal pis the same as above.

11. For all the aforementioned models:

(a) obtain one-step ahead forecast errors, and calculate and report the out-of-sample root mean square forecast error (FINISFE) measures:

(b) test the hypotheses of (i) error unbiasedness; (ii) error efficiency; and (iii) no autocorrelation.

12. Combine forecasts from 10 using the equal-weights scheme, and calculate and report the associated out-of-sample RIVSFE measure.

13. Based on your observations from 10 and 11:

(a) discuss which of the considered models is preferred in terms of accu¬rate forecasting of the commodity price series.

(b) is there evidence of out-of-sample Granger causality between the crude oil prices and the commodity prices?

# clean up the working space (not necessary, but can be a good practice)
rm(list=ls())
gc()

# download the Soybeans price Index (internet connection is necessary) <- read.csv("https://www.quandl.com/api/v3/datasets/ODA/PSOYB_USD.csv?api_key=K8-6WCWm9UHx18pve3yx&end_date=2016-08-30")
soy <- read.csv("https://www.quandl.com/api/v3/datasets/ODA/PSOYB_USD.csv?api_key=K8-6WCWm9UHx18pve3yx&start_date=1995-01-01&end_date=2015-12-31")

# download the producer price index (internet connection is necessary)
index <- read.csv("https://www.quandl.com/api/v3/datasets/FRED/PPIACO.csv?api_key=9acm7DjKwub3xaFHzp4o&collapse=monthly&start_date=1994-12-31&end_date=2015-12-31")

## soybeans Average
soy.a <- as.matrix(soy$Value)
ts.soy.a <- ts(soy.a,start=c(1995,1),end=c(2015,12),f=12)

## index Average
index.a <- as.matrix(index$VALUE)
ts.index.a <- ts(index.a,start=c(1995,1),end=c(2015,12),f=12)


#Q1
##calculate real price
soy.real <- soy.a/index.a
##transform to natural logarithm, get pt
p <- log(soy.real)


#Q2
##transform data to time series format
ts.p <- ts(p,start=c(1995,1),end=c(2015,12),f=12)
summary(ts.p)
##plot time series
par(mar=c(3,3,1,1),mgp=c(2,.5,0),cex=2)
plot(ts.p,type="l",xlab="Year",ylab="log real soybeans price",col=4,lwd=2)
abline(h=mean(ts.p),col=2,lwd=2,lty=2)

Reference no: EM131243583

Questions Cloud

Construct an original fallacy argument of that type : Identify and define the fallacy. For example, appeal to tradition, false dichotomy, etc. Explain why this type of fallacy is a bad way of reasoning. Construct an original fallacy argument of that type.
Which imply a violation of the no arbitrage assumption : Which of the following necessarily imply a violation of the no-arbitrage assumption? Assume T > 0 and ? > 0, and that all portfolios are self-financing.
Explain the security vulnerabilities associated : Briefly describe your mobile device and another device currently on the market that uses a different OS. Explain the security vulnerabilities associated with each device. Explain the security solutions that would address the vulnerabilities. Final..
Choose the most appropriate relationship between prices : For each of the pairs of A and B in Table, choose the most appropriate relationship between prices at time t ≤ T out of =, ≥, ≤ and ?, where ?
Calculate real prices from the obtained nominal prices : Calculate real prices from the obtained nominal prices. using U.S. producer price index as a deflator, and transform these real prices to the natural logarithm - discuss which of the considered models is preferred in terms of accu¬rate forecasting ..
What would be the childrens school arrangements : Should the organization set assignment lengths of one year or two with families? What does research say is the optimal time period? If there are families, what would be the children's school arrangements?
Explain your implicit ethical decision-making style : First, explain how you think through and determine what is "right" and "wrong" (personally and professionally) in your own daily life. Second, identify four examples of ethical behaviors and explain how your cultural heritage has shaped your value..
Estimate the fraction of the solar emission : Estimate the fraction of the solar emission that is in the following spectral regions: the ultraviolet, the visible, and the infrared.
Determine efficiency as a function of filament temperature : Assuming that the glass bulb transmits all incident visible radiation, what is its efficiency? The efficiency is defined as the ratio of the visible radiant power to the consumed electrical power.

Reviews

Write a Review

 

Managerial Accounting Questions & Answers

  Calculate parrishs cost of goods manufactured

Calculate Parrishs cost of goods manufactured and calculate Parrish's cost of goods sold - What is the total amount of production/inventoriable costs listed above? Show your work.

  The ultimate outcome is in the best interest of the company

Is it unethical of Joan to bias her estimate of incremental sales on the high side, given that she believes the ultimate outcome is in the best interest of the company?

  Discuss the importance of capacity planning in deciding

Discuss the importance of capacity planning in deciding on the number of police officers or fire trucks to have on duty at a given time.

  Assume that inventory is overstated

What effect will this have on the 2013 income statement?

  At what point should managers reorder the steering wheels

At what point should managers reorder the steering wheels, assuming that both demand and purchase-order lead time are known with certainty?

  Walberg associates, antique dealers, purchased

1. Walberg Associates, antique dealers, purchased the contents of an estate for $ 75,000. Terms of the purchase were FOB shipping point, and the cost of transporting the goods to Walberg Associates warehouse was $ 2,400.

  Identify the costs and benefits of the organisation

Demonstrate their ability to research, critically analyse trends and issues in creating and managing a learning organisation in Australia today.

  You are given the following information about the costs

You are given the following information about the costs of a perfectly competitive firm.

  Identify three types of manufacturing companies

Identify three types of manufacturing companies for which process costing would be an appropriate product costing system.

  Goose down is used in a wide variety of products

Goose down is used in a wide variety of products, including jackets, bedding, and pillows.) In recent years, the cost of down has been increasing. For example, in October 2010, Lands' End, a retailer of clothing and bedding items, was paying about $1..

  Compute the break-even point in dollars for 2014

Compute the break-even point in dollars for 2014 and compute the contribution margin under each of the alternative courses of action.

  Dr massy who specializes in internal medicine wants to

dr. massy who specializes in internal medicine wants to analyze his sales mix to find out how the time of his physician

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