序号 | 方程 |
1 | GDP增长率 = 0.09 |
2 | GDP增长量 = GDP * GDP增长率 |
3 | GDP = INTEG (GDP增长量,489,300.6) |
4 | 国内高速增长率 = 0.0914 |
5 | 高内高速增长量 = 国内高速总里程 * 国内高速增长量 |
6 | 国内高速总里程 = INTEG(国内高速增长量,8.49) |
7 | 国内汽车增长率 = 0.18 |
8 | 国内汽车增长量 = 国内汽车总量 * 国内汽车增长率 |
9 | 国内汽车总量 = INTEG (国内汽车增长量,7326) |
10 | 出生率 = 0.0122 |
11 | 死亡率 = 0.00713 |
12 | 出生人口 = 人口总量 * 出生率 |
13 | 死亡人口 = 人口总量 * 死亡率 |
14 | 人口总量 = INTEG (出生人口−死亡人口,134,735) |
15
| 员工变化率 = WITHLOOKUP (Time, ([(2011, −0.06) − (2020, 0.2)], (2011, 0.098), (2012, 0.008), (2013, 0.004), (2014, 0.18), (2015, −0.05), (2016, 0.056), (2017, 0.056), (2018, 0.056), (2019, 0.056), (2020, 0.056)) |
16
| 薪资待遇 = WITHLOOKUP(Time, ([(2011, 0) − (2020, 60,000)], (2011, 27,735.3), (2012, 28,874.6), (2013, 44,975.4), (2014, 13,283.8), (2015, 11,814.8), (2016, 13,856.8), (2017, 13,856), (2018, 13,856), (2019, 13,856), (2020, 13,856)) |
17 | 员工工资 = 员工数量 * 薪资待遇 |
18 | 房地产销售收入 = WITHLOOKUP (Time, ([(2011, 0) − (2020, 200,000)], (2011, 0), (2012, 103,361), (2013, 14,936.2), (2014, 87,037.1), (2015, 138,587), (2016, 31,645.6), (2017, 85,794.1), (2018, 94,055), (2019, 103,111), (2020, 113,040)) |
19 | 技术服务销售收入 = WITHLOOKUP (Time, ([(2011, 0) − (2020, 2000)], (2011, 1000.4), (2012, 1350.4), (2013, 857.87), (2014, 989.72), (2015, 261.44), (2016, 150.4), (2017, 198.5), (2018, 134.9), (2019, 91.7), (2020, 62.3) |
20 | 成品油销售收入 = WITHLOOKUP(Time, ([(2011, 0) − (2022, 8000)], (2011, 0), (2012, 0), (2013, 0), (2014, 0), (2015, 0), (2016, 6510.6), (2017, 6511), (2018, 6511), (2019, 6511), (2020, 6511)) |
21 | 收费价格 = IF THEN ELSE(Time ≤ 2020, 0.45, 0) |
22 | 运营成本 = 高速公路总里程 * (养护费用 + 折旧摊销) + 管理费用 |
23 | 年通行量 * 收费价格 * 高速公路总里程/10,000 |
24 | 年收益 = 现金流入 − 现金流出 |
25 | 在建工程 = 其他费用 + 贷款本金 + 资本金 |