HomeContact UsModels
 Z Score Private Model 

You can override the existing parameters in the model with those from your counterparty.  Use the TAB key to advance to the next input cell.  You may change the value of the parameters to reflect various scenarios and view their impacts on credit quality.  When using this model all income statement values must be annual (or twelve month rolling) amounts and total assets should represent only tangible assets.  If you reduce total assets for intangible assets, you will also need to reduce equity and/or retained earnings accordingly.  If an entity has substantially reorganized or issued a stock divend, the effect of which is to substantially alter retained earnings or book equity, then an appropriate adjustment to these values may be necessary.

Z Score Private.xls
Company
Financial Statement Date
Income Statement
Sales (net)
Net Income
Interest Expense
Taxes
EBIT
Balance Sheet - Assets
Current Assets
Total Assets (tangible)
Balance Sheet - Liabilities
Current Liabilities
Total Liabilities
Retained Earnings
Book Equity
Model Output
Ratio Calculation Weight Value
Working Capital / Total Assets 0.717
Retained Earnings / Total Assets 0.847
EBIT / Total Assets 3.107
Book Equity / Total Liabilities 0.420
Sales / Total Assets 0.998
Credit Score
Estimated Rating
One-Year Probability of Default
Five-Year Cumulative Probability of Default

Trade Receivable Credit Risk Management

CreditAnalyzer LLC
Email: gpc@creditanalyzer.com