Assignment 1 (FRE 501) Name & Student ID:

Instructions: i. Data for the questions are provided in the accompanying excel file

ii. Please submit the following on Canvas: o Your typed answers as a PDF file o Your completed excel file o Your class participation record (Lectures 1 to 4)

Question 1: (23 marks total)

a. Plot world wheat prices from Jan 2015 to July 2022. (1) b. On the same graph, plot inflation rates over the same period and on the secondary axis

(view example on the excel file). (1) c. What is the relationship between the two? Run a regression to show the relationship

statistically, wheat prices as the independent variable and inflation as the dependent variable. (2)

d. State the month when inflation really begins to take off (increase)? (1) e. Now re-run the regression in two parts, first for the period from Jan 2015 to Dec 2020;

second from Jan 2021 to July 2022. Explain your results. (3) Background Information:

Use Canada as an example of a wheat producer/exporter. Note that the production of wheat each year requires farmers to decide in March-April which crops they will grow. If they wish to produce more wheat, they will allocate more of their land to wheat and away from the alternative crop they would otherwise be growing (e.g., canola). In anticipating their wheat production, they will have to acquire adequate supplies of fertilizer and other farm inputs, typically making purchases also in those early spring months. The wheat price will be determined by the world supply and demand. Some supplies of wheat will be determined even earlier if there is planting of winter wheat or an earlier growing season.

f. Describe the process by which inflation will affect Canadian wheat prices. (3) More information:

Suppose inflation in wheat producing countries starts to rise in (Canadian data follows) July 2021, jumping from 3.1 to 3.7%, and only begins to rise seriously in Jan 2022 (monthly inflation hits 5%), rising each month to June (8.1%). By planting decision time, inflation is running at annual rate of 5-7% (year over year, calculated each month.

g. How will that affect wheat prices over the period from January to July 2022 that we have so far observed? Putting this differently, if there was no significant inflation in 2021 through to date, how would this have changed the observed rise in global wheat prices? (3)

h. How would the actual observed inflation affect world wheat prices looking forward (in the future), ignoring other factors in the wheat market such as the war in Ukraine? (2)

i. Assume that fertilizer input costs account for 30% of total revenues. If fertilizer costs doubled, and if wheat prices increased by 50%, we wish to calculate the net effect on profits and planting decisions (these are roughly realistic numbers for spring 2022).

i. Calculate the effect on net profit or earnings before taxes for “Wheat-Hard Red Spring” (The relevant financial data can be found on Page 4 of the following document: https://www.gov.mb.ca/agriculture/farm- management/production-economics/pubs/cop-crop-production.pdf) (3)

ii. What is the effect on farmer’s planting decision from this change in profit? i.e., will they increase wheat plantings, given both an increase in fertilizer costs and an increase in the wheat price? (2)

j. Now show how this example of the long term effect of inflation will likely affect wheat prices (for late 2022, 2023)? (2)

Question 2: (9 marks total)

a. Plot the relationship between agricultural commodity prices (Farm Product Price Index) & retail food prices (Food CPI). Do this for Jan 2020 through to July 2022. (1)

i. What is the relationship between the two? (1) b. Conduct regressions and interpret the corresponding R Squared values

i. Food CPI in period t-1 (Independent variable) on Farm Product Price Index in period t (Dependent variable). (2)

ii. Farm Product Price Index in period t-1 (Independent variable) on Food CPI in period t (Dependent variable). (2)

iii. Contemporaneous effects, Farm Product Price Index in period t (Independent variable) on Food CPI in period t (Dependent variable). (1)

c. Give some economic arguments for why one direction of causation would be more plausible than another (comparing i. with ii.)? (2)

Question 3: (8 marks total)

a. On excel, convert the monthly Farm Product Price Index & Food CPI data into a quarterly series. (1)

b. Create 2 new data series that depicts the quarterly change in both Farm Product Price Index & Food CPI. (2)

c. Plot the quarterly percentage change in Farm Product Price Index & Food CPI from Q2- 2000 to Q1-2022. (1)

i. Comment on the relationship between the quarterly percentage change in Farm Product Price Index and Food CPI. (1)

ii. Provide reasons for the difference in volatility between the quarterly percentage change in Farm Product Price Index & Food CPI. (3)

Qn 1

Qn 2

	Data Sources
	Statistics Canada. Table 32-10-0098-01  Farm product price index (FPPI), monthly https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3210009801
	Statistics Canada. Table 18-10-0004-01  Consumer Price Index, monthly, not seasonally adjusted https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000401
	Date	Farm Product Price Index	Food CPI
	Jan-20	132.4	153.5		Question 2a)
	Feb-20	132.4	152.9
	Mar-20	132.7	152.8
	Apr-20	130.5	154
	May-20	134.5	154.3
	Jun-20	133	154.8
	Jul-20	132.5	155
	Aug-20	132.9	153.8
	Sep-20	134.3	152.6
	Oct-20	137.3	153.3
	Nov-20	138.2	153.9
	Dec-20	139.5	153.6
	Jan-21	143	155
	Feb-21	147.9	155.6
	Mar-21	153.1	155.5
	Apr-21	158.5	155.4		Question 2bi)
	May-21	158.6	156.6
	Jun-21	164.4	156.8
	Jul-21	167.5	157.6
	Aug-21	163.8	158
	Sep-21	167	158.5
	Oct-21	167.4	159.2
	Nov-21	173.6	160.7
	Dec-21	175.7	161.6
	Jan-22	185.7	163.9
</t Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. Do you need an answer to this or any other questions? Order Plagiarism Free Answer Here About Wridemy We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It Works To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts? All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first order Related Tags Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA