(800) 234-1111

FINPACK News

How to Use Portfolio Risk Analyst (PRA)

by David Maguire | May 5, 2022

Each borrower, be they Ag or Commercial, has their own unique business risks. You also need to know how your entire loan portfolio is positioned to face the volatility of today’s business environment.

PRA (Portfolio Risk Analyst) creates a database of your Ag or Commercial borrowers and generates reports that help you see where the stress points are if market conditions change. You can base stress tests on either past or projected financial performance, analyze the financial position and performance of portfolio segments with clear, concise reports, and identify borrowers who contribute most to portfolio risk. In addition, you can provide customers with benchmarks of their financial performance, building customer loyalty in the process.

How does it work?

For your ag portfolio, aggregate and stress test either past performance or projection data on your farm customers. For past performance analysis, choose between FINPACK Financial Analysis (FINAN) or Schedule F Cash to Accrual data. Then use the Shock Selection tab to choose what % changes in your gross income, operating expenses, interest rates, or assets you’d like to stress test. Apply whichever client criteria suits your analysis — Farm Type, Gross Income, Profitability, Total Assets, or D to A Ratio — and FINPACK’s PRA tool will generate the stress report, which you can then output as a PDF. For forward-looking analysis, either monthly or annual types of FINPACK Projections can be analyzed by PRA.

For your commercial portfolio, PRA stress tests FINPACK’s C & I Business Analysis data. Choose to shock Net Sales, COGS, Operating Expenses, Interest Rates, or Current and Noncurrent Assets, set the % change you want to investigate, then select your client criteria. PRA creates a database of this FINPACK information on your borrowers and then generates reports to help you see where stress points lie, should market conditions change.

PRA Commercial Stress Test report [sample]

Benchmarking Customers

You can also use PRA to prepare benchmark reports on your ag customers, using your customer group to identify the financial strengths and weaknesses of your individual borrowers. The benchmark reports can be pared down by farm type, size of farm, profitability level, and solvency position. Here the performance of an individual farm is rated against their peer group from your bank’s portfolio.

PRA Benchmark report sample.

Summary

Use the PRA tool to get a better sense of how your entire portfolio — both Ag and Commercial — is positioned to face the volatility of today’s business environment, and build customer loyalty by providing them benchmarks of their financial performance. The Portfolio Risk Analyst (PRA) tool is included in the FINPACK system-wide license at no additional cost, and will soon be accessible right inside the FINPACK+ environment. Contact us today to learn more about the benefits of using PRA to evaluate your portfolio.

David Maguire became the FINPACK Relationship Manager in 2021. He helps Ag and Commercial lenders across the country understand the value of using FINPACK for credit analysis and loan management. David has worked in the marketing, training and education fields in Minnesota, Ireland and Germany.

Latest News
FINPACK News March Digest

FINPACK News March Digest

FINPACK FAQs, Registration for FINPACK Lender Training, Consolidating Data Sources in FINPACK+, How to Import Data into FINPACK+ Credit Analysis Files, Unlocking Business Secrets wtih UCA Cash Flows and more!

Unlocking Business Secrets with UCA Cash Flows

Unlocking Business Secrets with UCA Cash Flows

In the commercial lending world, the uniform credit analysis (UCA) cash flow is a powerful tool allowing lenders to accurately determine sources and uses of cash for a business and determine the ability of a business to repay a loan. In this article, we will discuss UCA cash flows in FINPACK, how to use the UCA cash flow, and how to sleuth for discrepancies in the UCA cash flow.

How To Learn FINPACK

How To Learn FINPACK

FINPACK offers multiple training resources, including in-person, online and customized training options. FINPACK Lender Training Workshops offer two days of intensive, interactive training in-person on the University of Minnesota, St. Paul campus. Covering all the...

How to Import Data into FINPACK+ Credit Analysis Files

How to Import Data into FINPACK+ Credit Analysis Files

New data, from an external FINPACK Credit Analysis file can be imported into your institution’s
FINPACK+ Credit Analysis file for a customer. This feature allows you to add information, like
a balance sheet or cash flow projection, into an existing Credit Analysis file without overwriting the
remaining contents of the file.

Consolidating Data Sources in FINPACK+

Consolidating Data Sources in FINPACK+

FINPACK Credit Analysis allows users to consolidate the balance sheets or tax forms from several different data files into a consolidated file. For example, a farm or business may have multiple entities for tax reasons, but these entities are controlled by the same...