建模用模型-2018 - 副本

上传人：1*** IP属地：江西上传时间：2023-06-01 格式：XLS 页数：120 大小：276.50KB 积分：12 举报 版权申诉

已阅读5页，还剩115页未读，继续免费阅读

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

2018/4/2512:00AM,,,,,,,,,,,,,,,

单位:万元,,=请输入数据,,,=计算结果,,,=链自他表,,,,,,,

,,,,,,,,,,,,,,,,

估值对象概况:,,公司代码,,,,公司名称,,,,行业名称,农林牧渔,,,货币单位,人民币万元

,,,,,,,,,,,,,,,,

历史资产负债表,,,,,,,,,,,,,,,

,,历史数据,,,,预测数据,,,,,,,,,

资产负债表项目,备注,2014,2015,2016,2017,2018E,2019F,2020F,2021F,2022F,2023F,2024F,2025F,2026F,2027F

-,,-,-,-,-,-,-,-,-,-,-,-,-,-,-

资产,,,,,,,,,,,,,,,

流动资产,,,,,,,,,,,,,,,

货币资金,,954.75,"4,774.28","33,665.44","18,249.99",,,,,,,,,,

交易性金融资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

应收票据,,0.00,0.00,0.00,0.00,,,,,,,,,,

应收账款净值,,"2,798.75","2,992.69","4,429.27","5,951.90",,,,,,,,,,

预付款项,,"2,132.27","1,004.28","1,467.95","1,459.99",,,,,,,,,,

应收利息,,0.00,0.00,0.00,0.00,,,,,,,,,,

应收股利,,0.00,0.00,0.00,0.00,,,,,,,,,,

其他应收款净值,,311.47,329.02,632.97,469.09,,,,,,,,,,

存货净值,,"11,832.71","13,467.94","25,960.82","33,036.03",,,,,,,,,,

待摊费用,,0.00,0.00,0.00,0.00,,,,,,,,,,

一年内到期的非流动资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

其他流动资产,,15.62,34.72,34.52,34.83,,,,,,,,,,

流动资产合计,,"18,045.56","22,602.94","66,190.97","59,201.82",,,,,,,,,,

非流动资产,,,,,,,,,,,,,,,

可供出售金融资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

持有至到期投资,,0.00,0.00,0.00,0.00,,,,,,,,,,

长期应收款,,0.00,0.00,0.00,0.00,,,,,,,,,,

长期股权投资净值,,0.00,0.00,5.00,5.00,,,,,,,,,,

投资性房地产,,0.00,0.00,0.00,0.00,,,,,,,,,,

固定资产净值,,"4,230.94","5,132.44","5,602.67","12,596.93",,,,,,,,,,

在建工程净值,,"1,439.01",137.84,504.02,"1,271.25",,,,,,,,,,

工程物资,,0.00,0.00,0.00,0.00,,,,,,,,,,

固定资产清理,,0.00,0.00,0.00,0.00,,,,,,,,,,

生产性生物资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

油气资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

无形资产净值,,"8,177.80","8,419.96","8,313.56","16,939.31",,,,,,,,,,

开发支出,,0.00,0.00,0.00,0.00,,,,,,,,,,

商誉,,0.00,0.00,0.00,0.00,,,,,,,,,,

长期待摊费用,,0.00,0.00,"2,339.44","6,538.37",,,,,,,,,,

递延所得税资产,,33.57,46.22,13.23,127.77,,,,,,,,,,

其他非流动资产,,0.00,0.00,0.00,0.00,,,,,,,,,,

非流动资产合计,,"13,881.33","13,736.46","16,777.92","37,478.64",,,,,,,,,,

资产总计,,"31,926.89","36,339.39","82,968.89","96,680.46",,,,,,,,,,

流动负债,,,,,,,,,,,,,,,

短期借款,,"7,410.00","2,300.00","10,200.00","11,000.00",,,,,,,,,,

交易性金融负债,,0.00,0.00,0.00,0.00,,,,,,,,,,

应付票据,,0.00,0.00,0.00,0.00,,,,,,,,,,

应付账款,,294.59,203.57,"3,378.43","2,117.04",,,,,,,,,,

预收款项,,418.88,573.67,83.41,"1,697.64",,,,,,,,,,

应付职工薪酬,,49.30,32.65,73.96,580.19,,,,,,,,,,

应交税费,,255.10,225.91,295.10,447.92,,,,,,,,,,

应付利息,,31.13,35.89,13.26,28.60,,,,,,,,,,

