Pro forma Financial Statements

by Michael Langemeier

(opens in new tab)

Tweet
Share

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(opens in new tab)
User's Guide(opens in new tab)

Tweet
Share

TAGS:

,

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

ARC/PLC 2026: Making Your Crop Risk Management Decision

Compare PLC, ARC-CO and ARC-IC before making your 2026 farm program election. Join Purdue’s Michael Langemeier November 16 for a free webinar covering the pros and cons of each option, with time for Q&A.

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.

POPULAR RESOURCES

See What Others Like >>