【Excel计算表】源、网、荷、储一体化(变电站)财务测算表VIP专享

项目总投资估算表序号项目估算单价1建设投资210501.1工程费用192001.1.1土建工程100010001.1.2设备采购及安装变电站常规变13000130001.1.3电网铺设线路LGJ-2×6302005200同塔双回1.2工程建设其他费用1850.001.2.1前期咨询费用01.2.2勘察费用01.2.3设计费用01.2.4施工监理费01.2.5招标代理费01.2.601.2.7土地费用18001.2.8联合试运转费301.2.9人员培训费202基本预备费1052.503静态总投资22102.504建设期利息21605工程投投资24262.50类别名称规格估算投资(万元)备注220kV大龙东变电站含110kV开关站,后期转为出线间隔500kV铜仁变~大龙东220kV线路场地准备费及临时设施费2000万开关站建设项目固定资产残值率折旧年限12345678910829.13829.13829.13829.13829.13829.13829.13829.130.0520.00原值13000.0013000.0012382.5011765.0011147.5010530.009912.509295.008677.50折旧费12350.00617.50617.50617.50617.50617.50617.50617.50617.50残值650.0012382.5011765.0011147.5010530.009912.509295.008677.508060.00电网0.1030.00原值5200.005200.005026.674853.334680.004506.674333.334160.003986.67折旧费4680.00173.33173.33173.33173.33173.33173.33173.33173.33残值520.005026.674853.334680.004506.674333.334160.003986.673813.33无形资产47.00原值1800.001800.001761.701723.401685.111646.811608.511570.211531.911493.621455.32摊销费1800.0038.3038.3038.3038.3038.3038.3038.3038.3038.3038.30残值0.001761.701723.401685.111646.811608.511570.211531.911493.621455.321417.02附表6:项目总折旧摊销表单位:万元折旧摊销费设备及安装序号单位单价(元)用电递增系数123456789101用电成本合计13400047695.559027.2572027.884043.1698461.592115763.7104136526.25248161441.302976用电量合计117000145500178000206800241360282832332598.4392318.081.1340001700025500340003400034000340003400034000自有电源成本5975.58963.251195111951119511195111951119511.1.1用电量240001200018000240002400024000240002400024000风电0.3515421863278436843684368436843684361.1.2用电量1000050007500100001000010000100001000010000光伏0.35151757.52636.253515351535153515351535151.2自有生产负荷50%75%100%100%100%100%100%100%1.3其他电源10000020%417205006460076.872092.1686510.592103812.7104124575.25248149490.3029761.3.1用电量100000100000120000144000172800207360248832298598.4358318.081.3.2电网购电0.4172417205006460076.872092.1686510.592103812.7104124575.25248149490.3029761.41.4.1110KV90%12060042925.9553124.52564825.0275638.84488615.4328104187.33936122873.627232145297.17267841.4.235KV5%67002384.7752951.36253601.394202.1584923.07965788.185526826.3126248072.06514881.4.310KV3%4020126.54189.81253.08253.08253.08253.08253.08253.081.4.4居民用电2%268035.1552.72570.370.370.370.370.370.31.5电网损耗1.5.1110KV2%2412858.5191062.49051296.50041512.776881772.3086562083.74678722457.472544642905.9434535681.5.235KV4%26811.95117.926523.90223.90223.90223.90223.90223.9021.5.310KV8%321.610.123215.184820.246420.246420.246420.246420.246420.24641.5.4居民用电8%214.42.8124.2185.6245.6245.6245.6245.6245.6242燃料动力费10101010101010102.1水2.65.65555555552.2电1195.02555555553总可变成本费用5985.58973.25119611196111961119611196111961附表4:项目原材料及动力消耗费用估算表单位:万元项目年售电量(万KW.h)自有电源用电量合计元/KW.h元/KW.h元/KW.h电压等级用电量占比万m3万kWh序号项目单位1231销售收入16570.831.1自有电源收入万元8922.721.1.1110KV万元0.548096.761.1.235kv万元0.58473.281.1.310kv万元0.6281.521.1.4居民用电万元0.45571.161.2电网购电销售差价收入万元7648.111.2.1110KV万元0.04485294.821.2.235kv万元0.0814523.561.2.310kv万元0.48141780.411.2.4居民用电万元0.0249.312销售税金万元1981.333.1自有电...

1、当您付费下载文档后,您只拥有了使用权限,并不意味着购买了版权,文档只能用于自身使用,不得用于其他商业用途(如 [转卖]进行直接盈利或[编辑后售卖]进行间接盈利)。
2、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。
3、如文档内容存在违规,或者侵犯商业秘密、侵犯著作权等,请点击“违规举报”。

碎片内容

碳中和
已认证
内容提供者

碳中和

确认删除?
回到顶部
微信客服
  • 管理员微信
QQ客服
  • QQ客服点击这里给我发消息
客服邮箱