FINPACK Version History

Changes / Fixes to FINPACK release 5.9.12, dated 7/11/2018

Cash Flow Projection (FINFLO)
–Removed the optional year 2 acres in data entry in a monthly
projection without budgets and an annual projection. That
entry was not used in a plan without crop and livestock
budgets.
–Corrected issue with an incorrect warning message for an
annual projection. This was a message for too many finishing
livestock transferred out of an enterprise.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.11, dated 4/23/2018

Financial Analysis (FINAN)
–Include new projections in the list of Planned vs. Actual
comparisons. It was including only legacy projections in
the list.
–Corrected issue with occassional divide-by-zero error when
printing report with comparative balance sheets.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.10, dated 4/3/2018

General
–Changed the dialogs shown during the network installation
when performing a quick update. Allows user to verify settings
from previous installation.
–In the update utility, improved the download process to try
and help with slower or intermittent internet speeds.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.9, dated 3/28/2018

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2017
data from FINBIN (Minnesota).
–Added dialog after opening a file that allows you to choose
to clear an existing lock on the file. This is the same
functionality as in the FINPACK Admin Utility, just happens
in a more convenient place.

Balance Sheets
–Sold items in the Land detail were sometimes appearing on the
Executive Summary output page. This did not affect the totals,
they were always correct. The display problem has been fixed.

Crop and Livestock Budgets
–In the new budgets without Feed Equivalents the Historic Data
displayed during input is no longer being adjusted if the crop
had a Feed Equivalent factor in the Setup File.

Cash Flow Projection (FINFLO)
–In the annual version, set the first year’s ending month so
report headings will print correctly for multi-year plans.
–In the annual version, fixed issue with livestock enterprises
sold per head. Those enterprises were not included in the
cash inflows in the output.
–In the annual version, fixed issue with copying detail values
for expenses and other cash flows.
–In the annual version, fixed issue with the order of detail
values in the one-page cash flow report.
–In the annual version, fixed issue copying expenses to a new
year in the plan when using the Schedule F expense chart of
accounts.
–In the annual version, fixed pasting historic data.
–In the monthly version with budgets, fixed issue with livestock
cost of production calculations when there was not a consistent
feed fed list across all livestock budgets.
–Fixed issue with the calculation of beginning inventory value
of a crop for display in data entry.
–In the annual version, fixed issue with warning message regarding
selling too many finishing livestock.
–In the annual version, fixed issue in a breeding livestock
enterprise where modifying the cull income detail did not update
the “modified” setting in data entry.

Financial Analysis (FINAN)
–Resolved the issue with importing multiple FIF files into
the same Analysis that caused the total interest to be
double counted.
–Scorecard Graphs no longer include years with missing data.
–Trend reports no longer report government crop loans on a
separate line.

Commercial Real Estate Analysis (commercial)
–Fixed issue where the depreciation value added back for the
net operating income calculation did not update if depreciation
was entered through detail.

Credit Decision Scorecard
–Fixed issue when creating a new scorecard where the selected
scorecard model would not hold.

Presentations
–Fixed issue with the Schedule F attachment where the check list
box containing the years in the form would not automatically
be filled out. Usually happened when there were multiple
Schedule F forms to choose from.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.8, dated 2/06/2018

Cash Flow Projection (FINFLO)
–In the annual version, corrected issue where multiple livestock
plans of the same enterprise would be double-counted in the
livestock inventory summary.

Financial Analysis (FINAN)
–Crop enterprise analysis combines like crops on the output and
now adds the crop type description to the output for clarity.

FINAN / Sch. F Analysis Trend Graphs
–Fixed issue with livestock Cost of Production numbers being
divided and graphing as very small numbers.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.7, dated 1/25/2018

Cash Flow Projection (FINFLO)
–Fixed issue in monthly projection where crop purchases entered
through detail did not flow through to “Crop purchases” expense
account in Expenses section.

Schedule F Cash to Accrual Analysis
–Capital purchases and sales detail that allows the user to
select purchases and sales entered in detail from the balance
sheet calculates ending values properly upon return.
–The detail that allows the user to select purchases and sales
entered in detail from the balance sheet displays the total
value of the items selected on the form.

Financial Analysis (FINAN)
–The detail that allows the user to select purchases and sales
entered in detail from the balance sheet displays the total
value of the items selected on the form.
–The right combinations of cash flows and analysis would cause
the program to freeze when previewing output. That has been fixed.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.6, dated 1/2/2018

General
–Added work-around in Admin utility for situation where internal
machine identifiers used in software registration change depending
on different hardware setups.

Cash Flow Projection (FINFLO)
–Fixed issue in Dairy enterprise using the Pattern shortcut to
distribute monthly milk production did not recalculate monthly
income totals.
–Fixed issue using Schedule F expense chart of accounts, the
Depreciation expense account was incorrectly included. It has
been removed from the list.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.5, dated 12/19/2017

General
–International version, made generic Income Statement available.

Financial Analysis (FINAN)
–Fixed issue where checking the “Show group summary information”
box would sometimes show a “Dataset not in edit mode” dialog.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.4, dated 12/8/2017

General
–Restored File+Open functionality on the toolbar (it had been lost).

Vault
–More work to reduce the number of cases where all the local data
files need to be re-scanned and compared to what is in the
Vault.

Detailed Balance Sheet
–Sold assets are no longer being included in the list of assets
that appear in the Percent Adjustment detail form.

Crop and Livestock Budgets
–Fixed issue where notes per budget would not save.

Cash Flow Projection (FINFLO)
–Corrected issue with loan calculations in certain legacy plans
when checking for a payment distribution.
–Corrected issue in annual projection with a warning message
about crop sales exceeding available inventory. The format of
the warning message caused an error.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.3, dated 11/27/2017

General
–Restored File+Open functionality in the menu (it had been lost).

Vault
–Work to reduce the number of cases where all the local data
files need to be re-scanned and compared to what is in the
Vault.
–Corrected issue where a lost connection during a check-in may
result with in a Conflict status.
–Several improvements when using the Map Vault Locations to
Sub-folders setting.

Detailed Balance Sheet
–Allow detail for machinery and equipment, titled vehicles, land,
and buildings and improvements to be maximized.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.2, dated 11/17/2017

General
–Corrected issue with update software that would not recognize
the installation location or serial number for a network
installation.
–Fixed issue with the New dialog for risk reports and credit
decision scorecard where the right side was being cut off.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.1, dated 11/7/2017

Detailed Balance Sheet
–Fixed issue merging balance sheets when there is a value
for deferred liabilities on capital assets without using
detail.

C & I Business Analysis (commercial)
–Updated RMA data for 2017-18.

__________________________________________________________

Changes / Fixes to FINPACK release 5.9.0, dated 10/5/2017

General
–Added “Legacy Projections” and “Projections” sections to the
file navigation dialog. The “Legacy Projections” section has
the Annual Cash Flow Plan and Monthly Cash Flow Plan (FINFLO)
tools that work the same as in previous releases. The
“Projections” section has updated tools with new features.
o Crop and Livestock budgets – Feed equivalents are no longer
used. Specific crops are fed in a livestock budget. This
carries through to the updated FINFLO and FINLRB components.
Legacy crop and livestock budgets may be copied to this new
component.
o Cash Flow Projection (FINFLO) – The updated FINFLO component
has the ability to do monthly plans using budgets, monthly
plans without budgets, or multi-year annual plans. Legacy
Annual Plans or FINFLO plans may be copied to this new component.
o Long Range Planning (FINLRB) – The updated FINLRB component
uses budgets that feed specific crops rather than using feed
equivalents.

Balance Sheet
–Added columns for Purchase Price, Year Sold, and Sales Price
in detail for machinery & equipment, titled vehicles, and land.
This is mainly for information purposes, but can be used to
complete capital purchases and sales detail in FINAN, Earned
Net Worth Analysis, and Schedule F Cash to Accrual Analysis.

Earned Net Worth Analysis (agriculture)
–Corrected a typo in data entry – the sign next to “Personal
asset depreciation” in the Net Farm Income section changed
from a plus sign to a minus sign. This is a display issue
and does not affect the results.
–On the output, changed the order of items in the Net Farm
Income section to match the order of these items in data entry.
This is a display issue and does not affect the results.
–Corrected the sign on personal asset depreciation when using
market-only balance sheets so that it matches business asset
depreciation. This does impact the earned net worth change.
–Added a button to the toolbar of capital purchases and sales
detail that allows the user to select purchases and sales
entered in detail from the balance sheet.

Schedule F Cash to Accrual Analysis
–Added a button to the toolbar of capital purchases and sales
detail that allows the user to select purchases and sales
entered in detail from the balance sheet.

Financial Analysis (FINAN)
–Added a button to the toolbar of capital purchases and sales
detail that allows the user to select purchases and sales
entered in detail from the balance sheet.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.8, dated 5/15/2017

General
–Teaching version now has all the features of the lender version.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.7, dated 3/30/2017

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2016
data from FINBIN (Minnesota).

FINPACK Vault
–When syncing files with the Vault, only those files just
updated are rescanned rather than scanning all files again.
–Made other changes to improve speed of file scanning and
to help with “Not Responding” issue when communicating
with the Vault server.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.6, dated 2/28/2017

FSA Forms
–Updated forms 2211 and 2212 to the February 2017 versions.
–Environmental Information questions are now answered on the
form rather than in Annual Plan / FINFLO.

FINPACK Vault
–Made changes to clean out temp folder after using Vault.
–Fixed issue moving files to a different group.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.5, dated 2/15/2017

FINPACK Vault
–Added “File Version” is shown in Compare Changes dialog
–Corrected logic that in some situations showed the local
FINPACK file was in conflict with the Vault when the status
should be Get Latest.
–Added logic to ignore changes to Historic Database information
when comparing local FINPACK file to version in the Vault.
–Made changes so that if VaultTemp Folder is found then its
removed on refresh and also before its used.

FINFLO
–Corrected loading issue for certain plans with incomplete
cost of production data.

FINAN
–For summary farms, the ‘Analysis complete, include
in RankEm/PRA’ check box gets validated during the save.
If it is missing information, the check box will be
turned off when the FINAN is saved.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.4, dated 1/30/2017

FINPACK Vault
–Made corrections for the “Last FINAN” and “FINAN complete”
columns. Those values were not always being updated.
–Made correction where “Forgot Password?” from vault login
screen was not always working. It will now correctly open
vault website password reset page.
–Fixed issue where if in FINPACK data folder there is
only one file which was created using Get Version Copy
then it would show that file to be added.
–When files are synced, Vault will refresh only those files
that synced. This will speedup refreshing information on
grid.

Annual Plan (agriculture)
–Corrected issue with data entry where 3- and 5-year averages
for expenses were not displayed when using a Schedule F
tax form as the expense format.

FINAN
–Fixed issue where Detailed Income Statement output was
not printing the label for Interest on Accounts Payable.
–Some existing FINANs were not converting correctly if
there was a mid-year CCC loan borrow and repayment.
That has been fixed.
__________________________________________________________

Changes / Fixes to FINPACK release 5.8.3, dated 1/19/2017

FINPACK Vault
–Changed the directory structure in the data folder when
mapping Vault locations as sub-folders.
–Added link on login form to reset password.
–Correct FINPACK file name that is created when copied
locally from vault.

FINFLO
–Corrected issue populating the annual payment and
payment distribution of a CCC Crop Loan from an older
balance sheet into a new FINFLO.

FINAN
–Import Data – Fixed issue with family living detail and
personal interest.
–Import Data – If an income or expense can not be found
due to a change in the chart of account, it is displayed
in the message block where you can save the information
to a file and manually enter it later.

C & I Business Analysis (commercial)
–Changed where prepaid expenses is listed on the summary
balance sheet to better align with where it is listed
in other areas of FINPACK. It is now listed as an other
current asset rather than a noncurrent asset. This
change impacts the current ratio and working capital
calculations in the results.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.2, dated 12/1/2016

FINAN
–Repicking the ending Balance Sheet would sometimes leave
a principal balance in the data entry screen causing an
apparent discrepancy. This was a display issue that did
not affect the calculations and has been fixed.

FSA Forms
–Corrected issue to allow FINFLO cash flow plans to be
selected with loan applications.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.1, dated 11/7/2016

General
–New process to quickly update older versions of FINPACK.

__________________________________________________________

Changes / Fixes to FINPACK release 5.8.0, dated 11/3/2016

FINPACK Vault
–Added new columns “Last FINAN” and “FINAN complete” in the
Vault dialog. This allows for checking this status before
downloading the file from the Vault.

Balance Sheet
–Removed data entry section for Crops Under Gov’t Loan.
Data entered in this section was transferred to crop inventory
and current loans sections. Going forward, CCC loans are
always treated as loans.

Tax Forms / Income Statement
–Corrected issue with duplicate years in one tax form / income
statement where only the first instance was included in the
output.

