光明乳业与伊利财务报表分析

光明乳业2014资产负债表LINKExcel.Sheet.12"C:\\Users\\asus\\Desktop\\新建MicrosoftExcel工作表.xlsx"Sheet1!C1:C3\a\f5\h报告期2014-12-312013-12-31流动资产货币资金2,001,684,3792,600,367,233交易性金融资产--18,537,959应收票据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消耗性生物资产----待摊费用----一年内到期的非流动资产--0其他流动资产209,385,691219,829,683影响流动资产其他科目00流动资产合计6,418,526,9106,411,090,945非流动资产可供出售金融资产2,478,3740持有至到期投资--0投资性房地产--0长期股权投资16,397,87618,719,300长期应收款923,9391,223,939固定资产4,357,378,3833,371,200,199工程物资--0在建工程808,234,611672,880,766固定资产清理--0生产性生物资产241,989,680205,140,803油气资产--0无形资产312,395,871281,590,505开发支出--0商誉245,996,250258,884,662长期待摊费用1,174,8963,286,520递延所得税资产372,682,680344,034,545其他非流动资产104,965,6710影响非流动资产其他科目00非流动资产合计6,464,618,2315,156,961,239资产总计12,883,145,14111,568,052,184流动负债短期借款1,813,994,215949,638,200交易性金融负债--4,036,740应付票据--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预提费用----预计负债----递延收益-流动负债----一年内到期的非流动负债----应付短期债券----其他流动负债--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所有者权益实收资本（或股本）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未确认的投资损失----少数股东权益687,929,894745,674,042归属于母公司股东权益合计4,511,645,9874,278,112,842影响所有者权益其他科目----所有者权益合计5,199,575,8815,023,786,884负债及所有者权益总计12,883,145,14111,568,052,184光明乳业2014利润表报告期2014-12-312013-12-31一、营业总收入20,385,061,87316,290,910,116营业收入20,385,061,87316,290,910,116二、营业总成本19,662,209,88315,680,136,201营业成本13,330,774,05110,630,422,997营业税金及附加86,278,30183,529,201销售费用5,469,247,5304,410,107,077管理费用580,520,009484,235,421财务费用78,395,40653,160,235资产减值损失116,994,58618,681,270三、其他经营收益-63,050,9619,772,545允许价值变动净收益-24,555,6280投资净收益-371,42415,344,341联营、合营企业投资收益-371,4242,327,401汇兑净收益--0四、营业利润697,924,938626,118,256营业外收入70,491,843130,389,005营业外支出54,502,92548,175,109非流动资产处置净损失28,607,34746,348,294五、利润总额713,913,856708,332,152所得税130,856,303233,821,232未确认的投资损失----六、净利润(百万元)568406.04少数股东损益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

