Pro forma Financial Statements

by Michael Langemeier

This spreadsheet uses projected inventories, crop sales and expenses, and non-farm income and expense to create pro-forma income and sources and uses of funds statements, and to compute repayment capacity and liquidity measures.

Go to Tool

User's Guide

TAGS:

financial statements, plans + decisions

TEAM LINKS:

Michael Langemeier

RELATED RESOURCES

Contingency Planning with Cash Flow Shortages

June 4, 2026

A contingency plan is a course of action designed to help a business determine how to respond to possible future events. Contingency plans are often referred to as “Plan B”. One of the most common contingency plans used by a business, particularly a small business, relates to how to respond to the departure or absence of key personnel. Contingency plans relating to how to respond to changes in projected cash flow are also important. Given the recent increase in input prices for fertilizer and fuel and wide variability in expected prices, it would be prudent for a farm to examine the sensitivity of their cash flow and repayment capacity to changes in crop prices. This article illustrates the use of contingency plans for a case farm in southwest Indiana.

Adoption of Conservation Practices and Farm Goals

July 29, 2025

How do farm goals shape conservation decisions? This analysis draws on a nationwide survey of 400 producers to explore how priorities like profitability, risk, and sustainability impact the adoption of practices like no-till, cover crops, and crop diversification. Farmers who rank conservation as a top goal are significantly more likely to implement these practices—offering a window into what drives long-term thinking in farm management.

Farm Goals

July 23, 2025

One-third of recently surveyed farmers identified farm transfer as their top goal, but priorities like profit, conservation, debt reduction, and income stability also ranked high. The study reveals that most farms pursue a mix of goals, and understanding the tradeoffs between them can lead to better long-term business decisions. Take time to define your farm’s goals—and use them to shape long-term business decisions.

UPCOMING EVENTS

Weathering Water Extremes: Connecting Soil Health, Drainage, Irrigation, and Farm Resilience

Join educators from across the Midwest to build skills for communicating soil health concepts on Nov. 4-5, 2026. In the field, we’ll evaluate the relationship between soil health and water management focusing on irrigation and edge of field practices. The in-service will have both classroom and on farm demonstrations.

Land of Opportunity: A Conference for Farmland Owners!

The Land of Opportunity: A Conference for Farmland Owners will be held at two locations on October 5 and October 6, providing farmland owners with valuable information and resources to help them make informed decisions about their land. The conference will feature keynote presentations, educational breakout sessions, and networking opportunities designed specifically for those who own, manage, or have an interest in farmland.

POPULAR RESOURCES

See What Others Like >>