Changes / Fixes to FINPACK release 6.4.7, dated 3/7/2024 General --Fixed issue with Default Output Options in Lender edition, where Collateral Analysis check box always appeared checked even after the user changed it. Summary Balance Sheet --Added a line item for accumulated depreciation in cost balance sheets for commercial files. Tax Forms --Change calculation of average Debt Coverage Ratio. Divide average Cash Available for Debt Service by average Total Debt Payments, instead of taking an average of Debt Coverage Ratios across years. Global Cash Flow Analysis --Made calculation of average Debt Coverage Ratio consistent with Tax Forms: divide average Cash Available for Debt Service by average Total Debt Payments, instead of taking an average of Debt Coverage Ratios across years. Cash Flow Projection (FINFLO) --The total acres in the crop plan data entry were not being calculated correctly. This was a display issue only. --Cash flows (annual and monthly without budget) were not displaying number of offspring produced when offspring were transferred out. Long Range Planning (FINLRB) --Fixed issue with deleting alternatives taking a long time. Financial Analysis (FINAN) --Added Value of labor and management to the allocated expenses data entry in Market Channel analysis. Commercial Real Estate Analysis (commercial) --Made calculation of average Debt Coverage Ratio consistent with Tax Forms and Global Cash Flow: divide average Cash Available for Debt Service by average Total Debt Payments, instead of taking an average of Debt Coverage Ratios across years. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.6, dated 01/03/2024 Financial Analysis (FINAN) --Livestock Enterprise Analysis output. Feed that was not a crop (DDGS, Protein, etc) were being labelled as the crop preceding them not what they really were. This was a label only issue that was introduced over the summer and has been corrected. --Import Data (FINPACK+ only). The program would hang after the user uploaded their FIF file and clicked the OK button. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.5, dated 12/19/2023 General --Fixed issue with importing Tax Forms/Income Statements. --Removed the option to import legacy items. Financial Analysis (FINAN) --It was possible for the over allocation check to fail based on insignificant digits and has been corrected. --Fixed the issue with the Market Channel labor categories appearing in the Value Added analysis and being displayed as codes instead of their description. --Fixed the issue with allocated overheads using default distributons instead of user entered values. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.4, dated 12/5/2023 General --Updated benchmark setup for Minnesota. Schedule F Cash to Accrual Analysis --Fixed issue in Personal Income detail where the selection of "Other" was not saving when there was also detail from the 1040 form present. Budgets --Fixed issue with Production Detail for crop budgets. Financial Analysis (FINAN) --Turning on the Market Channel analysis option was resulting in a error when saving or previewing the output. That has been fixed. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.3, dated 11/28/2023 General --Fixed issue with navigating to Earned Net Worth Analysis. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.2, dated 11/27/2023 General --Fixed issue with displaying the Producer/Company information when file is first opened. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.1, dated 11/09/2023 Tax Forms --Fixed issue with Other Income detail on Schedule F. --Added "(not itemized)" to title of detail rows in the output for years where detail is not itemized. __________________________________________________________ Changes / Fixes to FINPACK release 6.4.0, dated 11/01/2023 General --For agricultural files, added an “Organic” checkbox when selecting a crop in various areas of data entry. Rather than having a separate organic crop in the crop list, now any crop in the list can be identified as organic. Existing organic crops have been identified in this new way with this release. --For commercial files, add ability to import C&I Analysis and Cash Flow Projections from another FINPACK data file. --Added option to remove notes when copying a data file. --Updated FINAN / Sch. F Analysis scorecard graphs with 2022 data from FINBIN (Missouri, Nebraska, North Dakota, Pennsylvania, Utah-2021). Detailed Balance Sheets --Added option for signature line on Balance Sheet Input Worksheet. --Personal assets that have been sold no longer appear on the input worksheet. Tax Forms --Added detail to Other Income line item on Schedule F. Balance Sheet Trend Reports --Fixed issue where accrued interest was not displayed in the report. C & I Business Analysis (commercial) --Updated RMA data for 2023-24. Financial Analysis (FINAN) --Revised the value-added enterprise analysis. --Fixed issue copying a crop enterprise. Cash Flow Projection (FINFLO) - commercial --Modified Executive Summary to display net cash flow, changes to LOC balance and working capital, and shocks to DSCR. --Modified Projected Inventory Change report section to match changes on the Executive Summary and added one section per plan year. --Added the ability to use an income statement for historical comparisons. --Fixed bug that was creating duplicate, mislabeled years in historic data. Presentations --Fixed bug in embedded and attached trend reports that was causing the same trend year to repeat across columns. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.10, dated 7/5/2023 General --Fixed issue in data entry grids where font would change when highlighting a row or column. Tax Forms --Fixed issue where save was very slow after deleting detail. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.9, dated 6/8/2023 General --Updated FINAN / Sch. F Analysis scorecard graphs with latest data from FINBIN (Ohio, Wisconsin, and South Dakota). Cash Flow Projection (FINFLO) --For commercial files, add input and monitoring worksheets. --Do not take capital distributions from the contributed capital account. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.8, dated 4/17/2023 General --Fixed bug #15388 that was causing an error when updating FINFLOs for older Ag files. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.7, dated 4/4/2023 General --Fixed issue where the automatic file update would randomly throw an exception and stop working. --Updated FINAN / Sch. F Analysis scorecard graphs with 2022 data from FINBIN (Minnesota). Cash Flow Projection (FINFLO) --For commercial files, remove history from Statement of Equity and display projection years only. --For commercial files, added some risk rating variables including Current ratio and Quick ratio. --For annual cash flows in commercial files, included equity purchase and sale amounts in LOC input screen and cash flow output. --For commercial files, fixed bug that displayed warning when toggling between distribution factors and dollars. --Fixed bug in calculating DSCR when beginning balance sheet has no loans. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.6, dated 3/8/2023 Cash Flow Projection (FINFLO) --For commercial files, fixed issues with equity accounts and inventory changes. Modified Statement of Equity to accommodate both cost and market balance sheets. Added C&I based on cash tax forms to list of available Income/Expense history. --Made commercial FINFLO variables available in Risk Rating Reports and Presentation templates. Long Range Planning (FINLRB) --Fixed the calculation error that would occur if there were no Intermediate or Longterm farm liabilites. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.5, dated 2/3/2023 Cash Flow Projection (FINFLO) --Fixed issue with the direct livestock expenses and feed inventories displayed in data entry in year 2+ of a projection. This did not impact the output, it only occurred in data entry. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.4, dated 1/19/2023 General --Fixed issue with some file updates that would lock up while updating a cash flow projection (FINFLO) with a message like "Field FeedFedUnit123 not found" from the related livestock budgets. Financial Analysis (FINAN) --The Cash Flow and Crop & Feed Check pop up form is now sizeable for those that need it. --Fixed "Invalid Floating Point Operation" error in FINAN that popped up when you had Market Channel Analysis turned on, no labor information and tried to go to the "Related Oper Exp Alloc" input form or other enterprise allocation forms. Presentations --Fixed bug for presentation template not allowing user to add a section. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.3, dated 12/15/2022 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2021 data from FINBIN (Michigan, Missouri, Nebraska, North Dakota, Ohio, Pennsylvania, South Dakota, Utah, Wisconsin). --Added seaweed to crop list. --Add "Show completed tasks" to Reminders form, default is off. Crop Budgets --Fixed data conversion issue with historic crop information that was not displaying any history in crop budgets. Financial Analysis (FINAN) --Fixed data conversion issue with Debt Coverage Ratio in previous years for the Comparative Trend Report. --Added ability to delete a Market Channel enterprise but only when the user is on the Market Channel Sales page. --Fixed the issue with labor not being allocated to Crop/Livestock/Value Added enterprises when Market Channel analysis is active. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.2, dated 11/30/2022 Financial Analysis (FINAN) --Fixed the issue with FINPACK freezing when creating a copy of a FINAN that had Market Channel enterprises and selecting the option to "Clear the data". --Fixed issue with Related Operating Expense Allocations when turning off / on different analysis types and the Percent Remaining value. Presentations --Fixed the issue with Auto-save breaking the Insert Fields list and failing to make the Save function available after changes. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.1, dated 11/1/2022 Tax Forms --Fixed issue with Schedule E calculation of line 26 when line 21 is negative (loss). C & I Business Analysis (commercial) --Updated RMA data for 2022-23. Cash Flow Projection (FINFLO) - commercial --Added new Cash Flow Projection component for commercial files. This new component allows for monthly or annual projections, and can be for a few months or multiple years. This replaces the previous Annual Plan component. Those legacy projections are available under the File Settings section of Tools + Options. Financial Analysis (FINAN) --Added new Market Channel enterprise analysis. This analysis allows you to examine the returns of different marketing channels such as farmers markets, wholesale, etc. --Added a new Field ID description field to the crop enterprise input. This field is specifically for tracking cover crop fields over time and the entry should not change. --Cash Flow check button has been renamed and made more powerful. There are now two tabs on the pop up form. One for the Cash Flow check and another that shows Crop & Feed check information. Presentations --Added an auto-save feature that automatically saves the presentation every 10 minutes. This setting can be changed from the menu under Tools + Options on the General page. --Changed how the cursor behaves after saving a presentation. It used to reset to the top of the presentation. Now it stays in the same place. __________________________________________________________ Changes / Fixes to FINPACK release 6.3.0, dated 10/7/2022 Tax Forms --Moved "Interest on current debt" field from the "Cash Flow for Debt Service" section to the "Debt Information" section. This is used to calculate total debt payments. --(Sch F) Add “Total debt coverage ratio (cash basis)” calculated field. This field represents the new debt coverage ratio calculation approach where debt payments include all interest rather than interest on term debt. The previous calculated field “Term debt coverage ratio (cash basis)” is still included for consistency. --(Other than Sch F) Changed calculation of "Debt coverage ratio" to include all interest rather than interest on term debt. Schedule F Cash to Accrual Analysis --Revised the Financial Standards Measures based on the 2022 Financial Guidelines for Agriculture from the Farm Financial Standards Council. Added two new ratios -- working capital to operating expense and debt coverage ratio. --In the Repayment Capacity section, the two columns are Total Debt and Term Debt. The Total Debt column shows the new debt coverage ratio which includes interest on all debt and the Term Debt column shows the previous term debt coverage ratio which includes interest on term debt (includes personal debt if available). Financial Analysis (FINAN) --Revised the Financial Standards Measures based on the 2022 Financial Guidelines for Agriculture from the Farm Financial Standards Council. Added two new ratios -- working capital to operating expense and debt coverage ratio. --In the Repayment Capacity section, the two columns are Total Debt and Term Debt. The Total Debt column shows the new debt coverage ratio which includes interest on all debt and the Term Debt column shows the previous term debt coverage ratio which includes interest on term debt (includes personal debt if available). Global Cash Flow Analysis --Updated data entry for Primary Business Cash Flow to make it more apparent that using a beginning balance sheet for debt payments is optional. Cash Flow Projection (FINFLO) --Revised the Financial Standards Measures based on the 2022 Financial Guidelines for Agriculture from the Farm Financial Standards Council. Added two new ratios -- working capital to operating expense and debt coverage ratio. --In the Debt Coverage section, the two columns are Total Debt and Term Debt. The Total Debt column shows the new debt coverage ratio which includes interest on all debt and the Term Debt column shows the previous term debt coverage ratio which includes interest on term debt (includes personal debt if available). Long Range Planning (FINLRB) --Revised the Financial Standards Measures based on the 2022 Financial Guidelines for Agriculture from the Farm Financial Standards Council. Added two new ratios -- working capital to operating expense and debt coverage ratio. C & I Business Analysis (commercial) --The interest expense stored for the Portfolio Risk Analyst was not correct in the case of an accrual income statement or tax form. Detailed Balance Sheet (collateral analysis) --Updated titles for loan to discounted value and discounted collateral coverage margin. Credit Decision Scorecard --Added a risk rating report as a possible data source, uses the risk rating score value. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.10, dated 5/17/2022 FINPACK+ --Adjusted internal data for use in Portfolio Risk Analyst. --Include "Account type" as a column selection in a deposits / accounts table in a presentation (using core interface data). __________________________________________________________ Changes / Fixes to FINPACK release 6.2.9, dated 4/13/2022 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2021 data from FINBIN (Minnesota). FSA Forms --Updated forms 2211 to March 2022 version. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.8, dated 3/14/2022 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2020 data from FINBIN (Nebraska). __________________________________________________________ Changes / Fixes to FINPACK release 6.2.7, dated 3/10/2022 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2020 data from FINBIN (Michigan, Ohio, Pennsylvania, South Dakota, Wisconsin). Tax Forms --Updated 1040 with new line numbers for the 2021 format. Any historic 1040 data is transferred to the new format, mainly reordering and renumbering lines. FINAN / Sch. F Analysis Trend Reports --Fixed issue with fields marked as "Grown After Cover Crop" that were combined with a field marked as "Cover Crop" being counted twice for reporting. Risk Rating --Corrected the average calculation for the term debt coverage ratio from a Sch F tax form, now it is the average over the selected years rather than a simple average of the ratio from the selected years. --Added "Current + Intermediate ratio" as a variable from the balance sheet. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.6, dated 2/14/2022 Financial Analysis (FINAN) --Fixed issue with graphs where commercial ratios were being displayed in the results. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.5, dated 2/2/2022 FINPACK+ --Fixed issue printing a risk rating model (under Tools + Options) Detailed Balance Sheets (Import) --Fixed issue changing loan term in the Import data and still having it imported into the original section. Cash Flow Projection (FINFLO) --Fixed issue with refinancing a personal loan, the principal payments on personal debt were not correct. This impacted the farm term debt coverage calculation. Annual Plan (commercial) --Fixed issue with refinancing a personal loan, the "business and personal" term debt coverage calculations were not correct. Also, in the business column, the term debt coverage calculation was correct but the refinanced personal principal was shown in the wrong category. This did not impact the business term debt coverage calculation, however. Financial Analysis (FINAN) --Enterprise analysis no longer checks for missing cash rent on Double Crop enterprises. --Auto combined Double Crop enterprises that are tagged as a Cover Crop calculate an average, no longer all zeros. Presentations --Fixed error "Bookmark with that name already exists" --Fixed issue with blacked-out text in presentations converted from 6.1 --Fixed issue with loan amounts > 999,999 being excluded from totals. --Added Reset from Template functionality for FINPACK+ tables. --Added "Fix blacked-out text" button in Tools|Options presentation viewer. --Fixed issue with totals in loans tables wrapping to the next line. --Added error message for blank column header in presentation loans table templates. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.4, dated 12/17/2021 Presentations --Added ability to select loan and account data from FINPACK+ into a pre-defined table in a presentation. --Fixed issue with opening Presentations editor in a read-only file. --Fixed "Argument out of range" error for data tables defined with ratios from another file type (ag or commercial). --Fixed issue with some paragraphs being blacked out. --Fixed issue where pagination on screen did not match printout or output to PDF. Accounting Interface - Quicken --Fixed the issue that was not letting you save the results. Tools + Options --Added presentation viewer under File Settings to help with troubleshooting. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.3, dated 11/22/2021 General --Updated benchmark setup for Iowa, Minnesota, and Nebraska. Presentation Template --Fixed issue with initializing spell-check dictionary when editing a template. Presentations --Fixed issue with placement of trend reports that have an Average column. --Fixed issue with trend report captions not being removed after user deletes them in the data entry form. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.2, dated 11/9/2021 Detailed Balance Sheets --Adjusted the interface used to import balance sheet data from PcMars Farm Accounting Software. User can no longer edit the loan description on loans that are flagged as . Cash Flow Projection (FINFLO) --Added crop sales detail to the output for an annual projection with detailed output. Financial Analysis (FINAN) --Crop Enterprise detail for Other Income items (except Hedging) can now be selected from the detail already entered in the Whole Farm sections. Presentations --Fixed issue with the toolbar not updating correctly to match the current cursor position in the main document (bold, italics, justification, etc). __________________________________________________________ Changes / Fixes to FINPACK release 6.2.1, dated 11/1/2021 Detailed Balance Sheets --Added columns for Year Purchased, Purchase Price, Year Sold, and Sales Price in detail for all personal assets. 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. --Fixed issue when deleting all entries in detail that would sometimes display message "Could not convert variant of type (null) into type (double)" Balance Sheet Trend Reports --Fixed issue with "" report variables where certain descriptions were generating errors when running the report. --Fixed issue with "" report variables where having both cost and market variables in one report would not display the detail lists for both. Cash Flow Projection (FINFLO) --In crop sales detail, added "Select from Balance Sheet" icon to the toolbar to allow selecting crop beginning inventory from the balance sheet for sales. --Added "Accounts payable" in the expense list when using the Schedule F chart of accounts so paying down beginning accounts payable can be shown in the projection. --In accounts payable detail, added "Select from Balance Sheet" icon to the toolbar to allow selecting detail from accounts payable on the beginning balance sheet. --In other farm income detail, added "Select from Balance Sheet" icon to the toolbar to allow selecting detail from accounts receivables on the beginning balance sheet. --Fixed calculation issue with breeding livestock enterprises with transfers out that were not displayed in the production summary. This impacted annual projections and monthly projections without enterprise budgets. C & I Business Analysis (commercial) --Updated RMA data for 2021-22. Presentations --Added ability to embed a balance sheet, farm analysis, or C & I analysis trend report into the body of a presentation. This is a new section defined in the presentation template area under Tools + Options. --Added ability to print a presentation to a *.docx file (Microsoft Word). This is available in the print dialog of a presentation. __________________________________________________________ Changes / Fixes to FINPACK release 6.2.0, dated 9/16/2021 Presentations --Implemented new text editor component for the presentation. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.12, dated 8/26/2021 General --After a trend report is exported to a CSV file, launch the Windows CSV file viewer (typically Microsoft Excel). Balance Sheet Trend Reports --Fixed issued where accrued interest was sometimes not being displayed in a report. Livestock Budgets --If the generic "Hay" crop is used in the file, use that as the default hay feed fed in a livestock budget rather than "Hay, Alfalfa". __________________________________________________________ Changes / Fixes to FINPACK release 6.1.11, dated 7/23/2021 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2020 data from FINBIN (North Dakota, Missouri, Utah). --Updated FINAN / Sch. F Analysis scorecard graphs with 2019 data from FINBIN (Ohio). C & I Business Analysis (commercial) --Fixed issue in UCA operating expense calculation that was including other miscellaneous expenses in certain situations. This impacted cash discrepancy when these expenses were being double counted in the UCA calculations. --Fixed issue in UCA miscellaneous income calculation that was not including up to four income values specifically from the 1120-S, 1120, and 1065 tax forms. These values included ordinary income from other partnerships (1065), net farm profit or loss (1065), net 4797 gain or loss (1065, 1120 and 1120-S), and capital gain net income (1120). This impacted cash discrepancy. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.10, dated 6/17/2021 Detailed Balance Sheets --When working with a consolidated balance sheet, fixed issue where inserting a line in various data entry screens would cause the program to freeze or lock-up. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.9, dated 6/7/2021 FINPACK+ --Fixed issue with PDF output file names with special characters that would cause an issue when downloading the results. General --Corrected issue with expense setup that might lead to conflicts with user-added expenses. FSA Forms --Updated forms 2211 to April 2021 version. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.8, dated 3/25/2021 FINPACK+ --Consolidating detailed balance sheets or tax forms, allow for the selection of the current file as a source file. Previously only related files could be selected. General --Updated FINAN / Sch. F Analysis scorecard graphs with 2020 data from FINBIN (Minnesota). Detailed Balance Sheets --When working with a consolidated balance sheet, add blank lines in various detail data entry so that items can be added at the end of the list for each contributing balance sheet. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.7, dated 2/12/2021 FINPACK+ --Added "Other business entity" to Business Type list to map user-added entities from FINPACK+. General --Added FINAN / Sch. F Analysis scorecard graph data for Michigan and Pennsylvania. --Updated benchmark setup for Idaho. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.6, dated 2/1/2021 Detailed Balance Sheets --Fixed issue in asset detail with showing / hiding sold assets that could lead to the application freezing when trying to insert a new item in the middle of the list. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.5, dated 1/14/2021 General --Updated benchmark setup for Pennsylvania and South Carolina. Financial Analysis (FINAN) --Messages about unknown direct enterprise expenses found during enterprise importing from PC Mars are no longer being shown. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.4, dated 1/4/2021 FINPACK+ --Fixed issue consolidating balance sheets. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.3, dated 12/21/2020 FINPACK+ --Fixed issue where printing a balance sheet or other trend report in a web browser resulted in an error. --Fixed issue opening a file from the user's working folder that was not checked out (either a previous version of the file or an uploaded file). --Fixed issue opening and closing files from the working folder that would sometimes result in an error. Cash Flow Projection (FINFLO) --Added check for financial trend report that would sometimes result in an error when trying to preview or print output. Financial Analysis (FINAN) --Added check for balance sheet trend and financial trend reports that would sometimes result in an error when trying to preview or print output. --The new PC Mars import caused an error reading Version 1.0 FIF files. That has been fixed. Presentations --Fixed issue in presentation templates where selecting Earned Net Worth Analysis as an optional attachment resulted in an error. Accounting Interface --Fixed Quicken and Quickbooks interface so that it no longer creates the resulting FIF file with a double file extension. i.e. MyData.FIF.FIF __________________________________________________________ Changes / Fixes to FINPACK release 6.1.2, dated 11/20/2020 FINPACK+ --Fixed issue where deleting an item in the file, such as a balance sheet, also archives the corresponding Credit Analysis document when the file is checked in. General --Updated benchmark setup for Texas and Oklahoma. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.1, dated 11/1/2020 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2019 data from FINBIN (Missouri, Nebraska, North Dakota, Ohio, South Dakota, Utah, Wisconsin). Detailed Balance Sheets --Added ability to import balance sheet data from PcMars Farm Accounting Software. C & I Business Analysis (commercial) --Updated RMA data for 2020-21. Financial Analysis (FINAN) --Added ability to import crop and livestock enterprise data from PcMars PLUS Farm Accounting Software. FSA Forms --Updated forms 2211 September 2020 version. Form 2212 is no longer used. __________________________________________________________ Changes / Fixes to FINPACK release 6.1.0, dated 9/15/2020 General --Integration with FINPACK Plus. Earned Net Worth Analysis --Print just one page of the most recent years for the first page report if no specific years are selected. Cash Flow Projection (FINFLO) --Changed entry of prices for livestock enterprises so they do not auto-fill for the remaining months. Only impacts monthly data entry. Long Range Planning (FINLRB) --Fixed calculation issue where all subtotals on output were sometimes reset to zero when previewing output multiple times. Presentations --Added Earned Net Worth Analysis as a data source and optional attachment for commercial files. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.9, dated 5/7/2020 General --Fixed issue introduced in 6.0.7 related to importing parts of another file. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.8, dated 4/23/2020 General --Updated benchmarking setup for Idaho. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.7, dated 4/2/2020 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2019 data from FINBIN (Minnesota). --Fixed issue when importing a tax form from a commercial file to an agriculture file (or vice-versa). Import worked, but left internal settings set to the file type of the imported file. Tax Forms --Updated Schedule F calculation for other nontaxable income so that it no longer includes the difference between 3a and 3b (cooperative distributions). This change was made because of how grain sales from cooperatives are commonly reported and should not be in the other nontaxable income calculation. Cash Flow Projection (FINFLO) --Fixed issue in monthly projection (no budgets), miscellaneous income detail in a livestock plan would display a warning message when entering detail with multiple lines. --Fixed issue previewing / printing when some options were selected that were not available, such as FSA Interest Assistance. This mainly occurred when the projection was an attachment to a presentation. --Fixed issue with monthly projection, family living detail allowed for adding records to the fixed-list of items. Tools + Options --Fixed issue setting default output options for Long Range Planning (FINLRB). __________________________________________________________ Changes / Fixes to FINPACK release 6.0.6, dated 1/27/2020 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2018 data from FINBIN (Missouri, Nebraska, North Dakota, Ohio, South Dakota, Utah, Wisconsin). Cash Flow Projection (FINFLO) --Fixed issue with custom hire detail from a livestock budget was not displayed when previewing output with detail. This did not impact the calculations or results, just the display of the detail values. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.5, dated 1/7/2020 General --Updated benchmarking setup for Colorado, Idaho, and Michigan. Financial Analysis (FINAN) --Minor updates for order of various government payments in Other Farm Income and special sort list. --Turned off output of Energy Corrected Milk. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.4, dated 1/6/2020 General --Updated benchmarking setup for Minnesota State - Northland. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.3, dated 12/2/2019 FSA Forms --Fixed issue with duplicate entry error when trying to save any form. Also, made the Direct Loan forms available in the professional and producer versions. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.2, dated 11/8/2019 General --Updates to benchmark setup for North Dakota. Cash Flow Projection (FINFLO) --Fixed issue where three- and five-year averages for expenses were not calculating when using a tax form as the source of historical data. Annual Plan (commercial) --Fixed issue where three- and five-year averages for expenses were not calculating when using a tax form as the source of historical data. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.1, dated 11/1/2019 C & I Business Analysis (commercial) --Updated RMA data for 2019-20. --Added Statement of Equity report. Cash Flow Projection (FINFLO) --Fixed issue in finishing livestock data entry in a monthly plan where the total column was sometimes editable for certain rows that should not be editable. This did not impact calculations or results since that total is for display only. --Fixed issue with Sch F expenses where the Income Statement trend report was not displaying any expenses for the projection. __________________________________________________________ Changes / Fixes to FINPACK release 6.0.0, dated 9/23/2019 General --Added Pima Cotton to the crop list. --Added Finishing Goats to the livestock list. --Changed "Year Sold" title to "Year Sold or Traded" everywhere it is used. Tax Forms / Income Statement --Add "Period End Date" and "Months in Period" fields to better describe partial years, for example quarterly reports. Also, cash debt coverage ratios are adjusted for less than annual periods. Long Range Planning (FINLRB) --Fixed issue in calculations where livestock death loss was not being reflected in income. Issue started in 5.9.0 release with introduciton of new style budgets. Cash Flow Projection (FINFLO) --Fixed issue with multi-year plans where the cull income and miscellaneous income detail for a breeding livestock plan did not copy to the next year. This was only the case for a monthly plan without budgets. --Fixed issue with entering loan P & I payment detail for a loan refinance in an annual plan type. Entries made in detail were not being brought back to the main screen. --Fixed issue in breeding livestock data entry in a monthly plan using budgets, editing the first month's beginning inventory did not automatically recalculate the following inventory. --Added "Working capital burn rate (years)" and "Net worth burn rate (years)" to the Executive Summary. These are displayed when there is a negative change in working capital or a negative change in earned net worth, respectively. Financial Analysis (FINAN) --In the case of market-only balance sheets with a change in land value, added a separate "Change in land valuation" line in the Statement of Owner's Equity to remove that change from the discrepancy. --Changed headings in Crop Enterprise production detail. --When switching from output to input and back to output the Scorecard graphs were not always displaying the correct graphs. This has been resolved. --Combined crops in the enterprise analysis where one of the crops is a Double Crop only divides by the acres of the normal crop. For example: Winter Wheat combined with Double Crop soybeans only divides by the wheat acres. --Added items in the Dairy "Other Information" area to calculate Energy Corrected Milk and Cows per Milker Unit. --Fixed Historic Trend reports so individual personal income items now appear in the report. --Revised the calculation of the Crop Enterprise Analysis cost of production to exclude Hedging and LDP income from the other income add-backs. C & I Business Analysis (commercial) --Added ability for partial-year analysis (monthly, quarterly, etc). Some measures are adjusted to allow for consistent comparison. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.6, dated 6/17/2019 Detailed Balance Sheet (agriculture or commercial) --Added feature to export / import detail for intermediate and long term (noncurrent) assets. --Fixed issue where sold assets for other intermediate assets / other noncurrent assets were listed in the input worksheet. Cash Flow Projection (FINFLO) --Fixed issue with multi-year plans where the one-year Executive Summary was always the last year of the plan regardless of which year was selected in the report options. --Added Input Worksheet format for new projection types (annual, monthly, monthly with budgets). --Include livestock plan description in Inventory Summary output section. --Fixed issue where updated livestock inventory value from the beginning balance sheet was not transferring into data entry. This was a display issue and did not impact calculations or results. --Added Financial Scorecard to the output. --"Accounts payable" is now active in the expense list for all plan types. This is so pay-downs of large beginning accounts payable can be better documented in the plan. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.5, dated 5/14/2019 Cash Flow Projection (FINFLO) --Fixed issue with user-added expense and income accounts where those accounts were not being saved with the file and would not display the item description when the account was not in the user's program setup. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.4, dated 3/25/2019 General --Updated FINAN / Sch. F Analysis scorecard graphs with 2018 data from FINBIN (Minnesota). Tax Forms --Updated 1040 with new line numbers for the 2018 format. Any historic 1040 data is transferred to the new format, mainly reordering and renumbering lines. --Updated Schedule F calculation for other nontaxable income to exclude crop insurance deferred from a previous year in the calculation of cash flow for debt service in the current year. Issue is this crop insurance payment was already included in a previous year cash flow for debt service. Earned Net Worth Analysis / Schedule F Cash to Accrual Analysis --Using market-only balance sheets, depreciation does not apply for breeding livestock, other intermediate assets, and other long term assets. Any change in value for those asset categories is reflected as inventory change. In this case, any depreciation percent entered caused the calculation for change in earned net worth to be incorrect. This did not impact the term debt coverage ratio. Any depreciation percent for these asset categories was cleared and the data entry is protected. Risk Rating --Fixed issue calculating results when the particular Schedule F tax form had been deselected. Presentations --Fixed issue inserting a row in the Loan Request Table then pressing tab to move to a new column resulted in a range check error. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.3, dated 2/7/2019 Crop and Livestock Budgets --Fixed issue previewing output including historic trend data. --Fixed issue after using the generic Hay crop in livestock budgets that resulted in an error "Linkfields to detail must be unique." --Fixed issue with historic data coming from FINAN, now it only uses data from full-year analyses, no partial years. --Fixed issue with historic purchased feed data coming from FINAN for a livestock enterprise. It was reporting the quantity of purchased feed rather than the expense amount. Cash Flow Projection (FINFLO) --Fixed issue with Direct Livestock Expenses where some of the livestock budgets expenses were not displaying in data entry. --Fixed issue with Related Operating Expenses where the description for new expenses was not displaying in data entry. --Fixed issue with Direct Livestock Expenses where totals were not being cleared when an expense in the budget was changed to zero. --Added warning in annual projection when a crop has a negative ending inventory from feeding. --Fixed issue in annual projection using Schedule F expense list, detail cash outflows was not printing correctly (detail items were all at the end of the report and not under their respective expense category). --Fixed issue with historic data coming from FINAN, now it only uses data from full-year analyses, no partial years. Long Range Planning (FINLRB) --Fixed issue when trying to delete an alternative after viewing the discrepancy detail for an alternative. The error message reported a read-only dataset. Financial Analysis (FINAN) --Changed several data entry forms where the Notes button was inadvertently disabled. --Fixed crop yield calculation issue in enterprise analysis with share rental percentages. The calculations were using the share rental percent entered in the whole farm area of the analysis rather than the percent entered in the enterprise analysis area. --Corrected the variable displayed on the Comparative Trend reports for Debt to Asset ratio. The reports were displaying Net Worth Change rather than the Debt to Asset ratio. --Fixed occassional issue with preview resulting in a divide by zero error. Issue was in generating the comparative balance sheet trend. Detailed Balance Sheet (collateral analysis) --Fixed issue where multiple entries in crop inventory of the same crop, description, and quantity were only appearing once in the collateral analysis detail. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.2, dated 12/21/2018 General --Corrected an issue in the update installation where a custom user logo was being overwritten. Detailed Balance Sheet (commercial) --Fixed issue consolidating balance sheets with equity stock. Cash Flow Projection (FINFLO) --Fixed issue with monthly projection (without budgets) where a warning was not generated when feeding a crop resulted in negative inventory. Financial Analysis (FINAN) --Widened some detail forms in the area of capital purchases and sales. FSA Forms --Updated forms 2211 and 2212 to the November 2018 versions. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.1, dated 11/1/2018 Detailed Balance Sheet --Fixed issue printing detail schedules where equity detail would sometimes print over the top of a loan schedule, depending on what schedules were in the output. Cash Flow Projection (FINFLO) --When switching from the standard FINPACK expense list to a Schedule F expense list in an annual or monthly plan type, the existing historic information in the Other Cash Flows section did not immediately clear. Financial Analysis (FINAN) --Replaced the debt to asset ratio in the comparative trend report to the ratio that includes personal assets and personal liabilities. C & I Business Analysis (commercial) --Updated RMA data for 2018-19. --Added Cash Drivers reports. --Added detail ratio report for the most recent year. --Added detail expense list in the income statement reports. --Schedule E and Form 8825 are not used in this type of analysis. Those forms should be used with the Commercial Real Estate (CRE) Analysis. __________________________________________________________ Changes / Fixes to FINPACK release 5.10.0, dated 10/1/2018 General --Made the Earned Net Worth Analysis available in commercial files. --Corrected issue with software registration where using an external hard drive would sometimes invalidate a previous registration. --Split the Tax Forms / Income Statement section of the file navigation dialog into two separate sections. All existing data is still available, this just makes the generic income statement more prominent for new users. Detailed Balance Sheet --Relaxed the rule check in crops held for sale so it no longer requires a unique description for multiple entries of the same crop and quantity. --Added columns for Year Purchased, Purchase Price, Year Sold, and Sales Price in detail for Breeding Livestock, Other Intermediate and Other Longterm Assets. 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. --Corrected issue consolidating balance sheets where some noncurrent asset accounts would be duplicated. Only happened when starting in a commercial balance sheet then consolidating an agriculture balance sheet. --In detail for Cash Value of Life Insurance, added fields for Person Insured and Beneficiary. --In Collateral Analysis, changed terminology of Discount Rate to Advance Rate. Detailed Balance Sheet (commercial) --In the Equity section, added entries for preferred stock, common stock, and other stock. --Renamed several asset accounts to be more consistent with the C & I Analysis. --Added Other Noncurrent Liabilities as a data entry item. Crop and Livestock Budgets --Corrected issue importing budgets from another file, they were always imported as legacy budgets regardless of the actual setting. --When attempting to delete a crop from the Feed Fed list, display an information message that the default crops cannot be deleted. Cash Flow Projection (FINFLO) --Corrected issue in a new projection where the crop inventory section did not populate all the crops from the beginning balance sheet. --Corrected issue on Financial Trend report where some of the solvency measures did not exclude deferred liabilities. --Added a form to edit number of months covered by the budget for a breeding livestock enterprise in a new monthly projection. This was removed when converting from the legacy projection. --In monthly plan using budgets, changed the direct crop expense detail entry "Beg. Month for Next Year Acres" to be "Last Month for Current Year Acres." This change was made so expenses for the current year could be made in the last month of the projection. --Fixed issue in capital sales data entry where the balance sheet value was not being updated when first entering a capital sale. The first time a sale is entered the balance sheet value should default to the sales price. Financial Analysis (FINAN) --Modifed the calculations in the area of Repayment Capacity to more accurately reflect coverage ratios and margins for a partial year analysis. --Interest on term debt in the Personal and Farm column of the Repayment Capacity section of the Financial Statements and Measures output was including current nonfarm principal and has been fixed. C & I Business Analysis (commercial) --Added trend reports for C & I Business Analysis. --Expanded the output with an Executive Summary trend report. Risk Rating --Corrected issue using averages from a Commercial Real Estate Analysis as a new property without income history. Vault --Allow users to see their archived files when there are no other files currently on their computer. __________________________________________________________ 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. Risk Rating --Corrected issue referring to variables from a Commercial Real Estate Analysis when one did not exist for the file. __________________________________________________________ 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. Detailed Balance Sheet --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 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 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 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 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 800x600 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.