首页 财务报表分析模板

财务报表分析模板

举报
开通vip

财务报表分析模板财务报表分析财务报表异常说明:2393257年m月1、资产负债表:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX;⑤XXXXXX。43301.704332870372、损 益 表:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX。财务报表:3、财务分析指标:详见报表4、销售成本趋势图:XXXXXXXXXXXXXX。5、费用趋势图①XXXXXXX。②XXXXXXX。③XXXXXXX。费用明细表:6、制造费用明细①XXXXXXX。②XXXXXXX。7、财务费用明细XXXXXXX。8、营业费...

财务报表分析模板
财务报表 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 财务报表异常说明:2393257年m月1、资产负债表:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX;⑤XXXXXX。43301.704332870372、损 益 表:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX。财务报表:3、财务分析指标:详见报表4、销售成本趋势图:XXXXXXXXXXXXXX。5、费用趋势图①XXXXXXX。②XXXXXXX。③XXXXXXX。费用明细表:6、制造费用明细①XXXXXXX。②XXXXXXX。7、财务费用明细XXXXXXX。8、营业费用明细①XXXXXXX。②XXXXXXX。9、管理费用明细①XXXXXXX。②XXXXXXX。③XXXXXXX。④XXXXXXX。⑤XXXXXXX。正确10、损益说明:1、XXXXXXXXXXXXXX;2、XXXXXXXXXXXXXX;3、XXXXXXXXXXXXXX;4、XXXXXXXXXXXXXX。系统制作:秦始皇XXXXXXXXXX股份有限公司資產負債表39325.0异常说明:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX;⑤XXXXXX。資產期初數期末數本期增(減)負債及股東權益期初數期末數本期增(減)流動資產流動負債貨幣資金5,332,834.195,310,716.82-22,117.37短期借款4,000,000.00-4,000,000.00應收帳款17,463,656.8113,973,624.40-3,490,032.41應付帳款12,199,600.7711,403,345.52-796,255.25預付帳款0.00應付工資794,018.001,015,069.67221,051.67其他應收款1,060,790.692,059,892.90999,102.21应付福利费62,553.9262,553.920.00應收補貼款0.00未交稅金-190,768.04-348,639.92-157,871.88存貨7,049,920.777,496,901.43446,980.66应付股利4,898,934.864,898,934.860.00待攤費用73,920.00162,502.5088,582.50其他應付款178,902.93231,854.9152,951.98流動資產合計30,981,122.4629,003,638.05-1,977,484.41预提费用0.000.00流動負債合計21,943,242.4417,263,118.96-4,680,123.48固定資產0.00負債合計21,943,242.4417,263,118.96-4,680,123.48固定資產原價18,325,521.3119,856,271.541,530,750.230.00減:累計折舊4,976,091.986,160,267.791,184,175.81本企業股東權益0.00固定資產淨值13,349,429.3313,696,003.75346,574.42實收資本(股本)20,692,741.1320,692,741.130.00在建 工程 路基工程安全技术交底工程项目施工成本控制工程量增项单年度零星工程技术标正投影法基本原理 0.00資本公積16,186.0616,186.060.000.00盈餘公積926,530.92926,530.920.00固定資產合計13,349,429.3313,696,003.75346,574.42其中:公積金0.000.000.000.00未分配利潤1,986,142.694,669,843.782,683,701.09無形資產及遞延資產0.000.00長期待攤費用1,234,291.45868,779.05-365,512.40股東權益合計23,621,600.8026,305,301.892,683,701.090.00無形資產及遞延資產合計1,234,291.45868,779.05-365,512.40資產總計45,564,843.2443,568,420.85-1,996,422.39負債及股東權益45,564,843.2443,568,420.85-1,996,422.39XXXXXXXX股份有限公司損益表(FST)2007年01-12月份异常说明:①XXXXXX;②XXXXXX;③XXXXXX;④XXXXXX。月份Jan-07%Feb-07%Mar-07%Apr-07%May-07%Jun-07%Jul-07%Aug-07%Sep-07%Oct-07%Nov-07%Dec-07%本年度累計數%主營業銷售(營業)收入5,640,172100.00%4,311,734100.00%5,992,303100.00%7,399,516100.00%6,705,860100.00%8,068,306100.00%6,305,969100.00%5,247,499100.00%#DIV/0!#DIV/0!#DIV/0!#DIV/0!49,671,358100.00%銷貨成本5,640,345100.00%3,935,56991.28%4,881,26581.46%5,631,13976.10%4,751,14670.85%6,057,79975.08%4,943,74478.40%4,937,69594.10%0#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!40,778,70182.91%材料3,026,64853.66%2,327,57953.98%3,234,26553.97%4,307,85058.22%3,103,33846.28%3,215,14839.85%2,920,03646.31%2,112,51740.26%#DIV/0!#DIV/0!#DIV/0!#DIV/0!24,247,38048.82%人工447,6777.94%348,8668.09%411,6966.87%444,7956.01%500,1157.46%569,3967.06%561,1678.90%617,79511.77%#DIV/0!#DIV/0!#DIV/0!#DIV/0!3,901,5077.85%製造費用1,849,78532.80%918,46221.30%1,274,05021.26%1,426,29119.28%1,302,77719.43%1,637,18220.29%1,660,76126.34%2,532,70248.26%#DIV/0!#DIV/0!#DIV/0!#DIV/0!12,602,00925.37%期初商品存貨1,268,87122.50%939,36621.79%619,48410.34%659,9478.92%1,210,75918.06%1,363,88716.90%741,56011.76%980,21918.68%#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!1,268,8712.55%期末商品存貨939,36616.65%619,48414.37%659,94711.01%1,210,75916.36%1,363,88720.34%741,5609.19%980,21915.54%1,382,18226.34%#DIV/0!#DIV/0!#DIV/0!#DIV/0!980,2191.97%免抵退货物不得抵扣税额-13,270-0.24%20,7810.48%1,7160.03%3,0140.04%-1,955-0.03%13,7460.17%40,4390.64%76,6441.46%#DIV/0!#DIV/0!#DIV/0!#DIV/0!141,1160.28%主營業銷售(營業)利潤-173-0.00%376,1658.72%1,111,03818.54%1,768,37723.90%1,954,71329.15%2,010,50724.92%1,362,22521.60%309,8045.90%0#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!8,892,65717.09%加:其他銷售(營業)收入24,1990.43%0.00%0.00%28,8040.39%320,0254.77%41,2340.51%0.00%398,6257.60%#DIV/0!#DIV/0!#DIV/0!#DIV/0!812,8861.64%減:其他业务支出、营业费用41,2450.73%50,5521.17%13,5250.23%68,3300.92%154,4102.30%62,6210.78%40,0460.64%78,3711.49%#DIV/0!#DIV/0!#DIV/0!#DIV/0!509,0981.02%管理費用502,8418.92%559,36812.97%402,1096.71%641,3028.67%846,11312.62%786,9769.75%637,96910.12%645,16512.29%#DIV/0!#DIV/0!#DIV/0!#DIV/0!5,021,84310.11%財務費用128,5442.28%123,8642.87%60,0841.00%118,7001.60%196,0092.92%184,6322.29%200,9333.19%74,9081.43%#DIV/0!#DIV/0!#DIV/0!#DIV/0!1,087,6742.19%營業利潤-648,604-11.50%-357,619-8.29%635,32010.60%968,84913.09%1,078,20616.08%1,017,51212.61%483,2797.66%-90,015-1.72%0#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!3,086,9275.41%0补贴收入0.00%00.00%0.00%0.00%6,0000.09%0.00%0.00%16,4090.31%#DIV/0!#DIV/0!#DIV/0!#DIV/0!22,4090.05%營業外收入18,0000.32%00.00%0.00%0.00%0.00%0.00%0.00%0.00%#DIV/0!#DIV/0!#DIV/0!#DIV/0!18,0000.04%減:營業外支出47,5000.84%0.00%0.00%3,5020.05%0.00%1,1050.01%0.00%31,6780.60%#DIV/0!#DIV/0!#DIV/0!#DIV/0!83,7850.17%加:以前年度损益调整(调减以“-”号表示)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%#DIV/0!#DIV/0!#DIV/0!#DIV/0!00.00%0利潤總額-678,104-12.02%-357,619-8.29%635,32010.60%965,34713.05%1,084,20616.17%1,016,40712.60%483,2797.66%-105,284-2.01%0#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!3,043,5515.32%企业所得税359,8504.46%359,8502.86%淨利潤-678,104-12.02%-357,619-8.29%635,32010.60%965,34713.05%1,084,20616.17%656,5578.14%483,2797.66%-105,284-2.01%0#DIV/0!0#DIV/0!0#DIV/0!0#DIV/0!2,683,7012.46%利润表会企02表编制单位:XXXXXX有限公司39325.0单位:元项目行数本月数本年累计数一、主营业务收入15,247,498.7249,671,357.81减:主营业务成本44,937,694.7040,778,701.10主营业务税金及附加5二、主营业务利润(亏损以“-”号填列)10309,804.028,892,656.71加:其他业务利润(亏损以“-”号填列)11398,625.04812,886.05减:营业费用1478,370.54509,097.77管理费用15645,164.735,021,843.20财务费用1674,908.481,087,674.30三、营业利润(亏损以“-”号填列)18-90,014.693,086,927.49加:投资收益(损失以“-”号填列)19补贴收入221640922409营业外收入2318000减:营业外支出2531677.8483,785.31四、利润总额(亏损总额以“-”号填列)27-105,283.533,043,551.18减:所得税28359850.09五、净利润(净亏损以“-”号填列)30-105,283.532,683,701.09补充资料:项目:本年累计数上年实际数1、出售、处置部门或被投资单位所得收益2、自然灾害发生的损失3、会计 政策 公共政策概论形成性考核册答案公共政策概论形成性考核册答案2018本科2018公共政策概论形成性考核册答案公共政策概论作业1答案公共政策概论形成考核册答案 变更增加(或减少)利润总额4、会计估计变更增加(或减少)利润总额5、债务重组损失6、其他现金流量表39325.0编制单位:XXXXXXXX公司单位:元项目行次金额一、经营活动产生的现金流量:  销售商品、提供劳务收到的现金154,735,198.391=收入+销项数额-应收帐款(期末-期初)+预收帐款(期末-期初)+其他业务利润-财务费用(现金折扣)-营业费用(销售折扣)  收到的税费返还31,977,368.623=应交税金(出口退税)-应收补贴款(期末-期初)  收到的其他与经营活动有关的现金870,197.828=营业外收入+利息收入现金流入小计956,782,764.839=1+3+8  购买商品、接受劳务支付的现金1037,744,932.7110=主营业务成本+进项税额-退进项转出-应付帐款(期末-期初)+预付帐款(期末-期初)+存货(期末-期初)-制造费用(工资、折旧、摊销)-生产成本(工资)  支付给职工以及为职工支付的现金128,822,535.4512=管理费用、制造费用、生产成本(工资、福利费)-应付工资(期末-期初)-应付福利费(期末-期初)-应交个人所得税(期末-期初)  支付的各项税费13359,850.0913=已交税金  支付的其他与经营活动有关的现金184,057,372.4818=其他应收款(期末-期初)+待摊费用(期末-期初)-其他应付款(期末-期初)+管理费用+营业费用+财务费用(手续费、工本费、不含调整现金银行的汇兑损益)+营业外支出+因定资产清理-管理费用(工资、福利、职工保险、折旧、摊销)-营业费用(销售折扣)现金流出小计2050,984,690.7320=10+12+13+18经营活动产生的现金流量净额215,798,074.1021=9-20二、投资活动产生的现金流量:  收回投资所收到的现金22  取得投资收益所收到的现金23  处置固定资产、无形资产和其他长期资产所收回的现金净额250.00  收到的其他与投资活动有关的现金28现金流入小计290.0029=22+23+25+28  购建固定资产、无形资产和其他长期资产所支付的现金301,595,150.2330=固定资产(期末-期初)+在建工程(期末-期初)+长期待摊费用(期末-期初)+长期待摊费用摊销  投资所支付的现金31  支付的其他与投资活动有关的现金3547,500.00现金流出小计361,642,650.2336=30+31+35投资活动产生的现金流量净额37-1,642,650.2337=29-36三、筹资活动产生的现金流量:  吸收投资所收到的现金38  借款所收到的现金400.00  收到的其他与筹资活动有关的现金43现金流入小计440.0044=38+40+43  偿还债务所支付的现金454,000,000.00  分配股利、利润和偿付利息所支付的现金46162,435.0046=利息支出-应付股利(期末-期初)  支付的其他与筹资活动有关的现金52现金流出小计534,162,435.00筹资活动产生的现金流量净额54-4,162,435.00四、汇率变动对现金的影响(汇兑损益中调整银行存款的部份)55-15,106.2455=仅含调整现金和银行存款的汇兑损益要录入五、现金及现金等价物净增加额56-22,117.3756=21+37+54+55补充资料行次金额1、将净利润调节为经营活动现金流量:  净利润572,683,701.0957=净利润加:计提的资产损失准备58  固定资产折旧591,184,175.8159=固定资产(期末-期初)  无形资产摊销60429,912.4060=长期等摊费用摊销  待摊费用减少(减:增加)61-88,582.5061=-待摊费用(期末-期初)  预提费用增加(减:减少)640.0062=预提费用(期末-期初)  处置固定资产、无形资产和其他长期资产的损失(减:收益)65  固定资产报废损失6747,500.00  财务费用(筹资活动和汇兑损益中调整银行存款的部份)68177,541.24筹资活动和汇兑损益中调整银行存款的部份  投资损失(减:收益)69  递延税款贷项(减:借项)70  存货的减少(减:增加)71-446,980.6661=-存货(期末-期初)  经营性应收项目的减少(减:增加)722,490,930.2062=-应收帐款(期末-期初)-其它应收款(期末-期初)-应收补贴款(期末-期初)-预付帐款(期末-期初)  经营性应付项目的增加(减:减少)73-680,123.4863=应付帐款(期末-期初)+其它应付款(期末-期初)+应付工资(期末-期初)+应付福利费(期末-期初)+应交税金(期末-期初)  其他(长期待摊费用的减少)74  经营活动产生的现金流量净额755,798,074.102、不涉及现金收支的投资和筹资活动  债务转为资本76  一年内到期的可转换公司债券77  融资租入固定资产783、现金及现金等价物净增加情况:  现金的期末余额795,310,716.82 减:现金的期初余额805,332,834.19 加:现金等价物的期末余额81 减:现金等价物的期初余额82现金及现金等价物净增加额83-22,117.37财务分析指标39325.0指标名称指标说明本年数理想 标准 excel标准偏差excel标准偏差函数exl标准差函数国标检验抽样标准表免费下载红头文件格式标准下载 提示一、获利能力分析1、销售净利率净利润/销售收入5.40%10.00%关注2、销售毛利率毛利润/销售收入17.90%15.00%良好3、成本费用利润率营业利润/(销售成本+销售费用+管理费用+财务费用)5.66%4、盈余现金保障倍数经营活动产生的现金流量净额/净利润216.05%良好5、总资产报酬率(净利润+利息费用+所得税)/资产平均值6.39%6、总资产收益率净利润/资产平均值6.02%越高越好7、资本保值增值率股东权益期末数/股东权益期初数111.36%8、净资产收益率净利润/股东权益平均数10.75%8.00%良好二、偿债能力分析1、流动比率流动资产/流动负债168.01%200.00%关注2、速动比率速动资产/流动负债123.64%100.00%良好3、现金流动负债比率经营活动产生的现金流量净额/流动负债33.59%良好1、资产负债率负债总额/资产总额39.62%70.00%关注2、产权比率负债总额/所有者权益总额65.63%120.00%关注3、已获利息倍数(税前利润+利息费用)/利息费用19.742.50良好三、资产管理效果分析1、流动资产周转情况分析(1)应收帐款周转率赊销收入净额/应收账款平均余额3.163.00(2)存货周转率销货成本/存货平均余额5.613.00(3)流动资产周转率产品销售成本净额/流动资产平均占用额1.661.002、固定资产周转率产品销售收入净额/固定资产平均净值3.673、总资产周转率产品销售收入净额/平均资产总额1.110.80四、发展能力分析1、销售(营业)增长率(本月与上月)(本月销售收入-上月销售收入)/上月销售收入38.98%2、资本积累率(所有者权益期末数-所有者权益期初数)/所有者权益年初数11.36%3、总资产增长率(资产期末数-资产期初数)/资产期初数-4.38%关注2007年1月至12月销售成本趋势图项目1月2月3月4月5月6月7月8月9月10月11月12月合计销售收入5,640,171.554,311,734.495,992,302.647,399,515.906,705,859.608,068,305.876,305,969.045,247,498.7249,671,357.81销售成本5,640,344.643,935,569.474,881,264.625,631,138.944,751,146.176,057,798.824,943,743.744,937,694.7040,778,701.10销售成本率100%91%81%76%71%75%78%94%82.10%异常说明:XXXXXXXXXXXXXX。说明:颜色表示本月数与本年平均数的高低(其它表格相同)蓝色:有利;红色:不利;颜色红色蓝色收入<>成本><销售成本率><应交税金明细表会企03表编制单位:XXXXXXXXXXXXXX公司39325.0单位:元项目行数本月数本年累计数一、增值税:1.应交增值税  (1)期初未抵扣数(用负号填列)1-173,956.96-224,491.95  (2)销项税额2274,598.171,211,861.37   出口退税397,312.771,977,368.62   进项税额转出4116,094.36239,157.13   转出多交增值税50.00  (3)进项税额6710,372.063,600,218.89   已交税金70.0089   转出未交增值税10  (4)期末未抵扣数(用负号填列)11-396,323.72-396,323.722.未交增值税  (1)期初未交数(多交数用负号填列)120.00  (2)本期转入数(多交数用负号填列)130.00  (3)已交数140.00  (4)期末未交数(多交数用负号填列)150.000.00二、消费税:1.期初未交数(多交数用负号填列)162.应交数173.已交数184.期末未交数(多交数有负号填列)19三、营业税:1.期初未交数(多交数用负号填列)202.应交数213.已交数224.期末未交数(多交数有负号填列)23四、城乡维护建设税:1.期初未交数(多交数用负号填列)242.应交数253.已交数264.期末未交数(多交数有负号填列)27五、企业所得税:1.期初未交数(多交数用负号填列)282.应交数29359,850.093.已交数30359,850.094.期末未交数(多交数有负号填列)310.000.00附:应交个人所得税1.年初数33,723.912.期末数47,683.803.期末-年初数13,959.89处置固定资产原值100,000.00固定资产清理(累计折旧)52,500.00处置固定资产收到的现金0.002007年1月至12月费用趋势图月份1月2月3月4月5月6月7月8月9月10月11月12月合计制造费用1,849,784.61918,461.551,274,050.391,426,291.291,302,776.671,637,181.701,660,760.692,532,702.0512,602,008.95管理费用502,841.20559,367.69402,109.43641,301.97846,113.49786,976.15637,968.54645,164.735,021,843.20营业费用41,244.8550,551.8413,524.7968,329.80154,409.7461,120.7138,545.5076,870.54504,597.77财务费用128,543.56123,864.4960,083.75118,700.15196,009.28184,631.83200,932.7674,908.481,087,674.30异常说明:①XXXXXXX。②XXXXXXX。③XXXXXXX。说明:1、红色:数据超过全年平均数;蓝色:数据低于全年平均数。2、部份单元格有批注说明。3、可在上列图表中,点击左上角的下拉框,选择您所需要的查看明细科目。2007年1至12月产成品入库明細匯總表异常说明:①XXXXXXX。②XXXXXXX。制造费用直接人工直接材料总入库成本销售收入月份物料消耗加工费工资折旧费长期待摊费用摊销低值易耗品摊销水电费租赁费模具开发费模具维修费设备维修费其它制造费用合计直接人工直接材料总入库成本销售收入1.0物料消耗1.0310,365.4589,714.05331,069.14123,622.8529,589.024,049.9975,634.0273,920.00558,671.20199,671.8347,527.065,950.001,849,784.61447,677.003,026,647.825,324,109.435,640,171.55加工费2.0130,662.5771,484.65321,985.48126,604.2629,589.023,013.2183,691.7673,920.0045,213.685,096.15970.0026,230.77918,461.55348,865.882,327,579.293,594,906.724,311,734.49工资3.0185,842.0497,371.79306,132.00129,362.2029,589.020.0068,153.0373,920.00252,190.8683,027.8446,796.611,665.001,274,050.39411,696.003,234,265.284,920,011.675,992,302.64折旧费4.0298,717.81202,610.45296,343.99129,846.3629,589.020.0068,188.0973,920.00248,794.5034,818.553,985.1239,477.401,426,291.29444,795.004,307,849.966,178,936.257,399,515.90长期待摊费用摊销5.0250,356.85203,173.15303,503.09129,952.4129,589.020.0068,188.0973,920.00182,979.5142,917.9916,596.561,600.001,302,776.67500,115.003,103,337.624,906,229.296,705,859.60低值易耗品摊销6.0517,309.59231,744.70276,802.00130,387.4130,794.580.0075,774.29161,895.00147,391.3545,038.3318,064.451,980.001,637,181.70569,395.903,215,148.145,421,725.748,068,305.87水电费7.0228,017.66471,953.26315,059.51130,760.1630,794.580.0078,722.9588,582.50232,001.7483,076.621,601.71190.001,660,760.69561,167.002,920,035.545,141,963.236,305,969.04租赁费8.0515,223.45837,922.70363,476.00133,823.1130,794.580.00121,195.4188,582.50243,433.61155,026.8739,406.423,817.402,532,702.05617,795.472,112,516.625,263,014.145,247,498.72模具开发费9.0模具维修费10.0设备维修费11.0其它12.0制造费用合计合計2,436,495.422,205,974.752,514,371.211,034,358.76240,328.847,063.20639,547.64708,660.001,910,676.45648,674.18174,947.9380,910.5712,602,008.953,901,507.2524,247,380.2740,750,896.4749,671,357.81直接人工直接材料总入库成本销售收入说明:1、颜色表示本月数与本年平均数的高低(其它表格相同)蓝色:有利;红色:不利;颜色红色蓝色收入<>成本><2、部份单元格有批注说明。3、可在上列图表中,点击左上角的下拉框,选择您所需要的查看明细科目。2007年1至12月管理費用明細匯總表异常说明:①XXXXXXX。②XXXXXXX。③XXXXXXX。④XXXXXXX。⑤XXXXXXX。月份差旅费办公费业务招待费职工福利费工资劳动保险费财产保险费折旧费长期待摊费用摊销低值易耗品摊销运输费职工培训费咨询费报关费租赁费水电费固定电话费IP电话费小灵通手机话费其它邮电费伙食费工会经费管理费用合計2.0差旅费1.030,081.2538,721.0024,783.0041,907.35120,348.0047,711.400.0026,547.9223,406.280.0027,159.990.000.0048,605.001,050.009,253.189,518.609,109.5012,263.133,133.0029,242.600.00502,841.20办公费2.014,248.007,238.0718,122.0018,030.70297,030.8443,101.004,790.0025,078.4923,406.28860.0015,942.530.000.000.0012,514.009,826.1812,312.9012,751.301,344.800.0042,770.600.00559,367.69业务招待费3.05,386.0019,670.7635,205.009,533.20122,767.0041,787.800.0025,078.4923,406.280.0018,649.97619.000.0053,353.001,050.0020,408.248,530.1010,948.3012,457.605,417.69-12,159.000.00402,109.43职工福利费4.0102,132.0014,058.9939,990.0077,322.91139,664.0065,382.900.0025,106.9823,406.286,638.8026,517.25600.0076,000.0014,884.650.007,636.459,137.4012,662.8010,343.205,466.36-15,649.000.00641,301.97工资5.019,907.0016,259.7824,996.0011,415.79144,737.00425,153.100.0025,106.9823,989.614,387.8619,969.501,190.000.004,826.000.007,576.4510,798.0012,798.408,884.31451.5183,666.200.00846,113.49劳动保险费6.043,284.3018,833.4984,055.0035,817.65153,680.0081,847.200.0025,106.9823,989.612,305.6435,326.590.001,000.0040,681.951,050.0030,668.1910,464.6012,405.5048,658.981,715.0028,333.49107,751.98786,976.15财产保险费7.024,254.0033,688.9557,913.0029,115.29168,396.0078,777.000.0025,106.9823,989.614,706.1837,827.85200.000.0057,384.990.0027,849.2610,890.1012,259.7032,633.807,919.335,056.50637,968.54折旧费8.012,359.0023,827.8554,929.5020,266.73163,812.00107,201.800.0025,184.2323,989.617,175.2545,417.710.0016,000.0040,853.800.0013,466.1611,630.8011,416.7026,275.008,367.0932,991.500.00645,164.73长期待摊费用摊销9.0低值易耗品摊销10.0运输费11.0职工培训费12.0咨询费合計251,651.55172,298.89339,993.50243,409.621,310,434.84890,962.204,790.00202,317.05189,583.5626,073.73226,811.392,609.0093,000.00260,589.3915,664.00126,684.1183,282.5094,352.20152,860.8232,469.98194,252.89107,751.985,021,843.20报关费租赁费水电费固定电话费、IP电话费小灵通、手机话费其它邮电费伙食费工会经费管理费用合計说明:1、红色:数据超过全年平均数;蓝色:数据低于全年平均数。2、部份单元格有批注说明。3、可在上列图表中,点击左上角的下拉框,选择您所需要的查看明细科目。2007年1至12月營業費用明細表匯總表异常说明:①XXXXXXX。②XXXXXXX。月份运输费销售折扣查验费营业费用合計1.0运输费1.031,044.850.0010,200.0041,244.85销售折扣2.020,951.6225,700.223,900.0050,551.84查验费3.09,624.790.003,900.0013,524.79营业费用合計4.064,029.800.004,300.0068,329.805.061,806.8286,902.925,700.00154,409.746.048,068.728,716.994,335.0061,120.717.034,663.1682.343,800.0038,545.508.063,607.509,863.043,400.0076,870.549.00.0010.00.0011.00.0012.00.00合計333,797.26131,265.5139,535.00504,597.77说明:1、红色:数据超过全年平均数;蓝色:数据低于全年平均数。2、部份单元格有批注说明。3、可在上列图表中,点击左上角的下拉框,选择您所需要的查看明细科目。2007年1至12月財務費用明細匯總表月份手续费利息收入利息支出现金折扣汇兑损益工本费财务费用合計5.0手续费1.02,318.000.0021,157.5061,731.9343,062.63273.50128,543.56利息收入2.01,106.50-1,534.5421,157.5059,276.2843,852.756.00123,864.49利息支出3.03,444.00-15,170.8419,110.0037,005.5915,695.000.0060,083.75现金折扣4.03,026.75-499.6621,157.5037,968.8456,955.2291.50118,700.15汇兑损益5.02,764.99-9.2920,475.0052,582.23120,196.35196,009.28工本费6.02,257.21-11,001.2321,157.5058,261.56113,956.790.00184,631.83财务费用合計7.01,027.76-1,573.2620,475.0053,000.77127,942.4960.00200,932.768.02,624.500.0017,745.0051,577.052,839.93122.0074,908.489.00.0010.00.0011.00.0012.00.00合計18,569.71-29,788.82162,435.00411,404.25524,501.16553.001,087,674.30异常说明:XXXXXXX。说明:1、红色:数据超过全年平均数;蓝色:数据低于全年平均数。2、部份单元格有批注说明。3、可在上列图表中,点击左上角的下拉框,选择您所需要的查看明细科目。
本文档为【财务报表分析模板】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
该文档来自用户分享,如有侵权行为请发邮件ishare@vip.sina.com联系网站客服,我们会及时删除。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
下载需要: ¥16.9 已有0 人下载
最新资料
资料动态
专题动态
个人认证用户
培训考核小魏子
叉车专业培训老师
格式:xls
大小:249KB
软件:Excel
页数:17
分类:金融会计考试
上传时间:2022-01-19
浏览量:11