《Excel表格模板:年度财务报告0428.xlsx》由会员分享,可在线阅读,更多相关《Excel表格模板:年度财务报告0428.xlsx(3页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、年度财务报表2010您的公司名称关键指标收入营业利润利息折旧净利润1,650,446767,55331,48550,241614,83610%1%0%1%3%所有指标指标今年(2010)去年(2009)变化百分比5 年趋势收入1,650,445.611,506,874.6510%营业费用816,743.71789,012.784%营业利润767,552.62756,432.551%折旧50,241.1149,742.121%利息31,485.3031,361.280%净利润614,835.94597,479.583%税款283,356.76274,988.623%税后利润406,077.403
2、98,950.532%指标 1155.78142.939%指标 2204.84201.722%指标 3246.76231.936%指标 4137.62137.060%指标 59.158.923%指标 62.972.816%输入您的财务数据 最多可以定义 25 个关键指标指标名称2006200720082009201020112012收入1,250,000.001,341,374.551,427,283.841,506,874.651,650,445.611,800,266.391,805,838.85营业费用650,000.00709,623.12759,248.66789,012.78816
3、,743.71808,833.31944,194.58营业利润600,000.00642,073.04688,576.91756,432.55767,552.62773,178.36734,259.96折旧5,000,000.0045,177.7346,569.2549,742.1250,241.1150,684.23500,000.00利息25,000.0027,458.2128,931.1231,361.2831,485.3033,383.0737,894.73净利润540,000.00547,610.76558,608.16597,479.58614,835.94662,721.0267
4、4,748.59税款220,000.00239,205.46255,767.41274,988.62283,356.76294,245.32314,082.56税后利润320,000.00349,434.92384,185.32398,950.53406,077.40424,382.04502,476.84指标 1128.00128.12137.84142.93155.78167.87199.64指标 2182.00185.93192.21201.72204.84218.44260.20指标 3191.00205.56218.75231.93246.76263.96310.87指标 4121.00122.18125.93137.06137.62145.90149.25指标 57.507.948.538.929.1510.0310.37指标 62.302.532.732.812.973.093.45在这里定义关键指标 报表顶部最多可显示 5 个关键指标1收入2营业利润3利息4折旧5净利润