財(cái)務(wù)報(bào)表分析excel模型

1、財(cái)務(wù)狀況分析,,,,

項(xiàng)目,期末數(shù),期初數(shù),增長(zhǎng)率,增長(zhǎng)額

資產(chǎn)總額,"8,048,516,787.37","5,273,866,221.90",52.61%,"2,774,650,565.47"

年末股東權(quán)益總額,"4,318,917,631.89","2,728,880,021.29",58.27%,"1,590,037,610.60"

年末負(fù)債總額,"3,729,899,455.48","2,544,966,200.61",46.56%,"1,184,933,254.87"

主營(yíng)業(yè)務(wù)收入,"7,160,864,275.53","4,430,833,020.53",61.61%,"2,730,031,255.00"

主營(yíng)業(yè)務(wù)利潤(rùn),"1,524,986,449.83","664,065,525.33",129.64%,"860,920,924.50"

凈利潤(rùn),"981,728,105.53","349,079,804.36",181.23%,"632,648,301.17"

2、資產(chǎn)變化分析,,,,

項(xiàng)目,期末數(shù),期初數(shù),增長(zhǎng)率,增長(zhǎng)額

貨幣資金,"735,204,979.84","467,612,180.59",57.23%,"267,592,799.25"

應(yīng)收票據(jù),"624,375,847.86","363,147,763.88",71.93%,"261,228,083.98"

應(yīng)收賬款,"4,000.00","122,721.58",-96.74%,"-118,721.58"

其他應(yīng)收款,"1,416,848.35","3,642,209.58",-61.10%,"-2,225,361.23"

預(yù)付賬款,"86,448,381.65","54,311,170.97",59.17%,"32,137,210.68"

存貨,"1,254,543,580.86","622,649,696.61",101.48%,"631,893,884.25"

待攤費(fèi)用,"12,646,443.79","8,738,927.97",44.71%,"3,907,515.82"

資產(chǎn)總趨勢(shì),"2,714,640,082.35","1,520,224,671.18",78.57%,"1,194,415,411.17"

,,,,,

,,,,,

3、負(fù)債變化分析,,,,

項(xiàng)目,期末數(shù),期初數(shù),增長(zhǎng)率,增長(zhǎng)額

應(yīng)付票據(jù),"90,582,683.91","73,484,799.22",23.27%,"17,097,884.69"

應(yīng)付賬款,"199,904,445.71","217,739,314.01",-8.19%,"-17,834,868.30"

預(yù)收賬款,"584,723,563.43","102,299,281.63",471.58%,"482,424,281.80"

其他應(yīng)