上市公司财务指标纵向及横向分析EXCEL模板(内带自动计算公式)

1、财务指标横向分析（2006年）.相对估值法排名代码简称每股收益（元）每股净资产（元）毛利率（%）净利率（%）净资产收益率（）主营业努收入增长率（%）行业中值0.21002.5250.0512.548.8524.571000568泸州老窖0.39002.5256.4218.0115.3228.332000596古井贡酒0.05603.5033.391.431.6040.843000799S*ST酒鬼-0.77001.7550.05-115.81-44.21-43.514000858五粮液0.43203.0552.8015.8414.1715.075000995皇台酒业0.01101.9638.3

2、31.810.5833.546600197伊力特0.22001.9449.1920.0811.3212.217600199金种子酒0.07602.0113.732.593.760.528600519贵州茅台1.59006.2583.8430.7225.5124.579600702沱牌曲酒0.05914.9433.922.461.20-0.3510600735*ST锦股-0.19700.125.98-39.88-162.95-26.2611600779水井坊0.21002.3770.9712.548.7033.1912600809山西汾酒0.60402.5873.6717.2123.3641.7

3、2数据来源：WIND资讯净利润增长率（）应收账款周转率（次）存货周转率（次）流动比率（倍）速动比率（倍）资产员债率（%）最新日期最新价恪（元）47.8617.901.031.990.9436.152007-11-0124.33628.8952.520.682.010.9835.362007-11-0262.91158.4533.801.081.560.4839.992007-11-0218.9916.553.090.230.610.0859.542007-11-0230.8447.861,515.712.362.471.7319.732007-11-0243.90-58.651.990.561

4、.170.6144.992007-11-026.55540.0515.111.102.741.6319.262007-11-0210.21235.675.823.411.340.7034.822007-11-028.1034.4788.120.411.991.4136.152007-11-02184.0735.8719.940.721.330.4333.742007-11-0213.76-72.184.373.840.380.2286.432007-11-0211.1229.6413.470.312.150.9437.922007-11-0224.3397.5417.901.032.751.8427.232007-11-0231.79每股收益（元）市盈率PE市净率PB07E08E0607E08E0.44210.6355115.8677.3445.9810.830.74991.1645161.3183.8954.0223.45339.115.3817.150.44210.6355101.6299.3069.0817.64595.453.4046.414.960.22000.3300106.5836.8224.553.572.25833.2165115.7781.5157.2325.270.18330.3050232.8375.074