应付股利,,0.00,0.00,0.00,0.00,,,,,,,,,,

其他应付款,,195.48,464.01,417.27,814.31,,,,,,,,,,

一年内到期的非流动负债,,0.00,"3,000.00","1,500.00",0.00,,,,,,,,,,

其他流动负债,,0.00,0.00,0.00,0.00,,,,,,,,,,

流动负债合计,,"8,654.47","6,835.70","15,961.43","16,685.69",,,,,,,,,,

非流动负债,,,,,,,,,,,,,,,

长期借款,,"4,500.00","3,000.00","1,500.00","4,500.00",,,,,,,,,,

应付债券,,0.00,0.00,0.00,0.00,,,,,,,,,,

长期应付款,,430.07,540.07,80.00,80.00,,,,,,,,,,

专项应付款,,0.00,0.00,129.17,462.38,,,,,,,,,,

预计负债,,0.00,0.00,0.00,176.89,,,,,,,,,,

递延所得税负债,,0.00,0.00,0.00,0.00,,,,,,,,,,

其他非流动负债,,0.00,0.00,0.00,0.00,,,,,,,,,,

非流动负债合计,,"4,930.07","3,540.07","1,709.17","5,219.27",,,,,,,,,,

负债总计,,"13,584.54","10,375.77","17,670.60","21,904.96",,,,,,,,,,

所有者权益（或股东权益）,,,,,,,,,,,,,,,

实收资本（或股本）,,"5,593.73","6,293.73","8,393.73","8,393.73",,,,,,,,,,

资本公积,,"1,030.10","3,244.28","34,037.85","34,042.68",,,,,,,,,,

减：库存股,,0.00,0.00,0.00,0.00,,,,,,,,,,

盈余公积,,"2,052.82","2,523.19","3,173.45","4,117.89",,,,,,,,,,

未分配利润,,"9,525.48","13,758.84","19,550.05","28,074.82",,,,,,,,,,

留存收益,,"11,578.29","16,282.02","22,723.50","32,192.71",,,,,,,,,,

外币报表折算差额,,0.00,0.00,0.00,0.00,,,,,,,,,,

归属于母公司所有者权益合计,,"18,202.12","25,820.04","65,155.08","74,629.12",,,,,,,,,,

少数股东权益,,140.23,143.58,143.21,146.38,,,,,,,,,,

所有者权益总计,,"18,342.35","25,963.62","65,298.29","74,775.49",,,,,,,,,,

负债及所有者权益总计,,"31,926.89","36,339.39","82,968.89","96,680.46",,,,,,,,,,

,,,,,,,,,,,,,,,,

Check,,OK,OK,OK,OK,,,,,,,,,,

,,,,,,,,,,,,,,,,

历史损益表,,,,,,,,,,,,,,,

,,历史数据,,,,,,,,,,,,,

损益表项目,备注,2014,2015,2016,2017,2018E,2019F,2020F,2021F,2022F,2023F,2024F,2025F,2026F,2027F

-,-,-,-,-,-,,,,,,,,,,

一、营业收入,,"15,779.18","19,054.45","25,746.55","34,194.76",,,,,,,,,,

减：营业成本,,"9,958.57","12,203.61","16,624.96","22,009.98",,,,,,,,,,

税金及附加,,85.87,123.00,86.64,291.86,,,,,,,,,,

销售费用,,551.50,608.14,"1,009.70","1,806.21",,,,,,,,,,

管理费用,,645.15,698.26,985.46,"1,133.77",,,,,,,,,,

财务费用,,605.69,637.07,735.79,227.09,,,,,,,,,,

资产减值损失,,124.54,71.85,181.16,234.40,,,,,,,,,,

加：公允价值变动收益（损失以“-”号填列）,,0.00,0.00,0.00,0.00,,,,,,,,,,

投资收益（损失以“-”号填列）,,0.00,0.05,0.00,0.00,,,,,,,,,,

其他收益,,0.00,0.00,0.00,0.00,,,,,,,,,,

二、营业利润（亏损以“-”号填列）,,"3,808","4,713","6,123","8,491",,,,,,,,,,

加：营业外收入,,0.10,91.88,500.07,341.28,,,,,,,,,,

减：营业外支出,,10.65,20.32,53.77,82.16,,,,,,,,,,

其中：非流动资产处置损失,,10.65,20.20,0.03,6.84,,,,,,,,,,

三、利润总额（亏损总额以“-”号填列）,,"3,797","4,784","6,569","8,751",,,,,,,,,,

