公司企业财务管理07-财务报表分析Excel模型.xls

《公司企业财务管理07-财务报表分析Excel模型.xls》由会员分享，可在线阅读，更多相关《公司企业财务管理07-财务报表分析Excel模型.xls（11页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、资资产产负负债债表表编制单位：资资 产产负负债债及及所所有有者者权权益益流动资产：流动负债：货币资金735,204,979.84467,612,180.59短期借款短期投资应付票据应收票据624,375,847.86363,147,763.88应付账款应收股利预收账款应收利息应付工资应收账款4,000.00122,721.58应付福利费其他应收款1,416,848.353,642,209.58应付股利预付账款86,448,381.6554,311,170.97应交税金应收补贴款其他应交款存货1,254,543,580.86622,649,696.61其他应付款待摊费用12,646,443.79

2、8,738,927.97预提费用一年内到期的长期债权一年内到期的长期负债其他流动资产其他流动负债流流动动资资产产合合计计2,714,640,082.352,714,640,082.351,520,224,671.181,520,224,671.18流流动动负负债债合合计计：长期投资：长期负债：长期股权投资长期借款长期债权投资应付债券长期投资合计长期应付款固定资产:其他长期负债固定资产原值6,120,700,922.584,058,189,062.93长长期期负负债债合合计计减：累计折旧1,874,773,420.311,520,624,895.97递延税项：固定资产净值4,245,927,50

3、2.272,537,564,166.96递延税项贷项减：固定资产减值准备21,859,077.159,553,398.08负负债债合合计计：固定资产净额4,224,068,425.122,528,010,768.88所有者权益：工程物资392,909,004.54股本在建工程716,899,275.361,225,630,781.84资本公积固定资产清理盈余公积固固定定资资产产合合计计5,333,876,705.025,333,876,705.023,753,641,550.723,753,641,550.72其中：法定公益金无形资产及其他资产：拟分配现金股利无形资产未分配利润长期待摊费用股股

4、东东权权益益合合计计其他长期资产无形资产及其他资产合计递延税项：递延税项借项资资产产总总计计8,048,516,787.378,048,516,787.375,273,866,221.905,273,866,221.90负负债债和和所所有有者者权权益益总总计计货币单位：元274,000,000.00300,700,000.0090,582,683.9173,484,799.22199,904,445.71217,739,314.01584,723,563.43102,299,281.6332,887,152.3531,231,962.5622,085,855.67446,965,036.631

5、74,431,925.891,771,703.37953,853.5254,525,028.23212,529,890.241,694,279.292,981,280.43403,986,000.00400,000,000.002,122,271,855.482,122,271,855.481,507,206,200.611,507,206,200.611,607,627,600.001,037,760,000.001,607,627,600.001,607,627,600.001,037,760,000.001,037,760,000.003,729,899,455.483,729,899,

6、455.482,544,966,200.612,544,966,200.61838,200,000.00447,200,000.001,906,669,123.711,521,739,648.01351,651,631.88204,392,411.64117,217,210.6268,130,803.87251,460,000.00970,936,876.30555,547,961.644,318,917,631.894,318,917,631.892,728,880,021.292,728,880,021.298,048,817,087.378,048,817,087.375,273,846

7、,221.905,273,846,221.90利利润润表表编制单位：货币单位：元项项目目名名称称一、主营业务收入7,160,864,275.534,430,833,020.53 减:主营业务成本5,596,198,414.003,740,863,287.41 主营业务税金及附加39,679,411.7025,904,207.79二、主营业务利润（亏损以“”号填列）1,524,986,449.83664,065,525.33 加:其他业务利润（亏损以“”号填列）17,478,039.667,376,815.40 减:营业费用18,291,277.9623,528,913.89 管理费用129,3

8、18,989.08104,416,856.90 财务费用30,469,265.1920,502,541.67三、营业利润1,364,384,957.26522,994,028.27 加:投资收益（亏损以“”号填列）补贴收入 营业外收入132,930.631,116,398.72 减:营业外支出25,506,103.029,553,398.72四、利润总额1,339,011,784.87514,557,028.27 减:所得税357,283,679.34165,477,223.91五、净利润981,728,105.53349,079,804.36 加:年初未分配利润555,567,961.642

9、58,850,127.44六、可供分配的利润1,537,296,067.17607,929,931.80 减:提取法定公积98,172,813.4934,907,980.49 提取法定公益金49,086,406.7517,453,990.24分配普通股股利419,100,000.00七、年末未分配利润970,936,846.93555,567,961.071 1、财财务务状状况况分分析析项项目目期期末末数数期期初初数数增增长长率率资产总额8,048,516,787.375,273,866,221.9052.61%年末股东权益总额4,318,917,631.892,728,880,021.295

