Repayment Capacity Sensitivity Analysis Using Purdue Farm Financial Analysis Spreadsheet

Many agricultural producers purchased capital items the past few years and some used borrowed funds to finance the purchase. The principal payments on those term loans are paid from net farm income. This paper discusses the sensitivity of farm loan repayment capacity to changes in the gross revenue and operating expenses that determine net farm income. Sensitivity analysis is conducted using the Purdue Farm Financial Analysis Spreadsheet. The sensitivity analysis and application of the updated program are illustrated using a case study