光明乳業(yè)與伊利財務(wù)報表分析

光明乳業(yè)2014資產(chǎn)負債表LINKExcel.Sheet.12"C:\\Users\\asus\\Desktop\\新建MicrosoftExcel工作表.xlsx"Sheet1!C1:C3\a\f5\h報告期2014-12-312013-12-31流動資產(chǎn)貨幣資金2,001,684,3792,600,367,233交易性金融資產(chǎn)--18,537,959應收票據(jù)5,563,4612,678,307應收賬款1,695,027,4481,386,392,941預付賬款396,767,016603,372,752應收利息--0應收股利--0其他應收款79,365,22279,125,091存貨2,030,733,6931,500,786,979消耗性生物資產(chǎn)----待攤費用----一年內(nèi)到期的非流動資產(chǎn)--0其他流動資產(chǎn)209,385,691219,829,683影響流動資產(chǎn)其他科目00流動資產(chǎn)合計6,418,526,9106,411,090,945非流動資產(chǎn)可供出售金融資產(chǎn)2,478,3740持有至到期投資--0投資性房地產(chǎn)--0長期股權(quán)投資16,397,87618,719,300長期應收款923,9391,223,939固定資產(chǎn)4,357,378,3833,371,200,199工程物資--0在建工程808,234,611672,880,766固定資產(chǎn)清理--0生產(chǎn)性生物資產(chǎn)241,989,680205,140,803油氣資產(chǎn)--0無形資產(chǎn)312,395,871281,590,505開發(fā)支出--0商譽245,996,250258,884,662長期待攤費用1,174,8963,286,520遞延所得稅資產(chǎn)372,682,680344,034,545其他非流動資產(chǎn)104,965,6710影響非流動資產(chǎn)其他科目00非流動資產(chǎn)合計6,464,618,2315,156,961,239資產(chǎn)總計12,883,145,14111,568,052,184流動負債短期借款1,813,994,215949,638,200交易性金融負債--4,036,740應付票據(jù)--0應付賬款2,053,400,5981,998,690,181預收賬款506,196,840748,733,090應付職工薪酬206,841,812183,033,041應交稅費275,308,472288,613,574應付利息4,032,6103,531,167應付股利--0其他應付款1,580,751,9051,508,636,603預提費用----預計負債----遞延收益-流動負債----一年內(nèi)到期的非流動負債----應付短期債券----其他流動負債--0影響流動負債其他科目----流動負債合計6,482,466,2235,948,055,729非流動負債長期借款858,503,081336,347,214應付債券--0長期應付款65,782,6151,022,500專項應付款700,0006,677,119遞延所得稅負債94,049,61397,777,846遞延收益-非流動負債----其他非流動負債280,000154,384,892影響非流動負債其他科目181,787,7280非流動負債合計1,201,103,037596,209,571負債合計7,683,569,2606,544,265,300所有者權(quán)益實收資本（或股本）1,230,636,7391,224,497,459資本公積金1,771,264,2411,756,143,964盈余公積金410,419,606364,268,748未分配利潤1,196,992,430920,122,969庫存股64,760,1150外幣報表折算差額--13,079,702未確認的投資損失----少數(shù)股東權(quán)益687,929,894745,674,042歸屬于母公司股東權(quán)益合計4,511,645,9874,278,112,842影響所有者權(quán)益其他科目----所有者權(quán)益合計5,199,575,8815,023,786,884負債及所有者權(quán)益總計12,883,145,14111,568,052,184光明乳業(yè)2014利潤表報告期2014-12-312013-12-31一、營業(yè)總收入20,385,061,87316,290,910,116營業(yè)收入20,385,061,87316,290,910,116二、營業(yè)總成本19,662,209,88315,680,136,201營業(yè)成本13,330,774,05110,630,422,997營業(yè)稅金及附加86,278,30183,529,201銷售費用5,469,247,5304,410,107,077管理費用580,520,009484,235,421財務(wù)費用78,395,40653,160,235資產(chǎn)減值損失116,994,58618,681,270三、其他經(jīng)營收益-63,050,9619,772,545允許價值變動凈收益-24,555,6280投資凈收益-371,42415,344,341聯(lián)營、合營企業(yè)投資收益-371,4242,327,401匯兌凈收益--0四、營業(yè)利潤697,924,938626,118,256營業(yè)外收入70,491,843130,389,005營業(yè)外支出54,502,92548,175,109非流動資產(chǎn)處置凈損失28,607,34746,348,294五、利潤總額713,913,856708,332,152所得稅130,856,303233,821,232未確認的投資損失----六、凈利潤(百萬元)568406.04少數(shù)股東損益15,137,74268,470,444歸屬于母公司股東的凈利潤567,919,811406,040,476七、每股收益00.33基本每股收益0.460.33稀釋每股收益0--LINKExcel.Sheet.12"C:\\Users\\asus\\Desktop\\新建MicrosoftExcel工作表.xlsx"Sheet1!R1C1:R28C3\a\f5\h