10、8.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 2、资资产产变变化化分分析析项项目目期期末末数数期期初初数数增增长长率率货币资金735,204,979.84467,612,180.5957.23%应收票据624,375,847.86363,147,763.8871.93%应收账款4,000.00

11、122,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.352,714,640,082.351,520,224,671.181,520,224,671.1878.57%78.57%财财务务状状况况变变动动分分析析资产总额年末股东权益总额年末负债总额主营业务收入主营业务利润净利润0

12、1,000,000,000 2,000,000,000 3,000,000,000 4,000,000,000 5,000,000,000 6,000,000,000 7,000,000,000 8,000,000,000 9,000,000,000 0%20%40%60%80%100%120%140%160%180%200%期末数期初数增长率资资产产变变化化分分析析货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用0 200,000,000 400,000,000 600,000,000 800,000,000 1,000,0

13、00,000 1,200,000,000 1,400,000,000-150%-100%-50%0%50%100%150%期末数期初数增长率3 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.23212,529,890.24-74.34%负负债债变变化化分分析析应付票据应付账款预收账款其他应付款应付票据应付账款预收账

14、款其他应付款0 100000000 200000000 300000000 400000000 500000000 600000000 700000000-200%-100%0%100%200%300%400%500%期末数期初数增长率资资产产变变化化分分析析货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用0 200,000,000 400,000,000 600,000,000 800,000,000 1,000,000,000 1,200,000,000 1,400,000,000-150%-100%-50%0%50%10

15、0%150%期末数期初数增长率增增长长额额2,774,650,565.471,590,037,610.601,184,933,254.872,730,031,255.00860,920,924.50632,648,301.17增增长长额额267,592,799.25261,228,083.98-118,721.58-2,225,361.23 32,137,210.68631,893,884.253,907,515.821,194,415,411.171,194,415,411.17财财务务状状况况变变动动分分析析资产总额年末股东权益总额年末负债总额主营业务收入主营业务利润净利润0 1,000,

16、000,000 2,000,000,000 3,000,000,000 4,000,000,000 5,000,000,000 6,000,000,000 7,000,000,000 8,000,000,000 9,000,000,000 0%20%40%60%80%100%120%140%160%180%200%期末数期初数增长率资资产产变变化化分分析析货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用0 200,000,000 400,000,000 600,000,000 800,000,000 1,000,000,000

17、 1,200,000,000 1,400,000,000-150%-100%-50%0%50%100%150%期末数期初数增长率增增长长额额17,097,884.69-17,834,868.30 482,424,281.80-158,004,862.01 资资产产变变化化分分析析货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用货币资金应收票据应收账款其他应收款预付账款 存货 待摊费用0 200,000,000 400,000,000 600,000,000 800,000,000 1,000,000,000 1,200,000,000 1,400,000,000-150%-100%-

18、50%0%50%100%150%期末数期初数增长率负负债债变变化化分分析析应付票据应付账款预收账款其他应付款应付票据应付账款预收账款其他应付款0 100000000 200000000 300000000 400000000 500000000 600000000 700000000-200%-100%0%100%200%300%400%500%期末数期初数增长率一一、资资产产结结构构分分析析资资产产负负债债率率46.34%所所有有者者权权益益比比率率53.66%产产权权比比率率86.36%二二、偿偿债债能能力力分分析析流流动动比比率率127.91%速速动动比比率率68.80%利利息息保保障障

19、倍倍数数44.95三三、企企业业货货币币资资金金分分析析1、货币资金支付能力分析可可用用于于支支付付的的资资金金金金额额返返期期支支付付款款项项金金额额1.1.银银行行存存款款41600 1.1.应应付付账账款款600002.2.现现金金400 2.2.应应付付税税金金220003.3.应应收收账账款款100000 3.3.应应付付工工资资400004.4.其其他他应应收收款款3000 4.4.应应付付利利润润40005.5.其其他他应应付付款款2000合合计计145000 合合计计128000不不足足数数0 多多余余数数17000平平衡衡145000 平平衡衡145000货货币币资资金金支支

20、付付能能力力168.00%支付能力较强2、货币资金周转率货货币币资资金金期期初初余余额额1700000本本期期销销售售额额11600000现现销销比比例例80%收收回回以以前前赊赊销销款款项项160000资资金金周周转转率率5.55一一、盈盈利利能能力力分分析析分分析析指指标标百百分分比比主营业务利润率21.30%主营业务成本利润率27.25%主营业务税金及附加利润率3843.27%总资产报酬率20.56%净资产收益率27.86%资本收益率117.12%二二、成成本本、费费用用消消化化能能力力分分析析指指标标百百分分比比主营业务成本率78.15%管理费用率1.81%财务费用率0.43%成本、费用利润率751.92%