Dairying regions in Victoria: Risk profiles using historical data and @RISK®

Research output: Book chapter/Published conference paperConference paper

393 Downloads (Pure)


The paper asks, “What comparisons of farm financial risk characterise the key Victorian dairy regions over the past 13 years?” The dairy industry is the 3rd largest rural industry in Australia (Dairy Australia, 2018). The dairy farmers, though, are facing a continuous cost price squeeze amid a challenging global environment that suppresses milk prices and raises feed costs in the face of drier and hotter weather conditions (Dairy Australia, 2019). For this analysis, we focused on three key Victorian dairy regions, namely North (N), Gippsland (G) and South West (SW) which have a combined share of 67% in Australia's milk production (Agriculture Victoria and Dairy Australia, 2018). We analysed the financial risks of these regions based on a representative farm from each region. Balance sheet, profit and loss budget and cash flow were integrated (Malcolm, Makeham, & Wright, 2005) to create a probabilistic model using @RISK version 7.6 from Palisade (2018). The variability in historical inputs of dairy prices, quantities and costs for thirteen years from 2006-07 to 2018-19 in Victorian dairy regions (Agriculture Victoria and Dairy Australia, 2019) was captured using a multivariate copula in @RISK. We, thus, generated decadal (10-year) distributions of profit and loss budgets, balance sheets and cash flows to simulate risks with one hundred thousand iterations under Monte Carlo method. The simulation showed that the net farm income was positive 55, 70 and 80 percent of decades respectively for farms in North, Gippsland and South West regions. Sensitivity analysis of the variable components of income, production and cost and their contributions to variance in net farm income showed that the price of milk was the largest source of variation in net farm income for all regions. Variations in feed costs were greatest in the North region compared to the other two. At the close of a decade (year 10), South West region outperformed on all accounts, including debt repayments, building/retaining equity, return of capital (ROC) and return on investment (ROE) and, thus, appeared the most viable for dairying. The business and financial risk for dairy farms based on variability in production, prices and costs was captured in this analysis by using historical data. We extended its usefulness through @RISK by illuminating their recent probabilistic risk profiles. The method allowed us to summarise the long-term portfolios of farm net profits, debt management and key performance indicators of ROC and ROE. There is a need to extend this analysis to capture the shortages and rising costs of water, particularly in the Northern region.
Original languageEnglish
Title of host publicationProceedings of the 64th AARES Annual Conference
Number of pages12
Publication statusPublished - 17 Sept 2020
EventThe Australasian Agricultural and Resource Economic Society Conference 2020: AARES 2020 - University of Western Australia, Perth, Australia
Duration: 12 Feb 202014 Feb 2020
https://web.archive.org/web/20191213052109/https://www.aares2020.org/ (Conference website)
https://static1.squarespace.com/static/5c83296465019faefa0dfe43/t/5d6e6198e4f17a0001c90201/1567515039377/Call_for_Contributed_Papers_and_Posters5.pdf (call for papers)
http://fleximeets.com/aares2020/?p=programme# (program)


ConferenceThe Australasian Agricultural and Resource Economic Society Conference 2020
OtherThe 64th Annual Conference of the Australasian Agricultural and Resource Economics Society (AARES) will be held in Perth, Western Australia from 11 to 14 February 2020. The conference organizer is the Western Australian branch of the AARES, in collaboration with the University of Western Australia. In its annual conference, economists, policy makers, practitioners and students from Australasia and around the world present research and discuss current issues.
Internet address


Dive into the research topics of 'Dairying regions in Victoria: Risk profiles using historical data and @RISK®'. Together they form a unique fingerprint.

Cite this