编辑代码

import pandas as pd

# 假设的固定资产投资估算及折旧政策
assets = {
    '项目': ['传输设备', '服务器及存储设备', '其他设备', '合计'],
    '投资额': [30000, 25000, 25000, 80000],
    '折旧期': [8, 5, 5, 0],
    '残值率': [0.05, 0.05, 0.05, 0],
    '残值': [30000 * 0.05, 25000 * 0.05, 25000 * 0.05, sum([30000 * 0.05, 25000 * 0.05, 25000 * 0.05])]
}

# 计算每年折旧额
for i in range(3):
    assets[f'2021年（建设期）'] = '-'
    assets[f'2022年'] = '-'
    assets[f'2023年'] = '-'
    assets[f'2024年'] = '-'
    assets[f'2025年'] = '-'
    assets[f'2026年'] = (assets['投资额'][i] - assets['残值'][i]) / assets['折旧期'][i] if assets['折旧期'][i] > 0 else '-'
    assets[f'2027年'] = (assets['投资额'][i] - assets['残值'][i]) / assets['折旧期'][i] if assets['折旧期'][i] > 0 and assets['折旧期'][i]!= 8 else '-'
    assets[f'2028年'] = (assets['投资额'][i] - assets['残值'][i]) / assets['折旧期'][i] if assets['折旧期'][i] > 0 and assets['折旧期'][i]!= 8 else '-'
    assets[f'2029年'] = (assets['投资额'][i] - assets['残值'][i]) / assets['折旧期'][i] if assets['折旧期'][i] == 8 else '-'
    assets[f'2030年'] = (assets['投资额'][i] - assets['残值'][i]) / assets['折旧期'][i] if assets['折旧期'][i] == 8 else '-'

# 创建DataFrame
df = pd.DataFrame(assets)

# 保存为Excel文件
excel_path = '/mnt/扩展固定资产折旧表.xlsx'
df.to_excel(excel_path, sheet_name='折旧表', index=False)