SOIL CRC

Benefit-Cost Analysis Tool

Version 2026.18

SOIL CRC BCA Analytical Tool

A Benefit-Cost Analysis decision aid for agricultural production trials. This release uses the official trial workbook structure, sums direct cost components from the Excel file, supports clear treatment comparison, flexible discounting, sensitivity testing, integrated reporting, and a guided workflow for farmers, advisers, researchers, and project partners.

Publisher and developer

Dr Frank Wogbe Agbola, Newcastle Business School, The University of Newcastle, Australia

Co-developer

Dr Mesfin Genie, Newcastle Business School, The University of Newcastle, Australia

Contact

Email any feedback, comments and suggestions, quoting Version 2026.18, to Frank.Agbola@newcastle.edu.au

About this tool

The Soil CRC BCA Tool was developed as part of the CRC High Performance Soils Project 1.2.008, Packaging Soil CRC tools to enhance the extension and adoption of improved soil management practices.

Use the tool together with the Guide. The Guide explains each tab, the formulas used in the calculations, the meaning of each metric, and worked examples based on the included example dataset.

The current version focuses on direct benefits and direct costs. Direct costs are calculated by summing the individual cost components in the workbook. Key outputs include present value of benefits, present value of costs, net present value, benefit-cost ratio, gross profit margin, and return on investment.

How the workflow works

Download the standard template, enter one row for each replicate in the BCA Data sheet, save the workbook, upload it, review the validation notes, complete the project information section, set the analysis choices in the Settings tab, run the analysis, and then review the results, graphs, and report.

Acknowledgements

Thanks to the project team members, Simon Kruger as Project Lead, and representatives of Western Midlands Group, Riverine Plains Incorporated, Corrigin Farm Improvement Group, Agricultural Innovation Research and Research Eyre, University of Tasmania, and Murdoch University.

CRC for High Performance Soils acknowledges the Australian Government for funding obtained through the CRC Program and all partners and members of the Soil CRC. We also acknowledge the support and valuable contributions gained from industry partners of the Soil CRC in developing the Soil BCA Analytical Tool.

Disclaimer and copyright

The CRC for High Performance Soils has endeavoured to ensure that the tool provides the benefits and costs of using soil amendments and management practices in crop production. It makes no warranty regarding the accuracy of the information provided and will not be liable if the information is inaccurate, incomplete or out of date, nor will it be liable for any direct or indirect damages arising from its use. The outputs of the BCA Tool and related summary report should not be used as a substitute for seeking independent professional advice.

This BCA Tool is copyright to the Cooperative Research Centre for High Performance Soils. Apart from any use permitted under the Australian Copyright Act 1968, no part of it may be reproduced by any process without written permission from the publisher.

What this tool can and cannot do

What it can do

  • Compare treatments using your uploaded trial data.
  • Calculate BCA metrics under the assumptions you select.
  • Show how results respond to changes in key assumptions.
  • Generate draft report text for review.

What it cannot do

  • Guarantee farm-level profitability.
  • Replace professional agronomic, financial or project-specific advice.
  • Account for indirect benefits and costs unless you enter them.
  • Correct poor-quality or incomplete data automatically.
  • Predict future market prices.

Results are interpretation support based on the uploaded data and selected assumptions. Before relying on any result, check data quality and assumptions.

Data upload and project information

Complete these steps in sequence. The same project information is used at the beginning of the report.

Download template
1

Download the template

Use the official Excel file supplied with this tool. It contains the BCA Data sheet and a data dictionary sheet to help with data entry.

2

Fill one row per replicate

Each replicate should have its own row. Keep amendment names and treatment IDs consistent across replicates. The control is identified from the control treatment row in the workbook.

3

Save and upload

Save the completed file before uploading it back into the tool. This helps avoid incomplete workbook errors.

4

Complete project details

Enter the project details below so they can appear in the report and in the Word or PDF-ready export.

No workbook uploaded yet.
Active data source: none loaded yet
Next recommended action Upload a completed workbook or load the sample data. Continue to Results becomes available once the data load and pass essential validation.

Workbook summary

Workbook-
Sheet used-
Rows-
Treatments-
Control rows-
Rows with yield-
Upload a workbook to see validation messages.
Waiting for data. Upload a workbook or load the sample data to begin.

What the tool checks

Template structure The workbook should contain the standard BCA Data layout.

Treatment consistency Treatment names, IDs, and control flags should be clearly and consistently populated.

Costs Yield and direct cost values should be provided as numeric entries where applicable and on a hectare basis.

Control rows At least one control row must be included for the control treatment.

Project details for the report

These fields are shown at the beginning of the report and help tailor the narrative to the project.

Data preview

The first cleaned rows from the uploaded workbook are shown below.

Settings

Current settings are shown above. Click Apply settings to confirm and refresh the analysis.

How discounting is applied

Constant rate The same discount rate is used for every year.

Increasing rate The initial rate applies up to the switch year, after which the later rate comes into effect.

Declining rate The initial rate applies up to the switch year, after which the later rate comes into effect.

The active discount schedule will be shown here after analysis is run.

Results

Choose the comparison mode, then run the analysis. The full table below reports all treatment results.