Annual Plan (agriculture)
–Removed data entry section for Crops Under Gov’t Loan.
Data entered in this section was transferred to crop inventory
and current loans sections. Going forward, CCC loans are
always treated as loans.

FINFLO
–Removed data entry section for Crops Under Gov’t Loan.
Data entered in this section was transferred to crop inventory
and current loans sections. Going forward, CCC loans are
always treated as loans.

Schedule F Cash-to-Accrual Analysis
–Adjustments for Crops Under Gov’t Loan from the balance sheet.
–Added input for “CCC loan principal repayment included in farm
expenses” for the situation where a CCC loan was treated as
income in a previous year and a subsequent loan buy back was
included in farm expenses in a following year.

FINAN
–Removed data entry section for Crops Under Gov’t Loan.
Data entered in this section was transferred to crop inventory
and current loans sections. Going forward, CCC loans are
always treated as loans.
–Importing data now captures interest payments on personal loans
and pts them in the detail family living.
–Users can no longer allocate more than 100 percent of livestock
overhead expenses.

C & I Business Analysis (commercial)
–Updated RMA data for 2016-17.

Commercial Real Estate Analysis (commercial)
–Changed loan-to-value value display to be consistent with
other areas of FINPACK. For example, value is now displayed
as 65.0% rather than 0.65.

Risk Rating
–Added Gross Profit Margin, Operating Profit Margin, and Net
Profit Margin as items for commercial C & I Analysis.
–Fixed issue using ratios from Commercial Real Estate Analysis.
–Fixed issue with scoring ratios that fell exactly on a
breakpoint.

Presentations
–Added CustomerID, Business type, and Business code as items
under the “General” section.
–Added Gross Profit Margin, Operating Profit Margin, and Net
Profit Margin as items for commercial C & I Analysis.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.15, dated 8/22/2016

General
–Corrected issues related to detail not displaying in
various sections of the software. An upgrade to a library
component created this issue in 5.7.14.
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.14, dated 8/17/2016

FINPACK Vault
–Corrected issues related to deleting items in a file and
file status would stay as “Check-in.”
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.13, dated 5/23/2016

General
–Corrected an issue with the Repeat Last Number (Ctrl+R)
feature that was introduced in 5.7.12. This mainly impacted
FINFLO data entry.
–Corrected an occassional issue with FINPACK detecting the
Windows Active Directory group. This impacted configuring
the group roles.
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.12, dated 5/3/2016

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2015
data from FINBIN (Minnesota).

Balance Sheet
–Corrected issue with blank loans in the balance sheet that
would not allow FINFLO to load.
–Corrected issue loading a balance sheet with collateral that
could lead to problems saving and resulting in a message
about the cdsCAAssetItemDetail dataset.

FINFLO
–Corrected an issue with the average cost of production values
in the crop summary. The weighted averages were not being
calculated correctly when combining crop production.

FINAN
–Corrected the contract grow/finish hog cost of production
divisor in the enterprise analysis.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.11, dated 3/15/2016

FINPACK Vault
–When user has access to multiple Vault Locations, added
separate drop-down box to select which Vault Location to work
with to avoid scanning potentially hundreds of files with
each refresh.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.10, dated 2/25/2016

Annual Plan (agriculture)
–Changed calculation of interest on term debt for the combined
personal and farm column in the Term Debt Coverage section.
Interest on term debt now includes accrual farm term interest
payments and cash personal term interest payments. With this
method the same personal term interest is added and subtracted
from the cash flow stream to arrive at the same capital debt
repayment margin in the farm only and personal and farm combined
columns.

FINFLO
–Changed calculation of interest on term debt for the combined
personal and farm column in the Term Debt Coverage section.
Interest on term debt now includes accrual farm term interest
payments and cash personal term interest payments. With this
method the same personal term interest is added and subtracted
from the cash flow stream to arrive at the same capital debt
repayment margin in the farm only and personal and farm combined
columns.

Schedule F Cash-to-Accrual Analysis
–In the Repayment Capacity output section, the principal
payments on personal debt value was actually displaying
the total personal debt payments. The calculation was
correct if the option to include the cash discrepancy
in repayment capacity was set.
–In the case where the cash discrepancy was not included
in repayment capacity, total personal loan payments were
being used rather than principal payments on personal
debt.

Presentations
–When using a balance sheet optional attachment, the Asset
Value drop-down is now always enabled.

FINPACK Vault
–Added File Count to footer row of Vault dialog.
–Added ability to map Vault Locations to data directory
sub-folders in the situation where a user can access
more than one Vault Location. Result is data files stored
in sub-folders that match Vault Locations. This is a setting
on the Tools + Options + FINPACK Vault screen.
–Changed logic used in Compare Versions dialog so the local
file is always compared to the latest version in the Vault.
–Using Select All feature now will select only those items
in the dialog in the case of filtering the file list.
–Added ability to force check-in the local file through the
Compare Versions dialog.
–Added Delete File button to Vault dialog. This will remove
the file and all it’s history from the Vault. It does not
remove the local copy of the file.
–Scanning the local files no longer changes the date modified.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.9, dated 2/3/2016

Annual Plan (agriculture)
–Fixed issue with the calculation of personal interest expense
for the Term Debt Coverage ratio. This would only occur when
there are multiple personal term loans.
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.8, dated 1/26/2016

General
–File + List Files from the menu now shows the most recently
completed Financial Analysis (FINAN).

Collateral Analysis
–Corrected calculation of loan to value by collateral group.
The overall loan to value was correct, this only impacted
the calculation by collateral group. (Introduced in 5.7.6)
This corrects the report and the table in presentations.
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.7, dated 1/14/2016

Balance Sheets
–Release 5.7.6 did not calculate some current asset detail
correctly (accounts receivable, hedging accounts, other current
assets) with regards to cost values. This impacted FINAN.
All balance sheets are loaded and recalculated again.

Annual Plan (agriculture)
–Fixed issue calculating crop inventory value on the projected
ending balance sheet. This was an intermittent issue that
was introduced with release 5.7.0.
__________________________________________________________

Changes / Fixes to FINPACK release 5.7.6, dated 1/11/2016

General
–File + List Files was not showing the Group Summary ID and
Analyst ID for agricultural files. This has been fixed.
–Corrected more trend reports. Some reports from RankEm
were being included in the FINPACK setup.
–Removed ability to delete records in data entry using just
the <Delete> key when the entire record is highlighted and
the grid is no longer in edit mode. When this occurred in
a detail form the change was not recognized, the “Modified”
setting was not set, and the total on the main form would
not be recalculated.
–Completed changes to setup for the International metric
version.

Balance Sheets
–All balance sheets are loaded and recalculated due to the
above issue of using the <Delete> key to delete records in
detail.

Collateral Analysis
–Fixed issue with collateral group sub-totals on the output.
When previewing the results multiple times, the asset
sub-totals for each collateral group would include all
asset values rather than just what was selected. Printing
showed the correct results, just occurred during multiple
preview of the results.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.5, dated 1/4/2016

General
–Replaced some missing trend reports that were dropped out
of a new installation from 5.7.4.

FINAN
–Allocation factors are no longer reset when an analysis
is started with a copy. Any adjustments made in the original
are kept “as is” in the new copy.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.4, dated 12/14/2015

Presentations
–Fixed issue with Loan Request table not summing columns.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.3, dated 11/30/2015

General
–Fixed issue updating older files.
–Fixed installation issue with MergeSetup loading older
Presentation Templates.

FINFLO
–Fixed issue with saving Monitoring Worksheet to Excel
spreadsheet when file name did not have an “.xlsx” extension.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.2, dated 11/2/2015

C & I Business Analysis (commercial)
–Updated RMA data for 2015.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.1, dated 10/29/2015

Balance Sheet Collateral Analysis
–Changed total market value of CCC crops to be net of loan.

__________________________________________________________

Changes / Fixes to FINPACK release 5.7.0, dated 10/15/2015

General
–Added Default Output Options under Tools + Options.
–The loan calculator now calculates amortized payments using
a 360 day year (the interest rate is adjusted by 365 / 360).

Balance Sheet
–Fixed occassional issue with saving, problem was reported
in the cdsCAAssetItemsDetail dataset.

Tax Forms
–Corrected consolidation of tax forms / income statement
with an interest rate field. That is now calculated as a
weighted average.
–Schedule F: Nontaxable value of crop insurance proceeds
is now included in other nontaxable income for the cash
available for debt service.

Annual Plan (agriculture)
–Included interest payments on personal debt in Term Debt
Coverage calculation. Unlike FINAN, personal interest
expense is not included in family living in the Annual Plan
and must be included separately in this calculation.

FINFLO
–Included interest payments on personal debt in Term Debt
Coverage calculation. Unlike FINAN, personal interest
expense is not included in family living in FINFLO and must
be included separately in this calculation.
–Added ability to generate a Monitoring Worksheet as a
Microsoft Excel spreadsheet.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.11, dated 9/1/2015

General
–Corrected issue with some data entry forms that were always
setting the “Modified” flag regardless of whether any data
had actually changed.
–Added features for the FINPACK Vault.

Tax Forms
–Added entry for “Section 179 deduction” to Form 1065 and
Form 1120-S. This is used in the calculation of net
depreciation for cash flow for debt service.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.10, dated 5/21/2015

General
–Updated FSA Forms 2211 and 2212 to version dated 5/15/15.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.9, dated 5/12/2015

General
–Corrected one scorecard graph data element for 2014.
–Updated FSA Forms to the latest 2038 and 2212.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.8, dated 5/4/2015

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2014
data from FINBIN (Minnesota).

FINFLO
–Corrected the crop budget expenses used with the cost of
production calculations in a multi-year plan with multiple
columns in the budget.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.7, dated 3/3/2015

General
–Added extra data check for incomplete behind-the-scenes data that
was resulting in “Unspecified error” message and data that would
not save.

Annual Plan
–Corrected calculation of the principal due on term loans for the
projected ending balance sheet in the case of a refinanced loan.
This impacted the change in working capital and current ratio.
A change was made in release 5.6.6 to adjust this calculation in
the case of a partial loan refinance, but that introduced a
problem when there is a total loan refinance.

FINFLO
–Corrected calculation of the principal due on term loans for the
projected ending balance sheet in the case of a refinanced loan.
This impacted the change in working capital and current ratio.
A change was made in release 5.6.6 to adjust this calculation in
the case of a partial loan refinance, but that introduced a
problem when there is a total loan refinance.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.6, dated 2/16/2015

General
–Updated the scorecard red/yellow/green ranges for several agriculture
ratios, mainly used with FINAN and Schedule F Cash to Accrual Analysis.
(requires a full install)

FINFLO
–Fixed issue with output to speed up the first-time preview of
a plan.
–Fixed sporadic divide by zero error in crop inventory calculations.
–Improved handling of debt forgiveness in calculations.
–Fixed issue displaying the loan in the data entry section for
FSA loans.
–Fixed the EBITDA calculation. It did not have the correct interest expense
added back.

Annual Plan (agriculture)
–Fixed issue with output to speed up the first-time preview of
a plan.
–Improved handling of debt forgiveness in calculations.
–Fixed issue displaying the loan in the data entry section for
FSA loans.

Schedule F Cash to Accrual Analysis
–Fixed issue with output to speed up the first-time preview of
a plan.

C & I Business Analysis (commercial)
–Fixed issue with output to speed up the first-time preview of
a plan.

Risk Rating
–Fixed issue scoring custom criteria with a “-1” value.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.5, dated 1/30/2015

General
–Added ability to select the database driver in the Admin Utility.
–Updated 3rd-party component for grids, pressing <Enter> now works
as expected in certain data entry (e.g., crop enterprise analysis).

Crop and Livestock Enterprise Budgets
–Fixed issue calculating feed cost on a livestock budget
when using barley equivalents.

Annual Plan
–Fixed issue on projected balance sheet report where a loan
may show the incorrect beginning balance.

FINFLO
–Fixed issue with report options sometimes displaying an
error when switching to Monitoring Worksheet options.
(List index out of bounds)
–Fixed issue displaying balance sheet feed equivalent price
on the Ending Inventory input screen when using barley
equivalents.
–Fixed issue displaying the enterprise name in the data entry
section for livestock.
–Fixed issue displaying the enterprise name in the data entry
section for crop purchases and sales.

FINAN
–Added “Milk price feed margin” to dairy enterprise analysis.
(requires full install)
–Reset the starting position for livestock enterprise analysis
to the Livestock Inventory tab.

Presentations
–Fixed issue with some of the Optional Attachment forms
shrinking the check list box of sections to include for FINFLO,
Annual Plan, and others.

Presentation Templates (Tools + Options)
–Fixed issue selecting the Optional Attachment form for the
Schedule F Cash to Accrual Analysis.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.4, dated 1/7/2015

Tax Forms
–Updated Global Cash Flow Only view for Schedule E tax form.
(requires full install)

FINFLO / Annual Plan
–Fixed issue with some loans from the balance sheet being
labeled as “Unknown loan” in the output.

