(800) 234-1111

FINPACK News

How to Use Portfolio Risk Analyst (PRA)

by | 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.

Latest News
FINPACK Digest – May 2022

FINPACK Digest – May 2022

1. Cover Crop Financial Data Profitability The Environmental Defense Fund (EDF) collaborated with the Center for Farm Financial Management (CFFM) to integrate a new data gathering process into FINBIN — the largest publicly-available farm financial database...

How To Use Tasks To Speed Up Credit Decisions

How To Use Tasks To Speed Up Credit Decisions

Speeding up the credit decision process is vital. While striving to be as methodical and rigorous as possible in their evaluation of every loan request received, lenders need to get to a decision in as timely a fashion as possible. Using a coherent 'tickler' or task...

Using Core Data in FINPACK+

Using Core Data in FINPACK+

https://vimeo.com/705769854/86a95ea1be Wynn Richardson gives an overview of how the FINPACK+ API can connect your core system with FINPACK+. Learn how to import customer, account and loan data from your core system into FINPACK+ to use in a FINPACK credit analysis....

FINPACK Digest: April 2022

FINPACK Digest: April 2022

From April: FINPACK Credit Analysis Tools for commercial customers, an overview of Global Cash Flow Analysis, celebrating ICBA Community Bank Month, and training workshops update. 1. FINPACK Credit Analysis Tools for Commercial Customers FINPACK offers credit analysis...

How to use Global Cash Flow Analysis

How to use Global Cash Flow Analysis

Global Cash Flow Analysis is a widely used financial analysis tool to evaluate more complex borrowers. The Global Cash Flow Analysis tool included in both the Ag and Commercial versions of FINPACK calculates a global debt coverage ratio when commingling the...