Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Managerial Accounting Expert

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)

Managerial Accounting, Accounting

  • Category:- Managerial Accounting
  • Reference No.:- M91999445
  • Price:- $70

Guranteed 36 Hours Delivery, In Price:- $70

Have any Question?


Related Questions in Managerial Accounting

Managerial accounting assignment -instructions for

Managerial Accounting Assignment - Instructions for Preparation of Assignment: 1. You are to choose one management accounting topic from the list below for this assignment, and register your chosen topic with your lectur ...

Corporate accounting assignment -assessment task - select

Corporate Accounting Assignment - Assessment task - Select two public limited companies listed on the Australian Securities Exchange (ASX) that are in the same industry. Go to the website of your selected companies. Then ...

Managerial accounting assignment -background you have been

Managerial Accounting Assignment - Background: You have been hired by the Board of Directors of your chosen company (ASX Listed) to explain how ABC model can improve the management accounting information available to its ...

Management accounting assessment - research amp analysis

Management Accounting Assessment - Research & Analysis Teamwork Assessment Description - Learning Outcome - Analyse the issues or problems (in a given scenario) using management accounting techniques and tools, and formu ...

Assume you have been hired as a consultant to prepare a

Assume you have been hired as a consultant to prepare a balanced scorecard that will be presented to top management. You will choose a company to research and will provide a professional report that will include the foll ...

Accounting for decision makersproject - appendix

Accounting for Decision Makers PROJECT - APPENDIX A Requirements: 1. Choose a publicly traded company that you currently own/invest in or one that you would like to own / invest in 2. Research the company through the com ...

Task descriptionyou have gained a position as vacation

Task Description You have gained a position as vacation student at the accounting firm T&K Solutions. In your capacity of vacation student you have been asked by the two partners of T&K Solutions to assist them with two ...

Corporate accounting assignment -objectives -the

Corporate Accounting Assignment - Objectives - The educational objective of this task is to develop student capabilities to read, interpret and analyse financial statements; to apply international accounting standards; t ...

You need to prepare a paper about lacroix companycompany

You need to prepare a paper about Lacroix company Company: Lacroix Home Work: History & background Page: 1 and half

Corporate accounting assignment -question 1 - dr kelvin

Corporate Accounting Assignment - Question 1 - Dr. Kelvin opened a dental clinic on August 1, 2018. The business transactions for August are shown below: August 1 Dr. Kelvin invested $280,000 cash in the business in exch ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As