Earned Net Worth Analysis (agriculture)
–Fixed issue in capital purchases / capital sales detail when
one balance sheet is market-only and the other is cost-and-
market. Specific message was “Field ‘CapitalPurchases’ not
found” when exiting detail.

Presentations
–Fixed issue with displaying sums in tables.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.3, dated 12/16/2014

Tax Forms
–Since the net income for the Schedule E tax form is calculated
rather than entered, it cannot have a Global Cash Flow Only
view.

FINFLO
–Fixed a calculation issue with principal payments on personal
debt. This impacts the Farm Only term debt coverage ratio in
the results. This change does not impact the Personal and Farm
term debt coverage ratio.
–Added Capital Debt Repayment Margin to Executive Summary for
multiple year projections.

Presentations
–Fixed issue with presentations displaying tables inside a larger
table.
–Fixed issue with embedded variables not being updated when placed
in the header or footer.

Presentation Templates
–Fixed issue with upgrading embedded FINPACK variables when the
template has more than one narrative / text section.
–Fixed issue with templates displaying tables inside a larger
table.
–Fixed issue copying templates where embedded fields were not
being copied.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.2, dated 12/2/2014

Balance Sheets (detailed)
–Fixed data issue with older balance sheets that prevented
them from being copied.

FINAN (agriculture)
–Fixed issue saving all items in the Feed Fed entries in
livestock enterprise analysis.

Presentation Templates
–Fixed issue trying to edit a presentation template immediately
after importing it.

__________________________________________________________

Changes / Fixes to FINPACK release 5.6.1, dated 11/7/2014

FINFLO
–Fixed a printing issue with FINFLO when there is detail for
purchased feed.

FINAN (agriculture)
–Fixed issue with importing accounting data.
__________________________________________________________

Changes / Fixes to FINPACK release 5.6.0, dated 10/31/2014

General
–Added setting under Tools + Options to set the screen font size.
This is on the General Information page.
–Updated icons with newer, larger images. Easier to use with touch
devices.
–Added setting under Tools + Options to direct how a cash discrepancy
in FINAN or Sch. F Cash to Accrual Analysis impacts Change in
Retained Earnings and Repayment Capacity.

Balance Sheets (detailed)
–Added setting in report options to include or exclude notes.

Earned Net Worth Analysis (agriculture)
–Changed the approach to displaying the Term Debt Coverage Ratio.
The calculation now starts at Change in Earned Net Worth rather
than starting with Net Farm Income. The result is the same, just
a simplification.
–When using cost value balance sheets, the reported ending cost
asset values are used from the ending balance sheet rather than
using the adjusted ending values calculated through capital purchase
and sales detail. Any discrepancies shown in that detail still
exist, they are shown as a depreciation check against economic
depreciation. This approach aligns the results with FINAN.
–Corrected calculation of “Change in personal accounts” to include
change in personal accrued interest.

Schedule F Cash-to-Accrual Analysis
–When using cost value balance sheets, the reported ending cost
asset values are used from the ending balance sheet rather than
using the adjusted ending values calculated through capital purchase
and sales detail. Any discrepancies shown in that detail still
exist, they are shown as a depreciation check against economic
depreciation. This approach aligns the results with FINAN.
–Updated first page trend report, changed which financial measures
are reported.
–Added a version of the Term Debt Coverage Ratio that includes
personal term debt payments as part of total term debt payments.
This provides more of a global view of debt coverage.
–Added Term Debt to EBITDA ratio.
–Added a check-box to indicate whether the results should be
included in the Portfolio Risk Analyst database.

FINAN (agriculture)
–Updated Executive Summary, changed which financial measures are
reported.
–Added a version of the Term Debt Coverage Ratio that includes
personal term debt payments as part of total term debt payments.
This provides more of a global view of debt coverage.
–Added Term Debt to EBITDA ratio.
–Lenders Version: Added a check-box to indicate whether the results
should be included in the Portfolio Risk Analyst database.

Commercial Real Estate Analysis (commercial)
–Changed so that it does not require an income statement or
tax forms to create a new analysis for a new customer.

C & I Analysis (commercial)
–Lenders Version: Added a check-box to indicate whether the results
should be included in the Portfolio Risk Analyst database.
–Added gross margin, operating profit margin, and net margin to the
ratio report section.
–Re-ordered Efficiency ratios into one section.

Global Cash Flow Analysis
–Corrected output in Other Cash Flow section when using the
borrower’s share of debt payments.
–Added warning when Schedule E is missing an entry on line 41,
which is the amount to deduct from personal 1040 income.
–Corrected data entry for “Net income to deduct from personal 1040
income.” In some situations a change to this value would not
be saved.

Annual Plan (agriculture)
–Do not print historic trends when printing the input worksheet.
–When printing the historic trends, only include FINAN years
prior to the plan year.
–Updated Executive Summary, changed which financial measures are
reported.
–Added a version of the Term Debt Coverage Ratio that includes
personal term debt payments as part of total term debt payments.
This provides more of a global view of debt coverage.
–Added Term Debt to EBITDA ratio.
–Lenders Version: Added a check-box to indicate whether the plan
should be included in the Portfolio Risk Analyst database.

FINFLO
–Do not print historic trends when printing the input worksheet.
–When printing the historic trends, only include FINAN years
prior to the plan years.
–Corrected calculation of Projected Earned Net Worth change to
start with Net Farm Income rather than Net Farm Income from
Operations.
–Updated Executive Summary, changed which financial measures are
reported.
–Added a version of the Term Debt Coverage Ratio that includes
personal term debt payments as part of total term debt payments.
This provides more of a global view of debt coverage.
–Added Term Debt to EBITDA ratio.
–Lenders Version: Added a check-box to indicate whether the plan
should be included in the Portfolio Risk Analyst database.

Risk Rating
–Corrected issue with getting the personal debt coverage ratio
from a 1040 tax form.

Presentations
–Added ability to attach other PDF documents to a presentation.
–Added ability to select a Form 1040 as a data source.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.10, dated 3/31/2014

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2013
data from FINBIN (Minnesota).

Schedule F Cash to Accrual Analysis
–Updated the “Earned net worth change (reported)” value
on the first page report to include gifts and inheritances.
–Updated the “Market net worth change” value on the first
page to match the value from the Solvency Measures rather
than from the Statement of Owner’s Equity. This does not
include the cash discrepancy.

Risk Rating (agriculture)
–Changed the calculation of “Earned Net Worth Change %”
coming from the Earned Net Worth Analysis. Matches the
calculation coming from the Annual Plan and FINFLO.
–Changed the calculations for averaging certain variables,
such as debt coverage ratios and percent change ratios,
to represent an average ratio over the selected years
rather than averaging individual year ratios.
–Made Form 1040 variables available in a risk rating report.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.9, dated 2/4/2014

General (agriculture)
–Added personal income taxes payable to balance sheet so
an accrual income tax could be included in the repayment
capacity calculations for all projection and analysis
components.

Annual Plan (agriculture)
–Updated Financial Trend report to exclude deferred liabilities
in the solvency section.

FINFLO (agriculture)
–Updated Financial Trend report to exclude deferred liabilities
in the solvency section.

FINAN (agriculture)
–Fixed issue importing loan data.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.8, dated 1/3/2014

FINAN (agriculture)
–Updated special sort lists to include items for continuous
crop years.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.7, dated 12/23/2013

General
–Changed order of updating Annual Plan & FINFLO projections
when loading older agriculture files. Most recent plan
is updated last.
–Implemented “Reviewer” user role, can only open data files
as read-only.

FINFLO
–Corrected issue with storing output options, no longer stores
options when printing monitoring worksheet.

Commercial Real Estate Analysis
–Corrected calculation of total interest expense added back
for net operating income. It was not always updating as
loan information changed in a proforma column.
–In a proforma column, changed calculation of annual interest
expense to be based on monthly payments.
–Cleaned up options for stress test report.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.6, dated 12/5/2013

General
–Corrected issue with file version stamp for newly created
commercial file.
–Activated “Prevented planting” in the crop list by default.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.5, dated 11/26/2013

Schedule F Cash to Accrual Analysis
–Corrected calculations to no longer use the specified
income lines coming from the Schedule F tax form.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.4, dated 11/25/2013

Tax Forms
–On the Schedule F form, added a one-time update to retrieve
values entered on the “specified income” lines. Those were
not intended to be used.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.3, dated 11/01/2013

General
–Updated RMA data for 2013-14.

FINFLO
–Corrected issue with stored report options between single
year and multi-year plans.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.1, dated 10/24/2013

Tax Forms
–Corrected detail printing for 1040 form with personal debt.

Schedule F Cash to Accrual Analysis
–Fixed issue with feeder livestock purchases value not being
used in calculations, related to change in tax form for 2013.

Global Cash Flow Analysis
–Corrected column settings on the report to allow for
larger font size.

__________________________________________________________

Changes / Fixes to FINPACK release 5.5.0, dated 10/16/2013

Added Commercial Real Estate Analysis component to lender
commercial version for evaluating income-producing,
investor-owned real estate properties.
———————————————-

Added Credit Decision Scorecard component to lender
version for quick evaluation of less complex credits.
———————————————-

General
–Remember the last selected report options for previewing
or printing output.

Detailed Balance Sheets
–For loans with a zero balance but with accrued interest,
check that the annual payment is not more than accrued
interest.
–For consolidated balance sheets, printed schedules
indicate the source for assets and liabilities similar
to grouping in data entry.

Annual Plan
–Store output for comparison to historical trends.
–Added reports for Income Statement and Financial Trends
to compare actuals vs. projection from the plan.

FINFLO
–Store output for comparison to historical trends.
–Added reports for Income Statement and Financial Trends
to compare actuals vs. projection from the plan.

Tax Forms
–Fixed issue printing detail when one year did not have
detail.
–Updated for 2013.
–Added entry for interest on current debt, part of Cash
Available for Debt Service calculation.

Schedule F Accrual Analysis
–Fixed issue with feeder livestock purchases not displaying
in some trend reports.

Earned Net Worth Analysis
–Added market-value ratios to summary report when using
cost-and-market value balance sheets.

FINAN (agriculture)
–Added Analyst ID to group summary information.

Financial Analysis (commercial)
–Corrected calculation of debt coverage ratios to include
other depreciation coming from Schedule M-1 on Form 1065,
1120-S, and 1120.
–Corrected calculation of Form 8825 gross rents coming into
profit before taxes. Also impacted the debt coverage ratios.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.8, dated 5/14/2013

FSA Forms
–Updated forms 2211 & 2212 to latest version dated 4/16/2013.

Risk Rating
–Added variable for Global Cash Flow projected debt coverage
ratio.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.7, dated 4/24/2013

General
–Contains 2012 FINBIN data for analysis comparisons.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.6, dated 3/18/2013

Tax Forms / Income Statement
–Fixed issue consolidating 1040’s and Schedule F.

FINFLO
–Fixed issue in related operating expense detail where
toggling between distributions & dollars would sometimes
recalculate the total distribution incorrectly.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.5, dated 1/18/2013

General
–Changed functionality of file restore. When there is an
existing file with the same name, now there is an option
to either overwrite the existing file or restore to a copy
of the file.

Detailed Balance Sheets
–In the loan calculator, fixed-principal payments option,
changed the starting date to be next month for end-of-the
month balance sheets.

Crop and Livestock Budgets
–Fixed issue with dairy replacement heifer budget where
several FINFLO year columns were added to the budget and
FINFLO did not use the default Long Range column.

FINAN (agriculture)
–Fixed Trend Graphs issue found when switching back and
forth between input and output. The output would not
always refresh to relect the change in options.
–Importing data into FINAN leaves the Special Sort selections
as they are, it no longer deletes them.

Financial Analysis (commercial)
–UCA Cash After Operations section now adds back Change in
Prepaid Expenses rather than subtracting it from Operating
Expenses. No change to bottom-line, just better alignment
to explain moving from accrual back to cash.
–Fixed issue with gross receipts not coming in correctly
when using the generic Income Statement.

Global Cash Flow Analysis
–Fixed issue with 1065 and 1120-S forms not populating the
business income to deduct from personal income value.

Presentations
–Fixed issue where embedded values were displaying too wide
when printing. Resulting paragraphs would not wrap correctly.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.4, dated 12/6/2012

Detail Balance Sheets
–Fixed problem with printing/previewing display values
when balance sheet is either cost or market only.
–Fixed problem consolidating balance sheets always
causing file to become a Mixed type file.

Summary Balance Sheets
–Fixed issue with Close button working sporadically.

Tax Forms / Income Statement
–Fixed issue with consolidating a tax form into a generic
income statement format (merchant card income was not
included in the consolidation).
–Added 8825 and Schedule E to list of tax forms that can be
consolidated into an Income Statement.
–Fixed issue with missing data when consolidating other tax
forms into a generic income statement.

Schedule F Accrual Analysis
–Fixed issue with capital sales calculation in output when
there is a gain on the sale.

