FINPACK® Knowledge Base
Detailed information from the creators of FINPACK®.
- 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
“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?”
- Handling Fluctuating Values of Ag Co‐op Stock
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.”
- 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.
Setup & Deployment
Instructions on various deployment options with FINPACK® and related tools
- FINPACK Vault documentation
These are instructions to configure the FINPACK Vault for use by farm business management instructors.
- FINPACK QuickBooks Interface setup
These are instructions to install the QuickBooks driver required for the FINPACK QuickBooks Interface, plus settings within QuickBooks to allow FINPACK access.
- Configuring FINPACK User Roles
In the Lender version of FINPACK, different user roles can be configured. The main distinction is users in the Analyst role can lock and unlock individual items in a data file. This document describes how to configure these roles within FINPACK.
- FINPACK Deployment Options for Lenders
This paper describes the different options and best practices for FINPACK deployment options.
These input forms are useful for data collection (OR, for those times when you want to use pen and paper to collect the data)
- Schedule F Analysis Input Form
This is a blank input form for the Schedule F Cash to Accrual analysis to help collect information that is not found on the tax form.
- Balance Sheet Input Form (agriculture)
This is a blank input form to help collect information for the FINPACK agriculture balance sheet.
- Balance Sheet Instructions (agriculture)
This is a set of instructions to help collect information for the FINPACK agriculture balance sheet.
- Balance Sheet Input Form (commercial)
This is a blank input form to help collect information for the FINPACK commercial balance sheet.
- Balance Sheet Instructions (commercial)
This is a set of instructions to help collect information for the FINPACK commercial balance sheet.
- Crop Budgets Input Form
This is a blank input form to help collect information for crop budgets for a FINFLO monthly cash flow plan.
- Livestock Budgets Input Form
This is a blank input form to help collect information for livestock budgets for a FINFLO monthly cash flow plan.