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

{"sheet":"開始","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"關於此範本"]
[null,"請使用此網站預算工具來追蹤網站的初期投資、獲益和成本。"]
[null,"在表格中輸入詳細資料，以供系統自動計算總計和評估指標。"]
[null,"附註：  "]
[null,"我們已在 [預算工具] 工作表的欄 A 提供額外指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取欄 A，然後變更字型色彩。"]
[null,"若要深入了解此工作表中的表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"預算工具","index":1,"n_rows":43,"n_cols":6,"rows_kept":43}
[]
[null,"Quadrex 硬體"]
[null,"網站預算工具"]
[null,"2022-12-01"]
[]
[null,"公司資料","比率"]
[null,"必要報酬率",{"v":0.1,"d":"10%"}]
[null,"稅率",{"v":0.3,"d":"30%"}]
[]
[null,"網站初期投資","年份"]
[null,"硬體 (例如伺服器)",{"v":25000,"d":"HK$25,000.00"}]
[null,"軟體 (例如電子商務型錄軟體)",{"v":15000,"d":"HK$15,000.00"}]
[null,"開發 (例如協力廠商網站設計與開發)",{"v":150000,"d":"HK$150,000.00"}]
[null,"初期投資總額",{"$f":"SUBTOTAL(109,初期投資[年份])","v":{"v":190000,"d":"HK$190,000.00"}}]
[]
[null,"網站的獲益","第 1 年","第 2 年","第 3 年"]
[null,"直接銷售",{"v":15000,"d":"HK$15,000.00"},{"v":50000,"d":"HK$50,000.00"},{"v":75000,"d":"HK$75,000.00"}]
[null,"增強促銷/銷售人員效率而帶來的銷售增益",{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"}]
[null,"合作夥伴參與程度上升而帶來的銷售增益",{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"}]
[null,"縮減的差旅成本",{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"},{"v":25000,"d":"HK$25,000.00"}]
[null,"縮減的客戶服務成本",{"v":50000,"d":"HK$50,000.00"},{"v":50000,"d":"HK$50,000.00"},{"v":50000,"d":"HK$50,000.00"}]
[null,"總獲益",{"$f":"SUBTOTAL(109,獲益[第 1 年])","v":{"v":140000,"d":"HK$140,000.00"}},{"$f":"SUBTOTAL(109,獲益[第 2 年])","v":{"v":175000,"d":"HK$175,000.00"}},{"$f":"SUBTOTAL(109,獲益[第 3 年])","v":{"v":200000,"d":"HK$200,000.00"}}]
[]
[null,"成本 (不含初期投入資本)","第 1 年","第 2 年","第 3 年"]
[null,"銷售成本",{"v":7500,"d":"HK$7,500.00"},{"v":25000,"d":"HK$25,000.00"},{"v":37500,"d":"HK$37,500.00"}]
[null,"維護",{"v":15000,"d":"HK$15,000.00"},{"v":15000,"d":"HK$15,000.00"},{"v":15000,"d":"HK$15,000.00"}]
[null,"專案管理、客戶支援",{"v":35000,"d":"HK$35,000.00"},{"v":35000,"d":"HK$35,000.00"},{"v":35000,"d":"HK$35,000.00"}]
[null,"線上廣告、搜尋引擎註冊",{"v":10000,"d":"HK$10,000.00"},{"v":10000,"d":"HK$10,000.00"},{"v":10000,"d":"HK$10,000.00"}]
[null,"資本支出折舊 (使用期限以三年計)",{"$f":"初期投資[[#Totals],[年份]]/3","v":{"v":63333.333333333336,"d":"HK$63,333.33"}},{"$f":"初期投資[[#Totals],[年份]]/3","v":{"v":63333.333333333336,"d":"HK$63,333.33"}},{"$f":"初期投資[[#Totals],[年份]]/3","v":{"v":63333.333333333336,"d":"HK$63,333.33"}}]
[null,"總成本",{"$f":"SUBTOTAL(109,成本[第 1 年])","v":{"v":130833.33333333334,"d":"HK$130,833.33"}},{"$f":"SUBTOTAL(109,成本[第 2 年])","v":{"v":148333.33333333334,"d":"HK$148,333.33"}},{"$f":"SUBTOTAL(109,成本[第 3 年])","v":{"v":160833.33333333334,"d":"HK$160,833.33"}}]
[]
[null,"總計"," ","第 1 年","第 2 年","第 3 年"]
[null,"淨利 (成本)",null,{"$f":"獲益[[#Totals],[第 1 年]]-成本[[#Totals],[第 1 年]]","v":{"v":9166.666666666657,"d":"HK$9,166.67"}},{"$f":"獲益[[#Totals],[第 2 年]]-成本[[#Totals],[第 2 年]]","v":{"v":26666.666666666657,"d":"HK$26,666.67"}},{"$f":"獲益[[#Totals],[第 3 年]]-成本[[#Totals],[第 3 年]]","v":{"v":39166.66666666666,"d":"HK$39,166.67"}}]
[null,"稅金",null,{"$f":"D33*稅率","v":{"v":2749.999999999997,"d":"HK$2,750.00"}},{"$f":"E33*稅率","v":{"v":7999.999999999996,"d":"HK$8,000.00"}},{"$f":"F33*稅率","v":{"v":11749.999999999996,"d":"HK$11,750.00"}}]
[null,"稅後淨利",null,{"$f":"D33-D34","v":{"v":6416.666666666661,"d":"HK$6,416.67"}},{"$f":"E33-E34","v":{"v":18666.66666666666,"d":"HK$18,666.67"}},{"$f":"F33-F34","v":{"v":27416.66666666666,"d":"HK$27,416.67"}}]
[null,"加入折舊",null,{"$f":"C29","v":{"v":63333.333333333336,"d":"HK$63,333.33"}},{"$f":"D29","v":{"v":63333.333333333336,"d":"HK$63,333.33"}},{"$f":"E29","v":{"v":63333.333333333336,"d":"HK$63,333.33"}}]
[null,"現金流量",{"$f":"-初期投資[[#Totals],[年份]]","v":{"v":-190000,"d":"-HK$190,000.00"}},{"$f":"D35+D36","v":{"v":69750,"d":"HK$69,750.00"}},{"v":82000,"d":"HK$82,000.00"},{"v":90750,"d":"HK$90,750.00"}]
[null,"累計現金流量",{"$f":"C37","v":{"v":-190000,"d":"-HK$190,000.00"}},{"$f":"C38+D37","v":{"v":-120250,"d":"(HK$120,250.00)"}},{"$f":"D38+E37","v":{"v":-38250,"d":"(HK$38,250.00)"}},{"$f":"E38+F37","v":{"v":52500,"d":"HK$52,500.00"}}]
[]
[null,"評估指標","數值"]
[null,"淨現值 (NPV)",{"$f":"C37+(NPV(ROR,D37:F37))","v":{"v":9359.504132231377,"d":"HK$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,\"無\"))))","v":{"v":2.4214876033057853,"d":"2.42"}}]