FINAN (agriculture)
–When copying a FINAN forward, special sort items were
sometimes reported wrong in the screen that asks if you
want to keep them. This has been fixed.

Financial Analysis (commercial)
–Fixed issue in UCA cash flow where net sales calculation
did not include merchant card income.

Global Cash Flow Analysis
–Fixed issue with personal debt payments from 1040 form
not updating in the analysis.
–Fixed issue with net income from Schedule E not updating.

Annual Plan (commercial)
–Fixed issue with rental income and royalty income data items
not being able to access detail in data entry. Requires a
full re-install rather than just a program update.

Risk Rating
–Fixed issue where the initial selection of schedule F,
Global Cash Flow or Financial Analysis within a commercial
risk rating crashes when previewing. Error does not
occur when there is only a single instance of each type.
__________________________________________________________

Changes / Fixes to FINPACK release 5.4.3, dated 11/13/2012

General
–Fixed problem with double-clicking on a data file to
automatically open it.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.2, dated 11/13/2012

FINAN (agriculture)
–In livestock enterprise analysis inventory entry, detail
from transfers in/out of other enterprises is available to
help complete detailed transfer information.
–Made it possible to change the Previous Crop entry in
the Crop Enterprise Summary information to “None Selected”.
–If you chose to clear the general data when creating a
copy of a FINAN the detail headings were not being saved
in the family living detail sub-detail. Now they are.
–Fixed loan matching when importing data from Quicken / QuickBooks
interface.

FSA Forms
–Guarantee / interest assistance forms 2211 & 2212 now report
net cash flow without interest assistance even when the
application is only for a guarantee.

Risk Reports
–Fixed issue selecting Global Cash Flow Analysis and Financial
Analysis.

Presentations
–Fixed issue selecting Global Cash Flow Analysis and Financial
Analysis.
–Allow selection of K-1 tax forms as optional attachments.
–Fixed problem where variables in the presentation were not
filled out when printing.
–Allow selection of Global Cash Flow variables in an agriculture
file.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.1, dated 11/01/2012

General
–Updated RMA data for 2012-13.

Annual Plan (agriculture)
–Fixed calculations for FSA Forms, occassional problem when
creating form 2211/2212 with only one loan in the application.

Global Cash Flow Analysis
–Corrected cash available for debt service calculation in
Form 1065.
–Corrected net income to deduct from personal income for
Schedule E.

Presentations
–Allow selection of JPG files when inserting pictures.

Quicken Accounting Interface
–Made some adjustments for reading latest version QIF files.

__________________________________________________________

Changes / Fixes to FINPACK release 5.4.0, dated 10/22/2012

General
–Added CustomerID entry to Producer / Customer information.
–Added business code to Producer / Customer information.
–Added linkage to AccuAccount.

Detailed Balance Sheets
–Loans with zero principal balance are included in the
calculations for accrued interest and payments, but a
warning is generated.
–Added ability to turn off signature line on first page (output
option).
–Added a warning when annual P & I payment for a loan is
less than estimated annual interest on the loan.

Income Statement / Tax Database
–Added Form 8825, K-1 for 1065, K-1 for 1120-S.
–Reduced entry on Schedule E to rental / royalty information;
partnership, REMICS, etc, information is not used.
–Updated entry for other tax forms for new items (merchant card
income, etc).
–Added ability to select an abbreviated view for Global Cash
Flow entry. The forms with this ability include Schedule E,
Form 8825, Form 1065, Form 1120-S and Form 1120.
–Added calculation of “Debt to Total Income” and “Debt to
Recurring Income” on Form 1040.
–Added “Compiled” and “Interim” statement types.

FINFLO
–Cost of production now calculates for year 2 when year 1
is less than a full 12 months.
–Crop cost of production calculation now uses operators
share of production for cost of production.
–Livestock cost of production feed cost per lb or cwt
now calculated based on gain for finishing enterprises.
–Prepaid expense detail now shows correct values for
plan expenses in multi-year plans.

Financial Analysis (commercial)
–Allow for the creation of multiples per file.
–Allow Schedule E to be selected as the business income statement.

Global Cash Flow Analysis
–Allow for the creation of multiples per file.
–Fixed calculation of borrower’s share of income in the output.
–Changed default output to an abbreviated format. Can select
detail output for output similar to previous versions.
–Allow selection of K-1 forms in the analysis.

FINAN (agriculture)
–In livestock enterprise analysis inventory entry, detail
from feeder livestock purchases is available to help
complete purchase information.
–If using special sorts in the analysis (typically with
a FBM association), this data can now be kept when copying
from a previous FINAN.

Presentations
–Fixed problem printing presentation with multiple
Schedule F attachments.
–Fixed problem with multi-year FINFLO plans not showing
the options to select multiple years in the optional
attachment section.
–Undefined ratios are displayed as “n/a” (such as balance
sheet current ratio when there are no current liabilities).

Risk Rating Models (under Tools+Options)
–Added ability to print a risk rating model.
__________________________________________________________

Changes / Fixes to FINPACK release 5.3.9, dated 5/22/2012

General
–Added 2011 graph data for Missouri.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.8, dated 4/30/2012

General
–Added some missing data for 2011 data from FINBIN (Minnesota).

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.7, dated 3/30/2012

General
–Updated FINAN / Sch. F Analysis scorecard graphs with 2011
data from FINBIN (Minnesota).

FSA Forms
(direct forms – 2037/38)
–Properly set the headings for the overflow printing of personal
liabilities on the appropriate attachment.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.6, dated 3/5/2012

FINFLO
–Fixed accrued interest expense calculation in cost of
production section.

Schedule F Analysis
–Fixed use of cooperative distributions and ag program payments.
These are back to using the taxable amount. (Issues releated to
grain sales reported on 1099-PATR and marketing gain on CCC
loans reported as income.)

FINAN (agriculture)
–Fixed Historic Trend issue dealing with missing price per unit
caused by multiple sales of livestock products like milk.
–When importing data from a FIF file and assigning borrowings or
payments to a new current loan (less than one year) the total
principal did not always match the total of the detailed items.
This issue has been corrected.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.5, dated 2/2/2012

Detailed Balance Sheets
–Allow zero percent interest rate on loans when calculating
principal balance and balance remaining, etc.

FINAN (agriculture)
–Relaxed the detail in livestock enterprise products so user
can manually enter adjustments for things like Milk.

Quickbooks Interface
–Display more information in error message if FINPACK fails
to connect to the QODBC driver.
__________________________________________________________

Changes / Fixes to FINPACK release 5.3.4, dated 1/23/2012

General
–Added FINPACK Knowledge Base web site link to the Help menu.
The Knowledge Base has several articles, including blank
input forms.

Detailed Balance Sheets
–Fixed printing cash value of life insurance schedule with
market-only balance sheets.
–Fixed issues checking for duplicate entries in crops held
for sale and government crop loans.
–Fixed issue where the balance sheet description could not
be cleared.

Summary Balance Sheets
–Fixed issues with locking and unlocking individual balance
sheets.

Balance Sheet Trend Reports
–Corrected reporting of government crop loans in both cost and
market trend reports.

Livestock Enterprise Trend Reports
–Users that had both a Dairy Enterprise and Dairy Replacement
Enterprise can now get an historic report on the resulting
combined Dairy and Replacement Enterprise.

FINAN (agriculture)
–The Import Data function was skipping capital sales. Fixed.
–Added special sort (“Seedstock production”) for livestock
enterprise analysis.

Presentations
–Fixed issue with commercial Financial Analysis optional
attachment when one did not exist in the file.

Quicken/QuickBooks Interface
–If a memo field ended with a number and the user selected to
use numbers in memo field, the last digit was being cut off
as the number was pulled out. This has been fixed.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.3, dated 12/5/2011

Balance Sheet
–Fixed calculation of current ratio (business and personal)
and working capital (business and personal). They did not
include all personal current liabilities.

Balance Sheet trend reports
–Updated commercial market balance sheet report to include
intangible assets.

Monthly Cash Flow (FINFLO)
–Fixed multi-year output for shocks which had incorrect
title and no decimal places for the values. Title now
reads “Shocks to Term Debt Coverage Ratio” and shock
values display two decimal places.

Schedule F Analysis
–Fixed use of cooperative distributions, ag program payments,
and CCC loans forfeited in income calculations. These are
now using the total rather than the taxable amount.

FINAN (agriculture)
–Added special sort (“Cow-calf w/backgrounding”) for
livestock enterprise analysis.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.2, dated 11/22/2011

QuickBooks Interface
–Fixed issue with some revenue transactions being imported
as a negative number.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.1, dated 11/11/2011

General
–Fixed problem importing summary balance sheets.

Summary Balance Sheets
–View now defaults to common asset valuation method for
existing balance sheets.

FINAN
–Added the ability to clear only the whole farm information when
importing data from your accounting software.

QuickBooks Interface
–Removed popup messages when loading data.

__________________________________________________________

Changes / Fixes to FINPACK release 5.3.0, dated 11/04/2011

Annual fall update/release. There were many additions,
tweaks and fixes made to the software.

Major additions include…
— Streamlined file navigator dialog
— Modified shocks in Annual Plan and FINFLO (now shows
impact on term debt coverage ratio)
— New Quicken and QuickBooks accounting interfaces
(optional add-ons)
— Summary balance sheets (lender version)
— Revised Global Cash Flow Analysis (lender version)
— Schedule F cash-to-accrual analysis (lender version)

__________________________________________________________

Changes / Fixes to FINPACK release 5.2.6, dated 4/28/2011

General
–Made Schedule F tax database available in personal version.

FINFLO
–Fixed display of the current year in data entry for a multiple year
plan. Previewing output then returning to data entry did not
update the title on the form to indicate the current year had been
moved to year 1.
–In livestock plan, allow entry of items with up to 4 decimal places.

FSA Forms
–Updated direct form 2037 to 11-04-2010 version which corrected
several typos and 2L. Current Portion of Principal Due On: line
titles (from current and intermediate to intermediate and long term).

FINAN
–Accrued interest from Balance Sheet loans with no principal was
not being included in the Beg. Accounts Payable portion of the
Accrual Adjustment section in the Enterprise Analysis. This
has been fixed.
–Fixed printing bug where detailed expense items are entered with
leading spaces. This caused an infinite loop when output.

Historic Trend Livestock Reports
–Cost of Production with Labor and Management varaiable was reporting
the total value instead of the “per unit” value and has been fixed.

Historic Trend Graphs
–Fixed display of some expenses in crop enterprise graphs.

Presentations
–Fixed problem where ratios from FINFLO were not appearing in the
document.

__________________________________________________________

Changes / Fixes to FINPACK release 5.2.5, dated 2/14/2011

Tools + Options
–File Setup|Crops was adjusted so that the <Restore Default Crop>
button restores the FINAN feed information for a crop as well.

FSA Forms
–Detail in assets was displaying cost value rather than
market value. Now cost value is only used if no market
value available.
__________________________________________________________

Changes / Fixes to FINPACK release 5.2.4, dated 1/21/2011

FINAN
–Users would copy an old FINAN forward for a new year, edit
the data and then were not able to reload it after closing
or previewing the output. This issue has been fixed.
–Family living detail descriptions we being cut off on some
monitors. An adjustment was made to help this.

FSA Forms
– Both direct and interest assistance now displays interest
rates with three decimal places; i.e., 7.000 rather than
7.

Presentations
–When creating a presentation template in Tools + Options,
fixed problem selecting Annual Plan or FINFLO as an
optional attachment.
–Fixed problem with options for Earned Net Worth Analysis
as an optional attachment. The list of years would
duplicate when moving onto the report options for this
selection.

__________________________________________________________

Changes / Fixes to FINPACK release 5.2.3, dated 12/22/2010

General
–Added extra step when updating file to check for a specific
missing previous update.

Balance Sheets
–Changed when some current asset totals are stored to address
occassional reports of current asset totals not appearing
on Executive Summary report.

Budgets
–Fixed feed fed display in livestock budgets when using barley
equivalents.

FINFLO
–Added warning to cost of production calculations when there
is no FINFLO feed purchase price in the budgets. This
price is used to value feed equivalents in the feed cost
calculations.
–Fixed problem with livestock cost of production calculations
that were not finding purchase price of livestock purchased
per head (finish feeder pigs, beef bulls, etc).

Annual Plan
–Fixed calculation problem with expense shock when using Sch. F
expense list.

FSA Interest Assistance, Guarantee Forms
— Fix to form 2212, wasn’t properly displaying individual loan
security detail items.
— Fix to form 2212, marital status fields were not displaying
properly.

__________________________________________________________

-Changes / Fixes to FINPACK release 5.2.2, dated 11/12/2010

FSA Direct Forms
–Fixed missing data issue with Dairy and using Annual Plan
as the source cash flow plan.

Annual Plan (commercial)
–On Executive Summary, updated ratio descriptions to match
descriptions used in Financial Analysis.

________________________________________________________

Changes / Fixes to FINPACK release 5.2.1, dated 10/19/2010

