Using the UCA Cash Flow for Commercial Analysis

UCA Cash FlowAnalyzing a commercial credit can be challenging. Figuring out how a business is doing when you don’t have a good comparison or even figuring out if the core of the business is providing for the other pieces can make it difficult for you to understand how to analyze the business or structure the loan. Fortunately, FINPACK includes a report in the C & I Business Analysis tool that can be used to help you identify where the cash is being used in the business.

The Uniform Credit Analysis, or UCA Cash Flow, is designed to help you identify where the business’s cash is going and how it is being used. Is it being used to purchase additional inventory or is it being used to purchase equipment? [Read more…]

Which Commercial Analysis Tool is Right?

Which Commercial Analysis Tool is Right?When analyzing a commercial customer in FINPACK there are several tools available.  Deciding which tool best fits the analysis needed is important to get the optimal information, in order to reduce risk in the customer credit decision.  The type of business and customer information available will drive the commercial analysis tool used. [Read more…]

Spreadsheets vs. Software

Spreadsheets vs Software in Credit AnalysisAre you still using spreadsheets to complete the annual credit analysis on your customers?  Do your spreadsheets provide you the best information on a customer’s financial position?  Have your spreadsheets left you with questions related to your bank’s true risk?  If so, FINPACK Credit Analysis Solutions software is the tool you’ve been looking for! [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…]

The Value of a Cost Balance Sheet

Cost balance sheets value assets at purchase price less accumulated depreciation.  This accumulated depreciation can be done using tax or management depreciation methods. Management depreciation differs from tax depreciation by using the economic or useful life of the asset for depreciation calculations.

Using cost balance sheets allow lenders to better monitor the financial performance of the business over time.  With cost balance sheets, net worth growth comes from business retained earnings.  Cost value balance sheets do not have market valuation changes affecting the net worth of the business.  Hence true business performance is measured by the cost balance sheet.

[Read more…]