光明乳业财务报告分析一、偿债能力分析：1、短期偿债能力分析年初流动比率=流动资产/流动负债=1.077年末流动比率=流动资产/流动负债=0.990年初速动比率=速动资产/流动负债=0.826年末速动比率=速动资产/流动负债=0.677年初现金比率=（货币资金+交易性金融资产）/流动负债=0.440年末现金比率=（货币资金+交易性金融资产）/流动负债=0.3092、长期偿债能力分析：年初资产负债率=（负债总额/资产总额）*100%=56.57%年末资产负债率=（负债总额/资产总额）*100%=59.64%年初产权比率=（负债总额/股东权益总额）*100%=125.09%年末产权比率=（负债总额/股东权益总额）*100%=141.18%二、营运能力分析：存货周转天数=360/（营业成本/平均存货余额）=47.68应收账款周转天数=360/(销售收入/应收账款平均余额）=27.21流动资产周转天数=360/（营业收入/流动资产平均余额）=113.29三、盈利能力分析：上期营业毛利率=（营业收入-营业成本）/营业收入*100%=34.746%本期营业毛利率=（营业收入-营业成本）/营业收入*100%=34.605%上期营业利润率=营业利润/营业收入*100%=3.843%本期营业利润率=营业利润/营业收入*100%=3.423%上期营业净利率=净利润/营业收入*100%=2.912%本期营业净利率=净利润/营业收入*100%=2.860%

四、杜邦财务分析净资产收益率12.59%总资产收益率*权益乘数4.77%1/(1-59.64%)销售净利率*总资产周转率2.79%1.67净利润/营业收入营业收入/平均资产总额567,919,811.0020,385,061,873.0020,385,061,873.0012,875,329,445.50营业收入-全部成本+投资收益-所得税+其他20,385,061,873.0019,662,209,883.00-371,424130,856,303--营业成本销售费用管理费用财务费用13,417,052,3525,469,247,530.00580,520,009.0078,395,406.00

伊利股份2014年资产负债表报告期2014-12-312013-12-31流动资产货币资金14,272,616,3868,173,346,441.54交易性金融资产----应收票据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消耗性生物资产----待摊费用----一年内到期的非流动资产----其他流动资产542,319,4683,635,136,661.22影响流动资产其他科目00流动资产合计21,001,066,30116,467,180,048.56非流动资产可供出售金融资产822,022,810347,855,799.72持有至到期投资----投资性房地产----长期股权投资25,726,556558,412,708.80长期应收款----固定资产13,121,335,66810,403,990,333.74工程物资18,825,0249,254,624.85在建工程939,357,0301,483,941,376.16固定资产清理3,601,099.09--生产性生物资产1,289,067,3441,277,685,352.65油气资产----无形资产930,399,643912,646,268.89开发支出----商誉10,678,61010,678,610.25长期待摊费用185,625,66088,584,979.27递延所得税资产686,182,446825,479,424.45其他非流动资产460,410,627491,678,032.20影响非流动资产其他科目00非流动资产合计18,493,232,51716,410,207,510.98资产总计39,494,298,81732,877,387,559.54流动负债短期借款8,071,984,1464,086,000,000交易性金融负债----应付票据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预提费用----预计负债----递延收益-流动负债----一年内到期的非流动负债----应付短期债券----其他流动负债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所有者权益实收资本（或股本）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未确认的投资损失----少数股东权益187,629,650187,682,685.47归属于母公司股东权益合计18,633,924,84216,125,099,260.91影响所有者权益其他科目----所有者权益合计18,821,554,49216,312,781,946.38负债及所有者权益总计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一、营业总收入54,436,426,79247,778,865,826.24营业收入54,436,426,79247,778,865,826.24二、营业总成本50,154,479,85045,251,239,943.22营业成本36,399,991,13934,082,758,122.46营业税金及附加185,388,696233,907,600.71销售费用10,074,550,8618,546,072,726.90管理费用3,163,230,5472,391,831,003.48财务费用154,886,534-33,093,470.24资产减值损失176,432,07329,763,959.91三、其他经营收益2,592,7877,195,961.84允许价值变动净收益----投资净收益107,739,751131,385,457.64联营、合营企业投资收益-1,724,3194,429,323.49汇兑净收益----四、营业利润4,389,686,6932,659,011,340.66营业外收入463,408,540439,842,693.13营业外支出67,209,77938,476,634.76非流动资产处置净损失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少数股东损益22,257,59613,957,232.68归属于母公司股东的净利润4,144,280,5363,187,239,562.47七、每股收益11.65基本每股收益1.351.65稀释每股收益11.65

伊利股份年度财务报告分析一、偿债能力分析：1、短期偿债能力分析年初流动比率=流动资产/流动负债=1.061年末流动比率=流动资产/流动负债=1.120年初速动比率=速动资产/流动负债=0.824年末速动比率=速动资产/流动负债=0.852年初现金比率=（货币资金+交易性金融资产）/流动负债=0.527年末现金比率=（货币资金+交易性金融资产）/流动负债=0.7612、长期偿债能力分析：年初资产负债率=（负债总额/资产总额）*100%=50.38%年末资产负债率=（负债总额/资产总额）*100%=52.34%年初产权比率=（负债总额/股东权益总额）*100%=95.12%年末产权比率=（负债总额/股东权益总额）*100%=103.39%二、营运能力分析：存货周转天数=360/（营业成本/平均存货余额）=42.98应收账款周转天数=360/(销售收入/应收账款平均余额）=2.85流动资产周转天数=360/（营业收入/流动资产平均余额）=124.99三、盈利能力分析：上期营业毛利率=（营业收入-营业成本）/营业收入*100%=28.67%本期营业毛利率=（营业收入-营业成本）/营业收入*100%=32.54%上期营业利润率=营业利润/营业收入*100%=5.57%本期营业利润率=营业利润/营业收入*100%=8.14%上期营业净利率=净利润/营业收入*100%=6.70%本期营业净利率=净利润/营业收入*100%=7.72%

四、杜邦财务分析：净资产收益率6.53%总资产收益率*权益乘数4.77%1/(1-50.56%)销售净利率*总资产周转率8.69%0.37净利润/营业收入营业收入/平均资产总额1,302,767,938.3914,992,235,739.6414,992,235,739.6440,104,375,179.89营业收入-全部成本+投资收益-所得税+其他14,992,235,739.6413,513,097,237.22710,320223,423,366--营业成本销售费用管理费用