减：所得税费用,,73.68,77.04,128.04,70.61,,,,,,,,,,

四、净利润（净亏损以“-”号填列）,,"3,724","4,707","6,441","8,680",,,,,,,,,,

归属于母公司所有者的净利润,,"3,726.91","4,703.73","6,441.47","8,676.79",,,,,,,,,,

少数股东损益,,-3.28,3.36,-0.37,3.17,,,,,,,,,,

五、每股收益：,,,,,,,,,,,,,,,

（一）基本每股收益,,0.42,0.57,1.01,1.03,,,,,,,,,,

（二）稀释每股收益,,0.67,0.84,1.01,1.03,,,,,,,,,,

,,,,,,,,,,,,,,,,

历史现金流量表,,,,,,,,,,,,,,,

,,历史数据,,,,,,,,,,,,,

现金流量表项目,备注,2014,2015,2016,2017,2018E,2019F,2020F,2021F,2022F,2023F,2024F,2025F,2026F,2027F

-,-,-,-,-,-,,,,,,,,,,

净利润,,,,,,,,,,,,,,,

加：少数股东损益,,,,,,,,,,,,,,,

计提的资产减值准备,,,,,,,,,,,,,,,

折旧和摊销,,,,,,,,,,,,,,,

财务费用,,,,,,,,,,,,,,,

投资损失（减：收益）,,,,,,,,,,,,,,,

公允价值变动损失(减:收益),,,,,,,,,,,,,,,

递延所得税资产减少（减：增加）,,,,,,,,,,,,,,,

递延所得税负债增加（减：减少）,,,,,,,,,,,,,,,

营运资金的减少（减:增加）,,,,,,,,,,,,,,,

其他,,,,,,,,,,,,,,,

经营活动现金流量,,334.89,"4,751.72","-4,530.98","4,402.32",,,,,,,,,,

,,,,,,,,,,,,,,,,

短期投资,,,,,,,,,,,,,,,

资本性支出,,,,,,,,,,,,,,,

其他长期资产减少,,,,,,,,,,,,,,,

长期投资减少,,,,,,,,,,,,,,,

公允价值变动收益,,,,,,,,,,,,,,,

投资收益,,,,,,,,,,,,,,,

投资活动现金流量,,"-5,502.65",-528.96,"-3,783.45","-21,499.75",,,,,,,,,,

,,,,,,,,,,,,,,,,

应付债券的增加(减少),,,,,,,,,,,,,,,

长期借款的增加(减少),,,,,,,,,,,,,,,

其他长期负债增加,,,,,,,,,,,,,,,

财务费用,,,,,,,,,,,,,,,

普通股增加,,,,,,,,,,,,,,,

资本公积增加,,,,,,,,,,,,,,,

股利,,,,,,,,,,,,,,,

货币折算差额减少,,,,,,,,,,,,,,,

计入短期借款前融资活动现金流量,,,,,,,,,,,,,,,

短期借款的增加(减少),,,,,,,,,,,,,,,

筹资活动现金流量,,"-1,087.06",-403.23,"37,205.59","1,681.98",,,,,,,,,,

,,,,,,,,,,,,,,,,

现金净增加/减少,,,,,,,,,,,,,,,

现金期初余额,,,,,,,,,,,,,,,

现金期末余额,,,,,"18,250",,,,,,,,,,

,,,,,,,,,,,,,,,,

应收账款原值,,"2,993","3,243","4,809","6,574",,,,,,,,,,

应收账款坏账准备,,194.05,250.50,379.63,622.09,,,,,,,,,,

,,,,,,,,,,,,,,,,

其他应收款原值,,334,367,678,502,,,,,,,,,,

其他应收款坏账准备,,22.67,38.07,45.11,33.30,,,,,,,,,,

,,,,,,,,,,,,,,,,

存货原值,,"11,833","13,468","25,961","33,036",,,,,,,,,,

存货跌价准备,,0.00,0.00,0.00,0.00,,,,,,,,,,

,,,,,,,,,,,,,,,,

股利,,0.00,0.00,0.00,0.00,,,,,,,,,,

毛利,,"5,821","6,851","9,122","12,185",,,,,,,,,,

,,,,,,,,,,,,,,,,

人人文库> 全部分类> 教育资料 > 课件下载

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

建模用模型-2018 - 副本

文档简介

温馨提示

最新文档

评论

建模用模型-2018 - 副本

文档简介

温馨提示

最新文档

评论

相关文档