光明乳業(yè)財務(wù)報告分析一、償債能力分析：1、短期償債能力分析年初流動比率=流動資產(chǎn)/流動負債=1.077年末流動比率=流動資產(chǎn)/流動負債=0.990年初速動比率=速動資產(chǎn)/流動負債=0.826年末速動比率=速動資產(chǎn)/流動負債=0.677年初現(xiàn)金比率=（貨幣資金+交易性金融資產(chǎn)）/流動負債=0.440年末現(xiàn)金比率=（貨幣資金+交易性金融資產(chǎn)）/流動負債=0.3092、長期償債能力分析：年初資產(chǎn)負債率=（負債總額/資產(chǎn)總額）*100%=56.57%年末資產(chǎn)負債率=（負債總額/資產(chǎn)總額）*100%=59.64%年初產(chǎn)權(quán)比率=（負債總額/股東權(quán)益總額）*100%=125.09%年末產(chǎn)權(quán)比率=（負債總額/股東權(quán)益總額）*100%=141.18%二、營運能力分析：存貨周轉(zhuǎn)天數(shù)=360/（營業(yè)成本/平均存貨余額）=47.68應收賬款周轉(zhuǎn)天數(shù)=360/(銷售收入/應收賬款平均余額）=27.21流動資產(chǎn)周轉(zhuǎn)天數(shù)=360/（營業(yè)收入/流動資產(chǎn)平均余額）=113.29三、盈利能力分析：上期營業(yè)毛利率=（營業(yè)收入-營業(yè)成本）/營業(yè)收入*100%=34.746%本期營業(yè)毛利率=（營業(yè)收入-營業(yè)成本）/營業(yè)收入*100%=34.605%上期營業(yè)利潤率=營業(yè)利潤/營業(yè)收入*100%=3.843%本期營業(yè)利潤率=營業(yè)利潤/營業(yè)收入*100%=3.423%上期營業(yè)凈利率=凈利潤/營業(yè)收入*100%=2.912%本期營業(yè)凈利率=凈利潤/營業(yè)收入*100%=2.860%

四、杜邦財務(wù)分析凈資產(chǎn)收益率12.59%總資產(chǎn)收益率*權(quán)益乘數(shù)4.77%1/(1-59.64%)銷售凈利率*總資產(chǎn)周轉(zhuǎn)率2.79%1.67凈利潤/營業(yè)收入營業(yè)收入/平均資產(chǎn)總額567,919,811.0020,385,061,873.0020,385,061,873.0012,875,329,445.50營業(yè)收入-全部成本+投資收益-所得稅+其他20,385,061,873.0019,662,209,883.00-371,424130,856,303--營業(yè)成本銷售費用管理費用財務(wù)費用13,417,052,3525,469,247,530.00580,520,009.0078,395,406.00

伊利股份2014年資產(chǎn)負債表報告期2014-12-312013-12-31流動資產(chǎn)貨幣資金14,272,616,3868,173,346,441.54交易性金融資產(chǎn)----應收票據(jù)139,400,000181,939,000應收賬款513,023,498340,087,732.36預付賬款389,960,877329,620,482.99應收利息69,266,145418,491.70應收股利----其他應收款66,233,526123,728,486.12存貨5,008,246,4003,682,902,752.63消耗性生物資產(chǎn)----待攤費用----一年內(nèi)到期的非流動資產(chǎn)----其他流動資產(chǎn)542,319,4683,635,136,661.22影響流動資產(chǎn)其他科目00流動資產(chǎn)合計21,001,066,30116,467,180,048.56非流動資產(chǎn)可供出售金融資產(chǎn)822,022,810347,855,799.72持有至到期投資----投資性房地產(chǎn)----長期股權(quán)投資25,726,556558,412,708.80長期應收款----固定資產(chǎn)13,121,335,66810,403,990,333.74工程物資18,825,0249,254,624.85在建工程939,357,0301,483,941,376.16固定資產(chǎn)清理3,601,099.09--生產(chǎn)性生物資產(chǎn)1,289,067,3441,277,685,352.65油氣資產(chǎn)----無形資產(chǎn)930,399,643912,646,268.89開發(fā)支出----商譽10,678,61010,678,610.25長期待攤費用185,625,66088,584,979.27遞延所得稅資產(chǎn)686,182,446825,479,424.45其他非流動資產(chǎn)460,410,627491,678,032.20影響非流動資產(chǎn)其他科目00非流動資產(chǎn)合計18,493,232,51716,410,207,510.98資產(chǎn)總計39,494,298,81732,877,387,559.54流動負債短期借款8,071,984,1464,086,000,000交易性金融負債----應付票據(jù)266,080,000164,750,000應付賬款5,280,707,4545,192,005,724.97預收賬款2,163,040,7333,347,153,719.73應付職工薪酬1,487,540,0881,320,470,828.26應交稅費351,657,931381,203,800.11應付利息11,405,2203,029,413.33應付股利39,568,679.3415,281,350.54其他應付款1,014,466,402946,950,391.27預提費用----預計負債----遞延收益-流動負債----一年內(nèi)到期的非流動負債----應付短期債券----其他流動負債70,096,687.5360,150,662.12影響流動負債其他科目----流動負債合計18,756,547,34215,516,995,890.33非流動負債長期借款703,974,000289,000應付債券----長期應付款----專項應付款176,599,666101,724,400.63遞延所得稅負債6,778,6644,090,459.20遞延收益-非流動負債----其他非流動負債--941,505,863影響非流動負債其他科目1,028,844,6530非流動負債合計1,916,196,9831,047,609,722.83負債合計20,672,744,32516,564,605,613.16所有者權(quán)益實收資本（或股本）3,064,371,0332,042,914,022資本公積金6,481,242,2477,538,692,924.80盈余公積金1,143,309,803914,480,670.67未分配利潤7,922,404,0155,641,283,829.32庫存股----外幣報表折算差額---12,272,185.88未確認的投資損失----少數(shù)股東權(quán)益187,629,650187,682,685.47歸屬于母公司股東權(quán)益合計18,633,924,84216,125,099,260.91影響所有者權(quán)益其他科目----所有者權(quán)益合計18,821,554,49216,312,781,946.38負債及所有者權(quán)益總計39,494,298,81732,877,387,559.54伊利股份2014利潤表LINKExcel.Sheet.12"C:\\Users\\asus\\Desktop\\新建MicrosoftExcel工作表.xlsx"Sheet1!R1C1:R28C3\a\f5\h報告期2014-12-312013-12-31一、營業(yè)總收入54,436,426,79247,778,865,826.24營業(yè)收入54,436,426,79247,778,865,826.24二、營業(yè)總成本50,154,479,85045,251,239,943.22營業(yè)成本36,399,991,13934,082,758,122.46營業(yè)稅金及附加185,388,696233,907,600.71銷售費用10,074,550,8618,546,072,726.90管理費用3,163,230,5472,391,831,003.48財務(wù)費用154,886,534-33,093,470.24資產(chǎn)減值損失176,432,07329,763,959.91三、其他經(jīng)營收益2,592,7877,195,961.84允許價值變動凈收益----投資凈收益107,739,751131,385,457.64聯(lián)營、合營企業(yè)投資收益-1,724,3194,429,323.49匯兌凈收益----四、營業(yè)利潤4,389,686,6932,659,011,340.66營業(yè)外收入463,408,540439,842,693.13營業(yè)外支出67,209,77938,476,634.76非流動資產(chǎn)處置凈損失34,465,17422,658,866.86五、利潤總額4,785,885,4543,060,377,399.03所得稅619,347,322-140,819,396.12未確認的投資損失----六、凈利潤(百萬元)4,1443,187.24少數(shù)股東損益22,257,59613,957,232.68歸屬于母公司股東的凈利潤4,144,280,5363,187,239,562.47七、每股收益11.65基本每股收益1.351.65稀釋每股收益11.65

伊利股份年度財務(wù)報告分析一、償債能力分析：1、短期償債能力分析年初流動比率=流動資產(chǎn)/流動負債=1.061年末流動比率=流動資產(chǎn)/流動負債=1.120年初速動比率=速動資產(chǎn)/流動負債=0.824年末速動比率=速動資產(chǎn)/流動負債=0.852年初現(xiàn)金比率=（貨幣資金+交易性金融資產(chǎn)）/流動負債=0.527年末現(xiàn)金比率=（貨幣資金+交易性金融資產(chǎn)）/流動負債=0.7612、長期償債能力分析：年初資產(chǎn)負債率=（負債總額/資產(chǎn)總額）*100%=50.38%年末資產(chǎn)負債率=（負債總額/資產(chǎn)總額）*100%=52.34%年初產(chǎn)權(quán)比率=（負債總額/股東權(quán)益總額）*100%=95.12%年末產(chǎn)權(quán)比率=（負債總額/股東權(quán)益總額）*100%=103.39%二、營運能力分析：存貨周轉(zhuǎn)天數(shù)=360/（營業(yè)成本/平均存貨余額）=42.98應收賬款周轉(zhuǎn)天數(shù)=360/(銷售收入/應收賬款平均余額）=2.85流動資產(chǎn)周轉(zhuǎn)天數(shù)=360/（營業(yè)收入/流動資產(chǎn)平均余額）=124.99三、盈利能力分析：上期營業(yè)毛利率=（營業(yè)收入-營業(yè)成本）/營業(yè)收入*100%=28.67%本期營業(yè)毛利率=（營業(yè)收入-營業(yè)成本）/營業(yè)收入*100%=32.54%上期營業(yè)利潤率=營業(yè)利潤/營業(yè)收入*100%=5.57%本期營業(yè)利潤率=營業(yè)利潤/營業(yè)收入*100%=8.14%上期營業(yè)凈利率=凈利潤/營業(yè)收入*100%=6.70%本期營業(yè)凈利率=凈利潤/營業(yè)收入*100%=7.72%

四、杜邦財務(wù)分析：凈資產(chǎn)收益率6.53%總資產(chǎn)收益率*權(quán)益乘數(shù)4.77%1/(1-50.56%)銷售凈利率*總資產(chǎn)周轉(zhuǎn)率8.69%0.37凈利潤/營業(yè)收入營業(yè)收入/平均資產(chǎn)總額1,302,767,938.3914,992,235,739.6414,992,235,739.6440,104,375,179.89營業(yè)收入-全部成本+投資收益-所得稅+其他14,992,235,739.6413,513,097,237.22710,320223,423,366--營業(yè)成本銷售費用管理費用