Active data source: none loaded yet
No data loaded. Open the Data tab to upload a workbook or load the sample data, then run the analysis.
Present value of benefits-
Present value of costs-
Net present value-
Benefit-cost ratio-
Gross profit margin-
Return on investment-
Difference versus control-

Headline interpretation

Upload data and run the analysis to view the headline interpretation.

Comparison details

What these results suggest

Plain-language interpretation based on the uploaded data and the assumptions currently set. These are interpretation support only, not financial or agronomic advice.

Run the analysis to see a plain-language interpretation of NPV, BCR, ROI, the ranking and the comparison with the control.

Treatment ranking

Absolute performance (PV benefits, PV costs, NPV, BCR, gross profit margin, ROI) is shown alongside the incremental "Difference versus control". Note: a treatment's total NPV is not the same as its incremental NPV relative to the control.

RankTreatmentAverage yield (t/ha)Average direct costs ($/ha)PV benefits ($/ha)PV costs ($/ha)NPV ($/ha)BCRGross profit margin (%)ROI (%)Difference versus control ($/ha)

How the calculations work

All results are reported per hectare. Benefits and direct costs are discounted over the selected analysis period.

All figures are per hectare. Annual benefits and annual direct costs are assumed to repeat over the analysis period and are discounted to present value using the discount schedule set in Settings. Units are shown beside every result: $/ha, t/ha, $/t, % and years.

  • Annual gross benefit = average yield (t/ha) × grain price ($/t).
  • Annual direct cost = sum of the individual cost components in the workbook ($/ha).
  • PV benefits ($/ha) = discounted value of annual benefits over the analysis period.
  • PV costs ($/ha) = discounted value of annual direct costs over the analysis period.
  • NPV ($/ha) = PV benefits − PV costs.
  • BCR = PV benefits ÷ PV costs.
  • Gross profit margin (%) = (PV benefits − PV costs) ÷ PV benefits × 100.
  • ROI (%) = (PV benefits − PV costs) ÷ PV costs × 100.
  • Difference versus control ($/ha) = selected treatment NPV − control NPV.

Direct costs are summed from the individual cost components in the workbook, not taken from a single pre-totalled cost column. The components used are: seed, cost of amendment (where provided), total labour, total machinery, fertiliser, pesticides, fuel, marketing, repairs and maintenance, support services, electricity, water, insurance services, overheads, interest paid on loans, structure maintenance, and other direct costs. The reported total farm cost column in the workbook is shown for reference only.

The active discount schedule will appear here after you run the analysis.

Figure 1. Benefit-cost ratio by treatment

Figure 2. Net present value by treatment ($/ha)

Figure 3. Difference in net present value relative to the control ($/ha)

Figure 4. Gross profit margin by treatment (%)

Figure 5. Return on investment by treatment (%)

Chart data and plain-language summary (accessible tables)

The charts above use colour and height as cues. The same values are provided here as text and tables so they can be read in greyscale or by a screen reader.

Run the analysis to populate the chart data tables.

Sensitivity analysis

Test how the selected treatment responds to alternative assumptions. This does not change your workbook or the main analysis.

Selected treatment: run the analysis to select a treatment.

ScenarioDiscount rate (%)Grain price ($/t)Benefits change (%)Costs change (%)
Conservative
Alternative
Optimistic
ScenarioDiscount rate (%)Grain price ($/t)Benefits change (%)Costs change (%)PV benefits ($/ha)PV costs ($/ha)NPV ($/ha)BCRGross profit margin (%)

Report

Part A reproduces the project information you entered in the Data tab. Part B combines the analysis with a narrative summary.

Part A: Project summary

Part B: Summary source

External AI drafting (optional)

This is separate from the built-in Analysis Assistant. If you have your own ChatGPT or Copilot access, the tool copies a complete prompt (project details, ranking, sensitivity, settings and headline interpretation) and opens the service in a new tab. Paste the prompt there, generate the narrative, then paste it back into the box above. Anything generated this way is draft text requiring review.

Prepared prompt

Report preview

Help and FAQ

Practical help for farmers, advisers, and other users.

Why are my results missing?

Results usually remain empty when no workbook has been uploaded, when no control rows are present, or when yield and direct cost values are missing for the selected treatments.

Why is the ranking table empty?

The ranking table is filled after you upload a workbook and click Run Benefit-Cost Analysis in the Results tab.

How should I structure the uploaded workbook?

Use the standard template from this tool. Enter one row per replicate in the BCA Data sheet. Keep treatment names consistent and save the file before uploading it back into the tool.

How are direct costs calculated?

The tool sums the individual cost components in each replicate row directly from the workbook, including seed, cost of amendment where provided, labour, machinery, fertiliser, pesticides, fuel, marketing, repairs, support services, electricity, water, insurance, overheads, interest paid on loans, structure maintenance, and other direct costs. The reported total farm cost column is shown in the workbook for reference only.

What do the outputs mean?

Net present value shows benefits minus costs after discounting. Benefit-cost ratio compares discounted benefits with discounted costs. Gross profit margin shows the share of discounted benefits remaining after discounted costs are deducted. Return on investment shows net gains relative to discounted costs.

How do the two comparison modes differ?

The first mode compares a selected treatment against the control. The second mode compares any two treatments side by side. A warning appears if the same treatment is selected twice.