FINAN
–Added weights and values of livestock transferred in to the grow-
finish enterprise analysis reports.

RMA Add-on
–Updated RMA data for 2010.

________________________________________________________

Changes / Fixes to FINPACK release 5.2.0, dated 10/8/2010

Balance Sheet
–Personal loan data entry now correctly inserts new loans and
handles the creation of a new blank loan for the section where a
loan has been added.
–Added check when entering loans where the remaining balance
cannot be negative.

Budgets
–Added historic data when printing budgets.
–Fixed problem when entering and then deleting an enterprise and then
pressing Page Down. Two extra blank budgets were created.
–Added “FINFLO Purchase Price” to feed prices section.

FINFLO
–Added cost of production reports. There is a summary report for all
crops and livestock and reports by enterprise for each crop and
livestock enterprise in the plan.

Annual Plan
–Fixed issue where loan principal to be paid exceeds
principal remaining. Must be fixed in data entry, and added
warning to the output.
–Fixed issue where in rare case government crop loan crop list was
not initialized and appeared as blank.

Financial Analysis – Commercial
–Fixed bug when calculating the net income. Should have subtracted
other income from expenses rather than add it.
–Added Working Capital and UCA Debt Coverage to output.
–Changed titles for Operating Ratios “Profit before taxes/Net worth”
and “Profit before taxes/Total Assets” to “Return on equity” and “Return
on assets” respectively.
–Added “Discrepancy” line to bottom of UCA Cash Flow to show the
difference between Cash After Financing and Actual Change in Cash.

Earned Net Worth Analysis
–Added “Balance Sheet Value” column to capital sales detail when
using cost and market value balance sheets. This allows for the
calculation of gains / losses on capital sales, which impacts
the calculation of Net Farm Income from Operations and the Term
Debt Coverage ratio.

FSA Forms
–Updated FSA forms to the latest versions.
–On form 2037, fixed reporting of total farm assets which was including
personal assets. Now correctly reports farm assets only and then
calculates Total Farm Equity correctly.
–Ignore loans over the maximum form limit of nine loans per form package.
–Fixed problem in outputting the amount in Section D of the 2211.

Income Statement / Tax Database
–Fixed issue with calculating an accrual based schedule F net profit/loss
value. Now sets both that value and cash gross income values correctly.

Historic Trend Graphs
–Added to this release.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.8, dated 4/9/2010

Annual Plan
–Correctly checks new loans entered making sure that there
are no duplicates. Warning triggered whenever attempting
to leave data entry, loan must be corrected before exit.

FINLRB
–Correctly checks new loans entered making sure that there
are no duplicates. Warning triggered whenever attempting
to leave data entry, loan must be corrected before exit.
–Fixed issue when deleting an alternative after preview causes
stored options to potentially cause an out of range error
when next previewing.

Risk Rating
–Added “Earned Net Worth Change %” variable from Earned Net
Worth Analysis.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.7, dated 3/24/2010

General
–Fixed issue with File + List Files where a file that had not
been opened with any 5.1.x release would generate an error.

Balance Sheet
–Accounts payable detail will no longer print on the main
balance sheet report.

Budgets
–Fixed occassional error in budgets when filling out historic
data after selecting the crop or livestock enterprise.

FINLRB
–Deleting all detail in Loans detail, using the trash can icon,
no longer causes an error.
–Fixed problem that resulted in interest detail incrementing
with each preview.

FINFLO
–Fixed issue where liquidating government crop loans in detail
did not immediately flow into crop inventory in a crop purchases
and sales data entry screen.

Annual Plan (commercial)
–Fixed problem picking up asset values in Depreciation section
when working from a market-only or cost-and-market balance sheet.

FINAN
–Accounts payable forgiven will no longer cause a liabilities
discrepancy.
–Fixed problem causing owned crop enterprises to occasionally
be labeled as share rented out.

Historic Database Whole Farm Reports
–All income for a single crop (Cash sales and CCC income) is now
added together in the Farm Income Statement Detail report.
Previous versions would sometimes omit the CCC income.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.6, dated 2/22/2010

Annual Plan (agriculture)
–Cleaned up Edit + Paste Historic Data dialog.
–Fixed calculation of “Earned Net Worth % Change” variable, used
primarily with risk rating reports.

FINFLO
–Cleaned up Edit + Paste Historic Data dialog.

FINAN
–Fixed issue with calculations not always happening when returning
from a beginning or ending balance sheet.

Income Statement / Tax Database
–Fixed issue with consolidating statements that would sometimes
generate a data conversion error.

Income Statement / Tax Database (Schedule F)
–Fixed issue with term debt coverage ratio not calculating correctly.
(Problem was with converted data, not newly entered data.)

Historic Database Crop Enterprise Reports
–Fixed problem of returning to the report options after viewing a crop
report, and the crop type option was reverting back to “All”.

Risk Rating Reports
–Fixed issue creating a new risk rating report when there are
no cash flow plans in the file. (Problem introduced in 5.1.5)

________________________________________________________

Changes / Fixes to FINPACK release 5.1.5, dated 2/16/2010

General
–In FINPACK for Lenders version, added ability to lock / unlock
individual parts of a data file (balance sheet, cash flow plan,
etc.).

Budgets
–Fixed issue where it was possible to delete the primary
product through detail in a livestock budget.

Annual Plan (agriculture)
–Fixed issue with FSA Direct Forms filled out from an Annual Plan
where crop purchases were double-counted in the expenses.
–Fixed problem with personal interest increasing each time an
output report was displayed.
–Fixed problem with calculation of the ending cash balance on the
projected balance sheet. It was not immediately updating after entering
a capital purchase in the plan. This impacted the Ending Working
Capital on the Executive Summary.

FINFLO
–Fixed issue with FSA Interest Assistance forms where the annual
operating loan interest rate was not being updated from the balance
sheet.
–On Ending Inventory Values input, changed display of beginning balance
sheet $/unit for cash crops to reflect a weighted average price.
The output was correct, only change was to the displayed value in the
input.

Historic Database Reports (crop and livestock enterprise reports)
–Fixed issue with running an enterprise report sorted by description.

FSA Direct Forms
–Fixed reporting of breeding livestock inventory on the balance
sheet form (form 2037). If there was breeding livestock detail,
the total cost value was being reported rather than total market value.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.4, dated 2/2/2010

General
–Changed the default ShowReminders setting to “Show reminders
when there are reminders not completed and past due.”

FINAN
–Fixed preview issue where not all pages of the output would
print for an enterprise analysis.

Historic Database Reports
–Fixed issue running detail reports (machinery & equipment,
breeding livestock, etc.) where matching descriptions from one
year to the next was case sensitive (upper case vs. lower case,
not the equipment manufacturer). Now the matching is done
regardless of upper case or lower case descriptions.

Risk Rating
–Fixed issue calculating Overall Ratings when the result falls
exactly on the break between two ratings.
–Fixed issue when deleting a criteria and properly setting the
effective weights.
–Fixed issue with several ratios not being given a score (current
ratio, term debt coverage ratios, quick ratio). Introduced in
5.1.2.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.3, dated 01/15/2010

General
–Entering a new lender anywhere must have a name and abbreviation.

Balance Sheet
–Fixed problem with the detail percent adjustment on assets
in consolidated balance sheets.
–On loan data entry, changed column title to “Annual P & I
Payment.”
–Changed zero interest rate to print as “0.00” rather than “-“.

FINLRB
–Copy and Delete Alternatives now only allows data entry that links
to list entries. Previously, user could enter any name for the alternative.

Annual Plan
–Fixed issue with calculating accrued interest through detail
on a new borrowing as well as using correct principal value
on all accrued interest detail calculations.

FINAN
–Financial scorecard graphs appeared to be blank for files with only one
year of data. Changes were made to show the single data point.

Financial Analysis (commercial version)
–Fixed “divide by zero” in Z-score calculations.

Earned Net Worth Analysis
–Changed capital purchases / capital sales detail when there are
cost and market balance sheets. New detail form allows the user
to enter a depreciation percent to compare against the reported
ending cost value. Any discrepancy is displayed, and the resulting
depreciation column is the beginning cost value minus depreciated
ending value. Any value in the discrepancy column is not included
in depreciation (case of adding raised breeding livestock during
the year, this would no longer impact the total depreciation).
–Changed term debt coverage ratio calculation. “Change in personal
accounts payable” is now included in the calculation of “Balance
available for term debt payments.”

________________________________________________________

Changes / Fixes to FINPACK release 5.1.2, dated 12/21/2009

General
–Fixed problem importing a balance sheet (not all loans were
being imported.)

File Conversion
–Fixed problem converting incomplete FINLRB plans.

Balance Sheet
–When consolidating balance sheets (Edit + Consolidate), show the
optional balance sheet description in list of balance sheets to
select.
–Fixed issue creating a new balance sheet where you could enter a
blank date.
–Updating Quantity in Intermediate Assets – breeding livestock detail
and Long term Assets – Land now updates cost values as well as market
value(total cost and total market values).

Budgets
–Fixed problem displaying barley equivalents in the crop budgets.

FINLRB
–Fixed problem displaying barley equivalents in the output.
–Corrected error when deleting a loan, FINLRB didn’t update the detail
on other loans referenced by the deleted loan.
–Fixed problem with adding an alternative from general information page.
–Removed the check that user has over paid a loan within Liabilities detail.
Now shows a negative loan indicating something is wrong.

FINFLO
–Fixed problem displaying barley equivalents in the output.
–Fixed issue pulling beginning inventory of finishing livestock from
the balance sheet.
–Fixed issue where selecting a different balance sheet did not immediately
update the beginning inventory displayed in the crop sales & purchases
data entry section.
–Fixed issue where it was possible to delete records in prepaid expense
detail. The list of records there is pre-filled and cannot be removed
or added.

Annual Plan — agriculture version
–Fixed issue pulling beginning inventory of finishing livestock from
the balance sheet.

FINAN
–Changed FINAN so that the current analysis determines whether the
trend reports use market, cost or both valuation methods.
–If your Balance Sheet had detail in the prepaids or the accounts payable and
while importing data you checked “Delete existing FINAN data”, the detail
from the balance sheet in the accrual adjustments stayed but total was deleted.
This has been fixed.
–Fixed “Range check error” printing livestock enterprise reports for
enterprises with no sales unit.

Historic Database Reports
–Fixed issue running livestock reports where trying to preview a report
before selecting a livestock enterprise caused an error.
–UND numbers are now treated as a zero when calculating the average column.

Earned Net Worth Analysis
–Changed where the title appears on the output.
–Fixed issue where the incorrect detail entry form was being displayed for
capital purchases, capital sales, and personal asset depreciation when
using cost and market value balance sheets.

Risk Rating Reports
–Fixed issue where previewing a report without selecting a model generated
an error.

Presentations
–Fixed issue repopulating loan request table after balance sheet was
edited (“Dataset not in edit mode” error).

Setup
–Fixed issued editing the equivalent factor for a crop with barley
equivalents.

________________________________________________________

Changes / Fixes to FINPACK release 5.1.1, dated 11/24/2009

Budgets
–Paste Historic Data. Only displays 3 year and 5 year data if there is
data for all the years.
–Paste Historic Data. Picks up data for Dairy or Dairy and Replacements
depending on which one you have in your analysis.

FINLRB
–Corrected errors in the display of calculation detail on the output.

FSA Direct Loan Forms
–Fixed issue when previewing 2037 form. Problem occured when writing the
product unit value.

===============================================================================
Release 5.1.0, dated 11/6/2009
** Annual Update **
===============================================================================

Changes / Fixes to FINPACK release 5.0.21, dated 10/30/2009

Balance Sheet
–Fixed issue with printing collateral analysis report when
there were more loans than asset items.
–Added “Cost Value Per Unit” to breeding livestock detail.

FINFLO
–Fixed issue where calculations would not always happen
starting from the Ending Inventory Values input section.
–Fixed issue in related operating expense detail switching from
distribution to dollars. (Problem arose when a total had been
entered but cursor had not moved off that field yet, then click
the toggle button on the toolbar.)
–Fixed data entry display for livestock enterprises with a storable
product (wool, eggs, etc.). It was not displaying the inventory
line for these products.
–Fixed problem with disappearing lender names in new borrowings.

Annual Plan — agriculture version
–Fixed data entry display for livestock enterprises with a storable
product (wool, eggs, etc.). It was not using the balance sheet
beginning inventory or calculating an ending inventory value for
these products.
–Fixed problem trying to enter ending accrued interest detail on
the loan payments screen. The detail would always default to the
first loan in the list.
–Fixed problem in loan payments when going into P & I Payment or
Ending Accrued Interest detail and getting the wrong detail data.

Annual Plan — commercial version
–Added Financial Shocks to the executive summary.

Financial Analysis — commercial version
–Fixed calculation of “Operating profit” in common-size and
percent change report. It was incorrectly including other
income, which is already in “All other expenses (net).” This
did not impact the bottom-line calculation of “Net profit
before tax.”
–Fixed calculation of “All other expenses (net)” to include
“Capital gains / losses on sale of assets” when coming from
an income statement.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.20, dated 9/29/2009

