上市公司財務(wù)指標(biāo)縱向及橫向分析EXCEL模板(內(nèi)帶自動計算公式)

1、財務(wù)指標(biāo)橫向分析（2006年）.相對估值法排名代碼簡稱每股收益（元）每股凈資產(chǎn)（元）毛利率（%）凈利率（%）凈資產(chǎn)收益率（）主營業(yè)努收入增長率（%）行業(yè)中值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皇臺酒業(yè)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數(shù)據(jù)來源：WIND資訊凈利潤增長率（）應(yīng)收賬款周轉(zhuǎn)率（次）存貨周轉(zhuǎn)率（次）流動比率（倍）速動比率（倍）資產(chǎn)員債率（%）最新日期最新價恪（元）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