小微企业财务健康分析数据

内部应用场景：
1、通过对申请担保的企业进行财务分析，识别哪些企业有较高的还款能力和较低的违约风险。
2、定期对已担保企业的财务状况进行跟踪分析，有助于及时发现潜在风险点，并采取预防措施。
外部应用场景：
1、定期的财务健康分析可以帮助担保机构及时发现企业的财务风险，采取必要的措施保护自身利益。
2、财务健康分析报告可以帮助银行决定是否向企业提供贷款以及贷款额度。报告中的信息可以用来提供贷款利率、还款期限等条款参考。1、数据采集与处理：采集已授权企业的年报信息，按照指标规则对数据进行ETL处理，得到关键财务指标。
2、指标标准化，计算指标评分，其中：
流动比率得分=(MAX(MIN(流动比率,2),1)-1)*100;
速动比率得分=(MAX(MIN(速动比率,1.5),1)-1)*2*100;
净利率得分=MIN(净利率,0.2)/0.2*100;
资产负债率得分=(0.6-MIN(资产负债率,0.6))*100/0.6;
权益乘数得分=(3-MAX(MIN(权益乘数,3),1))/2*100;
总资产周转率得分=(MAX(MIN(总资产周转率,2),0)/2)*100;
应收账款周转天数得分=(60-MAX(MIN(应收账款周转天数,60),0))*100/60;
3、确定权重并计算财务健康评分，公式为：
财务健康评分=流动比率得分*15%+速动比率得分*15%+净利率得分*20%+资产负债率得分*15%+权益乘数得分*10%+总资产周转率得分*10%+应收账款周转天数得分*15%
4、确认财务健康评级，评级=IF(财务健康评分>50,"优秀",IF(财务健康评分>30,"良好","一般"))

Internal Application Scenarios:
1. Conduct financial analysis on enterprises applying for guarantees to identify those with high repayment capability and low default risk.
2. Regularly track and analyze the financial status of guaranteed enterprises, so as to timely detect potential risk points and take preventive measures.

External Application Scenarios:
1. Regular financial health analysis can help guarantee institutions detect enterprises' financial risks in a timely manner and take necessary measures to safeguard their own interests.
2. Financial health analysis reports can assist banks in deciding whether to provide loans to enterprises and determining the loan amount. The information in the reports can also serve as a reference for terms such as loan interest rates and repayment terms.

Data Collection and Processing:
1. Collect annual report information of authorized enterprises, and perform ETL processing on the data in accordance with indicator rules to obtain key financial indicators.
2. Conduct indicator standardization and calculate indicator scores, with the following formulas:
Current ratio score = (MAX(MIN(current ratio, 2), 1) - 1) * 100;
Quick ratio score = (MAX(MIN(quick ratio, 1.5), 1) - 1) * 2 * 100;
Net profit margin score = MIN(net profit margin, 0.2) / 0.2 * 100;
Asset-liability ratio score = (0.6 - MIN(asset-liability ratio, 0.6)) * 100 / 0.6;
Equity multiplier score = (3 - MAX(MIN(equity multiplier, 3), 1)) / 2 * 100;
Total asset turnover ratio score = (MAX(MIN(total asset turnover ratio, 2), 0) / 2) * 100;
Accounts receivable turnover days score = (60 - MAX(MIN(accounts receivable turnover days, 60), 0)) * 100 / 60;
3. Determine the weights and calculate the financial health score, with the formula:
Financial health score = Current ratio score * 15% + Quick ratio score * 15% + Net profit margin score * 20% + Asset-liability ratio score * 15% + Equity multiplier score * 10% + Total asset turnover ratio score * 10% + Accounts receivable turnover days score * 15%
4. Confirm the financial health rating, with the rating rule:
IF(Financial health score > 50, "Excellent", IF(Financial health score > 30, "Good", "Average"))

搜集汇总

数据集介绍

特点

该数据集为小微企业财务健康分析数据，包含2611条记录，每日更新，涵盖多个财务指标和评分算法，主要用于担保机构风险评估和银行信贷决策。