FINAN
–Plan data for the Planned vs. Actual analysis can now come
from the Annual Plan as well as monthly cash flows (FINFLO).
–Combined livestock enterprise analysis output will simply
sum the combined enterprise as in the Pre-2009 version.

Risk Rating – commercial version
–Fixed issue with reading the appropriate calculations from
the commercial Financial Analysis based on the type of
balance sheets used (cost vs. market).
________________________________________________________

Changes / Fixes to FINPACK release 5.0.19, dated 9/23/2009

General
–Added Options->File Setup->FINAN databases. User can delete
existing historic database entries.

Balance Sheet
–When consolidating balance sheets with deferred liabilities,
added a reminder message that data is NOT included in the
consolidation and must be reviewed or adjusted manually.
–Print the custom signature page with the input worksheet.

FINFLO
–Fixed problem introduced in release 5.0.18 where FINFLO
output was sometimes blank or only included loan payments.
–Fixed problem printing the Executive Summary when the peak
operating balance month was not set.
–Fixed problem importing a FINFLO with multiple years, some of
the data was not being imported. (Only the first year of data
for livestock plans, crop purchases and sales, new borrowings,
loan payments, operating loan interest rates, and depreciation
percents was being imported.)
–Changed crop distribution editing for partial year plans. Now
the crop distribution will always show 12 months, regardless of
the length of the plan, so data in months outside the plan can
be edited / deleted.

Income Statement / Tax Database — Commercial version
–Cannot delete an income statement or tax database if it is
used in a Financial Analysis or Global Cash Flow Analysis.

Financial Analysis — Commercial version
–Significant changes to the output format: flipped the ordering
of years to be consistent with other reports; RMA Industry
Comparison column now on the right; can now select whether to
show Actual dollars or Thousands of dollars; asset, liabilities,
and income spreads have been duplicated to show dollars and
common-size in one report then dollars and percent change in
another report.

Risk Rating
–Fixed calculation of the average “Profit before tax % growth”
ratio in the case where one year had a negative value. (The
change from a negative profit to positive profit was being
shown as a negative % change. Now, any decrease is a negative
% change, any increase is a positive % change.)

________________________________________________________

Changes / Fixes to FINPACK release 5.0.18, dated 8/24/2009

General
–Commercial version — Added Global Cash Flow Analysis for debt
coverage analysis of a closely-held business. Mixes business and
personal debt coverage to show total or global debt repayment
ability.
–On detail form toolbars, changed the “Delete All” image from a
red X to a trash can. Also, moved the button over next to the
help button. (Too many users clicking “Delete All” rather than
the “Delete Line” button.)
–Added “Export” button on loan calculator payment schedule. You can
export the full payment schedule to a *.CSV file, which can be read
by other software (e.g., Excel) for manipulation.

Balance Sheet
–Fixed problem where the “Final Year” entry on a loan could not
be deleted.
–Added ability to copy asset cost values to market values (Edit +
Copy Cost to Market…).
–Fixed problem with cost-only balance sheet not showing detail color
in data entry for noncurrent assets with detail.
–In buildings & improvements detail, both cost and market value columns
were always being displayed. For a cost-only or market-only balance
sheet, only one column needs to be displayed.
–Accrued interest detail now correctly resets value to zero when deleting
detail.
–Collateral analysis can now print detail entries on the output.
–Fixed problem in prior lien detail where selecting Accounts Payable as
the prior lien did not hold the selection.
–Fixed problem with proposed loans in collateral analysis where any change
to the proposed principal balance deleted that proposed loan from any
collateral analysis and in any presentation.

Balance Sheet – commercial version
–Added “Intangible assets” noncurrent asset category.
–Added “Income taxes payable” current liability category.
–Split “Accounts payable and other accrued expenses” current liability
category into two separate categories. Existing data stays with
“Accounts payable” category.
–A new balance sheet defaults to cost value.

Budgets
–Printing detail only displayed ‘dollar’ amounts. Thus showing zero if
amount was less than a dollar. Changed to Dollars and Cents fixed it.

FINLRB
–When changing balance sheet on General Information form, the liabilities
reset to the balances from the new balance sheet rather than keep the
user modified values (if any).
–Title of discrepancy detail form now reads “Discrepancy – Alt ?’ where
? is the number of the alternate being viewed.
–Changing current liabilities now correctly recalculates the discrepancy.
–Small fixes to liabilities when a loan that was previously on the balance
sheet gets deleted there but needs to stay in the plan.
–Fixed problem where deleting an alternative could lose the detail for the
remaining alternatives.

FINFLO
–Fixed screen redraw problem returning from budgets (occurred in
multi-year FINFLO when returning to crop or livestock plan).
–On the monitoring worksheet, the beginning cash balance was missing.
Affected the calculation of total inflows and cash surplus/deficit.
–Fixed problem copying an existing multi-year plan with detail in loan
payments, new borrowings, and capital purchases. Not all detail was
being copied.
–Fixed display problem with inventory for feed crops on crop sales /
purchases data entry in multi-year plans.
–Fixed problem with livestock plans (particularly dairy) calculating
production, revenue and expenses incorrectly after adding a year to
the plan and removing months from the first year.
–Changed calculation of livestock breeding fees for a plan less than
a full year. Breeding fees had been underestimated, now it more
closely reflects the partial-year expense. Only breeding fees were
impacted.

FSA Direct Loan Forms
–Fixed the 2038 form where death loss for finishing livestock was not
coming from FINFLO if the livestock were purchased during the plan and
not on inventory on the beginning balance sheet.
–Fixed attachments for other intermediate assets & other long term assets
not printing totals.

Annual Plan
–Properly initializes Depreciation data when using cost-only balance sheet.
If you have an existing plan, you must reset (change and change back) the
balance sheet to get the values set properly.
–Fixed problem in output for beginning inventory value; gov’t crop loans
weren’t working correctly. Checked out crops, livestock and gov’t crop
loans and all work now.

Annual Plan – commercial version
–Removed Schedule E from the tax database selection.

Financial Analysis – commercial version
–Output now defaults to using cost values from balance sheets. If the
selected balance sheets are market-only, then calculates using market
values.
–Added “Income taxes” and “Profit after taxes” lines to analysis when using
either an 1120 or an Income statement.
–Added Altman Z-score bankruptcy predictor ratios to output.
–Added UCA Cash Flow Analysis to output. Requires accrual income history.
–Added warnings to output for missing beginning or ending balance sheets,
UCA Cash Flow checks for accrual income and beginning and ending balance
sheets, etc.

FINAN
–Fixed calculation problem for rabbits enterprise (those wascally
wabbits).
–Added min/max ranges for graphs, protects against values from one
wild year driving the graph down where the “normal” years become
invisible.
–Fixed screen redraw problem returning from balance sheet (occurred
when jumping to balance sheet while on Accrual Adjustments to Expenses
page in FINAN data entry).
–For a whole-farm analysis, added crop yields to historic database
tables for reporting in RankEm.
–Fixed data entry for month/year entry on government crop loan. If you
now enter 01/09, it sees it as 01/2009.
–Fixed typo errors on whole farm report.
–Added “Description” field to feed fed data entry.
–Updated FINBIN graph data for 2008 (must re-install to get latest setup
containing this update).

Balance Sheet Trend Reports
–Changed internal data source to work from new balance sheet
summary table, speeds up reports.
–In default commercial cost balance sheet report, changed “Net worth
change” row to be “Retained earnings change” row.

Tax Database
–Fixed calculation problem in Schedule F tax database where accrual
gross income wasn’t being set on line 11.
–Fixed calculation problem with Term Debt Coverage Ratio.
–Added extra entries to personal 1040 database, mainly debt payments.
(Used in global cash flow analysis in commercial version.) Also,
these extra entries have detail.
–Fixed problem deleting a column (if two columns had the same year,
it always deleted the first column).

Income Statement Database
–Added ability to enter detail to all entries. Also, report option
to include detail in the output.
–Added ability to copy a year and choose whether to clear out values
but leave descriptions in detail entries.
–Added ability to consolidate Schedule C, Form 1065, Form 1120, and
Form 1120-S into an income statement. Allows for roll-up into a
larger entity from different income sources.

Risk Rating
–Fixed calculation problem with reports when used with presentations.
Specific issue was multiple risk models with custom criteria.
–Fixed calculation problem when a risk model used both single-values
and averages from a balance sheet. The averaged values were correct,
but the single-values were from the last balance sheet.

Presentations / Presentation Templates
–Added ability to select balance sheet output with collateral
analysis.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.17, dated 4/24/2009

General
–Fixed problem where Preview button would become permanently
disabled if an error occured trying to print a report.
–Fixed problem entering date for gov’t crop loans that would
occassionally result in a stack overflow error.
–Changed the editing of notes so that closing the notes form using
the X in the upper right corner saves any edits.
–Made changes to reduce flicker moving between data entry and preview.

Balance Sheet
–Fixed problem deleting all entries in prior lien detail in collateral
analysis.
–Fixed problem in some detail entries (land and breeding livestock
in particular) that were deleting entries that did not have
a description or cost value but did have a market value.

Budgets
–Fixed problem where breeding livestock expenses were lingering
in the budget when it was switched to finishing. (Breeding
Fees entered in the breeding livestock budget were still in the
file and used in calculations although the budget had been
switched to a finishing budget.)

FINLRB
–Fixed calculation in crop plan data entry, acres for double-crop
budgets were incorrectly included in the total acres at the
bottom of the screen.
–Fixed data entry error in operating expense detail where entering
a zero in Months Outstanding would generate an invalid number
error.
–Fixed two preview printing problems due to wrong headings when not
previewing all alternates. The preview options page also incorrectly
labelled alternates as “Alt 2” when it meant “Alt 1”, etc.
–Fixed data entry problem when changing liability detail, all loans
were recalibrated; not just the affected loans. Handles this correctly
now.

FINFLO
–Fixed problem in loan payment detail where new borrowings
were being displayed that had been deleted. This was a
display problem only, did not impact the calculations.
–Fixed problem in related operating expenses / other cash
flows data entry pages using detail when toggled over to
dollar mode.
–Fixed calculation in crop plan data entry, acres for double-crop
budgets were incorrectly included in the total acres at the
bottom of the screen.
–Fixed problem in multi-year plan where ending balance sheet
values on the Depreciation data entry were not being carried
forward into the beginning values of the next year. It was
happening correctly when the year was copied forward, but any
subsequent edits in a year were not carried forward.

FINAN
–Fixed problem with cost balance sheet trend report where
it would not print at all if some historical balance sheets
were market-only (the rest are cost and market, so it now
prints the balance sheets it can rather than ignoring them
all).

Historic Database Reports
–Fixed variables in whole farm reports for ending net worth
(the ending net worth-cost variable was reporting the
ending net worth-market value).

Risk Rating Reports
–Fixed issue where “[modified]” flag would always get set
when returning to data entry from previewing the report.
–Added “Collateral coverage margin” from collateral analysis
as a ratio to be selected.

Presentations
–Fixed problem selecting optional attachments that would
occassionally result in an error.
–Added “Collateral coverage margin” from collateral analysis
as a ratio to be selected.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.16, dated 3/31/2009

General
–Fixed problem where an entry of “999” printed as “Und” in
a report (was happening in several places).

FINFLO
–Fixed problem with creating a multi-year plan when year
1 was a partial year, some loan information was not getting
carried forward into year 2.

FINAN
–Fixed problem with household information not saving into the
historic database correctly in certain situations.

Income Statement / Tax Database
–When previewing selected years with the average column, the
average column now shows the average of the selected years
rather than the average of all years.

Annual Plan
–Fixed problem in output for beginning inventory value of
livestock when there were multiple instances of the same
enterprise in the plan.

Risk Rating Reports
–This fixes an out of range error that occurs whenever there
are more than 32 balance sheets within a file. We limit the
list to the most recent 32.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.15, dated 3/12/2009

File Conversion
–Fixed problem converting FINLRBs, it was failing during
the re-order of loans.

General
–In livestock enterprise setup, some finishing livestock
descriptions for growing male & females were not correct.
Need to re-install to get these changes.
–Resolved disappearing “Please wait” form in various places
(sometimes in FINAN calculations, presentations, etc.).

Annual Plan
–Fixed problem printing input worksheet with detail on
ending balance sheet entries.

FINAN
–Fixed problem calculating results when one of the balance
sheets is empty.

Financial Analysis (Commercial version)
–If user doesn’t have RMA option, then correctly displays the
years on all sections of the report (order problem).

Risk Rating Reports
–This applies to Presentations with Risk Rating Report.
Fixed issue where the calculation couldn’t find a custom
criteria value due to an upper/lower case string comparison.

Presentations
–Added checks for FINFLO attachments with no ending year
selection.
________________________________________________________

Changes / Fixes to FINPACK release 5.0.14, dated 3/4/2009

