Projected 2019 Rice Farm Cash Flow Model

The Projected 2019 Rice Farm Cash Flow Model was developed to assist producers in planning for the 2019 crop year.The model is an Excel spreadsheet which allows rice producers to enter projected acreage, yield, market price and production cost data for 2019 to estimate net returns above variable production costs and to easily evaluate the impact of changing percent of base planted on net returns.The primary purpose of the model is to evaluate the impact on net returns above variable production costs for alternative rice rental arrangements and percent of base acreage planted.This model does include the Price Loss Coverage (PLC) Program option in the 2014 Farm Bill.The model also includes entry cells for whole farm fixed expenses to estimate projected returns from rice production over all costs.Five worksheets are included to estimate rice cash flow on five different land tracts.Worksheets can be copied to accommodate additional land tracts if needed.

Data Input

The Projected 2019 Rice Farm Cash Flow Model calculates projected net returns above variable production costs for a rice farm or specific tract of land of a specified acreage.For each farm or tract, data to be entered into the model includes estimates for the 2019 crop season including rice acreage, base acres, percent of base planted, projected first crop and ratoon crop yields, program yields, projected prices and production costs.Gross returns, variable costs and net returns are calculated for the farm or tract based upon the data entered.Spreadsheet cells in which data must be entered are listed and defined below.

Acreage, Production and Price Data:

The first section of the model contains cells to enter data concerning projected 2019 rice acreage, production and market prices.The specific data entry cells in the spreadsheet (shaded in blue) are listed below.

Spreadsheet Cell Description

C5 Farm Name

C6 Tract Name / Number

G9 Rice Yield Unit (1 = cwt and 2 = bbls)

G10 Total Rice Base Acres

I11 Rice Acres Planted in 2019

I12 Ratoon Crop Acres in 2019

G13 Projected 2019 Rice First Crop Yield (cwt or bbl)

G14 Projected 2019 Rice Ratoon Crop Yield (cwt or bbl)

G15 Rice Sold on a Green-Weight Basis? (1 = no and 2 = yes)

G17 Rice Base Payment Acreage Percent

G18 Rice Price Loss Coverage (PLC) Program Yield (cwt or bbl)

G20 Rice Cash Rent ($ per acre)

G21Total Acres Cash Rented

G23 Rice Crop Share for Land and Water

G24 Percent of Irrigation Pumping Costs Paid by Grower

G26 Projected 2019 Diesel Price per Gallon

G27 Projected 2019 Nitrogen Price per pound of N

G28 Projected 2019 Phosphorous Price per pound of P

G29 Projected 2019 Potassium Price per pound of K

G31 Rice Reference Price for the PLC program ($ per cwt.)

G32 Projected 2019 Rough Rice Market Price ($ per cwt.)

G33 Projected 2019 World Rice Price ($ per cwt.)

Rice Variable Production Cost Data:

The second section of the model contains cells to enter data concerning projected variable rice production costs for the 2019 season.Costs are entered on a dollar per planted acre basis and should include the proportionate additional cost for any ratoon crop acreage.The specific data entry cells (shaded in blue) are listed below.

Spreadsheet Cell Description

G 59 Custom Aerial Application Costs ($ per acre)

H 59 Percent of Aerial Application Cost paid by grower

D 61 Drying Charge per Yield Unit – Dry-Weight Basis

H 61 Percent of Drying Cost paid by grower

B 64 Fertilizer Material 1 Applied (name)

C64 Pounds of Fertilizer Material 1 Applied (lbs per acre)

E6 Price of Fertilizer Material 1 ($ per ton)

H64 Percent of Fertilizer Material 1 paid by grower (%)

B65 Fertilizer Material 2 Applied (name)

C65 Pounds of Fertilizer Material 2 Applied (lbs per acre)

E65 Price of Fertilizer Material 2 ($ per ton)

H65 Percent of Fertilizer Material 2 paid by grower (%)

B66 Fertilizer Material 3 Applied (name)

C66 Pounds of Fertilizer Material 3 Applied (lbs per acre)

E66 Price of Fertilizer Material 3 ($ per ton)

H66P ercent of Fertilizer Material 3 paid by grower (%)

B67 Fertilizer Material 4 Applied (name)

C67 Pounds of Fertilizer Material 4 Applied (lbs per acre)

E67 Price of Fertilizer Material 4 ($ per ton)

H67 Percent of Fertilizer Material 4 paid by grower (%)

G68 Fungicide Cost ($ per acre)

H68 Percent of Fungicide Cost paid by grower

G69 Herbicide Cost ($ per acre)

H69 Percent of Herbicide Cost paid by grower

G70 Insecticide Cost ($ per acre)

H70 Percent of Insecticide Cost paid by grower

G71 Irrigation Supplies / Gate Cost ($ per acre)

G72 Seed Cost ($ per acre)

G73 Fertilizer Application Costs ($ per acre)

H73 Percent of Fertilizer Application Costs paid by grower

G74 Planting Costs ($ per acre)

G75 Hauling Costs ($ per acre)

G76 Labor Costs ($ per acre)

C77 Gallons of Diesel used for Tillage and Harvest (gallons per acre)

C78 Gallons of Diesel used for Irrigation (gallons per acre)

C79 Electricity Cost for Irrigation ($ per acre)

G80 Repair and Maintenance Costs ($ per acre)

G81 Other Variable Costs ($ per acre)

H81 Percent of Other Costs paid by Grower

C82 Interest Rate on Operating Capital (%)

C83 Term of Operating Loan (months)


Rice Fixed Production Cost Data:

The next section of the model contains cells to enter data concerning projected fixed rice production costs for the 2019 season.Costs are entered on a total farm or total tract allocated basis. Fixed costs entered must be relevant to the level of rice acres entered on the worksheet. Fixed costs per planted acre are calculated by dividing total entered fixed costs by planted acres.The specific data entry cells (shaded in blue) are listed below.

Spreadsheet CellDescription

B91 Name of Fixed Cost Item 1

I91 Value of Fixed Cost Item 1

B92 Name of Fixed Cost Item 2

I92 Value of Fixed Cost Item 2

B93 Name of Fixed Cost Item 3

I93 Value of Fixed Cost Item 3

Net Return Calculation:

Based on the acreage, production, price and cost data entered, the model calculates net returns above variable costs (for the percent of base planted) on a per farm tract, per acre, per cwt., and per bbl. basis.Net return estimates are also included at the upper portion of the spreadsheet (cells I7:L7) to allow for quick evaluation of the impact of changing percent of base planted on net returns above variable costs.A copy of the entire model along with a set of sample data entered is included below.

Rice Cash Flow Fig 1JPG

Figure cont.

Rice Cash Flow Fig 2JPG

1/4/2019 3:11:42 PM
Rate This Article:

Have a question or comment about the information on this page?

Innovate . Educate . Improve Lives

The LSU AgCenter and the LSU College of Agriculture

Top