FINPACK Knowledge Base – General

  • Cash Discrepancy Triggers
    Doing a thorough, accurate evaluation of a customer’s past performance is key to feeling confident when evaluating credit requests. Oftentimes in agriculture, the customer data received to perform this analysis is incomplete. Therefore, cash discrepancy errors can leave you scratching your head when completing a financial analysis (FINAN) or Schedule F cash to accrual analysis. Either missing sources or uses of cash may be a cash discrepancy culprit in an analysis. This missing cash can lead to either positive or negative cash discrepancies. Here we will look at potential culprits for both positive and negative cash discrepancies.
  • Accessing FINPACK Legacy Credit Presentations
    A new presentation text editor was introduced into existing FINPACK credit presentation templates last fall with the November 2021 FINPACK update (6.2.1 version1). Presentations created prior to this update are now termed ‘legacy presentations’. The following explains how legacy presentations can be printed, accessed, and modified.
  • Entering Finance Leases in FINPACK
    When should a lease be recorded on the balance sheet? If a lease is included on the balance sheet, how
    do you determine the asset value and loan balance? These are frequent questions as the use of leases for
    machinery, buildings, and other assets become more common.
  • Treatment of Breeding Livestock in FINPACK’s Earned Net Worth Analysis
    The purpose of Earned Net Worth Analysis is to back out Change in Market Valuation from total market value net worth change to arrive at the amount of net worth change resulting from earnings.
  • PPP Loans and the Impact on Credit Analysis
    PPP loans have been an important piece of the pandemic related relief packages. Many farmers and small businesses took advantage of these programs. This information is intended to help you correctly analyze the 2020 year in FINPACK Credit Analysis.
  • Detail is your friend in FINPACK’s Enterprise Analysis
    This document provides a short list of areas where it is important to enter detail in FINAN to aid in completing the Crop and Livestock Enterprise Analysis.
  • Discrepancies Caused by CCC Loans in Sched F Cash to Accrual
    Tax preparers are not consistent in reporting repayment of CCC loans that have previously been reported as income for tax purposes. FINPACK tries to adjust for these inconsistencies but adjustments are not always possible.
  • How Schedule F Income Is Determined in FINPACK
    FINPACK uses IRS Schedule F data in two analysis tools: 1) it is used to generate an accrual adjusted income statement in the Schedule F Cash to Accrual tool; 2) it can be used to calculate the cash based debt coverage measure that appears at the bottom of the Schedule F data entry in Tax Forms.
  • Handling Fluctuating Values of Ag Co‐op Stock
    “What is the proper way to handle Ag Co-op stock in a balance sheet in which the stock changes in value from year-to-year?”
  • Updating Cash Flows for Prevented Plant Acres
    Challenging production years lead to abnormally high levels of prevented plant acres. When this occurs, many revisit cash flow projections completed earlier in the year to consider the impact of prevented plant acres, including the addition of cover crop plantings. This document provides recommendations and considerations when working through cash flow projection updates for prevented plantings.
  • Importing and Exporting Balance Sheet Detail
    A helpful guide on the process of working with Intermediate, Long Term, and Personal Assets of an Agricultural balance sheet and Noncurrent and Personal Assets of a Commercial balance sheet.
  • Sleuthing Cash Discrepancies
    There are often tricky situations where a year end analysis will not balance when it comes to cash in and cash out. Whether you are using the Schedule F Cash to Accrual Analysis or the Financial Analysis (FINAN) there are some common culprits to track down cash discrepancies.
  • FINPACK Projection Tool Choices
    “Which projection tool should I use?”
  • Farm Finance Scorecard
    Guidelines for the Farm Financial Standards Council’s recommended financial ratios and measures.
  • FINPACK Livestock Budget Estimates
    These budgets are intended to provide guidelines for developing FINPACK livestock plans. They are based on the actual costs and returns of Minnesota farm producers included in the FINBIN Farm Financial Database.
  • Minnesota Price & Cost Summary
    These prices and costs are suggested as guides for planning based on historical cost and returns for Minnesota farms included in the FINBIN Farm Financial Database.
  • FINPACK Labor Hour Estimates
    FINFLO calculates Cost of Production Estimates for crop and livestock enterprises. These calculations rely on labor hours in the budgets. This document summarizes labor hours for several crop and livestock enterprises from FINBIN which can be used in the budgets.
  • Tax Impact on Debt Coverage (agriculture files)
    This paper discusses how to handle income taxes payable so the calculation for term debt coverage includes accrual income taxes rather than income taxes paid.
  • FINPACK Shortcut Icons
    Quick explanation of the toolbar icons
  • Consolidating Balance Sheets
    FINPACK allows users to consolidate the balance sheets or tax forms from several different data files into a consolidated file.
  • Importing Data from Another FINPACK File
    FINPACK allows users to import data from a different FINPACK data file into their current file. This feature allows the receiving file to add or import new data, without overwriting the remaining contents of the file.