File Conversion
–Fixed problem with FINAN’s losing principal paid. It is not
necessary to re-convert.

General
–When deleting items in data entry, the cursor now stays
in the same area rather than being reset to the top.
For example, deleting items in machinery detail, livestock
inventory, etc.

FINFLO
–Fixed problem that crop production wasn’t picked up correctly
when a year was copied.
–Changing the harvest month in a crop distribution wasn’t
immediately updating the production line in the crop purchases
and sales section.

Historic Database Reports
–Fixed problem with detailed income statement report not including
expenses that are no longer active in the report.
–Added “Gain or loss from capital sales” to detailed income
statement report.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.13, dated 2/26/2009

Balance Sheet
–For end-of-the-month balance sheets (Dec 31), changed
calculation of principal due in 12 months on term loans when
there is a payment in the balance sheet month. For example,
a December 31 balance sheet with a payment in December now treats
that payment as happening December of next year.

FINFLO
–Fixed problem calculating a FINFLO that was completely empty
(only possible in FINAN plan-vs-actual report).

Annual Plan
–Fixed divide-by-zero error when calculating yields in the crop
plan data entry.

Historic Database Reports
–Balance sheet reports, crops under gov’t loan taken as income
are now reported correctly.
–Added Farm Income Statement Detail report.

Risk Rating Reports
–Added Financial Analysis selection to the commercial version.

Risk Rating Models
–Properly set modified flag in Overall Ratings page.
–New risk rating model correctly handles overall ratings.

________________________________________________________

Changes / Fixes to FINPACK release 5.0.12, dated 2/19/2009

File Conversion
–When converting a FINFLO, fixed problem where Crop Sales/Purchases
got out of order when converting a file with both sales and
purchases of the same crop in the original FINFLO.

General
–Fixed problem printing cover page where the farm / business name
and address were getting cut-off.

Balance Sheet
–Livestock Held for Sale correctly calculates value per
unit when total value is changed.
–When loading a balance sheet, FINPACK scans the personal loans
looking for empty or blank loans and removes them.

Budgets
–On livestock budgets, there is now a check for a Months on Farm
entry no larger than 24 (maximum).

FINFLO
–Fixed problem where Crop Sales/Purchases Enterprises got out of
order when creating FINFLO from a copy.
–Fixed problem printing detail under crop budget expenses in cash
flow section.
–In Ending Inventory Values list, beginning balance sheet value of
crop and livestock were not being updated for display. They were
being updated for calculations, this was just a display problem.
–Negative numbers in the related operating / other cash flow
sections are now included in the output.

FINAN
–Change methods when importing loan information to better
label loans.
–Recalculate interest expense in Related Operating on load
if detail exists.
–Fixed value-added non-farm analysis so that selecting a livestock
enterprise retains the selection.
–Fixed printing comparative balance sheet reports, market-only
balance sheet report does not include retained earnings or market
valuation equity.
–If there are only market-value balance sheets in the trend, no
cost balance sheet trend report is printed.

FSA Direct Forms
–Correction in 2211 Application for Loan Guarantee when
printing from a FINFLO. Values for NET CASH FLOW (inflows – outflows)
WITHOUT INTEREST ASSISTANCE and WITH INTEREST ASSISTANCE were swapped.

Risk Rating Reports
–Fixed problem when result value for ratio landed exactly between
two range limits; i.e., result was 1.2427 and limits were greater
than 1.25 and less than 1.24.

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.11, dated 2/05/2009

General
–More work on storing default data location and program location
in the user’s settings.

FINFLO
–Fixed setting flags that loan payment & distribution have been
edited when done through detail (caused problem where doing a
refinance through detail then making any change on the balance
sheet cleared out the refinance payments in FINFLO).

FINLRB
–Return from liabilites keeps focus on the record from which went
into detail.

FSA Direct Forms
–Fixed setting file name of resulting PDF file.
–Corrected a field name in 2037 / 2038 Business Plan forms.

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.9, dated 2/3/2009

File Conversion
–When converting a FINAN, with the 5.0.8 converter, a second
column of “Summary Information” was added. This has been fixed
and the extra column will be removed when the file is loaded.

General
–Changed where default data location is stored to help with
network installation & common network data locations.
–File List implemented (select File + List Files from the menu).
Allows you to print list of files, export a CSV file with full
name and address information, or open a selected file.
–When using File + Copy, the file being copied is unlocked (when
opening the file later, won’t get a message about being locked
by another user).

Balance Sheet
–Personal liabilities schedule W now prints when the only
personal debt is accounts payable with detail.
–Fixed problem when entering detail in assets and clicking
percent adjustment before hitting enter on an entry.
–Fixed scroll bar problem on personal liabilities data entry
screen (in consolidated balance sheets, principal due column
was covered up sometimes).
–Fixed problem where deleting the only proposed loan which was
also the only loan in a collateral group fell into a loop.
–Current loans were resetting the current loan balance on loading
the balance sheet. This has been fixed.

FINLRB
–Added detail for Nonfarm Income in the Cash Flow section
of output.
–Problem with correctly shifting detail when deleting an alternative
within FINLRB has been fixed.
–User must pick a loan term for each loan (except current liabilities)
on the liability page before leaving.
–Fixed problem with delete and delete all within liabilities detail.

FINFLO
–Fixed problem trying to delete all detail entries in Ending Balance
Sheet input when there is detail coming in from the beginning
balance sheet.
–Fixed copying FSA guarantee loan information when copying a FINFLO.
–Fixed problem with loan payment distributions not updating from the
balance sheet correctly.

Annual Plan
–Fixed copying FSA guarantee loan information when copying an Annual
Plan.

FINAN
–Fixed error caused by Copy/Clear general data that would
not allow users to view output.
–Fixed problem in combined livestock enterprises reports
that resulted in incorrect divisors for columns 1 and 2 in
some situations.
–Fixed calculation problem in Dairy enterprise that resulted
in incorrect Gross Return. Gross margin and Net Return were
correct.
–Fixed problem printing detailed Value Added enterprise reports.
–Fixed problem printing personal business expense on the
Personal Business summary.
–When copying an existing FINAN, the check-box to “clear
data for another year” now defaults as checked.
–Fixed display of detail items on value-added enterprise
analysis, direct expense form (coming out of detail wasn’t
updating display on main form).
–Fixed a problem in the landlord share rent calculations.
–Fixed a problem editing notes, changes were not always being
kept and notes were sometimes not editable.
–Fixed scroll bar problem on farm non-current liabilities data
entry screen (discrepancy column was covered up sometimes).
–Fixed import problem that resulted in missing detail on
imported data in some circumstances.
–Fixed a problem resulting in multiple display of other asset
detail in Statement of Cash Flows.
–Fixed a design flaw in the placement of the inventory
change of Growing Crops.
–Fixed problem with blank loans coming from the balance sheet in
the personal loan section. (Getting strange “Update error” when
moving off the personal loan section.)
–Fixed description of first item in the comparative trend of
livestock (for example, hog farrow to finish shows number of
litters farrowed, not average number of sows).

Presentations
–Added more checks to calculations for incomplete risk rating
reports.
–Added missing output options for FINFLO attachments (wasn’t
printing body of the cash flow).
–Added work-around for bad text conversions (some characters
switching to other characters during conversion, in particular
“er” mysteriously switching to “FD”).

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.8, dated 1/20/2009

General
–Items with detail are displayed with a background color to
distinguish them from items with no detail.

Balance Sheet (commercial version)
–Fixed problem trying to open or create a balance sheet.
–Fixed total principal due calculation on personal loans.

Budgets
–Fixed “RecordIndex out of range” error when deleting the
last crop or livestock budget in the list.

FINLRB
–Fixed loan principal balance re-calculation problem when a
loan was paid-off in an alternative by a refinance in detail
(the FINLRB is fixed when loaded).

FINFLO
–Fixed error deleting last livestock plan in the list.
–Fixed error deleting last crop sales/purchases in the list.

FINAN
–Fixed error deleting last livestock enterprise in the list.
–Fixed “Share Rental Percent” to display only whole numbers
on crop production data entry screen.
–Fixed problem deleting last crop enterprise in the list.
–Fixed display problem with livestock enterprise form (grids on
Product Sales and Other Information tabs were not being displayed).

Presentations
–Fixed problem where changes to attachment output options (balance
sheet, FINFLO, etc.) were not being saved if you went directly
to the print dialog.

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.7, dated 1/16/2009

Balance Sheet
–Fixed problem on gov’t crop loans entry with checking date entered
vs. the balance sheet date.

FINFLO
–Fixed principal due in 12 months on the beginning year 2+ proforma
balance sheets. It was including payments on new loans that were
not on the balance sheet yet.
–Fixed display problem with Related Operating expenses data entry
screen in 800×600 resolution.
–Fixed loading historic FINAN data for display on Related Operating
and Other Cash Flows data entry screens. It wasn’t always displaying
the most recent FINAN data from the previous year.

FINLRB
–Fixed problem with loan values when jumping to and from balance sheet
and budgets.

FINAN
–Enabled “Re-order Enterprises” in FINAN.

Historic Database Reports
–Fixed problem printing balance sheet reports on a file that did not
have any FINAN’s (introduced in 5.0.6).

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.6, dated 1/16/2009

File Conversion
–When converting a FINAN the ‘Total Acres’ item, used for display only,
in the Crop Enterprise Analysis is now being calculated.

General
–Added a “beep” when detail exists on an item and you try to type over
it.

Balance Sheet
–Fixed balance sheet rename bug.
–Fixed month due detail bug when only selecting a single month
for payment.
–Fixed missing “Total Personal Assets” on the printed report.
–Added a fix for files with the month due detail bug.
–Added a fix for files with incorrect “Remaining Balance” on loans.
–Fixed a bug that occured when deleting the last loan in a balance sheet
that had collateral analysis.

Financial Analysis (commercial version)
–Fixed problem with guide labels when previewing output.

FINLRB
–Fixed problem updating loan principal and annual payments when changing
the loan info within the balance sheet.
–Fixed feeder livestock purchase expense for livestock purchased per head.

Annual Plan
–Added “Description” column from balance sheet to government crop loan
input.
–Fixed display order problem with govt crop loans. (One side effect was
detail would get jumbled when copying.)
–Fixed problem when changing a gov’t crop loan in balance sheet and then
updating the loan in the Annual Plan.
–Fixed problem when loading balance sheet loans into the annual plan. Wasn’t
properly deleting all loans when they were no longer part of the balance
sheet.

FINFLO
–Added “Description” column from balance sheet to government crop loan
input.
–Fixed display order problem with govt crop loans. (One side effect was
detail would get jumbled when copying.)
–Fixed input for crop sales & purchases to display “To CCC” and “From CCC”
lines for cash crops.
–Fixed pattern distribution, it was always filling every month not just the
months selected.
–Fixed problem when changing a gov’t crop loan in balance sheet and then
updating the loan in FINFLO.
–Added the missing Personal Loan Payments line to the Exec Summary Term
Debt Coverage output. The calculations were correct — a display issue only.

FINAN
–When a copy of a FINAN is made, we recalculate the ‘Total Acres’ item,
used for display only, in the Crop Enterprise Analysis.
–Fixed a bug that resulted in Balance Sheet accounts payable detail
being mixed with cash expense detail on the detailed income statement.
–Removed straw from the crops included in All Hay on the Crop and Feed
Check.
–Can now delete (backspace) the cash flow plan for comparison on the
first page of input.
–Fixed problem running comparative trend reports with very long crop
names.
–Fixed problem with “Clear out general data and prepare for another year”
not leaving detail descriptions in some of the income and expense items.
–Fixed calculation bug when entering quantity and total value
in Crop Sales form.
–Fixed a calculation bug that resulted in the Value Added calculations
sometimes causing a program crash.
–Fixed a calculation bug that resulted in missing Share Rented Out crop
enterprises.
–Fixed problem that deleted all records from labor hour detail. Only sets
the values to zero.
–Added ability to back calculate the hours per day when total hours and
number of days are specified.
–Fixed error with Special Sort detail on Summary Information form.
–Added FINBIN comparison graphs to the output.
–Added ability to re-order crops in enterprise analysis (Edit + Reorder
Enterprises from the menu).
–Added “Delete from summary” check box to Family Living Detail.
–Added ability to “Clear data” on the import file name selection form.
–Fixed comparative trend report, was not including irrigated or
double-cropped crops in report.
–Comparative trend crop price no longer includes government crop loans.
–Fixed import to allow multiple lines of family living with detail.
–Fixed comparative balance sheet reports to include the beginning balance
sheet of the first year in the trend.

Historic Database
–Fixed issue with inactive Crop and Livestock names not appearing in the
selection box of the report options.
–Fixed issue with Crop and Livestock reports not refreshing expense lists
when switching from preview to options and back.
–Fixed the Crop Enterprise report setup for Direct Expense per Unit
–Made a couple of other minor report definition changes.
–Added detail balance sheet reports for Titled Vehicles, Buildings, and
Breeding Livestock

