{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","预算工具"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"关于此模板"]
[null,"使用此网站预算工具，跟踪网站中的初始投资、网站收益和成本。"]
[null,"填写公司名称和日期。"]
[null,"在表格中输入详细信息，自动计算总计和评估度量。"]
[null,"注意：  "]
[null,"“预算工具”工作表的 A 列中均提供了额外的说明。此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关该工作表中各表格的详细信息，请在表格内按 Shift+F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"预算工具","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"merged":[[14,1,14,5],[22,1,22,5],[30,1,30,5],[38,1,38,5]]}
["使用该工作表创建网站预算。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。"]
["在右侧单元格中输入公司名称。","公司名称"]
["此工作表的标题位于右侧单元格中。","网站预算工具"]
["在右侧单元格输入日期。","日期"]
["提示位于右侧单元格中。","灰色单元格包含计算，不得涂改。"]
["从右侧单元格开始，在“比率”表中输入详细信息。下一条说明位于单元格 A10 中。","公司数据","比率"]
[null,"预期收益率",{"v":0.1,"d":"10%"}]
[null,"税率",{"v":0.3,"d":"30%"}]
[]
["从右侧单元格开始，在“初始投资”表中输入详细信息。下一条说明位于单元格 A16 中。","网站中的初始投资","年","1","2","3"]
[null,"硬件（如服务器）",{"v":25000,"d":"¥25,000.00"}]
[null,"软件（如电子商务目录软件）",{"v":15000,"d":"¥15,000.00"}]
[null,"开发（如第三方网站设计和开发）",{"v":150000,"d":"¥150,000.00"}]
[null,"初始总投资",{"$f":"SUBTOTAL(109,初始投资[年])","v":{"v":190000,"d":"¥190,000.00"}}]
[]
["从右侧单元格开始，在“收益”表格中输入详细信息。下一条说明位于单元格 A24 中。","网站效益","年","1","2","3"]
[null,"直接销售",null,{"v":15000,"d":"¥15,000.00"},{"v":50000,"d":"¥50,000.00"},{"v":75000,"d":"¥75,000.00"}]
[null,"促销/销售人员效率提高导致的增量销售",null,{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"合作伙伴参与增加导致的增量销售",null,{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"缩减差旅成本",null,{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"缩减客户服务成本",null,{"v":50000,"d":"¥50,000.00"},{"v":50000,"d":"¥50,000.00"},{"v":50000,"d":"¥50,000.00"}]
[null,"总收益",null,{"$f":"SUBTOTAL(109,收益[1])","v":{"v":140000,"d":"¥140,000.00"}},{"$f":"SUBTOTAL(109,收益[2])","v":{"v":175000,"d":"¥175,000.00"}},{"$f":"SUBTOTAL(109,收益[3])","v":{"v":200000,"d":"¥200,000.00"}}]
[]
["从右侧单元格开始，在“成本”表格中输入详细信息。值是在从包含公式的单元格中自动计算的。下一条说明位于单元格 A32 中。","成本（不包括初始资本投资）","年","1","2","3"]
[null,"销售成本",null,{"v":7500,"d":"¥7,500.00"},{"v":25000,"d":"¥25,000.00"},{"v":37500,"d":"¥37,500.00"}]
[null,"维护",null,{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"}]
[null,"项目管理、客户支持",null,{"v":35000,"d":"¥35,000.00"},{"v":35000,"d":"¥35,000.00"},{"v":35000,"d":"¥35,000.00"}]
[null,"在线广告、搜索引擎注册",null,{"v":10000,"d":"¥10,000.00"},{"v":10000,"d":"¥10,000.00"},{"v":10000,"d":"¥10,000.00"}]
[null,"资本支出折旧（计算使用三年）",null,{"$f":"初始投资[[#Totals],[年]]/3","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"初始投资[[#Totals],[年]]/3","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"初始投资[[#Totals],[年]]/3","v":{"v":63333.333333333336,"d":"¥63,333.33"}}]
[null,"总成本",null,{"$f":"SUBTOTAL(109,成本[1])","v":{"v":130833.33333333334,"d":"¥130,833.33"}},{"$f":"SUBTOTAL(109,成本[2])","v":{"v":148333.33333333334,"d":"¥148,333.33"}},{"$f":"SUBTOTAL(109,成本[3])","v":{"v":160833.33333333334,"d":"¥160,833.33"}}]
[]
["值是在从右侧单元格开始的“总计”表格中自动计算的。下一步说明位于单元格 A40。","总计","年","1","2","3"]
[null,"净收益（成本）",null,{"$f":"收益[[#Totals],[1]]-成本[[#Totals],[1]]","v":{"v":9166.666666666657,"d":"¥9,166.67"}},{"$f":"收益[[#Totals],[2]]-成本[[#Totals],[2]]","v":{"v":26666.666666666657,"d":"¥26,666.67"}},{"$f":"收益[[#Totals],[3]]-成本[[#Totals],[3]]","v":{"v":39166.66666666666,"d":"¥39,166.67"}}]
[null,"税费",null,{"$f":"D33*税率","v":{"v":2749.999999999997,"d":"¥2,750.00"}},{"$f":"E33*税率","v":{"v":7999.999999999996,"d":"¥8,000.00"}},{"$f":"F33*税率","v":{"v":11749.999999999996,"d":"¥11,750.00"}}]
[null,"税后利润",null,{"$f":"D33-D34","v":{"v":6416.666666666661,"d":"¥6,416.67"}},{"v":18666.66666666666,"d":"¥18,666.67"},{"v":27416.66666666666,"d":"¥27,416.67"}]
[null,"加回的折旧费用",null,{"$f":"D29","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"E29","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"F29","v":{"v":63333.333333333336,"d":"¥63,333.33"}}]
[null,"现金流",{"$f":"-初始投资[[#Totals],[年]]","v":{"v":-190000,"d":"(¥190,000.00)"}},{"$f":"D35+D36","v":{"v":69750,"d":"¥69,750.00"}},{"v":82000,"d":"¥82,000.00"},{"v":90750,"d":"¥90,750.00"}]
[null,"累积现金流",{"$f":"C37","v":{"v":-190000,"d":"(¥190,000.00)"}},{"$f":"C38+D37","v":{"v":-120250,"d":"(¥120,250.00)"}},{"v":-38250,"d":"(¥38,250.00)"},{"v":52500,"d":"¥52,500.00"}]
[]
["评估度量是在从右侧单元格开始的“度量”表格中自动计算的。","评估度量","值"]
[null,"净现值 (NPV)",{"$f":"C37+(NPV(收益率,D37:F37))","v":{"v":9359.504132231377,"d":"¥9,359.50"}}]
[null,"内部收益率 (IRR)",{"$f":"IRR(C37:F37)","v":{"v":0.12655165144706393,"d":"12.66%"}}]
[null,"回收期（以年计）",{"$f":"IF(F38<=0,\"超过 3 年\",IF(E38<=0,(F37-F38)/F37+2,IF(D38<=0,(E37-E38)/E37+1,IF(C38<=0,(D37-D38)/D37,\"NA\"))))","v":{"v":2.4214876033057853,"d":"2.42"}}]