Maize Cost & Profit per Acre Calculator (Excel) — Cost per Bag, Break-even Yield & Season Records

Know your cost per bag BEFORE you plant. Most maize farmers only discover whether the season paid at harvest. This Excel calculator shows you, in minutes, what one acre of maize will cost you, what you earn at different yields and prices, and the break-even yield and price you must beat.

What is inside (8 easy sheets, Arial, yellow cells = type here, grey cells = automatic):

• Start Here – 5-step guide.
• Settings – farm name, season, acres, bag size, expected price.
• Cost Plan – 16 example activities (seed, fertiliser, ploughing, planting, weeding, top-dressing, harvesting, shelling, bags, transport) with quantities and prices you change to your local rates; cost by category.
• Profit Check – profit per acre and for the whole farm at low, expected and high yield x 3 prices; break-even yield, break-even price, cost per bag, cost per kg and return per KES 1 spent.
• Expense Log (300 rows) and Sales Log (200 rows) for the real season.
• Monthly Summary – money out, money in and balance for 12 months.
• Season Report – plan vs actual per acre, by category.

Example built in: KES 29,500 per acre, KES 1,475 per bag at 20 bags, break-even 8.4 bags at KES 3,500. Edit every number to match your farm.

Works in: Microsoft Excel 2010+, WPS Office, LibreOffice and Google Sheets (upload). Phone-friendly in the Excel or WPS app. No macros, zero formula errors.

Who it is for: smallholder and commercial maize farmers in Kenya and East Africa, farm managers, agripreneurs, students and extension officers.

Made by Alphonce Kirui, a working dairy, silage and maize farmer in Bomet. Instant download after payment. Questions? WhatsApp 0728 801 352 or visit www.alphoncekirui.com.