Tools + Options
–Added setup section for “FINAN Graphs”, can set which graphs are active
and the strong / vulnerable (green / red) ranges.

_________________________________________________________

Changes / Fixes to FINPACK release 5.0.5, dated 12/23/2008

General
–Install update problem. See 5.0.4 list for other items.

File Conversion
–Fixed error with version 5.0.4 file conversion.

FINFLO
–Fixed problem with historic data in 5.0.4 version.
_________________________________________________________

Changes / Fixes to FINPACK release 5.0.4, dated 12/22/2008

General
–When restoring a data file, the file is now immediately opened
after being unzipped.
–Fixed problem renaming an Annual Plan, FINFLO, etc. New description
is limited to 25 characters.
–Fixed problem going to balance sheet and budgets from FINLRB, FINFLO,
etc. where toolbar did not update correctly.
–Fixed problem in 800 x 600 screen resolution where toolbars did not
show in the same order as other screen resolutions.
–Fixed problem where if the user logo was not a bitmap file, could not
clear the logo in Tools + Options.
–Fixed problem where some forms would not redraw correctly when
returning from the balance sheet / budgets (e.g., FINAN accrual
adjustments to expenses).

File Conversion
–Fixed problem converting historic database records with no accompanying
FINAN data. Beginning & ending balance sheets were not getting hooked
up correctly. No re-conversion is necessary if a file was converted with
a previous release.

Annual plan
–Paste historic data now works for Related Operating Expenses, etc. input.

Balance sheet
–Fixed problem trying to spell-check notes for collateral analysis.
–Fixed problem with data entry in deferred liability on capital assets
detail estimated marginal tax rate(%).

FINLRB
–Fixed problem with data entry on loan detail debt forgiveness.
–Added check-box to show historic data columns on Related Operating
Expenses and Other Cash Flows input.
–Paste historic data now works for Related Operating Expenses and
Other Cash Flows input.

FINFLO
–Fixed problem when entering data and then toggling between dollars
and distribution.
–Fixed problem in crops sales & purchases data entry screen where
beginning inventory for a cash crop was being picked up from CCC
crop beginning inventory.
–Fixed livestock feeding calculation problem when purchased feed
was turned off as a budget expense.
–Added check-box to show historic data columns on Related Operating
Expenses and Other Cash Flows input.
–Paste historic data now works for Related Operating Expenses and
Other Cash Flows input.
–Fixed printing family living detail
–Fixed printing detail on some livestock budget expenses such
as marketing
–Changed title on Shock test to reflect that it is the change
in net farm income
–Added a print option to choose if Notes are printed. Notes were
not printing with annual output unless print detail was selected.
–Fixed a year 2+ livestock inventory valuation problem in output
when using multiple occurances of the same enterprise in a plan.
–Fixed refinance and capital sale loan detail for personal loans.
Personal loan payments in term debt coverage are now adjusted.
–Fixed ending inventory values so that CCC feed crops put under
loan in the plan now appear in the list in data entry.

FINAN
–User is now able to page up and down during enterprise analysis
data entry and the cursor stays on the current enterprise.
–Fixed feed fed bug in livestock enterprise analysis that appeared
after deleting a line of feed fed, saving and reloading.
–Fixed problem printing balance sheet comparative trend when there
was bad historical data coming from the old file.
–Edit + Import Data now works to import data from accounting
software that generates a *.FIF file (exactly like previous version).

Historic Database
–Livestock feed fed values were not being stored correctly. That has been
fixed. This appears in the Livestock enterprise reports. Errors in the
data can be easily fixed by loading the FINAN and previewing the output.
–Crop enterprise reports are now available.
–Livestock enterprise reports are now available.

Commercial Financial Analysis
–Fixed problem where some tax forms were not properly reporting
operating expenses on output.

Earned Net Worth Analysis
–Fixed problem calculating change in market valuation with detail and
market-only balance sheets.

Risk Rating Reports
–Fixed problem when result value for ratio landed exactly between two range
limits; i.e., result was 1.2427 and limits were greater than 1.25
and less than 1.24. Ratio was not being scored, now it is.
_________________________________________________________

Changes / Fixes to FINPACK release 5.0.3, dated 12/5/2008

General
–Fixed problem with file locking in a Windows Terminal Services /
Citrix environment.
–Loan calculator fixed payment schedule now doesn’t clear interest
rate when clicking on Clear All button.
–Under Tools+Options, added a Shock Percents page to edit the shock
values for FINFLO and FINLRB.

File Conversion
–FINAN: Fixed problem where interest detail was lost on current
loans that were not on the Beg. or End. balance sheet and did not
have any money borrowed or payments made, only an interest amount.
–FINAN: The new version does not have a space to enter the “number
of units” for calculating results using allocation factors. In
order to keep the results consistent, all the livestock allocations
needed to be converted to percentages. A reconvert of the file
is required if you used livestock allocation factors in FINPACK 2005.

Balance Sheet
–Fixed collateral analysis calculation problem where loan to value
for each group wasn’t being updated. The overall loan to value
was correct.

FINFLO
–Fixed problem where beginning balance sheet values of assets was not
coming in from a cost-only balance sheet.
–Fixed problem where new borrowings were not coming into the correct
month in loan payment detail.
–Fixed problem in calculations with missing crop distributions.
–Fixed problem in calculations with missing livestock feed distributions.
–Fixed problem where updating new borrowing detail didn’t update the
total amount borrowed on the loan payments.
–Fixed problem pasting fixed-principal payments from the loan calculator.

FINLRB
–Fixed problem with deleting all detail under average annual operating
loan balance.
–Fixed depreciation detail form to keep it from deleting or inserting records.

FINAN
–Fixed livestock enterprise analysis feed calculations to include
multiple entries of the same feed.
–Fixed crop enterprise analysis government income calculation which
was incorrect when owned/cash rented acres were entered in the same
input column as share rented acres.
–Fixed trend report error that was not counting livestock average
number of head correctly.
–Fixed the labels on livestock enterprises on the whole farm production
summary.
–Changed the cost of production calculation for certain breeding livesotck
(beef cows, hog farrowing) to include transferred in as a cost of
production in the revenue adjustments.

FSA forms
–FSA-2211 Part G. – lines 52 and 53 (net cash flows without and with
interest assistance) values were reversed, but have been corrected.
–FSA-2211 Part E. – loan security items was only displaying the last item.
Now displays them all.

Risk Rating Reports
–Fixed FINFLO ratios weren’t being calculated on output.
–Fixed problem where some custom criteria output values were being
dropped on output.
–Changed Overall Ratings “From” value in output to display only two decimals.

Presentations
–Fixed problem creating loan request table (Present & Proposed Loans)
where only the first loan balance was being used for the proposed
balance.
–Changed how loan request table is made. Now *all* loans listed as
proposed loans in the balance sheet are used in this table, regardless
of whether they are used in the collateral analysis.
–Added Commercial Financial Analysis to list of optional attachments.
–Fixed problem with loan request table updates creating columns wider
than the table (table looked triple-spaced).
_________________________________________________________

Changes / Fixes to FINPACK release 5.0.2, dated 11/21/2008

General
–Added spell-check to notes form most everywhere.

File Conversion
–Fixed problem assigning livestock distribution to user-added enterprise.

Balance Sheet
–Fixed collateral analysis calculation problem where asset / loan
value changes were not flowing through into the totals.
–Added optional balance sheet description to headings on the output.
–Fixed problem copying a balance sheet, some loans were not copied
forward.

FINLRB
–Fixed problem adding an alternative after already previewing/printing
wouldn’t automatically preview the new alternative when next previewing.

FINFLO
–Fixed problem copying a FINFLO that has livestock feed
distributions.
–Finished input printing. (This is the “Input Worksheet Options” tab
on the Print dialog.)
–Fixed printing problem with FINFLO cover page (extra lines caused
it to flow onto a second page).
–Fixed calculation problem with finishing livestock beginning inventory.
Program was crashing on beginning inventory without a weight.
–Fixed problem with user-added livestock enterprise not having a
distribution link.
–Fixed problem with finishing livestock purchases when enterprise was
purchasing animals on a per-head basis (finish feeder pigs, etc).
–Fixed problem with multiple livestock purchase lines in the outflows
section. Did not change results, just a display problem.
–Fixed problem where new borrowing detail was changed but not reflected
within loanpayments.

Annual Plan
–Historic tax data is now displayed regardless of the plan year
in relation to the tax year. Previously, the tax database had
to have a year immediately before the plan year for the averages
to be calculated.

FINAN
–Fixed cash accuracy check calculation to include gifts and
inheritances.
–Fixed detail output for Other Income section.
–Copy FINAN with Clear General Data checked was deleting all the data in
detail. Now it leaves the descriptions, but removes the values & quantities.

Historic Database
–Default value for Gender Type and Contract Code were not being set
correctly. This causes options to show in the Historic Livestock
reports when they do not really exist. Reconverting the file or
previewing the FINAN output is suggested, but not required.

Risk Rating Reports
–Fixed calculation problem with average net worth change.
–Fixed “Invalid floating point” error for some average
ratio calculations.

Presentations
–Fixed problem printing attachments directly to a printer.
–Fixed problem switching optional attachments.
_________________________________________________________

Changes / Fixes to FINPACK release 5.0.1, dated 11/13/2008

General
–2008 RMA data is now available (add-on only).
–Printing loan payment schedule from loan calculator now
works.
–Fixed loan calculator problem previewing payment schedule
for amortized payments with uneven number of payments
(e.g., payments for 7.5 years, loan calculator was not expecting
a portion of a year).
–Fixed problem when creating a new file with “Partnership”
business type (when licensed for ag-only, user got a message
about not being able to create a commercial file).
–Updated installer to work better under Windows Vista (setting
folder permissions).
–In the Lender version, disabled selecting the file type on
an existing file. (Caused various errors.)

File Conversion (ConvertFPX)
–Fixed problem trying to convert feed equivalents (“File not
found” error).
–Fixed problem converting custom criteria values in risk models.
Risk models should be re-converted.
–Fixed problem converting FINAN Crop enterprise direct expense detail.
The file should be reconverted.
–Fixed problem with Crop Loans in FINAN not always converting. If
you got a message about your crop loans, you should reconvert.
–Fixed FINAN conversion problem that was caused by expense settings in
the old version. The problem caused all the data in a FINAN to be lost.
–Fixed FINAN conversion problem where if a current loan was not on either
of the Balance Sheets, had no principal borrowed or repaid but did have
interest paid in the detail it was being ignored.
–Fixed FINAN conversion problem where accounts payable interest recorded
in the related operating interest detail was being dropped.
–Fixed FINFLO conversion problem where a new borrowing on a loan that
used to be on the balance sheet but isn’t anymore was being dropped.
–Fixed FINAN conversion problem where older analysis crop loans were
being lost because there was no quantity, loan rate or date entered.

Balance Sheet
–Fixed problem copying an existing balance sheet, it was sometimes
losing detail in collateral analysis.

FINLRB
–Fixed problem when changing the value of a loan on the balance sheet.
It wouldn’t properly update the principal balance within FINLRB unless
there was detail behind the loan. Now sets the balance regardless.
–Fixed problem with updating loan alternate principal balance
detail and annual payment calculation when modifying a reference to
that loan in another loan detail.
–Fixed problem copying an existing FINLRB, it was sometimes losing
detail in income & expense items.
–Fixed problem printing FINLRB output with income & expense detail.
Expense detail from the budgets was getting scrambled across various
expenses. (Totals did not change.)

Annual Plan
–Fixed problem with livestock plan only showing data for first
enterprise in the list, regardless of which one was selected.
–Fixed problem copying an existing Annual Plan, it was sometimes losing
detail in income & expense items.

Budgets
–Fixed problem when printing finishing livestock. Purchase weight and
price units were displaying on a second line rather than as part
of the caption, also sales weight was not printing.

FINFLO
–Added “Income Shock” section to Executive Summary. Shows income
impact of 5% decrease in prices, 5% increase in expenses, and 3%
increase in interest rates.
–Fixed problem with finishing livestock not calculating when
budget is switched to different enterprise.
–Fixed problem copying an existing FINFLO, it was sometimes losing
detail in income & expense items.
–Added output for Input Worksheet. Does not yet show detail.

FINAN
–Fixed problem copying an existing FINAN, it was sometimes losing
detail in income & expense items.

Historic Database Reports
–Fixed problem using the print dialog box before going through
preview.

Risk Rating Reports
–Fixed problem where custom criteria didn’t show the value pick list.
Problem occurred whenever a custom criteria name was longer than 20
characters. It can now be 30 characters long.
–Added warnings specific to having multiple zero values for levels
and ratio scores. Also, tried to indicate which item has the error.
–Fixed that zero value for ratio scores or criteria levels indicated
that the value was invalid. Ignore such checks now, but replaced
with above additional warnings.

Risk Rating Models
–Fixed the toggle of overall ratings from low-high / high-low.