财务报表分析excel模型

1、财务状况分析

项目期末数期初数增长率

资产总额8,048,516,787.375,273,866,221.9052.61%年末股东权益总额4,318,917,631.892,728,880,021.2958.27%年末负债总额3,729,899,455.482,544,966,200.6146.56%主营业务收入7,160,864,275.534,430,833,020.5361.61%主营业务利润1,524,986,449.83664,065,525.33129.64%净利润981,728,105.53349,079,804.36181.23%

2、资产变化分析

项目期末数期初数增长率

货币资金735,204,979.84467,612,180.5957.23%应收票据624,375,847.86363,147,763.8871.93%应收账款4,000.00122,721.58-96.74%其他应收款1,416,848.353,642,209.58-61.10%预付账款86,448,381.6554,311,170.9759.17%存货1,254,543,580.86622,649,696.61101.48%待摊费用12,646,443.798,738,927.9744.71%资产总趋势2,714,640,082.351,520,224,671.1878.57%

3、负债变化分析

项目

期末数

期初数

增长率

应付票据90,582,683.9173,484,799.2223.27%应付账款199,904,445.71217,739,314.01-8.19%预收账款584,723,563.43102,299,281.63471.58%其他应付款

54,525,028.23

212,529,890.24

-74.34%

增长额

2,774,650,565.47 1,590,037,610.60 1,184,933,254.87 2,730,031,255.00 860,920,924.50

632,648,301.17

增长额

267,592,799.25

261,228,083.98

-118,721.58 -2,225,361.23

32,137,210.68

631,893,884.25

3,907,515.82 1,194,415,411.17

增长额

17,097,884.69 -17,834,868.30 482,424,281.80 -158,004,862.01