Loan Category Analysis
Explains how to use Bravo's Loan Category Analysis report to track loan performance across different item categories.
The Loan Category Analysis will show the loan base, payments, forfeitures, reactivations and confiscations within and paid service charges broken down by category.
This report can be found under Loan Reports as well as All Reports.
Clicking on Loan Category Analysis will bring up a window with configuration options at the top.
Select the store that you wish to view. To see loans from all stores within your company, select [ALL] under the Store Drop Down.
Select the date range. You can run this report for any date range you wish. Next select the Spec Type. You can limit the report to Jewelry, General Merchandise (Other), or run the report for all.
Once you have your parameters, select View Report.
As the report is running, you will see a notification that the report is loading. Clicking Cancel will abort the reporting process.
Once the report is run, you will see all loan categories along with the loan base balance (Current Loans), the payments, New Loans, Forfeitures, Reactivations, and Confiscations.
For the Forfeiture Rate, this is the calculation:
(Forfeiture PFI / (DaysInReport / 31)) / Current Loan Balance = Forfeit Rate
So for the Total above we get:
($12443.12 / (29 (June 1 - June 30) / 31)) / $784751.06
($12443.12 / .93548) / $784751.06
$13301.32 / $784751.06
.0169 (aka 1.69% Forfeiture Rate)
To see a detailed analysis of the item class or style, click on the + next to the category name (department). You can then click on the + by the sub category (class).
This report cannot be sorted or further grouped.
To learn how to get this tool for your company, please contact Bravo at 888-407-6287.