Projections Training

FINPACK Online Training

We want all users to have a positive experience using the FINPACK tools.  Therefore, several training options are available to assist with learning the ropes of the new FINPACK Projection tool.

One of the training options for FINPACK is online training.  Each FINPACK tool has a learning module in FINPACK Online Training.  As you migrate to the 3-in-1 cash flow projection (FINFLO), know training is available and accessible for your use. These training modules have been updated to specifically address using the FINPACK Projections tool (FINFLO).

[Read more…]

Converting Legacy Projections

The Legacy Projection tools in FINPACK will be retired at the end of 2019. This includes the Annual Cash Flow Plan and the Monthly Cash Flow Plan. As you work on renewals in 2019, the FINPACK Team suggests you test out the new Cash Flow Projection tool found in Projections. Yes, there are a few changes to cash flow projections in the new tool, but by and large, we think you will appreciate many of the updates.    

[Read more…]

The Credit Renewal Process

The Credit Renewal Process - FINPACK‘Tis the season for credit renewals.  FINPACK has several tools to assist lenders with this process, from spreading, to financial analysis, projection preparation, and pulling the pieces of the credit analysis together.

In general, within FINPACK, the recommendation is to work down the left side file navigation to complete the credit renewal and analysis process.  Start with data sources, move to financial analysis, complete cash flow projections, and then pull everything together with the credit analysis tools.  With that being said, here is a bit more background on these tools and how they aid the credit renewal process. [Read more…]

Cash Flow Planning Tools

Cash Flow Planning ToolsPutting together cash flow projections for farm clients can be tedious at times.  What is a reasonable feed expense for dairy operations?  Is the projected cost of production on corn acres in line with peers?  These are a few of the questions lenders and other professionals may ask when putting together projections, especially for new customers.  With that in mind, The Center for Farm Financial Management has put together two different cash flow planning tools.  The Minnesota Price and Cost Summary and the FINPACK Livestock Budget Estimates are two aides FINPACK users may find useful in cash flow planning.  These items and more are found in the FINPACK Knowledge Base.

[Read more…]

Mid-Year Monitoring

Cash Flow Monitoring WorksheetSomehow, we are already halfway through the year.  Periodic monitoring of projections that worked earlier this year may prevent surprises or problems later.  Now is a great time to use the cash flow monitoring worksheet to review how the monthly cash flow projection you completed compares to what has actually happened.  This tool is available for both of the monthly projection versions, with or without budgets.  Generating the cash flow monitoring worksheet is done in the cash flow plan that you wish to monitor.  Using this feature allows for timely monitoring of customer progress during the year.  And, if needed, adjustments to the cash flow plan can be made based on the actual data received.   [Read more…]

How to Use the FINPACK Loan Calculator

How to use FINPACK Loan CalculatorThe FINPACK Loan Calculator is a useful tool as you enter or edit loan payment information into a Balance Sheet, Cash Flow Projection, Long Range Plan, or Financial Analysis in FINPACK.  The loan payment details from the Loan Calculator can be pasted into data entry, or it can also be used as a freestanding tool to brainstorm possible loan payment options.  When using the calculator in freestanding mode, the information cannot be pasted into FINPACK.  Here the only option is to View Payment Schedule and print or export the schedule.

There are two types of repayment options in the FINPACK Loan Calculator – amortized payments or fixed-principal payments.  The type of loan being modeled will dictate the specific calculator chosen.  [Read more…]

Longevity of Legacy Cash Flow Plans

Longevity of Legacy Cash Flow PlansThe option to create an annual plan or monthly cash flow plan using the Legacy Projection tools in FINPACK will remain for the next year (or two).  No official sunset date has been set at this time.  If you are a seasoned user that is very comfortable with the Legacy Projection tools, feel free to continue using them for this renewal season.    [Read more…]

Cash Flow Projections – Which Projection Tool?

FINPACK - Which Projection Tool Should I Choose?FINPACK now offers 3 types of cash flow projections:  Annual Plan, Monthly Plan, and Monthly Plan with Budgets.  All three tools provide pro forma statements; debt coverage and other ratios; and the ability to complete multi-year plans.  Choosing the projection tool to use depends on the situation.  

[Read more…]