{"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,"この Web サイトの予算作成ツールを使用して、Web サイト、その利益、コストの初期投資を追跡します。"]
[null,"表に詳細を入力すると、合計と評価指標が自動的に計算されます。"]
[null,"注:  "]
[null,"予算ツール ワークシートの列 A に詳細な手順が記載されています。このテキストは意図的に非表示になっています。テキストを削除するには、列 A を選択し、[削除] を選択します。テキストを再表示するには、列 A を選択し、フォントの色を変更します。"]
[null,"ワークシートの表の詳細については、表内で Shift キーを押し、F10 キーを押して、[表] オプションを選択し、[代替テキスト] を選択します。"]

{"sheet":"予算ツール","index":1,"n_rows":43,"n_cols":6,"rows_kept":43}
[]
[null,"Quadrex ハードウェア"]
[null,"Web サイトの予算作成ツール"]
[null,"2022-12-01"]
[]
[null,"会社のデータ","割合"]
[null,"必要な利益率",{"v":0.1,"d":"10%"}]
[null,"税率",{"v":0.3,"d":"30%"}]
[]
[null,"Web サイトの初期投資","年"]
[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"}}]
[]
[null,"Web サイトからの利益","1 年目","2 年目","3 年目"]
[null,"直販",{"v":15000,"d":"¥15,000.00"},{"v":50000,"d":"¥50,000.00"},{"v":75000,"d":"¥75,000.00"}]
[null,"プロモーション向上/販売員の効果によって生じた売上の増加分",{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"パートナー参加が増えたことによる売上の増加分",{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"削減された交通費",{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"},{"v":25000,"d":"¥25,000.00"}]
[null,"削減された顧客サービス費",{"v":50000,"d":"¥50,000.00"},{"v":50000,"d":"¥50,000.00"},{"v":50000,"d":"¥50,000.00"}]
[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"}}]
[]
[null,"コスト (初期設備投資を除く)","年 1","年 2","年 3"]
[null,"売上原価",{"v":7500,"d":"¥7,500.00"},{"v":25000,"d":"¥25,000.00"},{"v":37500,"d":"¥37,500.00"}]
[null,"保守",{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"}]
[null,"プロジェクト管理、カスタマー サポート",{"v":35000,"d":"¥35,000.00"},{"v":35000,"d":"¥35,000.00"},{"v":35000,"d":"¥35,000.00"}]
[null,"オンライン広告、検索エンジンの登録",{"v":10000,"d":"¥10,000.00"},{"v":10000,"d":"¥10,000.00"},{"v":10000,"d":"¥10,000.00"}]
[null,"資本支出の減価償却費 (3 年間として計算)",{"$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,"総コスト",{"$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"}}]
[]
[null,"合計"," ","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":"C29","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"D29","v":{"v":63333.333333333336,"d":"¥63,333.33"}},{"$f":"E29","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,"評価指標","値​​"]
[null,"正味現在価値 (NPV)",{"$f":"C37+(NPV(ROR,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,\"使用できません\"))))","v":{"v":2.4214876033057853,"d":"2.42"}}]