finance model财务估值模型
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
减： 超额现金 非经营性资产
= 投资资本IC
本期净投资
5,560,000.00 732,297,779.24
0.00 4,240,687,180.35
672,000,000.00 791,982,903.84 791,982,903.84
1,209,600,000.00 292,695,462.76 292,695,462.76
0.00 1,780,672,047.58
29,261,765.95 68,267,343.86
0.00 2,932,170,828.21
96,598,416.96 38,572,430.85 36,900,160.63 5,288,217,373.33 25,551,508,762.08
#NAME?
200,000,000.00
0.00
103,019,246.47 4.21
184,877,351.32 18.17
737,466,727.99 13,536,490,724.02
0.00 14,761,854,049.80
500,000,000.00 0.00 0.00 0.00 0.00
673,576,307.62
18,440,807.91 5.09
440,336,219.79 1.50
112,532,331.35 2.84
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
0.00 0.00 96,598,416.96 0.00 36,900,160.63 #NAME? #NAME?
短期借款 以公允价值计量且其变动计入当期损益的 金融负债 应付票据及账款
营业成本*2/(期初额+期末额) 预收账款
营业收入*2/(期初额+期末额) 其他应付款 混业经营金融类负债 其他流动负债 流动负债合计 长期带息债务 长期应付款 专项应付款 预计负债 其他非流动负债
预测方法
2013-12-31
2014-12-31
0.00 0.00 29,715,054.46
97,472,800.37
675,121.07 598,874,803.34
0.00 726,737,779.24
0.00 0.00 0.00 0.00 5,560,000.00
0.00
0.00
51,004,796.57 3.68
137,252,963.04 5.21
单位：元
资产负债表
1、资产： 2、负债：
货币资金 以公允价值计量且其变动计入当期损益的 金融资产 应收票据及账款
营业收入*2/(期初额+期末额) 预付账款
营业成本*2/(期初额+期末额) 其他应收款
营业收入*2/(期初额+期末额) 存货
营业成本*2/(期初额+期末额) 混业经营金融类资产 其他流动资产 流动资产合计 长期应收款 长期股权投资 投资性房地产 固定资产 在建工程 无形资产 开发支出 商誉 金融资产投资 长期待摊费用 其他非流动资产 非流动资产合计 资产总计
0.00
276,748,365.75 7.77
67,471,031.31 5.09
1,679,267,563.64 1.50
134,922,022.30 4.79
3,283,710,830.66 5,277,548,001.56 20,263,291,388.75
0.00 305,774,379.29
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
0.00 0.00 96,598,416.96 0.00 36,900,160.63 #NAME? #NAME?
#NAME?
0.00
132,970,914.12 7.77
123,673,862.42 15.08
781,229,249.40 11,897,503,941.35
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
#NAME?
0.00
77,960,559.44 3.01
77,869,656.31 15.08
781,229,249.40 11,897,503,941.35
266,256,761.83 0.00
395,582,020.64 19,076,072.84
186,733,944.30 0.00
2,932,170,828.21 97,916,135.18 39,551,848.69 0.00
3,937,287,611.69 21,471,098,079.68
9,543,623,573.53
0.00 5.00 96,598,416.96 19,286,265.43 36,900,160.63 #NAME? #NAME?
#NAME?
0.00
181,309,602.72 7.77
47,458,988.75 5.09
1,185,533,504.41 1.50
5,708,776.93 2.13
3,558,321,299.00 6,827,161,958.67 6,827,161,958.67
1,911,612,478.71 377,412,004.96
1,534,200,473.75 8,169,289,461.16
7,503,914.09 8,176,793,375.25 23,438,647,425.05 -1,967,549,345.37
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
0.00 #NAME? #NAME? #NAME? #NAME?
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
200,000,000.00 500,000,000.00 700,000,000.00
3,989,575,273.13
0.00
103,973,294.49 7.99
20,582,565.24 10.47
1,556,989,021.19 0.69 0.00 0.00
5,705,945.07 220,295,702.13 5,897,121,801.25
0.00 0.00 0.00 48,481,119.22 0.00 130,497,913.04 0.00 4,731,868.08 28,200,000.00 11,361,946.48 0.00 223,272,846.82 6,120,394,648.07
0.00 0.00%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2,218,399,182.16 1,749,411,918.77
0.00 468,987,263.39
5,897,121,801.25 3,983,455,203.08
0.00 1,913,666,598.17
726,737,779.24 0.00 0.00
0.00 3,164,359,243.61 2,439,551,477.55
724,807,766.06 #NAME?
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
0.00 #NAME? 3,164,359,243.61 #NAME? #NAME?
资产与负债和股东权益的差额 资产与负债和股东权益的差额(%)
带息债务
带息短债 带息长债 带息债务合计
带息债务增量
经营营运资 本
流动资产 减： 超额现金
金融资产 = 经营流动资产
流动负债 减： 短期借款
交易性金融负债 = 经营流动负债
经营营运资本 经营营运资本增量
投资资本IC 净资产
加： 少数股东权益 带息债务合计
0.00
111,846,208.49 3.01
127,064,939.98 15.08
781,229,249.40 11,897,503,941.35
0.00 13,591,220,646.84
300,000,000.00 0.00 0.00 0.00 0.00
#NAME?
0.00
60,862,360.87 3.01
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
#NAME?
0.00
33,625,120.85 3.01
84,130,758.28 15.08
781,229,249.40 11,897,503,941.35
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
-8.39%
2,439,551,477.55 1,911,612,478.71
527,938,998.84 12,825,034,735.22
6,145,495.83 12,831,180,231.05 26,722,400,877.89 -1,170,892,115.81
-4.38%
#NAME? #NAME? 6,827,161,958.67 #NAME?
0.00
209,684,465.99 7.77
34,526,461.33 5.09
837,199,005.53 1.50
190,428,408.53 1.60
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
500,000,000.00 15,261,854,049.80
300,000,000.00 13,891,220,646.84
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
1,853,892,052.00 4,403,784,930.45 4,403,784,930.45
225,125,655.39
1,689,108,559.23 65,993.28
1,689,174,552.51 2,421,472,331.75
0.00 0.00%
377,412,004.96 225,125,655.39 152,286,349.57 1,879,707,467.72
0.00 1,879,707,467.72 6,120,394,648.07
2019-12-31
12,057,031,631.16
0.00
328,419,125.85 13.53
59,423,295.60 8.10
1,451,449,900.30 1.95 0.00 0.00
2,845,992,934.63 791,493,580.45
17,533,810,467.99 0.00
726,737,779.24
4,240,687,180.35 0.00 0.00
4,240,687,180.35
-257,750,515.85
-2,327,020,582.18 -2,069,270,066.33
1,689,108,559.23 65,993.28 0.00
1,749,411,918.77 0.00
-60,237,366.26
1,879,707,467.72 0.00 0.00
3,983,455,203.08 28,200,000.00
-2,131,947,735.36
-2,071,710,369.10
2015-12-31
2016-12-31
2017-12-31
2018-12-31
1,751,896,667.45 0.00
49,190,109.27
7,809,903.97
209,371,845.25
0.00
130,656.22 200,000,000.00 2,218,399,182.16
0.00 0.00 0.00 51,847,286.09 0.00 133,690,035.63 0.00 4,731,868.08 0.00 12,803,959.79 0.00 203,073,149.59 2,421,472,331.75
859,097.97 4,051,570,322.77
0.00 4,240,687,180.35
0.00 0.00 0.00 0.00 0.00
3、股东权 益：
非流动负债合计 负债合计
股本 资本公wk.baidu.com 其中：期初资本公积
本期发行溢价 新增其他资本公积 累计留存收益 其中：期初留存收益 当期留存收益 归属母公司股东的权益 少数股东权益 股东权益合计 负债和股东权益合计
= 投资资本IC
本期净投资
5,560,000.00 732,297,779.24
0.00 4,240,687,180.35
672,000,000.00 791,982,903.84 791,982,903.84
1,209,600,000.00 292,695,462.76 292,695,462.76
0.00 1,780,672,047.58
29,261,765.95 68,267,343.86
0.00 2,932,170,828.21
96,598,416.96 38,572,430.85 36,900,160.63 5,288,217,373.33 25,551,508,762.08
#NAME?
200,000,000.00
0.00
103,019,246.47 4.21
184,877,351.32 18.17
737,466,727.99 13,536,490,724.02
0.00 14,761,854,049.80
500,000,000.00 0.00 0.00 0.00 0.00
673,576,307.62
18,440,807.91 5.09
440,336,219.79 1.50
112,532,331.35 2.84
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
0.00 0.00 96,598,416.96 0.00 36,900,160.63 #NAME? #NAME?
短期借款 以公允价值计量且其变动计入当期损益的 金融负债 应付票据及账款
营业成本*2/(期初额+期末额) 预收账款
营业收入*2/(期初额+期末额) 其他应付款 混业经营金融类负债 其他流动负债 流动负债合计 长期带息债务 长期应付款 专项应付款 预计负债 其他非流动负债
预测方法
2013-12-31
2014-12-31
0.00 0.00 29,715,054.46
97,472,800.37
675,121.07 598,874,803.34
0.00 726,737,779.24
0.00 0.00 0.00 0.00 5,560,000.00
0.00
0.00
51,004,796.57 3.68
137,252,963.04 5.21
单位：元
资产负债表
1、资产： 2、负债：
货币资金 以公允价值计量且其变动计入当期损益的 金融资产 应收票据及账款
营业收入*2/(期初额+期末额) 预付账款
营业成本*2/(期初额+期末额) 其他应收款
营业收入*2/(期初额+期末额) 存货
营业成本*2/(期初额+期末额) 混业经营金融类资产 其他流动资产 流动资产合计 长期应收款 长期股权投资 投资性房地产 固定资产 在建工程 无形资产 开发支出 商誉 金融资产投资 长期待摊费用 其他非流动资产 非流动资产合计 资产总计
0.00
276,748,365.75 7.77
67,471,031.31 5.09
1,679,267,563.64 1.50
134,922,022.30 4.79
3,283,710,830.66 5,277,548,001.56 20,263,291,388.75
0.00 305,774,379.29
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
0.00 0.00 96,598,416.96 0.00 36,900,160.63 #NAME? #NAME?
#NAME?
0.00
132,970,914.12 7.77
123,673,862.42 15.08
781,229,249.40 11,897,503,941.35
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
#NAME?
0.00
77,960,559.44 3.01
77,869,656.31 15.08
781,229,249.40 11,897,503,941.35
266,256,761.83 0.00
395,582,020.64 19,076,072.84
186,733,944.30 0.00
2,932,170,828.21 97,916,135.18 39,551,848.69 0.00
3,937,287,611.69 21,471,098,079.68
9,543,623,573.53
0.00 5.00 96,598,416.96 19,286,265.43 36,900,160.63 #NAME? #NAME?
#NAME?
0.00
181,309,602.72 7.77
47,458,988.75 5.09
1,185,533,504.41 1.50
5,708,776.93 2.13
3,558,321,299.00 6,827,161,958.67 6,827,161,958.67
1,911,612,478.71 377,412,004.96
1,534,200,473.75 8,169,289,461.16
7,503,914.09 8,176,793,375.25 23,438,647,425.05 -1,967,549,345.37
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
0.00 #NAME? #NAME? #NAME? #NAME?
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
200,000,000.00 500,000,000.00 700,000,000.00
3,989,575,273.13
0.00
103,973,294.49 7.99
20,582,565.24 10.47
1,556,989,021.19 0.69 0.00 0.00
5,705,945.07 220,295,702.13 5,897,121,801.25
0.00 0.00 0.00 48,481,119.22 0.00 130,497,913.04 0.00 4,731,868.08 28,200,000.00 11,361,946.48 0.00 223,272,846.82 6,120,394,648.07
0.00 0.00%
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2,218,399,182.16 1,749,411,918.77
0.00 468,987,263.39
5,897,121,801.25 3,983,455,203.08
0.00 1,913,666,598.17
726,737,779.24 0.00 0.00
0.00 3,164,359,243.61 2,439,551,477.55
724,807,766.06 #NAME?
6,145,495.83 #NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
0.00 #NAME? 3,164,359,243.61 #NAME? #NAME?
资产与负债和股东权益的差额 资产与负债和股东权益的差额(%)
带息债务
带息短债 带息长债 带息债务合计
带息债务增量
经营营运资 本
流动资产 减： 超额现金
金融资产 = 经营流动资产
流动负债 减： 短期借款
交易性金融负债 = 经营流动负债
经营营运资本 经营营运资本增量
投资资本IC 净资产
加： 少数股东权益 带息债务合计
0.00
111,846,208.49 3.01
127,064,939.98 15.08
781,229,249.40 11,897,503,941.35
0.00 13,591,220,646.84
300,000,000.00 0.00 0.00 0.00 0.00
#NAME?
0.00
60,862,360.87 3.01
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
#NAME?
0.00
33,625,120.85 3.01
84,130,758.28 15.08
781,229,249.40 11,897,503,941.35
0.00 #NAME? #NAME?
0.00 0.00 0.00 0.00
-8.39%
2,439,551,477.55 1,911,612,478.71
527,938,998.84 12,825,034,735.22
6,145,495.83 12,831,180,231.05 26,722,400,877.89 -1,170,892,115.81
-4.38%
#NAME? #NAME? 6,827,161,958.67 #NAME?
0.00
209,684,465.99 7.77
34,526,461.33 5.09
837,199,005.53 1.50
190,428,408.53 1.60
3,283,710,830.66 5,277,548,001.56 #NAME?
0.00 305,774,399.29
0.00 #NAME?
0.00 #NAME?
500,000,000.00 15,261,854,049.80
300,000,000.00 13,891,220,646.84
#NAME? #NAME?
#NAME? #NAME?
#NAME? #NAME?
1,853,892,052.00 4,403,784,930.45 4,403,784,930.45
225,125,655.39
1,689,108,559.23 65,993.28
1,689,174,552.51 2,421,472,331.75
0.00 0.00%
377,412,004.96 225,125,655.39 152,286,349.57 1,879,707,467.72
0.00 1,879,707,467.72 6,120,394,648.07
2019-12-31
12,057,031,631.16
0.00
328,419,125.85 13.53
59,423,295.60 8.10
1,451,449,900.30 1.95 0.00 0.00
2,845,992,934.63 791,493,580.45
17,533,810,467.99 0.00
726,737,779.24
4,240,687,180.35 0.00 0.00
4,240,687,180.35
-257,750,515.85
-2,327,020,582.18 -2,069,270,066.33
1,689,108,559.23 65,993.28 0.00
1,749,411,918.77 0.00
-60,237,366.26
1,879,707,467.72 0.00 0.00
3,983,455,203.08 28,200,000.00
-2,131,947,735.36
-2,071,710,369.10
2015-12-31
2016-12-31
2017-12-31
2018-12-31
1,751,896,667.45 0.00
49,190,109.27
7,809,903.97
209,371,845.25
0.00
130,656.22 200,000,000.00 2,218,399,182.16
0.00 0.00 0.00 51,847,286.09 0.00 133,690,035.63 0.00 4,731,868.08 0.00 12,803,959.79 0.00 203,073,149.59 2,421,472,331.75
859,097.97 4,051,570,322.77
0.00 4,240,687,180.35
0.00 0.00 0.00 0.00 0.00
3、股东权 益：
非流动负债合计 负债合计
股本 资本公wk.baidu.com 其中：期初资本公积
本期发行溢价 新增其他资本公积 累计留存收益 其中：期初留存收益 当期留存收益 归属母公司股东的权益 少数股东权益 股东权益合计 负债和股东权益合计