{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["モデルのしくみ","Dashboard","作業と支出","生産と生産額","プロジェクト収支","自社収支 ","表8.2 ","グラフ"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":28,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"モデルのしくみ","index":0,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020.03.02版"]

{"sheet":"Dashboard","index":1,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,18,30,20],[29,20,29,22]]}
[]
[null,"中東石油開発プロジェクト",null,null,null,"ABC石油開発株式会社",null,null,null,"このシートで前提条件や感度分析のコントロールを行います。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"① 感度分析-１"]
[null,"前提条件",null,"原油のみ生産のケース",null,null,null,null,null,null,null,"計算結果",{"$f":"TODAY()","v":"2020-03-10"},null,null,null,"・セキュリティの警告：コンテンツの有効化→表示→マクロ→感度分析を選択→実行"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"・下表の感度分析はマクロでセットされています。"]
[null,"鉱区の名称",null,"中東A国海上鉱区",null,"Block-11","鉱区持分",null,null,"感度分析",null,"経済性指標",null,"プロジェクト","ABC石油",null,"・好みの組み合わせに応じたマクロを作成しておくと便利です。"]
[null,"パートナー",null,"ABC石油開発株式会社",null,"オペレーター",0.6,null,null,1]
[null,null,null,"XYZ　Oil Inc.",null,"ノンオペレーター",0.4,null,null,1,null,"全期間","ROR",{"$f":"プロジェクト収支!E33","v":0.1459504277871122},{"$f":"'自社収支 '!E38","v":0.14527732472774257},null,"マクロ作成用の作業セル",null,null,"条件変数","目的１","目的２"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NPV （百万ドル）",{"$f":"プロジェクト収支!AF30","v":475.39927448752223},{"$f":"'自社収支 '!E39","v":283.13063397509558},null,null,null,null,"初日産","ROR","NTV"]
[null,"鉱区条件","Royalty",null,null,null,0.1,null,null,1,null,null,"FIRR",null,{"$f":"'自社収支 '!E40","v":0.19318623789954104},null,null,null,null,"条件","計算値","計算値"]
[null,null,"Maximum Cost Recovery",null,null,"Oil",0.35,null,null,1,null,null,"投資回収期間（年）",{"$f":"プロジェクト収支!P38","v":9.8643647765588263},null,null,null,null,null,{"$f":"Q17","v":1},{"$f":"O8","v":0.14527732472774257},{"$f":"O9","v":283.13063397509558}]
[null,null,null,null,null,"Gas",0.4,null,null,1,null,"開発以降","ROR",{"$f":"プロジェクト収支!I33","v":0.31258555446157965},{"$f":"'自社収支 '!I38","v":0.31169679311210907},null,"感度分析（自社のROR)",null,null,null,null,"感度分析（自社のNPV：百万ドル)"]
[null,null,"Profit Sharing",null,"Oil　Tier-1","5万BDまで",0.3,null,null,1,null,null,null,"百万バレル","百万バレル",null,null,"初日産","リグレート","生産設備",null,null,"初日産","リグレート","生産設備"]
[null,null,null,null,"　 　Tier-2","5万BD超",0.2,null,null,1,null,null,"原油生産量",{"$f":"生産と生産額!AF35","v":103.90196897965225}]
[null,null,null,null,"Gas","全量",0.3,null,null,1,null,null,"権益原油取得量",{"$f":"プロジェクト収支!AF35","v":39.932094076984626},{"$f":"N15*G7","v":23.959256446190775},null,0.8,0.12156902597723573,0.16071449391349613,0.15404438464637504,null,0.8,192.75645738592175,302.719246570336,297.20641677263603]
[null,null,"石油収入税",null,null,null,0.5,null,null,1,null,null,null,null,null,null,0.9,0.13394244426652402,0.15261514081814243,0.1495684872538996,null,0.9,238.15046319643267,292.92494027271584,290.16852537386586]
[null,null,"ボーナス",null,"サインボーナス",null,10,"$ million",null,1,null,null,null,null,null,null,1,0.14527732472774257,0.14527732472774257,0.14527732472774257,null,1,283.13063397509558,283.13063397509558,283.13063397509558]
[null,null,null,null,"発見ボーナス",null,3,"$ million",null,1,null,"収支（名目額）",null,"百万ドル","百万ドル",null,1.1000000000000001,0.15600452566418133,0.13858795111918942,0.14116153062848547,null,1.1000000000000001,328.2824996454512,273.33632767747554,276.09274257632552]
[null,null,null,null,"生産移行ボーナス",null,5,"$ million",null,1,null,"費用","ボーナス",{"$f":"作業と支出!AF30","v":18},{"$f":"'自社収支 '!AF15","v":10.8},null,1.2,0.16620936892958205,0.13245623570616738,0.13721209785023447,null,1.2,373.58310649011935,263.54202137985538,269.05485117755541]
[null,null,null,null,null,null,null,null,null,null,null,null,"探鉱費",{"$f":"作業と支出!AF37","v":236.13458886249995},{"$f":"N20*G7","v":141.68075331749998}]
[null,"経済条件","インフレーション",null,null,null,1.4999999999999999E-2,"年率",null,1,null,null,"開発費",{"$f":"作業と支出!AF60","v":809.21187133869444},{"$f":"N21*G7","v":485.52712280321663},null,"② 感度分析-２",null,"ソルバーによる必要条件の計算"]
[null,null,"初期価格",null,"原油",null,75,"ドル/バレル",null,1,null,null,"生産操業費",{"$f":"作業と支出!AF73","v":653.7840210466594},{"$f":"N22*G7","v":392.27041262799565},null,"・データ →　ソルバーを選択"]
[null,null,null,null,"ガス",null,3,"ドル/MMBtu",null,1,null,null,"本社管理費",{"$f":"プロジェクト収支!AF26","v":9.4541906883915825},{"$f":"N23","v":9.4541906883915825},null,"・条件変数を選び、J列のセルをソルバーの「変数」に指定する。"]
[null,null,null,"エスカレーション",null,null,1.4999999999999999E-2,"年率",null,1,null,null,"合計",{"$f":"SUM(N19:N23)","v":1726.5846719362455},{"$f":"SUM(O19:O23)","v":1039.7324794371041},null,"・下記の作業用セルに目標を指定し、「目標値を入力」する。"]
[null,null,"初日産（原油）",null,null,null,2500,"バレル/日/坑",null,1,null,null,null,null,null,null,"・セルT27をソルバーの目的セルに指定し、「最小にする」を実行する。"]
[null,null,"リグレート",null,null,null,200,"千ドル/日",null,1,null,"収入","コスト原油",{"$f":"プロジェクト収支!AF21","v":1633.9830348484063},{"$f":"N26*$G$7","v":980.38982090904369}]
[null,null,null,"付帯費用比率（掘削費）",null,null,1,null,null,1,null,null,"プロフィット原油",{"$f":"プロジェクト収支!AF23","v":2435.9570433380845},{"$f":"N27*$G$7","v":1461.5742260028508},null,"目的変数","計算値","目標値","目的セル"]
[null,null,"生産設備費（「生産施設＋坑井」の総費用）",null,null,null,null,null,null,1,null,null,"合計",{"$f":"N26+N27","v":4069.9400781864906},{"$f":"O26+O27","v":2441.9640469118945},null,"ROR",{"$f":"O8","v":0.14527732472774257},0.15,{"$f":"(S28-R28)^2","v":2.2303661727191702E-5}]
[null,null,"生産操業費",null,"固定比率","設備費×",0.02,null,null,1,null,"税","石油収入税",{"$f":"プロジェクト収支!AF24","v":1217.9785216690423},730.78711300142538]
[null,null,null,null,"生産高比率×設備費×",null,0.01,null,null,1,null,null,"差し引き計",{"$f":"N28-N29","v":2851.9615565174481},{"$f":"O28-O29","v":1711.176933910469},null,"自社のROR=15%を達成するための条件",null,null,null,"実数"]
[null,null,"パイプイン使用料",null,null,null,1,"ドル/バレル",null,1,null,null,null,null,null,null,"変数セル",null,"基準ケース対比の解",null,null,"基準"]
[null,null,"本社管理費",null,null,null,300,"ドル/年",null,1,null,"ネット収支","借入金なし",{"$f":"プロジェクト収支!AF28","v":1125.3768845812035},{"$f":"'自社収支 '!AF30","v":671.44445447336534},null,"埋蔵量（初日産の変化）",null,null,1.0433808994048492,{"$f":"N14*T32","v":108.40932984392431},{"$f":"N14","v":103.90196897965225},"百万バレル"]
[null,null,null,null,null,null,null,null,null,null,null,null,"借入金あり",null,{"$f":"'自社収支 '!AF33","v":548.50460099353302},null,"リグレート",null,null,0.9345513177281688,{"$f":"G26*T33","v":186.91026354563377},{"$f":"G26","v":200},"千ドル/日"]
[null,"財務条件","借入金利",null,null,null,0.05,"年率",null,1,null,null,null,null,null,null,"生産設備費",null,null,0.89017286214264135,311.56050174992447,{"$f":"作業と支出!AF54","v":350},"百万ドル"]
[null,null,"返済期間",null,null,null,7,"年",null,null,null,null,"総借入額",null,{"$f":"'自社収支 '!AF22","v":457.33262545080174},null,"PS比率 Tier-1",null,null,1.0550979265171765,{"$f":"G13*T35","v":0.31652937795515296},{"$f":"G13","v":0.3}]
[null,null,"割引率",null,null,null,0.05,"年率",null,1,null,null,"支払い金利",null,{"$f":"'自社収支 '!AF23","v":122.939853479832}]
[null,null,"資本回収係数",null,"(上記による計算値）",null,{"$f":"G34/(1-(1+G34)^(-1*G35))","v":0.1728198184461707},"年率"]
[]
[null,"感度分析を行うため、上記の前提条件「GXX＊JXX」をモデルの該当箇所にリンクする。"]

{"sheet":"作業と支出","index":2,"n_rows":73,"n_cols":32,"rows_kept":73,"cut":false,"hidden":false,"merged":[[50,30,50,31],[66,30,66,31],[26,30,26,31],[10,9,10,10],[11,9,11,11]]}
[]
[null,"１．作業工程のシナリオ"]
[]
[null,null,"最初にプロジェクト全期間の作業シナリオと工程を整理する。",null,null,null,null,null,"作業は、探鉱計画の作成→埋蔵量と生産プロファイルの想定→開発計画の想定という流れで進む。"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→"]
[null,null,null,null,2021,{"$f":"E6+1","v":2022},{"$f":"F6+1","v":2023},{"$f":"G6+1","v":2024},{"$f":"H6+1","v":2025},{"$f":"I6+1","v":2026},{"$f":"J6+1","v":2027},{"$f":"K6+1","v":2028},{"$f":"L6+1","v":2029},{"$f":"M6+1","v":2030},2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2046,"合計"]
[null,null,"探鉱作業"]
[null,null,null,"物理探鉱と解釈","第１次",null,"第２次",null,null,null,null,"・第１次キャンペーン＋第１次試掘終了後追加震探を実施。"]
[null,null,null,"試掘・探掘・評価井",null,"第１次","第２次","評価井",null,null,null,"・第１次キャンペーンでは３坑中１坑で油兆あり、テストするも少量。",null,null,null,null,null,null,null,"第２次キャンペーンでは２坑で石油発見、評価井３坑を掘削。"]
[null,null,"開発作業"]
[null,null,null,"生産設備",null,null,null,null,"設計","生産設備建設",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"設備撤去"]
[null,null,null,"生産井",null,null,null,null,"設計","生産井掘削",null,null,"→合計１２坑",null,null,"改修",null,"In-fill well掘削",null,null,null,null,null,null,null,null,null,null,null,null,"廃坑"]
[null,null,"生産作業"]
[null,null,null,"生産・操業",null,null,null,null,null,null,null,"生産開始：4坑ずつ、半年間隔で生産開始",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"操業赤字化"]
[]
[null,"２．ボーナスと探鉱投資額の計算",null,null,null,null,null,null,"⇒ Dashboardでセットする前提条件",null,null,null,null,null,"→","項目別の費用は外注費や応援要員の費用。現地駐在員・社員の費用は「現地管理費」に含む。"]
[null,null,"・前提条件"]
[null,null,"　・ ボーナス：契約に沿って支払い（確定額で、インフレには左右されない。）"]
[null,null,"　・ 探鉱費"]
[null,null,"　　1. 地震探鉱費ほか",null,null,null,"第1次キャンペーン：",15,"百万ドル",null,null,null,"第2次キャンペーン：",5,"百万ドル",null,"作業の種類（2次元、3次元)と規模（測線長、面積）、作業単価を想定し、総費用を推定する。"]
[null,null,"　　2. 試探掘費",null,null,null,null,null,null,null,null,null,null,null,null,null,"１次キャンペーン",null,null,"２次キャンペーン"]
[null,null,null,"1) 試掘井","ドライホール：50日＊２坑＋成功井：（50日＋テスト20日）＊1坑+往航3日（復航はゼロとする）",null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+50*2+50+20","v":173},"日",null,{"$f":"3+(50+20)*2","v":143},"日"]
[null,null,null,"2) 評価井","[50日＊９０％（習熟率）＋テスト15日（２ゾーン）]＊3坑+モブ3日（デモブはゼロ）",null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(45+15)*3","v":183},"日"]
[null,null,null,"3) 掘削費","掘削費日額＊坑井数"]
[null,null,null,null,null,null,"千ドル/日",null,null,"千ドル/日",null,"千ドル/日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2046年までの合計"]
[null,null,null,"坑井掘削費用：日額",null,"リグレート",{"$f":"Dashboard!G26*Dashboard!J26","v":200},null,"　＋　付帯費用",{"$f":"Dashboard!G27*Dashboard!J27","v":1},"合計",{"$f":"G26*(1+J26)","v":400},null,null,"付帯費用＝","ヘリコプター、サプライボート、各種技術サービス、ケータリング、その他の費用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果（百万ドル）",null,2021,{"$f":"E28+1","v":2022},{"$f":"F28+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"AB28+1","v":2045},{"$f":"AC28+1","v":2046},{"$f":"AC28+1","v":2046},"合計"]
[null,null,null,null,"サインボーナス",null,null,null,"商業発見ボーナス",null,null,"生産移行ボーナス"]
[null,null,"ボーナス",null,10,null,null,null,3,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E30:AC30)+AE30","v":18}]
[null,null,"探鉱費","地震探鉱費ほか",{"$f":"H20","v":15},null,{"$f":"N20","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,"（実質）","試掘井掘削費",null,{"$f":"$L$26*Q22/1000","v":69.2},{"$f":"$L$26*T22/1000","v":57.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126.4]
[null,null,null,"評価井掘削費",null,null,null,{"$f":"$L$26*Q23/1000","v":73.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73.2]
[null,null,null,"スタディ費",null,0.5,0.5,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,"現地管理費",1.5,2,2,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,"（探鉱費計）",{"$f":"SUM(E31:E35)","v":16.5},{"$f":"SUM(F31:F35)","v":71.7},{"$f":"SUM(G31:G35)","v":64.7},{"$f":"SUM(H31:H35)","v":76.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229.60000000000002]
[null,null,null,"（計：インフレ含む名目値）",{"$f":"E36*((1+生産と生産額!$O$31)^(E28-2021))","v":16.5},{"$f":"F36*((1+生産と生産額!$O$31)^(F28-2021))","v":72.775499999999994},{"$f":"G36*((1+生産と生産額!$O$31)^(G28-2021))","v":66.655557499999986},{"$f":"H36*((1+生産と生産額!$O$31)^(H28-2021))","v":80.203531362499973},{"$f":"I36*((1+生産と生産額!$O$31)^(I28-2021))","v":0},{"$f":"J36*((1+生産と生産額!$O$31)^(J28-2021))","v":0},{"$f":"K36*((1+生産と生産額!$O$31)^(K28-2021))","v":0},{"$f":"L36*((1+生産と生産額!$O$31)^(L28-2021))","v":0},{"$f":"M36*((1+生産と生産額!$O$31)^(M28-2021))","v":0},{"$f":"N36*((1+生産と生産額!$O$31)^(N28-2021))","v":0},{"$f":"O36*((1+生産と生産額!$O$31)^(O28-2021))","v":0},{"$f":"P36*((1+生産と生産額!$O$31)^(P28-2021))","v":0},{"$f":"Q36*((1+生産と生産額!$O$31)^(Q28-2021))","v":0},{"$f":"R36*((1+生産と生産額!$O$31)^(R28-2021))","v":0},{"$f":"S36*((1+生産と生産額!$O$31)^(S28-2021))","v":0},{"$f":"T36*((1+生産と生産額!$O$31)^(T28-2021))","v":0},{"$f":"U36*((1+生産と生産額!$O$31)^(U28-2021))","v":0},{"$f":"V36*((1+生産と生産額!$O$31)^(V28-2021))","v":0},{"$f":"W36*((1+生産と生産額!$O$31)^(W28-2021))","v":0},{"$f":"X36*((1+生産と生産額!$O$31)^(X28-2021))","v":0},{"$f":"Y36*((1+生産と生産額!$O$31)^(Y28-2021))","v":0},{"$f":"Z36*((1+生産と生産額!$O$31)^(Z28-2021))","v":0},{"$f":"AA36*((1+生産と生産額!$O$31)^(AA28-2021))","v":0},{"$f":"AB36*((1+生産と生産額!$O$31)^(AB28-2021))","v":0},{"$f":"AC36*((1+生産と生産額!$O$31)^(AC28-2021))","v":0},{"$f":"AD36*((1+生産と生産額!$O$31)^(AD28-2021))","v":0},0,236.13458886249995]
[]
[null,"３．開発投資額の計算"]
[null,null,"・前提条件"]
[null,null,"　　１. 生産井掘削費",null,"合計 ５７９日"]
[null,null,null,"1) 掘削日数　　　 　　48日/１坑=","[45日（評価井基準）＊(3800m/4000m：生産層までの掘削)*80％（習熟率）＊120%（傾斜掘りによる平均屈伸長の増加）＋7日（坑井仕上げ）]*12坑",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"45*(3800/4000)*0.8*1.2+7","v":48.04}]
[null,null,null,"掘削日数＝","３日＋12坑×48日/坑＝579日",null,null,null,null,135,365,80,{"$f":"J43+K43+L43","v":580},"日（ラウンド）",null,null,null,null,null,null,null,{"$f":"3+V42*12","v":579.48}]
[null,null,null,"2） 生産井掘削費日額",null,null,null,null,null,{"$f":"L26*(1-N44)","v":360},"千ドル/日",null,"割引率",0.1,"→","生産井の掘削では、評価井に比べて、a. 　掘り止め深度がやや浅くなる、b.習熟度が増す、c.傾斜掘りとなる、d.長期の契約のため割引がある。"]
[null,null,null,"3) 坑井改修、廃坑作業",null,null,null,null,null,{"$f":"L26","v":400},"千ドル/日",null,null,null,"→","坑井改修や廃坑作業では作業期間が短いため、リグレートの割引なし。"]
[null,null,"→","生産終了の翌年に廃山費用を計上（AD33とAD35)。"]
[null,null,"　　２. 設備建設費"]
[null,null,null,"1) FEED費用",10,"百万ドル",null,null,null,2025,2026,"合計"]
[null,null,null,"2) 生産設備建設費",null,null,null,null,null,120,230,{"$f":"J49+K49","v":350},"百万ドル",null,"→","廃山費用：設備建設費に対する比率 →",null,null,null,null,0.05]
[null,null,null,"3) 建設費の生産規模による変化率",null,null,null,"初日産に対する比率：",{"$f":"生産と生産額!F16/Dashboard!G25","v":1},"の",null,0.5,"乗",{"$f":"I50^L50","v":1},"→","生産設備の建設費は生産規模に応じて変化すると考える。標準的には1/2乗～1/3乗程度。"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果（百万ドル）",null,2021,{"$f":"E52+1","v":2022},{"$f":"F52+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,{"$f":"V52+1","v":2039},2040,2041,2042,2043,2044,{"$f":"AB52+1","v":2045},{"$f":"AC52+1","v":2046},{"$f":"AC52+1","v":2046},"合計"]
[null,null,"開発費","FEED",null,null,null,null,{"$f":"E48*Dashboard!J28","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E53:AC53)+AE53","v":10}]
[null,null,"（実質）","生産施設建設",null,null,null,null,null,{"$f":"J49*Dashboard!$J$28*作業と支出!$N$50","v":120},{"$f":"K49*Dashboard!$J$28*作業と支出!$N$50","v":230},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350]
[null,null,null,"廃山費用",null,null,null,null,null,null,null,null,null,null,null,null,null,"In-fill well 掘削",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF54*U49","v":17.5},17.5]
[null,null,null,"生産井掘削",null,null,null,null,null,{"$f":"$J$44*135/1000","v":48.6},{"$f":"$J$44*365/1000","v":131.4},{"$f":"J44*80/1000","v":28.8},null,null,null,null,null,{"$f":"J44*(48*4+3)/1000","v":70.2},null,null,null,null,null,null,null,null,null,null,null,null,null,279]
[null,null,null,"改修・廃坑費用",null,null,null,null,null,null,null,null,null,null,null,{"$f":"J45*(7*12+3)/1000","v":34.799999999999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J45*(3+3*16)/1000","v":20.399999999999999},55.199999999999996]
[null,null,null,"現地管理費",null,null,null,null,2,2.5,2.5,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,"（開発費計）",{"$f":"SUM(E53:E58)","v":0},{"$f":"SUM(F53:F58)","v":0},0,0,12,171.1,363.9,29.8,0,0,0,34.799999999999997,0,70.2,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD53:AD58)","v":0},37.9,719.69999999999993]
[null,null,null,"（計：インフレ含む名目値）",{"$f":"E59*(1+生産と生産額!$O$31)^(E52-2021)","v":0},{"$f":"F59*(1+生産と生産額!$O$31)^(F52-2021)","v":0},{"$f":"G59*(1+生産と生産額!$O$31)^(G52-2021)","v":0},{"$f":"H59*(1+生産と生産額!$O$31)^(H52-2021)","v":0},{"$f":"I59*(1+生産と生産額!$O$31)^(I52-2021)","v":12.736362607499993},{"$f":"J59*(1+生産と生産額!$O$31)^(J52-2021)","v":184.32329306461642},{"$f":"K59*(1+生産と生産額!$O$31)^(K52-2021)","v":397.90400374872655},{"$f":"L59*(1+生産と生産額!$O$31)^(L52-2021)","v":33.073378404473019},{"$f":"M59*(1+生産と生産額!$O$31)^(M52-2021)","v":0},{"$f":"N59*(1+生産と生産額!$O$31)^(N52-2021)","v":0},{"$f":"O59*(1+生産と生産額!$O$31)^(O52-2021)","v":0},{"$f":"P59*(1+生産と生産額!$O$31)^(P52-2021)","v":40.992623021538286},{"$f":"Q59*(1+生産と生産額!$O$31)^(Q52-2021)","v":0},{"$f":"R59*(1+生産と生産額!$O$31)^(R52-2021)","v":85.191381571148625},{"$f":"S59*(1+生産と生産額!$O$31)^(S52-2021)","v":0},{"$f":"T59*(1+生産と生産額!$O$31)^(T52-2021)","v":0},{"$f":"U59*(1+生産と生産額!$O$31)^(U52-2021)","v":0},{"$f":"V59*(1+生産と生産額!$O$31)^(V52-2021)","v":0},{"$f":"W59*(1+生産と生産額!$O$31)^(W52-2021)","v":0},{"$f":"X59*(1+生産と生産額!$O$31)^(X52-2021)","v":0},{"$f":"Y59*(1+生産と生産額!$O$31)^(Y52-2021)","v":0},{"$f":"Z59*(1+生産と生産額!$O$31)^(Z52-2021)","v":0},{"$f":"AA59*(1+生産と生産額!$O$31)^(AA52-2021)","v":0},{"$f":"AB59*(1+生産と生産額!$O$31)^(AB52-2021)","v":0},{"$f":"AC59*(1+生産と生産額!$O$31)^(AC52-2021)","v":0},{"$f":"AD59*(1+生産と生産額!$O$31)^(AD52-2021)","v":0},{"$f":"AE59*(1+生産と生産額!$O$31)^(AE52-2021)","v":54.990828920691513},809.21187133869444]
[null,null,"回収対象投資合計（インフレ含む名目値）",null,{"$f":"E37+E60","v":16.5},72.775499999999994,66.655557499999986,80.203531362499973,12.736362607499993,184.32329306461642,397.90400374872655,33.073378404473019,0,0,0,40.992623021538286,0,85.191381571148625,0,0,0,0,0,0,0,0,0,0,0,0,54.990828920691513,1045.3464602011943]
[]
[null,"４．操業費の計算"]
[null,null,"・前提条件"]
[null,null,1,"初期投資＊（固定部分２％＋生産比例部分＊１％）",null,null,null,null,"固定部分",{"$f":"Dashboard!G29*Dashboard!J29","v":0.02},null,"比例部分",{"$f":"Dashboard!G30*Dashboard!J30","v":0.01},null,"生産比例部分は「ピーク生産量に対する各年の生産量の比率」に比例するとして計算。"]
[null,null,2,"パイプライン使用料",null,{"$f":"Dashboard!G31*Dashboard!J31","v":1},"ドル/バレル"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果（百万ドル）",null,2021,{"$f":"E68+1","v":2022},{"$f":"F68+1","v":2023},{"$f":"G68+1","v":2024},{"$f":"H68+1","v":2025},{"$f":"I68+1","v":2026},{"$f":"J68+1","v":2027},{"$f":"K68+1","v":2028},{"$f":"L68+1","v":2029},{"$f":"M68+1","v":2030},{"$f":"N68+1","v":2031},{"$f":"O68+1","v":2032},{"$f":"P68+1","v":2033},{"$f":"Q68+1","v":2034},{"$f":"R68+1","v":2035},{"$f":"S68+1","v":2036},{"$f":"T68+1","v":2037},{"$f":"U68+1","v":2038},{"$f":"V68+1","v":2039},{"$f":"W68+1","v":2040},{"$f":"X68+1","v":2041},{"$f":"Y68+1","v":2042},{"$f":"Z68+1","v":2043},{"$f":"AA68+1","v":2044},{"$f":"AB68+1","v":2045},{"$f":"AC68+1","v":2046},{"$f":"AC68+1","v":2046},"合計"]
[null,null,"操業費","生産操業費",null,null,null,null,null,null,null,{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!L34/生産と生産額!$M$34*$M$65)","v":15.725000000000001},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!M34/生産と生産額!$M$34*$M$65)","v":18.87},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!N34/生産と生産額!$M$34*$M$65)","v":18.618400000000001},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!O34/生産と生産額!$M$34*$M$65)","v":18.135328000000001},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!P34/生産と生産額!$M$34*$M$65)","v":17.690901760000003},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!Q34/生産と生産額!$M$34*$M$65)","v":17.233050144},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!R34/生産と生産額!$M$34*$M$65)","v":16.657541310399999},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!S34/生産と生産額!$M$34*$M$65)","v":17.678559287173336},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!T34/生産と生産額!$M$34*$M$65)","v":16.995407852764},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!U34/生産と生産額!$M$34*$M$65)","v":16.333096674849401},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!V34/生産と生産額!$M$34*$M$65)","v":15.655078008829451},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!W34/生産と生産額!$M$34*$M$65)","v":14.992471519118089},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!X34/生産と生産額!$M$34*$M$65)","v":14.479592199960166},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!Y34/生産と生産額!$M$34*$M$65)","v":14.004694149970124},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!Z34/生産と生産額!$M$34*$M$65)","v":13.630318684063148},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!AA34/生産と生産額!$M$34*$M$65)","v":13.336795734742804},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!AB34/生産と生産額!$M$34*$M$65)","v":13.125936506243916},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!AC34/生産と生産額!$M$34*$M$65)","v":12.962155554370741},{"$f":"($AF$54+$AF$56)*($J$65+生産と生産額!AD34/生産と生産額!$M$34*$M$65)","v":12.847508888059517},0,{"$f":"SUM(E69:AC69)+AE69","v":286.12432738648522}]
[null,null,null,"パイプライン使用料",null,null,null,null,null,null,null,{"$f":"生産と生産額!L35*$F$66","v":5.4749999999999996},{"$f":"生産と生産額!M35*$F$66","v":10.95},{"$f":"生産と生産額!N35*$F$66","v":10.512},{"$f":"生産と生産額!O35*$F$66","v":9.6710400000000014},{"$f":"生産と生産額!P35*$F$66","v":8.8973568000000007},{"$f":"生産と生産額!Q35*$F$66","v":8.1003019199999997},{"$f":"生産と生産額!R35*$F$66","v":7.0984224720000011},{"$f":"生産と生産額!S35*$F$66","v":8.8758703012000009},{"$f":"生産と生産額!T35*$F$66","v":7.6866003160200007},{"$f":"生産と生産額!U35*$F$66","v":6.5336102686169992},{"$f":"生産と生産額!V35*$F$66","v":5.3532757069447507},{"$f":"生産と生産額!W35*$F$66","v":4.1997715634885626},{"$f":"生産と生産額!X35*$F$66","v":3.3069212384044211},{"$f":"生産と生産額!Y35*$F$66","v":2.4801909288033164},{"$f":"生産と生産額!Z35*$F$66","v":1.8284562147045267},{"$f":"生産と生産額!AA35*$F$66","v":1.3174742918018623},{"$f":"生産と生産額!AB35*$F$66","v":0.95039821039282402},{"$f":"生産と生産額!AC35*$F$66","v":0.66527874727497671},{"$f":"生産と生産額!AD35*$F$66","v":0.46569512309248362},{"$f":"生産と生産額!AE35*$F$66","v":0},{"$f":"SUM(E70:AC70)+AE70","v":103.90196897965225}]
[null,null,null,"現地管理費",null,null,null,null,null,null,null,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,7,{"$f":"SUM(E71:AC71)+AE71","v":133}]
[null,null,null,"（計）",null,null,null,null,null,null,null,{"$f":"SUM(L69:L71)","v":28.200000000000003},{"$f":"SUM(M69:M71)","v":36.82},36.130400000000002,34.806368000000006,33.58825856,32.333352063999996,30.755963782400002,33.554429588373338,31.682008168784002,29.866706943466401,28.008353715774202,26.192243082606652,24.786513438364587,23.484885078773441,22.458774898767675,21.654270026544665,21.07633471663674,20.627434301645717,{"$f":"SUM(AD69:AD71)","v":20.313204011152003},7,{"$f":"SUM(E72:AC72)+AE72","v":523.02629636613744}]
[null,null,null,"（計：インフレ含む名目値）",{"$f":"E72*(1+生産と生産額!$O$31)^(E68-2021)","v":0},{"$f":"F72*(1+生産と生産額!$O$31)^(F68-2021)","v":0},{"$f":"G72*(1+生産と生産額!$O$31)^(G68-2021)","v":0},{"$f":"H72*(1+生産と生産額!$O$31)^(H68-2021)","v":0},{"$f":"I72*(1+生産と生産額!$O$31)^(I68-2021)","v":0},{"$f":"J72*(1+生産と生産額!$O$31)^(J68-2021)","v":0},{"$f":"K72*(1+生産と生産額!$O$31)^(K68-2021)","v":0},{"$f":"L72*(1+生産と生産額!$O$31)^(L68-2021)","v":31.297626543830173},{"$f":"M72*(1+生産と生産額!$O$31)^(M68-2021)","v":41.477457038439155},{"$f":"N72*(1+生産と生産額!$O$31)^(N68-2021)","v":41.311137166983876},{"$f":"O72*(1+生産と生産額!$O$31)^(O68-2021)","v":40.394211034848936},{"$f":"P72*(1+生産と生産額!$O$31)^(P68-2021)","v":39.56525347988611},{"$f":"Q72*(1+生産と生産額!$O$31)^(Q68-2021)","v":38.658343271981664},{"$f":"R72*(1+生産と生産額!$O$31)^(R68-2021)","v":37.323975016735986},{"$f":"S72*(1+生産と生産額!$O$31)^(S68-2021)","v":41.330860935645759},{"$f":"T72*(1+生産と生産額!$O$31)^(T68-2021)","v":39.609862548619354},{"$f":"U72*(1+生産と生産額!$O$31)^(U68-2021)","v":37.900419467281679},{"$f":"V72*(1+生産と生産額!$O$31)^(V68-2021)","v":36.075329020087331},{"$f":"W72*(1+生産と生産額!$O$31)^(W68-2021)","v":34.242183725482057},{"$f":"X72*(1+生産と生産額!$O$31)^(X68-2021)","v":32.890482482149267},{"$f":"Y72*(1+生産と生産額!$O$31)^(Y68-2021)","v":31.630735046598627},{"$f":"Z72*(1+生産と生産額!$O$31)^(Z68-2021)","v":30.702444114586672},{"$f":"AA72*(1+生産と生産額!$O$31)^(AA68-2021)","v":30.046679019841207},{"$f":"AB72*(1+生産と生産額!$O$31)^(AB68-2021)","v":29.683428317822123},{"$f":"AC72*(1+生産と生産額!$O$31)^(AC68-2021)","v":29.486975337083681},{"$f":"AD72*(1+生産と生産額!$O$31)^(AD68-2021)","v":29.473348987028086},{"$f":"AE72*(1+生産と生産額!$O$31)^(AE68-2021)","v":10.156617478755688},{"$f":"SUM(E73:AC73)+AE73","v":653.7840210466594}]

{"sheet":"生産と生産額","index":3,"n_rows":38,"n_cols":32,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,30,11,31],[31,30,31,31]]}
[]
[null,"５．原油生産プロファイルの計算",null,null,null,null,null,"⇒ Dashboardでセットする前提条件",null,null,null,null,null,"→","ここでは原油のみが商業生産され、随伴ガスは自家消費されるとしている。"]
[null,null,"・前提条件",null,null,null,null,null,null,null,null,null,null,"→","天然ガス田の場合には、坑井数、生産プロファイル、価格シナリオなどが異なる。"]
[null,null,1,"生産井は4坑ずつ、6ヶ月単位で生産に入るものとする。",null,null,null,null,null,null,null,null,null,null,"例えば、初日産＝４０MMCFD/坑、プラトー7年（生産を最大能力よりやや抑えている）、価格は$/kcf表示、など。"]
[null,null,2,"生産プロファイル"]
[null,null,null,"1) １坑当たり生産量は、初日産2,500BDとし、最初の2年間は初日産と同じ100％で推移し、3年目から年率８％で減少する。"]
[null,null,null,"2) 減退率は、生産量が初日産の80％を割り込むと年率15％、30％を割り込むと年率25％、10％を割り込むと年率30％になると想定する。"]
[null,null,3,"5年目に坑井改修作業を行うため、5年目と6年目は生産がやや持ち直す。"]
[null,null,4,"7年後に4項のIn-fill wellを追加する。生産開始は8年目とし、In-fill wellの初日産は、初期生産井の5年目相当（約80％）から始まり、同じ減退パターンをたどるものとする。"]
[null,null,"→","油田の生産プロファイルは条件によって変化するので、初期には標準的なシナリオを手入力するのが簡便でしょう。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2046年までの合計"]
[null,null,"・2046年には自社収支が赤字となるので、生産は2045年までとする。（「自社収支」参照）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"坑井改修",null,"In-fill well",null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果",null,2021,{"$f":"E13+1","v":2022},{"$f":"F13+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"AB13+1","v":2045},{"$f":"AC13+1","v":2046},2046,"合計"]
[null,null,"生産プロファイル",null,"プラトー","2年",null,null,"減退率：",null,null,0,0,0.08,0.08,0.08,0.1,0.15,0.15,0.15,0.15,0.25,0.25,0.25,0.25,0.3,0.3,0.3,0.3,0.3,0.3]
[null,null,"生産井",null,null,"BD",null,null,"プロファイル",null,null,1,{"$f":"L15*(1-M14)","v":1},{"$f":"M15*(1-N14)","v":0.92},{"$f":"N15*(1-O14)","v":0.84640000000000004},0.77868800000000005,0.70081920000000009,0.59569632000000006,0.50634187200000003,0.43039059120000001,0.36583200251999998,0.27437400189,0.20578050141749998,0.15433537606312497,0.11575153204734373,8.1026072433140611E-2,5.6718250703198421E-2,3.9702775492238891E-2,2.7791942844567222E-2,1.9454359991197052E-2,0]
[null,null,null,"原油生産開始時期","初日産",{"$f":"Dashboard!G25*Dashboard!J25","v":2500},null,null,"　同 半年遅れ",null,null,{"$f":"L15/2","v":0.5},{"$f":"(L15+M15)/2","v":1},0.96,0.88319999999999999,0.81254400000000004,0.73975360000000001,0.64825776000000013,0.5510190960000001,0.46836623160000002,0.39811129686000002,0.32010300220499999,0.24007725165374999,0.18005793874031248,0.13504345405523435,9.8388802240242171E-2,6.8872161568169513E-2,4.8210513097718656E-2,3.374735916840306E-2,2.3623151417882137E-2,0]
[null,null,"Ａ群","４坑（２０２８年１月）",null,null,null,null,"初日産×プロファイル",null,null,{"$f":"($F$16/1000)*365*4*L15","v":3650},{"$f":"($F$16/1000)*365*4*M15","v":3650},3358,3089.36,2842.2112000000002,2557.9900800000005,2174.2915680000001,1848.1478328000001,1570.92565788,1335.2868091979999,1001.4651068985,751.09883017387494,563.32412263040612,422.49309197280462,295.74516438096322,207.02161506667423,144.91513054667195,101.44059138267036,71.008413967869245,{"$f":"($F$16/1000)*365*4*AE15","v":0}]
[null,null,"Ｂ群","４坑（２０２８年７月）",null,null,null,null,"初日産×プロファイル",null,null,{"$f":"($F$16/1000)*365*4*L16","v":1825},{"$f":"($F$16/1000)*365*4*M16","v":3650},3504,3223.68,2965.7856000000002,2700.1006400000001,2366.1408240000005,2011.2197004000004,1709.5367453400002,1453.106233539,1168.3759580482499,876.28196853618749,657.21147640214053,492.9086073016054,359.11912817688392,251.38338972381871,175.9683728066731,123.17786096467117,86.224502675269804,{"$f":"($F$16/1000)*365*4*AE16","v":0}]
[null,null,"Ｃ群","４坑（２０２９年１月）",null,null,null,null,"初日産×プロファイル",null,null,null,{"$f":"($F$16/1000)*4*365*L15","v":3650},3650,3358,3089.36,2842.2112000000002,2557.9900800000005,2174.2915680000001,1848.1478328000001,1570.92565788,1335.2868091979999,1001.4651068985,751.09883017387494,563.32412263040612,422.49309197280462,295.74516438096322,207.02161506667423,144.91513054667195,101.44059138267036,0]
[null,null,"D群","In-fill well 4坑(2035年1月）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($F$16/1000)*P15*4*365","v":2842.2112000000002},{"$f":"($F$16/1000)*Q15*4*365","v":2557.9900800000005},2174.2915680000001,1848.1478328000003,1570.92565788,1335.2868091979999,1001.4651068985,751.09883017387494,563.32412263040612,422.49309197280456,295.74516438096327,{"$f":"($F$16/1000)*AA15*4*365","v":207.02161506667426},0]
[null,null,null,"生産量合計（千バレル/年）",null,null,null,null,null,null,null,{"$f":"SUM(L17:L20)","v":5475},{"$f":"SUM(M17:M20)","v":10950},10512,9671.0400000000009,8897.3568000000014,8100.3019199999999,7098.4224720000011,8875.8703012000005,7686.6003160200007,6533.6102686169997,5353.2757069447507,4199.7715634885626,3306.9212384044213,2480.1909288033162,1828.4562147045267,1317.4742918018624,950.3982103928239,665.27874727497669,{"$f":"SUM(AD17:AD20)","v":465.69512309248364},{"$f":"SUM(AE17:AE20)","v":0},{"$f":"SUM(M21:AC21)","v":98426.968979652258}]
[null,null,null,"日量（千バレル/日）",null,null,null,null,null,null,null,{"$f":"L21/365","v":15},30,28.8,26.496000000000002,24.376320000000003,22.192608,19.447732800000004,24.317452880000001,21.059178948000003,17.900302105799998,14.666508786150002,11.5062234616125,9.0600581874093731,6.7950436405570303,5.0094690813822647,3.609518607676335,2.6038307134049972,{"$f":"AC21/365","v":1.8226814993834979},{"$f":"AD21/365","v":1.2758770495684484},{"$f":"AE21/365","v":0},{"$f":"AVERAGE(M22:AC22)","v":15.862525218316236}]
[]
[]
[null,"６．生産額の計算"]
[null,null,"・前提条件"]
[null,null,1,"生産レートは上記の計算による"]
[null,null,2,"原油価格シナリオ：下記のような「任意のシナリオ」をセットする",null,null,null,null,null,null,null,"前提条件"]
[null,null,null,"1) 2025年の実質原油価格（2021年表示）をバレルあたり「75ドル」とする。",null,null,null,null,null,null,null,"初期原油価格",null,null,{"$f":"Dashboard!G22*Dashboard!J22","v":75},"ドル/バレル"]
[null,null,null,"2) 2021年を起点に、毎年の実質原油価格のエスカレーション率を「1.5％」とする。",null,null,null,null,null,null,null,"エスカレーション",null,null,{"$f":"Dashboard!G24*Dashboard!J24","v":1.4999999999999999E-2},"/年"]
[null,null,null,"3) 2021年を起点に、毎年のインフレ率を「1.5％」とする。",null,null,null,null,null,null,null,"インフレーション",null,null,{"$f":"Dashboard!G21*Dashboard!J21","v":1.4999999999999999E-2},"/年"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果",null,2021,{"$f":"E33+1","v":2022},{"$f":"F33+1","v":2023},{"$f":"G33+1","v":2024},{"$f":"H33+1","v":2025},{"$f":"I33+1","v":2026},{"$f":"J33+1","v":2027},{"$f":"K33+1","v":2028},{"$f":"L33+1","v":2029},{"$f":"M33+1","v":2030},{"$f":"N33+1","v":2031},{"$f":"O33+1","v":2032},{"$f":"P33+1","v":2033},{"$f":"Q33+1","v":2034},{"$f":"R33+1","v":2035},{"$f":"S33+1","v":2036},{"$f":"T33+1","v":2037},{"$f":"U33+1","v":2038},{"$f":"V33+1","v":2039},{"$f":"W33+1","v":2040},{"$f":"X33+1","v":2041},{"$f":"Y33+1","v":2042},{"$f":"Z33+1","v":2043},{"$f":"AA33+1","v":2044},{"$f":"AB33+1","v":2045},{"$f":"AC33+1","v":2046},2046,"合計"]
[null,null,"生産量","レート（1,000BPD)",null,null,null,null,null,null,null,{"$f":"L22","v":15},30,28.8,26.496000000000002,24.376320000000003,22.192608,19.447732800000004,24.317452880000001,21.059178948000003,17.900302105799998,14.666508786150002,11.5062234616125,9.0600581874093731,6.7950436405570303,5.0094690813822647,3.609518607676335,2.6038307134049972,1.8226814993834979,{"$f":"AD22","v":1.2758770495684484},0]
[null,null,null,"年生産量（百万バレル)",null,null,null,null,null,null,null,{"$f":"L34*365/1000","v":5.4749999999999996},{"$f":"M34*365/1000","v":10.95},10.512,9.6710400000000014,8.8973568000000007,8.1003019199999997,7.0984224720000011,8.8758703012000009,7.6866003160200007,6.5336102686169992,5.3532757069447507,4.1997715634885626,3.3069212384044211,2.4801909288033164,1.8284562147045267,1.3174742918018623,0.95039821039282402,0.66527874727497671,{"$f":"AD34*365/1000","v":0.46569512309248362},0,{"$f":"SUM(F35:AC35)","v":103.90196897965225}]
[null,null,null,"実質原油価格（ドル/バレル)",null,null,null,null,{"$f":"O29","v":75},{"$f":"I36*(1+$O$30)","v":76.124999999999986},77.266874999999985,78.425878124999983,79.602266296874973,80.796300291328095,82.008244795698005,83.238368467633464,84.486943994647959,85.754248154567676,87.040561876886187,88.346170305039465,89.671362859615044,91.016433302509256,92.381679802046889,93.767404999077584,95.17391607406374,96.601524815174685,98.0505476874023,99.521305902713323,101.01412549125401,{"$f":"AC36*(1+$O$30)","v":102.52933737362281},104.06727743422714]
[null,null,null,"名目原油価格（ドル/バレル)",null,null,null,null,{"$f":"I36*(1+$O$31)^(I33-2021)","v":79.602266296874959},82.008244795697976,84.48694399464793,87.040561876886144,89.671362859615016,92.381679802046861,95.173916074063712,98.050547687402258,101.01412549125396,104.06727743422711,107.21271089467659,110.45321508146816,113.7916635073055,117.23101653681377,120.77432401163895,124.42472795489071,128.18546535732725,132.05987104775244,136.0513806501707,140.16353363032209,144.39997643429854,148.76446572202519,150.99593270785556]
[null,null,null,"総生産額（百万ドル）",null,null,null,null,null,null,null,{"$f":"L35*L37","v":476.54707627595161},{"$f":"M35*M37","v":981.90142331278435},971.11621807911661,920.43074930891328,872.39070721023279,818.24491466392544,738.71350073897634,951.60611654120169,849.00971795063822,743.47038117434147,627.56995292696354,507.22457158363517,411.46277545672041,317.92442838367481,241.46569193034134,179.24419637074922,133.21117152459252,96.066235428746296,{"$f":"AD35*AD37","v":69.278886176206086},0,{"$f":"SUM(F38:AC38)","v":10837.599828861506}]

{"sheet":"プロジェクト収支","index":4,"n_rows":40,"n_cols":32,"rows_kept":40,"cut":false,"hidden":false,"merged":[[9,30,9,31]]}
[]
[null,"７．プロジェクト全体の収支計算"]
[null,null,"・前提条件"]
[null,null,1,"ロイヤリティ",{"$f":"Dashboard!G10*Dashboard!J10","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,"→","生産量に対する比率"]
[null,null,2,"コスト回収上限",null,"原油",{"$f":"Dashboard!G11*Dashboard!J11","v":0.35},null,"天然ガス",{"$f":"Dashboard!G12*Dashboard!J12","v":0.4},null,null,null,null,null,null,null,"→","生産量に対する比率"]
[null,null,3,"プロフィット・シェアリング（石油会社取り分）",null,null,null,null,"原油５万BD以下（Tier-1)",{"$f":"Dashboard!G13*Dashboard!J13","v":0.3},null,null,"原油5万BD超（Tier-2)",{"$f":"Dashboard!G14*Dashboard!J13","v":0.2},null,"ガス（一律）",{"$f":"Dashboard!G15*Dashboard!J15","v":0.3},"→","「生産量-（ロイヤリティ＋コスト回収）」に対する比率"]
[null,null,4,"石油収入税",{"$f":"Dashboard!G16*Dashboard!J16","v":0.5},null,null,null,null,null,null,null,null,null,null,null,null,"→","プロフィットオイルに対する税率"]
[null,null,5,"本社管理費",{"$f":"Dashboard!G32*Dashboard!J32","v":300},"千ドル/年"]
[null,null,6,"割引率",{"$f":"Dashboard!G36*Dashboard!J36","v":0.05},"/年"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果（百万ドル）",null,2021,{"$f":"E11+1","v":2022},{"$f":"F11+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"AB11+1","v":2045},{"$f":"AC11+1","v":2046},2046,"合計"]
[null,null,null,"①総生産額（再掲）",null,null,null,null,null,null,null,{"$f":"生産と生産額!L38","v":476.54707627595161},{"$f":"生産と生産額!M38","v":981.90142331278435},{"$f":"生産と生産額!N38","v":971.11621807911661},{"$f":"生産と生産額!O38","v":920.43074930891328},{"$f":"生産と生産額!P38","v":872.39070721023279},{"$f":"生産と生産額!Q38","v":818.24491466392544},{"$f":"生産と生産額!R38","v":738.71350073897634},{"$f":"生産と生産額!S38","v":951.60611654120169},{"$f":"生産と生産額!T38","v":849.00971795063822},{"$f":"生産と生産額!U38","v":743.47038117434147},{"$f":"生産と生産額!V38","v":627.56995292696354},{"$f":"生産と生産額!W38","v":507.22457158363517},{"$f":"生産と生産額!X38","v":411.46277545672041},{"$f":"生産と生産額!Y38","v":317.92442838367481},{"$f":"生産と生産額!Z38","v":241.46569193034134},{"$f":"生産と生産額!AA38","v":179.24419637074922},{"$f":"生産と生産額!AB38","v":133.21117152459252},{"$f":"生産と生産額!AC38","v":96.066235428746296},{"$f":"生産と生産額!AD38","v":69.278886176206086},0,{"$f":"SUM(E12:AC12)+AE12","v":10837.599828861506}]
[]
[null,null,null,"②ロイヤリティ（①生産額＊１０％）",null,null,null,null,null,null,null,{"$f":"L12*$E$4","v":47.654707627595165},{"$f":"M12*$E$4","v":98.190142331278437},97.111621807911661,92.043074930891336,87.239070721023282,81.824491466392544,73.871350073897631,95.160611654120174,84.900971795063825,74.347038117434153,62.756995292696359,50.722457158363518,41.146277545672042,31.792442838367482,24.146569193034136,17.924419637074923,13.321117152459252,9.6066235428746296,{"$f":"AD12*$E$4","v":6.9278886176206091},0,{"$f":"SUM(E14:AC14)+AE14","v":1083.7599828861505}]
[null,null,"コスト回収"]
[null,null,null,"③コスト回収原資（①生産額＊３５％）",null,null,null,null,null,null,null,{"$f":"L12*$G$5","v":166.79147669658306},343.66549815947451,339.89067632769081,322.15076225811964,305.33674752358144,286.38572013237388,258.54972525864173,333.0621407894206,297.15340128272334,260.21463341101952,219.64948352443722,177.52860005427229,144.01197140985212,111.27354993428618,84.512992175619459,62.735468729762225,46.62391003360738,33.623182400061204,24.247610161672128,0]
[null,null,null,"　Ａ．操業費（優先回収）",null,null,null,null,null,null,null,{"$f":"作業と支出!L73","v":31.297626543830173},{"$f":"作業と支出!M73","v":41.477457038439155},{"$f":"作業と支出!N73","v":41.311137166983876},{"$f":"作業と支出!O73","v":40.394211034848936},{"$f":"作業と支出!P73","v":39.56525347988611},{"$f":"作業と支出!Q73","v":38.658343271981664},{"$f":"作業と支出!R73","v":37.323975016735986},{"$f":"作業と支出!S73","v":41.330860935645759},{"$f":"作業と支出!T73","v":39.609862548619354},{"$f":"作業と支出!U73","v":37.900419467281679},{"$f":"作業と支出!V73","v":36.075329020087331},{"$f":"作業と支出!W73","v":34.242183725482057},{"$f":"作業と支出!X73","v":32.890482482149267},{"$f":"作業と支出!Y73","v":31.630735046598627},{"$f":"作業と支出!Z73","v":30.702444114586672},{"$f":"作業と支出!AA73","v":30.046679019841207},{"$f":"作業と支出!AB73","v":29.683428317822123},{"$f":"作業と支出!AC73","v":29.486975337083681},{"$f":"作業と支出!AD73","v":29.473348987028086},{"$f":"作業と支出!AE73","v":10.156617478755688},{"$f":"SUM(E17:AC17)+AE17","v":653.7840210466594}]
[null,null,null,"投資回収充当原資（③-A）",null,null,null,null,null,null,"累積投資額（建設仮勘定に相当）",{"$f":"IF(L16-L17>0,L16-L17,0)","v":135.49385015275288},{"$f":"IF(M16-M17>0,M16-M17,0)","v":302.18804112103533},298.57953916070693,281.75655122327072,265.77149404369533,247.72737686039221,221.22575024190576,291.73127985377482,257.543538734104,222.31421394373785,183.57415450434988,143.28641632879024,111.12148892770286,79.64281488768755,53.81054806103279,32.688789709921018,16.940481715785257,{"$f":"IF(AC16-AC17>0,AC16-AC17,0)","v":4.1362070629775225},0,0]
[null,null,null,"投資回収残",{"$f":"SUM(作業と支出!$E$61:'作業と支出'!E61)","v":16.5},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!F61)","v":89.275499999999994},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!G61)","v":155.93105749999998},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!H61)","v":236.13458886249995},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!I61)","v":248.87095146999994},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!J61)","v":433.19424453461636},{"$f":"SUM(作業と支出!$E$61:'作業と支出'!K61)","v":831.09824828334285},{"$f":"K19-K20+作業と支出!L61","v":864.17162668781589},{"$f":"L19-L20+作業と支出!M61","v":728.677776535063},{"$f":"M19-M20+作業と支出!N61","v":426.48973541402768},{"$f":"N19-N20+作業と支出!O61","v":127.91019625332075},{"$f":"O19-O20+作業と支出!P61","v":40.992623021538286},{"$f":"P19-P20+作業と支出!Q61","v":0},{"$f":"Q19-Q20+作業と支出!R61","v":85.191381571148625},{"$f":"R19-R20+作業と支出!S61","v":0},{"$f":"S19-S20+作業と支出!T61","v":0},{"$f":"T19-T20+作業と支出!U61","v":0},{"$f":"U19-U20+作業と支出!V61","v":0},{"$f":"V19-V20+作業と支出!W61","v":0},{"$f":"W19-W20+作業と支出!X61","v":0},{"$f":"X19-X20+作業と支出!Y61","v":0},{"$f":"Y19-Y20+作業と支出!Z61","v":0},{"$f":"Z19-Z20+作業と支出!AA61","v":0},{"$f":"AA19-AA20+作業と支出!AB61","v":0},{"$f":"AB19-AB20+作業と支出!AC61","v":0},{"$f":"AC19-AC20+作業と支出!AD61","v":0},{"$f":"AC19-AC20+作業と支出!AE61","v":54.990828920691513}]
[null,null,null,"　Ｂ．投資回収",null,null,null,null,null,null,null,{"$f":"IF(L19>L18,L18,L19)","v":135.49385015275288},{"$f":"IF(M19>M18,M18,M19)","v":302.18804112103533},298.57953916070693,127.91019625332075,40.992623021538286,0,85.191381571148625,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD19>AD18,AD18,AD19)","v":0},0,{"$f":"SUM(E20:AC20)+AE20","v":990.35563128050285}]
[null,null,null,"④コスト回収額（Ａ＋Ｂ）",null,null,null,null,null,null,null,{"$f":"IF(L17+L20>L16,L16,L17+L20)","v":166.79147669658306},{"$f":"IF(M17+M20>M16,M16,M17+M20)","v":343.66549815947451},339.89067632769081,168.30440728816967,80.557876501424403,38.658343271981664,122.51535658788461,41.330860935645759,39.609862548619354,37.900419467281679,36.075329020087331,34.242183725482057,32.890482482149267,31.630735046598627,30.702444114586672,30.046679019841207,29.683428317822123,29.486975337083681,24.247610161672128,0,1633.9830348484063]
[null,null,"プロフィット原油　（総生産額 － ロイヤリティー と コスト回収＝ ①－②－④）",null,null,null,null,null,null,null,null,{"$f":"L12-L14-L21","v":262.10089195177341},{"$f":"M12-M14-M21","v":540.04578282203136},534.11391994351413,660.08326708985237,704.59375998778512,697.76207992555123,542.32679407719411,815.11464395143571,724.49888360695502,631.22292358962557,528.73762861417981,422.25993069978961,337.42601542889912,254.50125049870869,186.61667862272051,131.2730977138331,90.206626054311144,56.972636548787989,{"$f":"AD12-AD14-AD21","v":38.103387396913348},{"$f":"AE12-AE14-AE21","v":0},8119.8568111269497]
[null,null,null,"⑤プロフィット原油取り分　（前提条件「３」を適用）",null,null,null,null,null,null,null,{"$f":"IF(生産と生産額!L22>50,L22*((生産と生産額!L22-50)/生産と生産額!L22*プロジェクト収支!$N$6+50/生産と生産額!L22*プロジェクト収支!$J$6),L22*プロジェクト収支!$J$6)","v":78.630267585532025},{"$f":"IF(生産と生産額!M22>50,M22*((生産と生産額!M22-50)/生産と生産額!M22*プロジェクト収支!$N$6+50/生産と生産額!M22*プロジェクト収支!$J$6),M22*プロジェクト収支!$J$6)","v":162.0137348466094},{"$f":"IF(生産と生産額!N22>50,N22*((生産と生産額!N22-50)/生産と生産額!N22*プロジェクト収支!$N$6+50/生産と生産額!N22*プロジェクト収支!$J$6),N22*プロジェクト収支!$J$6)","v":160.23417598305423},{"$f":"IF(生産と生産額!O22>50,O22*((生産と生産額!O22-50)/生産と生産額!O22*プロジェクト収支!$N$6+50/生産と生産額!O22*プロジェクト収支!$J$6),O22*プロジェクト収支!$J$6)","v":198.02498012695571},{"$f":"IF(生産と生産額!P22>50,P22*((生産と生産額!P22-50)/生産と生産額!P22*プロジェクト収支!$N$6+50/生産と生産額!P22*プロジェクト収支!$J$6),P22*プロジェクト収支!$J$6)","v":211.37812799633554},{"$f":"IF(生産と生産額!Q22>50,Q22*((生産と生産額!Q22-50)/生産と生産額!Q22*プロジェクト収支!$N$6+50/生産と生産額!Q22*プロジェクト収支!$J$6),Q22*プロジェクト収支!$J$6)","v":209.32862397766536},{"$f":"IF(生産と生産額!R22>50,R22*((生産と生産額!R22-50)/生産と生産額!R22*プロジェクト収支!$N$6+50/生産と生産額!R22*プロジェクト収支!$J$6),R22*プロジェクト収支!$J$6)","v":162.69803822315822},{"$f":"IF(生産と生産額!S22>50,S22*((生産と生産額!S22-50)/生産と生産額!S22*プロジェクト収支!$N$6+50/生産と生産額!S22*プロジェクト収支!$J$6),S22*プロジェクト収支!$J$6)","v":244.5343931854307},{"$f":"IF(生産と生産額!T22>50,T22*((生産と生産額!T22-50)/生産と生産額!T22*プロジェクト収支!$N$6+50/生産と生産額!T22*プロジェクト収支!$J$6),T22*プロジェクト収支!$J$6)","v":217.34966508208649},{"$f":"IF(生産と生産額!U22>50,U22*((生産と生産額!U22-50)/生産と生産額!U22*プロジェクト収支!$N$6+50/生産と生産額!U22*プロジェクト収支!$J$6),U22*プロジェクト収支!$J$6)","v":189.36687707688768},{"$f":"IF(生産と生産額!V22>50,V22*((生産と生産額!V22-50)/生産と生産額!V22*プロジェクト収支!$N$6+50/生産と生産額!V22*プロジェクト収支!$J$6),V22*プロジェクト収支!$J$6)","v":158.62128858425393},{"$f":"IF(生産と生産額!W22>50,W22*((生産と生産額!W22-50)/生産と生産額!W22*プロジェクト収支!$N$6+50/生産と生産額!W22*プロジェクト収支!$J$6),W22*プロジェクト収支!$J$6)","v":126.67797920993688},{"$f":"IF(生産と生産額!X22>50,X22*((生産と生産額!X22-50)/生産と生産額!X22*プロジェクト収支!$N$6+50/生産と生産額!X22*プロジェクト収支!$J$6),X22*プロジェクト収支!$J$6)","v":101.22780462866973},{"$f":"IF(生産と生産額!Y22>50,Y22*((生産と生産額!Y22-50)/生産と生産額!Y22*プロジェクト収支!$N$6+50/生産と生産額!Y22*プロジェクト収支!$J$6),Y22*プロジェクト収支!$J$6)","v":76.350375149612603},{"$f":"IF(生産と生産額!Z22>50,Z22*((生産と生産額!Z22-50)/生産と生産額!Z22*プロジェクト収支!$N$6+50/生産と生産額!Z22*プロジェクト収支!$J$6),Z22*プロジェクト収支!$J$6)","v":55.985003586816156},{"$f":"IF(生産と生産額!AA22>50,AA22*((生産と生産額!AA22-50)/生産と生産額!AA22*プロジェクト収支!$N$6+50/生産と生産額!AA22*プロジェクト収支!$J$6),AA22*プロジェクト収支!$J$6)","v":39.381929314149929},{"$f":"IF(生産と生産額!AB22>50,AB22*((生産と生産額!AB22-50)/生産と生産額!AB22*プロジェクト収支!$N$6+50/生産と生産額!AB22*プロジェクト収支!$J$6),AB22*プロジェクト収支!$J$6)","v":27.061987816293342},{"$f":"IF(生産と生産額!AC22>50,AC22*((生産と生産額!AC22-50)/生産と生産額!AC22*プロジェクト収支!$N$6+50/生産と生産額!AC22*プロジェクト収支!$J$6),AC22*プロジェクト収支!$J$6)","v":17.091790964636395},{"$f":"IF(生産と生産額!AD22>50,AD22*((生産と生産額!AD22-50)/生産と生産額!AD22*プロジェクト収支!$N$6+50/生産と生産額!AD22*プロジェクト収支!$J$6),AD22*プロジェクト収支!$J$6)","v":11.431016219074005},{"$f":"IF(生産と生産額!AE22>50,AE22*((生産と生産額!AE22-50)/生産と生産額!AE22*プロジェクト収支!$N$6+50/生産と生産額!AE22*プロジェクト収支!$J$6),AE22*プロジェクト収支!$J$6)","v":0},2435.9570433380845]
[null,null,null,"石油収入税（⑤×５０％）",null,null,null,null,null,null,null,{"$f":"L23*$E$7","v":39.315133792766012},{"$f":"M23*$E$7","v":81.006867423304698},80.117087991527114,99.012490063477856,105.68906399816777,104.66431198883268,81.349019111579111,122.26719659271535,108.67483254104324,94.683438538443838,79.310644292126966,63.33898960496844,50.613902314334865,38.175187574806301,27.992501793408078,19.690964657074964,13.530993908146671,8.5458954823181976,{"$f":"AD23*$E$7","v":5.7155081095370024},0,1217.9785216690423]
[null,null,"原油販売収入（税前＝④＋⑤）",null,{"$f":"E21+E23","v":0},{"$f":"F21+F23","v":0},0,0,0,0,0,245.42174428211507,505.6792330060839,500.12485231074504,366.32938741512538,291.93600449775994,247.98696724964702,285.2133948110428,285.86525412107648,256.95952763070585,227.26729654416937,194.69661760434127,160.92016293541894,134.11828711081898,107.98111019621123,86.687447701402832,69.428608333991136,56.745416134115466,46.57876630172008,35.678626380746131,0,4069.9400781864906]
[null,null,"本社管理費",null,{"$f":"E8/1000","v":0.3},{"$f":"E26*(1+生産と生産額!$O$31)","v":0.30449999999999994},{"$f":"F26*(1+生産と生産額!$O$31)","v":0.30906749999999988},{"$f":"G26*(1+生産と生産額!$O$31)","v":0.31370351249999984},{"$f":"H26*(1+生産と生産額!$O$31)","v":0.31840906518749978},{"$f":"I26*(1+生産と生産額!$O$31)","v":0.32318520116531224},{"$f":"J26*(1+生産と生産額!$O$31)","v":0.3280329791827919},{"$f":"K26*(1+生産と生産額!$O$31)","v":0.33295347387053376},{"$f":"L26*(1+生産と生産額!$O$31)","v":0.33794777597859171},{"$f":"M26*(1+生産と生産額!$O$31)","v":0.34301699261827057},{"$f":"N26*(1+生産と生産額!$O$31)","v":0.3481622475075446},{"$f":"O26*(1+生産と生産額!$O$31)","v":0.35338468122015776},{"$f":"P26*(1+生産と生産額!$O$31)","v":0.35868545143846009},{"$f":"Q26*(1+生産と生産額!$O$31)","v":0.36406573321003693},{"$f":"R26*(1+生産と生産額!$O$31)","v":0.36952671920818747},{"$f":"S26*(1+生産と生産額!$O$31)","v":0.37506961999631022},{"$f":"T26*(1+生産と生産額!$O$31)","v":0.38069566429625484},{"$f":"U26*(1+生産と生産額!$O$31)","v":0.38640609926069863},{"$f":"V26*(1+生産と生産額!$O$31)","v":0.39220219074960905},{"$f":"W26*(1+生産と生産額!$O$31)","v":0.39808522361085313},{"$f":"X26*(1+生産と生産額!$O$31)","v":0.40405650196501591},{"$f":"Y26*(1+生産と生産額!$O$31)","v":0.41011734949449113},{"$f":"Z26*(1+生産と生産額!$O$31)","v":0.41626910973690845},{"$f":"AA26*(1+生産と生産額!$O$31)","v":0.42251314638296206},{"$f":"AB26*(1+生産と生産額!$O$31)","v":0.42885084357870645},{"$f":"AC26*(1+生産と生産額!$O$31)","v":0.43528360623238699},{"$f":"AC26*(1+生産と生産額!$O$31)","v":0.43528360623238699},9.4541906883915825]
[null,null,"総支出（ボーナス＋費用＋税）",null,{"$f":"作業と支出!E30+作業と支出!E61+作業と支出!E73+プロジェクト収支!E24+E26","v":26.8},{"$f":"作業と支出!F30+作業と支出!F61+作業と支出!F73+プロジェクト収支!F24+F26","v":73.08},{"$f":"作業と支出!G30+作業と支出!G61+作業と支出!G73+プロジェクト収支!G24+G26","v":66.964624999999984},{"$f":"作業と支出!H30+作業と支出!H61+作業と支出!H73+プロジェクト収支!H24+H26","v":80.517234874999971},{"$f":"作業と支出!I30+作業と支出!I61+作業と支出!I73+プロジェクト収支!I24+I26","v":16.054771672687494},{"$f":"作業と支出!J30+作業と支出!J61+作業と支出!J73+プロジェクト収支!J24+J26","v":184.64647826578172},{"$f":"作業と支出!K30+作業と支出!K61+作業と支出!K73+プロジェクト収支!K24+K26","v":398.23203672790936},{"$f":"作業と支出!L30+作業と支出!L61+作業と支出!L73+プロジェクト収支!L24+L26","v":109.01909221493975},{"$f":"作業と支出!M30+作業と支出!M61+作業と支出!M73+プロジェクト収支!M24+M26","v":122.82227223772244},{"$f":"作業と支出!N30+作業と支出!N61+作業と支出!N73+プロジェクト収支!N24+N26","v":121.77124215112927},{"$f":"作業と支出!O30+作業と支出!O61+作業と支出!O73+プロジェクト収支!O24+O26","v":139.75486334583431},{"$f":"作業と支出!P30+作業と支出!P61+作業と支出!P73+プロジェクト収支!P24+P26","v":186.60032518081232},{"$f":"作業と支出!Q30+作業と支出!Q61+作業と支出!Q73+プロジェクト収支!Q24+Q26","v":143.68134071225279},{"$f":"作業と支出!R30+作業と支出!R61+作業と支出!R73+プロジェクト収支!R24+R26","v":204.22844143267375},{"$f":"作業と支出!S30+作業と支出!S61+作業と支出!S73+プロジェクト収支!S24+S26","v":163.96758424756928},{"$f":"作業と支出!T30+作業と支出!T61+作業と支出!T73+プロジェクト収支!T24+T26","v":148.6597647096589},{"$f":"作業と支出!U30+作業と支出!U61+作業と支出!U73+プロジェクト収支!U24+U26","v":132.96455367002179},{"$f":"作業と支出!V30+作業と支出!V61+作業と支出!V73+プロジェクト収支!V24+V26","v":115.772379411475},{"$f":"作業と支出!W30+作業と支出!W61+作業と支出!W73+プロジェクト収支!W24+W26","v":97.973375521200111},{"$f":"作業と支出!X30+作業と支出!X61+作業と支出!X73+プロジェクト収支!X24+X26","v":83.902470020094981},{"$f":"作業と支出!Y30+作業と支出!Y61+作業と支出!Y73+プロジェクト収支!Y24+Y26","v":70.209979123369948},{"$f":"作業と支出!Z30+作業と支出!Z61+作業と支出!Z73+プロジェクト収支!Z24+Z26","v":59.105063257489242},{"$f":"作業と支出!AA30+作業と支出!AA61+作業と支出!AA73+プロジェクト収支!AA24+AA26","v":50.153912786653081},{"$f":"作業と支出!AB30+作業と支出!AB61+作業と支出!AB73+プロジェクト収支!AB24+AB26","v":43.636935372351758},{"$f":"作業と支出!AC30+作業と支出!AC61+作業と支出!AC73+プロジェクト収支!AC24+AC26","v":38.461721662980587},{"$f":"作業と支出!AD30+作業と支出!AD61+作業と支出!AD73+プロジェクト収支!AD24+AD26","v":35.624140702797476},{"$f":"作業と支出!AE30+作業と支出!AE61+作業と支出!AE73+プロジェクト収支!AE24+AE26","v":65.582730005679593},2944.5631936052864]
[null,null,"収支（Net Cash Flow＝総収入－総支出)",null,{"$f":"E25-E27","v":-26.8},{"$f":"F25-F27","v":-73.08},-66.964624999999984,-80.517234874999971,-16.054771672687494,-184.64647826578172,-398.23203672790936,136.40265206717532,382.85696076836143,378.35361015961576,226.57452406929107,105.33567931694762,104.30562653739423,80.984953378369056,121.8976698735072,108.29976292104695,94.302742874147583,78.92423819286627,62.946787414218832,50.215817090724002,37.771131072841285,27.58238444391359,19.274695547338055,13.108480761763708,8.1170446387394932,5.4485677948655109E-2,-65.582730005679593,1125.3768845812035]
[null,null,"　収支累計（名目額）",null,{"$f":"+E28","v":-26.8},{"$f":"+E29+F28","v":-99.88},-166.84462499999998,-247.36185987499994,-263.41663154768742,-448.06310981346917,-846.29514654137847,-709.8924944742032,-327.03553370584177,51.318076453773983,277.89260052306508,383.2282798400127,487.53390637740694,568.51885975577602,690.41652962928322,798.71629255033019,893.01903542447781,971.94327361734406,1034.8900610315629,1085.1058781222869,1122.8770091951283,1150.4593936390418,1169.7340891863798,1182.8425699481436,1190.9596145868832,1191.0141002648318,{"$f":"+AC29+AE28","v":1125.3768845812035}]
[null,null,"現在価値（割引率５％）",null,{"$f":"E28/((1+$E$9)^(E11-2021))","v":-26.8},{"$f":"F28/((1+$E$9)^(F11-2021))","v":-69.599999999999994},-60.738888888888873,-69.553814814814785,-13.208300387338603,-144.67534726748957,-297.16687724032897,96.938818204376318,259.13266107469985,243.89011059208087,139.09710324082755,61.587590098469882,58.081275782475338,42.9480498575629,61.566606597935809,52.094037684222059,43.201173066039424,34.434383695757866,26.155690328160457,19.87210400213656,14.235542057571477,9.900486294734181,6.589052188091399,4.2677451986194148,2.5168350688049439,{"$f":"AD28/((1+$E$9)^(AD11-2021))","v":1.6089771716069491E-2},-19.366761946183175,{"$f":"SUM(E30:AC30)+AE30","v":475.39927448752223}]
[null,null,"　収支累計（割引額）",null,{"$f":"+E30","v":-26.8},{"$f":"+E31+F30","v":-96.399999999999991},-157.13888888888886,-226.69270370370364,-239.90100409104224,-384.57635135853184,-681.74322859886081,-584.80441039448453,-325.67174931978468,-81.781638727703807,57.315464513123743,118.90305461159363,176.98433039406896,219.93238025163186,281.49898684956764,333.59302453378973,376.79419759982915,411.22858129558699,437.38427162374745,457.256375625884,471.49191768345548,481.39240397818969,487.98145616628108,492.2492013649005,494.76603643370544,494.78212620542149,{"$f":"+AC31+AE30","v":475.39927448752223}]
[null,null,null,null,"21年起算",null,"23年起算",null,"25年起算"]
[null,null,null,"ROR",{"$f":"IRR(E28:AC28)","v":0.1459504277871122},"Onward",{"$f":"IRR(G28:AC28)","v":0.19478965901905299},null,{"$f":"IRR(I28:AC28)","v":0.31258555446157965}]
[null,null,null,"NPV　（百万ドル）",{"$f":"AF30","v":475.39927448752223}]
[null,null,"Equity 原油取り分（百万バレル）",null,{"$f":"AF35","v":39.932094076984626},null,null,null,null,null,null,{"$f":"IF(生産と生産額!L35>0,(L21+L23)/生産と生産額!L37,0)","v":2.8196249999999998},{"$f":"IF(生産と生産額!M35>0,(M21+M23)/生産と生産額!M37,0)","v":5.6392499999999988},{"$f":"IF(生産と生産額!N35>0,(N21+N23)/生産と生産額!N37,0)","v":5.4136800000000003},{"$f":"IF(生産と生産額!O35>0,(O21+O23)/生産と生産額!O37,0)","v":3.8490523719760596},{"$f":"IF(生産と生産額!P35>0,(P21+P23)/生産と生産額!P37,0)","v":2.9774030985373936},{"$f":"IF(生産と生産額!Q35>0,(Q21+Q23)/生産と生産額!Q37,0)","v":2.4549731638385395},{"$f":"IF(生産と生産額!R35>0,(R21+R23)/生産と生産額!R37,0)","v":2.7406635576807914},{"$f":"IF(生産と生産額!S35>0,(S21+S23)/生産と生産額!S37,0)","v":2.6663373375746855},{"$f":"IF(生産と生産額!T35>0,(T21+T23)/生産と生産額!T37,0)","v":2.3264105752030617},{"$f":"IF(生産と生産額!U35>0,(U21+U23)/生産と生産額!U37,0)","v":1.9972227273888008},{"$f":"IF(生産と生産額!V35>0,(V21+V23)/生産と生産額!V37,0)","v":1.66079441564171},{"$f":"IF(生産と生産額!W35>0,(W21+W23)/生産と生産額!W37,0)","v":1.3324037559499085},{"$f":"IF(生産と生産額!X35>0,(X21+X23)/生産と生産額!X37,0)","v":1.0779070150705301},{"$f":"IF(生産と生産額!Y35>0,(Y21+Y23)/生産と生産額!Y37,0)","v":0.84238185581497282},{"$f":"IF(生産と生産額!Z35>0,(Z21+Z23)/生産と生産額!Z37,0)","v":0.65642535475486663},{"$f":"IF(生産と生産額!AA35>0,(AA21+AA23)/生産と生産額!AA37,0)","v":0.51031167785436238},{"$f":"IF(生産と生産額!AB35>0,(AB21+AB23)/生産と生産額!AB37,0)","v":0.40485149499569639},{"$f":"IF(生産と生産額!AC35>0,(AC21+AC23)/生産と生産額!AC37,0)","v":0.32256768631062244},{"$f":"IF(生産と生産額!AD35>0,(AD21+AD23)/生産と生産額!AD37,0)","v":0.23983298839262907},{"$f":"IF(生産と生産額!AE35>0,(AE21+AE23)/生産と生産額!AE37,0)","v":0},{"$f":"SUM(G35:AD35)","v":39.932094076984626}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"投資回収期間（回収終了年分を手計算）",null,null,null,null,null,"割引後"]
[null,null,null,null,null,null,null,null,null,null,null,null,"初年度から",null,null,{"$f":"9+(1-N29/N28)","v":9.8643647765588263},"年",{"$f":"10+(1-O31/O30)","v":10.58794638293876},"年"]
[null,null,null,null,null,null,null,null,null,null,null,null,"開発開始以降",null,null,{"$f":"P38-4","v":5.8643647765588263},"年",{"$f":"R38-4","v":6.5879463829387603},"年"]
[null,null,null,null,null,null,null,null,null,null,null,null,"生産開始以降",null,null,{"$f":"P39-3","v":2.8643647765588263},"年",{"$f":"R39-3","v":3.5879463829387603},"年"]

{"sheet":"自社収支 ","index":5,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,30,10,31]]}
[]
[null,"８．自社投資の収支計算"]
[null,null,"・前提条件"]
[null,null,1,"参加比率",{"$f":"Dashboard!G7*Dashboard!J7","v":0.6}]
[null,null,2,"出資金","探鉱期間の費用全額"]
[null,null,3,"借入金","開発費全額",null,null,"→","ここでは坑井改修、In-fill well掘削時に追加借り入れを発生させているが、手元資金で賄ってもよい。"]
[null,null,4,"金利",{"$f":"Dashboard!G34*Dashboard!J34","v":0.05}]
[null,null,5,"返済期間（元利均等返済）",{"$f":"Dashboard!G35","v":7},"年",null,"→","追加借り入れを発生させているため、返済期間が引き延ばされている。"]
[null,null,6,"本社管理費",{"$f":"Dashboard!G32*Dashboard!J32","v":300},"千ドル/年",null,"→","本社で本事業の管理のために必要とされる費用。現地作業の応援のための出張などは事業費に計上される。オペレーターの収入となる「overhead」(ノンオペレーターが支払い）は無視している。"]
[null,null,7,"割引率",{"$f":"Dashboard!G36","v":0.05},"/年"]
[null,null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"廃山ケース"]
[null,null,"・計算結果（百万ドル）",null,2021,{"$f":"E12+1","v":2022},{"$f":"F12+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"AB12+1","v":2045},{"$f":"AC12+1","v":2046},2046,"合計"]
[null,null,"プロジェクト会社の収支"]
[null,null,null,"原油販売収入（税前）",{"$f":"(プロジェクト収支!E21+プロジェクト収支!E23)*$E$4","v":0},{"$f":"(プロジェクト収支!F21+プロジェクト収支!F23)*$E$4","v":0},{"$f":"(プロジェクト収支!G21+プロジェクト収支!G23)*$E$4","v":0},{"$f":"(プロジェクト収支!H21+プロジェクト収支!H23)*$E$4","v":0},{"$f":"(プロジェクト収支!I21+プロジェクト収支!I23)*$E$4","v":0},{"$f":"(プロジェクト収支!J21+プロジェクト収支!J23)*$E$4","v":0},{"$f":"(プロジェクト収支!K21+プロジェクト収支!K23)*$E$4","v":0},{"$f":"(プロジェクト収支!L21+プロジェクト収支!L23)*$E$4","v":147.25304656926903},{"$f":"(プロジェクト収支!M21+プロジェクト収支!M23)*$E$4","v":303.40753980365031},{"$f":"(プロジェクト収支!N21+プロジェクト収支!N23)*$E$4","v":300.07491138644701},{"$f":"(プロジェクト収支!O21+プロジェクト収支!O23)*$E$4","v":219.79763244907522},{"$f":"(プロジェクト収支!P21+プロジェクト収支!P23)*$E$4","v":175.16160269865597},{"$f":"(プロジェクト収支!Q21+プロジェクト収支!Q23)*$E$4","v":148.7921803497882},{"$f":"(プロジェクト収支!R21+プロジェクト収支!R23)*$E$4","v":171.12803688662567},{"$f":"(プロジェクト収支!S21+プロジェクト収支!S23)*$E$4","v":171.51915247264589},{"$f":"(プロジェクト収支!T21+プロジェクト収支!T23)*$E$4","v":154.1757165784235},{"$f":"(プロジェクト収支!U21+プロジェクト収支!U23)*$E$4","v":136.36037792650163},{"$f":"(プロジェクト収支!V21+プロジェクト収支!V23)*$E$4","v":116.81797056260476},{"$f":"(プロジェクト収支!W21+プロジェクト収支!W23)*$E$4","v":96.55209776125136},{"$f":"(プロジェクト収支!X21+プロジェクト収支!X23)*$E$4","v":80.470972266491387},{"$f":"(プロジェクト収支!Y21+プロジェクト収支!Y23)*$E$4","v":64.788666117726734},{"$f":"(プロジェクト収支!Z21+プロジェクト収支!Z23)*$E$4","v":52.012468620841695},{"$f":"(プロジェクト収支!AA21+プロジェクト収支!AA23)*$E$4","v":41.657165000394677},{"$f":"(プロジェクト収支!AB21+プロジェクト収支!AB23)*$E$4","v":34.047249680469278},{"$f":"(プロジェクト収支!AC21+プロジェクト収支!AC23)*$E$4","v":27.947259781032049},{"$f":"(プロジェクト収支!AD21+プロジェクト収支!AD23)*$E$4","v":21.407175828447677},{"$f":"(プロジェクト収支!AE21+プロジェクト収支!AE23)*$E$4","v":0},{"$f":"SUM(E14:AC14)+AE14","v":2441.9640469118949}]
[null,null,null,"ボーナス",{"$f":"作業と支出!E30*'自社収支 '!$E$4","v":6},{"$f":"作業と支出!F30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!G30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!H30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!I30*'自社収支 '!$E$4","v":1.7999999999999998},{"$f":"作業と支出!J30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!K30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!L30*'自社収支 '!$E$4","v":3},{"$f":"作業と支出!M30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!N30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!O30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!P30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!Q30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!R30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!S30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!T30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!U30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!V30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!W30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!X30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!Y30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!Z30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AA30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AB30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AC30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AD30*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AE30*'自社収支 '!$E$4","v":0},{"$f":"SUM(E15:AC15)+AE15","v":10.8}]
[null,null,null,"探鉱・開発費",{"$f":"作業と支出!E61*'自社収支 '!$E$4","v":9.9},{"$f":"作業と支出!F61*'自社収支 '!$E$4","v":43.665299999999995},{"$f":"作業と支出!G61*'自社収支 '!$E$4","v":39.993334499999989},{"$f":"作業と支出!H61*'自社収支 '!$E$4","v":48.122118817499981},{"$f":"作業と支出!I61*'自社収支 '!$E$4","v":7.6418175644999957},{"$f":"作業と支出!J61*'自社収支 '!$E$4","v":110.59397583876985},{"$f":"作業と支出!K61*'自社収支 '!$E$4","v":238.74240224923591},{"$f":"作業と支出!L61*'自社収支 '!$E$4","v":19.844027042683809},{"$f":"作業と支出!M61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!N61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!O61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!P61*'自社収支 '!$E$4","v":24.595573812922972},{"$f":"作業と支出!Q61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!R61*'自社収支 '!$E$4","v":51.114828942689172},{"$f":"作業と支出!S61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!T61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!U61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!V61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!W61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!X61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!Y61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!Z61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AA61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AB61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AC61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AD61*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!AE61*'自社収支 '!$E$4","v":32.994497352414903},627.20787612071661]
[null,null,null,"操業費",{"$f":"作業と支出!E73*$E$4","v":0},{"$f":"作業と支出!F73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!G73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!H73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!I73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!J73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!K73*'自社収支 '!$E$4","v":0},{"$f":"作業と支出!L73*'自社収支 '!$E$4","v":18.778575926298103},{"$f":"作業と支出!M73*'自社収支 '!$E$4","v":24.886474223063491},{"$f":"作業と支出!N73*'自社収支 '!$E$4","v":24.786682300190325},{"$f":"作業と支出!O73*'自社収支 '!$E$4","v":24.236526620909363},{"$f":"作業と支出!P73*'自社収支 '!$E$4","v":23.739152087931664},{"$f":"作業と支出!Q73*'自社収支 '!$E$4","v":23.195005963188997},{"$f":"作業と支出!R73*'自社収支 '!$E$4","v":22.394385010041592},{"$f":"作業と支出!S73*'自社収支 '!$E$4","v":24.798516561387455},{"$f":"作業と支出!T73*'自社収支 '!$E$4","v":23.765917529171613},{"$f":"作業と支出!U73*'自社収支 '!$E$4","v":22.740251680369006},{"$f":"作業と支出!V73*'自社収支 '!$E$4","v":21.645197412052397},{"$f":"作業と支出!W73*'自社収支 '!$E$4","v":20.545310235289232},{"$f":"作業と支出!X73*'自社収支 '!$E$4","v":19.734289489289559},{"$f":"作業と支出!Y73*'自社収支 '!$E$4","v":18.978441027959175},{"$f":"作業と支出!Z73*'自社収支 '!$E$4","v":18.421466468752001},{"$f":"作業と支出!AA73*'自社収支 '!$E$4","v":18.028007411904724},{"$f":"作業と支出!AB73*'自社収支 '!$E$4","v":17.810056990693273},{"$f":"作業と支出!AC73*'自社収支 '!$E$4","v":17.692185202250208},{"$f":"作業と支出!AD73*'自社収支 '!$E$4","v":17.684009392216851},{"$f":"作業と支出!AE73*'自社収支 '!$E$4","v":6.0939704872534124},392.27041262799554]
[null,null,null,"石油収入税",{"$f":"プロジェクト収支!E24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!F24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!G24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!H24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!I24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!J24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!K24*'自社収支 '!$E$4","v":0},{"$f":"プロジェクト収支!L24*'自社収支 '!$E$4","v":23.589080275659608},{"$f":"プロジェクト収支!M24*'自社収支 '!$E$4","v":48.604120453982816},{"$f":"プロジェクト収支!N24*'自社収支 '!$E$4","v":48.070252794916264},{"$f":"プロジェクト収支!O24*'自社収支 '!$E$4","v":59.40749403808671},{"$f":"プロジェクト収支!P24*'自社収支 '!$E$4","v":63.413438398900659},{"$f":"プロジェクト収支!Q24*'自社収支 '!$E$4","v":62.798587193299603},{"$f":"プロジェクト収支!R24*'自社収支 '!$E$4","v":48.809411466947466},{"$f":"プロジェクト収支!S24*'自社収支 '!$E$4","v":73.360317955629213},{"$f":"プロジェクト収支!T24*'自社収支 '!$E$4","v":65.204899524625944},{"$f":"プロジェクト収支!U24*'自社収支 '!$E$4","v":56.8100631230663},{"$f":"プロジェクト収支!V24*'自社収支 '!$E$4","v":47.58638657527618},{"$f":"プロジェクト収支!W24*'自社収支 '!$E$4","v":38.003393762981062},{"$f":"プロジェクト収支!X24*'自社収支 '!$E$4","v":30.368341388600918},{"$f":"プロジェクト収支!Y24*'自社収支 '!$E$4","v":22.905112544883782},{"$f":"プロジェクト収支!Z24*'自社収支 '!$E$4","v":16.795501076044847},{"$f":"プロジェクト収支!AA24*'自社収支 '!$E$4","v":11.814578794244978},{"$f":"プロジェクト収支!AB24*'自社収支 '!$E$4","v":8.1185963448880027},{"$f":"プロジェクト収支!AC24*'自社収支 '!$E$4","v":5.1275372893909186},{"$f":"プロジェクト収支!AD24*'自社収支 '!$E$4","v":3.4293048657222012},{"$f":"プロジェクト収支!AE24*'自社収支 '!$E$4","v":0},730.78711300142538]
[null,null,null,"支出合計",{"$f":"SUM(E15:E18)","v":15.9},{"$f":"SUM(F15:F18)","v":43.665299999999995},39.993334499999989,48.122118817499981,9.4418175644999955,110.59397583876985,238.74240224923591,65.21168324464152,73.490594677046303,72.856935095106593,83.64402065899607,111.7481642997553,85.9935931564886,122.31862541967823,98.158834517016672,88.97081705379756,79.550314803435299,69.231583987328577,58.548703998270298,50.102630877890476,41.883553572842956,35.216967544796844,29.842586206149704,25.928653335581274,22.819722491641127,21.113314257939052,39.088467839668319,1761.0654017501377]
[null,null,null,"借入金返済原資",{"$f":"IF(E14-E15-E17-E18>0,E14-E15-E17-E18,0)","v":0},{"$f":"IF(F14-F15-F17-F18>0,F14-F15-F17-F18,0)","v":0},0,0,0,0,0,101.88539036731132,229.91694512660399,227.21797629134045,136.15361179007914,88.009012211823631,62.798587193299589,99.92424040963661,73.360317955629213,65.204899524625944,56.810063123066328,47.58638657527618,38.003393762981062,30.368341388600911,22.905112544883774,16.795501076044847,11.814578794244975,8.1185963448880027,5.1275372893909221,0.29386157050862538,0]
[null,null,"出資",null,{"$f":"E19","v":15.9},{"$f":"F19","v":43.665299999999995},{"$f":"G19","v":39.993334499999989},{"$f":"H19","v":48.122118817499981},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:AC21)+AE21","v":147.68075331749998}]
[null,null,"借入れ","元本",{"$f":"IF(E19-E14-E21>0,E19-E14-E21,0)","v":0},{"$f":"IF(F19-F14-F21>0,F19-F14-F21,0)","v":0},{"$f":"IF(G19-G14-G21>0,G19-G14-G21,0)","v":0},{"$f":"IF(H19-H14-H21>0,H19-H14-H21,0)","v":0},{"$f":"I15+I16","v":9.4418175644999955},{"$f":"J15+J16","v":110.59397583876985},{"$f":"K15+K16","v":238.74240224923591},{"$f":"L15+L16","v":22.844027042683809},{"$f":"M15+M16","v":0},0,0,24.595573812922972,0,51.114828942689172,0,0,0,null,null,null,null,null,null,null,null,null,null,457.33262545080174]
[null,null,null,"金利",{"$f":"(E22)*$E$7","v":0},{"$f":"(F22)*$E$7","v":0},0,0,{"$f":"(H26+I22)*$E$7","v":0.47209087822499979},{"$f":"(I26+J22)*$E$7","v":6.0253942140747432},18.263784037240278,20.319174591236482,17.835133320798306,15.226889986838223,12.488234486180133,10.842424901135288,7.8845461461920543,7.6945855409711363,4.5793148180196921,1.3082805589206772,0,null,null,null,null,null,null,null,null,null,null,122.939853479832]
[null,null,"資金返済（金利含む7年均等返済）",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I22:L23)*E25,-1)","v":70},{"$f":"IF(L26+M22+M23>$L$24,IF(M20>$L$24,$L$24,M20),IF(M20>L26+M22+M23,L26+M22+M23,M20))","v":70},{"$f":"IF(M26+N22+N23>$L$24,IF(N20>$L$24,$L$24,N20),IF(N20>M26+N22+N23,M26+N22+N23,N20))","v":70},70,70,62.798587193299589,70,70,27.47389173733422,0,null,null,null,null,null,null,null,null,null,null,580.27247893063384]
[null,null,null,"資本回収係数",{"$f":"E7/(1-(1+E7)^(-1*E8))","v":0.1728198184461707},"/年",null,null,null,null,"Debt Service Coverage Ratio",{"$f":"SUM(L20:S20)/SUM(L24:S24)","v":1.8438290273511722}]
[null,null,"年末借入残（金利含む）",null,null,null,null,null,{"$f":"H26+I22+I23-I24","v":9.9139084427249955},{"$f":"I26+J22+J23-J24","v":126.53327849556959},{"$f":"J26+K22+K23-K24","v":383.5394647820458},{"$f":"K26+L22+L23-L24","v":356.70266641596612},{"$f":"L26+M22+M23-M24","v":304.53779973676444},249.76468972360266,192.2529242097828,157.69092292384107,102.77688187673354,91.586296360393845,26.165611178413542,0,0]
[null,null,null,"Debt/Equity Ratio",null,null,null,null,{"$f":"I26/$AF$21","v":6.713067356455725E-2},0.85680276984729842,2.597084969884135,2.415363264359089,2.0621360122807357,1.6912473975984645,1.30181435218208]
[null,null,"本社管理費",null,{"$f":"プロジェクト収支!E26","v":0.3},{"$f":"プロジェクト収支!F26","v":0.30449999999999994},{"$f":"プロジェクト収支!G26","v":0.30906749999999988},{"$f":"プロジェクト収支!H26","v":0.31370351249999984},{"$f":"プロジェクト収支!I26","v":0.31840906518749978},{"$f":"プロジェクト収支!J26","v":0.32318520116531224},{"$f":"プロジェクト収支!K26","v":0.3280329791827919},{"$f":"プロジェクト収支!L26","v":0.33295347387053376},{"$f":"プロジェクト収支!M26","v":0.33794777597859171},{"$f":"プロジェクト収支!N26","v":0.34301699261827057},{"$f":"プロジェクト収支!O26","v":0.3481622475075446},{"$f":"プロジェクト収支!P26","v":0.35338468122015776},{"$f":"プロジェクト収支!Q26","v":0.35868545143846009},{"$f":"プロジェクト収支!R26","v":0.36406573321003693},{"$f":"プロジェクト収支!S26","v":0.36952671920818747},{"$f":"プロジェクト収支!T26","v":0.37506961999631022},{"$f":"プロジェクト収支!U26","v":0.38069566429625484},{"$f":"プロジェクト収支!V26","v":0.38640609926069863},{"$f":"プロジェクト収支!W26","v":0.39220219074960905},{"$f":"プロジェクト収支!X26","v":0.39808522361085313},{"$f":"プロジェクト収支!Y26","v":0.40405650196501591},{"$f":"プロジェクト収支!Z26","v":0.41011734949449113},{"$f":"プロジェクト収支!AA26","v":0.41626910973690845},{"$f":"プロジェクト収支!AB26","v":0.42251314638296206},{"$f":"プロジェクト収支!AC26","v":0.42885084357870645},{"$f":"プロジェクト収支!AD26","v":0.43528360623238699},{"$f":"プロジェクト収支!AE26","v":0.43528360623238699},{"$f":"SUM(E28:AC28)+AE28","v":9.4541906883915825}]
[null,null,"プロジェクト会社のキャッシュフロー"]
[null,null,"　・借入金なし",null,{"$f":"E14-(E19+E28)","v":-16.2},-43.969799999999992,-40.302401999999987,-48.435822329999979,-9.7602266296874944,-110.91716103993517,-239.07043522841869,81.708409850756979,229.5789973506254,226.87495929872216,135.80544954257161,63.060053717680503,62.439901741861135,48.445345733737398,72.990791236421032,64.829829904629634,56.429367458770074,47.199980476015483,37.611191572231455,29.970256164990055,22.501056042918762,16.385383726550359,11.398309684508064,7.6960831985050433,4.6986864458122142,{"$f":"AD14-(AD19+AD28)","v":-0.14142203572376033},-39.523751445900707,{"$f":"SUM(E30:AC30)+AE30","v":671.44445447336534}]
[null,null,null,"収支累計",{"$f":"SUM($E$30:E30)","v":-16.2},{"$f":"SUM($E$30:F30)","v":-60.169799999999995},{"$f":"SUM($E$30:G30)","v":-100.47220199999998},{"$f":"SUM($E$30:H30)","v":-148.90802432999996},{"$f":"SUM($E$30:I30)","v":-158.66825095968744},{"$f":"SUM($E$30:J30)","v":-269.58541199962258},{"$f":"SUM($E$30:K30)","v":-508.65584722804124},{"$f":"SUM($E$30:L30)","v":-426.94743737728425},{"$f":"SUM($E$30:M30)","v":-197.36844002665885},{"$f":"SUM($E$30:N30)","v":29.506519272063315},{"$f":"SUM($E$30:O30)","v":165.31196881463492},{"$f":"SUM($E$30:P30)","v":228.37202253231544},{"$f":"SUM($E$30:Q30)","v":290.81192427417659},{"$f":"SUM($E$30:R30)","v":339.25727000791397},{"$f":"SUM($E$30:S30)","v":412.24806124433502},{"$f":"SUM($E$30:T30)","v":477.07789114896468},{"$f":"SUM($E$30:U30)","v":533.5072586077348},{"$f":"SUM($E$30:V30)","v":580.70723908375032},{"$f":"SUM($E$30:W30)","v":618.31843065598173},{"$f":"SUM($E$30:X30)","v":648.28868682097175},{"$f":"SUM($E$30:Y30)","v":670.78974286389052},{"$f":"SUM($E$30:Z30)","v":687.17512659044087},{"$f":"SUM($E$30:AA30)","v":698.5734362749489},{"$f":"SUM($E$30:AB30)","v":706.2695194734539},{"$f":"SUM($E$30:AC30)","v":710.9682059192661},{"$f":"SUM($E$30:AD30)","v":710.82678388354236},{"$f":"SUM($E$30:AC30)+AE30","v":671.44445447336534}]
[null,null,null,"現在価値（割引率５％）",{"$f":"E30/((1+$E$10)^(E12-2021))","v":-16.2},{"$f":"F30/((1+$E$10)^(F12-2021))","v":-41.875999999999991},-36.555466666666653,-41.84068444444442,-8.0297626027735305,-86.906497985185112,-178.39803964806566,58.068641395553087,155.38810210198295,146.24562163050615,83.372765377245557,36.869907377405994,34.768873677198457,25.691601181993882,36.865309517302428,31.184256650456145,25.850943411549149,20.59319513698269,15.628226952439977,11.860248064974183,8.4804113761120572,5.8814083803573753,3.8965106962544755,2.5056238564579667,1.4569118873264062,-4.1762319128366351E-2,{"$f":"AE30/((1+$E$10)^(AE12-2021))","v":-11.671473349867911},{"$f":"SUM(E32:AC32)+AE32","v":283.13063397509558}]
[null,null,"　・借入金あり",null,{"$f":"E14+E22-E19-E24-E28","v":-16.2},{"$f":"F14+F22-F19-F24-F28","v":-43.969799999999992},-40.302401999999987,-48.435822329999979,-0.31840906518749978,-0.32318520116531224,-0.3280329791827919,34.552436893440799,159.5789973506254,156.87495929872216,65.805449542571594,17.655627530603475,-0.35868545143845298,29.560174676426573,2.9907912364210256,37.355938167295413,56.429367458770074,47.199980476015483,37.611191572231455,29.970256164990058,22.501056042918762,16.385383726550359,11.398309684508064,7.6960831985050424,4.698686445812216,{"$f":"AD14+AD22-AD19-AD24-AD28","v":-0.14142203572376205},-39.523751445900707,{"$f":"SUM(E33:AC33)+AE33","v":548.50460099353302}]
[null,null,null,"収支累計",{"$f":"SUM($E$33:E33)","v":-16.2},{"$f":"SUM($E$33:F33)","v":-60.169799999999995},{"$f":"SUM($E$33:G33)","v":-100.47220199999998},{"$f":"SUM($E$33:H33)","v":-148.90802432999996},{"$f":"SUM($E$33:I33)","v":-149.22643339518746},{"$f":"SUM($E$33:J33)","v":-149.54961859635276},{"$f":"SUM($E$33:K33)","v":-149.87765157553554},{"$f":"SUM($E$33:L33)","v":-115.32521468209474},{"$f":"SUM($E$33:M33)","v":44.253782668530661},{"$f":"SUM($E$33:N33)","v":201.12874196725284},{"$f":"SUM($E$33:O33)","v":266.93419150982442},{"$f":"SUM($E$33:P33)","v":284.58981904042787},{"$f":"SUM($E$33:Q33)","v":284.23113358898939},{"$f":"SUM($E$33:R33)","v":313.79130826541598},{"$f":"SUM($E$33:S33)","v":316.78209950183702},{"$f":"SUM($E$33:T33)","v":354.13803766913242},{"$f":"SUM($E$33:U33)","v":410.56740512790248},{"$f":"SUM($E$33:V33)","v":457.76738560391794},{"$f":"SUM($E$33:W33)","v":495.37857717614941},{"$f":"SUM($E$33:X33)","v":525.34883334113943},{"$f":"SUM($E$33:Y33)","v":547.8498893840582},{"$f":"SUM($E$33:Z33)","v":564.23527311060855},{"$f":"SUM($E$33:AA33)","v":575.63358279511658},{"$f":"SUM($E$33:AB33)","v":583.32966599362157},{"$f":"SUM($E$33:AC33)","v":588.02835243943377},{"$f":"SUM($E$33:AD33)","v":587.88693040371004},{"$f":"SUM($E$33:AC33)+AE33","v":548.50460099353302}]
[null,null,null,"現在価値（割引率５％）",{"$f":"E33/((1+$E$10)^(E12-2021))","v":-16.2},{"$f":"F33/((1+$E$10)^(F12-2021))","v":-41.875999999999991},-36.555466666666653,-41.84068444444442,-0.26195592592592576,-0.25322406172839484,-0.24478325967078168,24.55577181066759,108.00934675997486,101.12299749526035,40.398837629392396,10.322879752968172,-0.19972948071684055,15.676391759713377,1.5105528076161043,17.968844973698154,25.850943411549149,20.59319513698269,15.628226952439977,11.860248064974183,8.4804113761120572,5.8814083803573753,3.8965106962544755,2.5056238564579667,1.4569118873264069,{"$f":"AD33/((1+$E$10)^(AD12-2021))","v":-4.1762319128366858E-2},-11.671473349867911,{"$f":"SUM(E35:AC35)+AE35","v":266.61578556272428}]
[null,null,null,"割引後収支累計",{"$f":"SUM($E$35:E35)","v":-16.2},{"$f":"SUM($E$35:F35)","v":-58.075999999999993},{"$f":"SUM($E$35:G35)","v":-94.631466666666654},{"$f":"SUM($E$35:H35)","v":-136.47215111111109},{"$f":"SUM($E$35:I35)","v":-136.73410703703701},{"$f":"SUM($E$35:J35)","v":-136.9873310987654},{"$f":"SUM($E$35:K35)","v":-137.23211435843618},{"$f":"SUM($E$35:L35)","v":-112.67634254776858},{"$f":"SUM($E$35:M35)","v":-4.6669957877937236},{"$f":"SUM($E$35:N35)","v":96.456001707466626},{"$f":"SUM($E$35:O35)","v":136.85483933685902},{"$f":"SUM($E$35:P35)","v":147.17771908982718},{"$f":"SUM($E$35:Q35)","v":146.97798960911032},{"$f":"SUM($E$35:R35)","v":162.65438136882369},{"$f":"SUM($E$35:S35)","v":164.1649341764398},{"$f":"SUM($E$35:T35)","v":182.13377915013797},{"$f":"SUM($E$35:U35)","v":207.98472256168711},{"$f":"SUM($E$35:V35)","v":228.57791769866981},{"$f":"SUM($E$35:W35)","v":244.20614465110978},{"$f":"SUM($E$35:X35)","v":256.06639271608395},{"$f":"SUM($E$35:Y35)","v":264.546804092196},{"$f":"SUM($E$35:Z35)","v":270.42821247255335},{"$f":"SUM($E$35:AA35)","v":274.32472316880785},{"$f":"SUM($E$35:AB35)","v":276.83034702526584},{"$f":"SUM($E$35:AC35)","v":278.28725891259222},{"$f":"SUM($E$35:AD35)","v":278.24549659346383},{"$f":"SUM($E$35:AC35)+AE35","v":266.61578556272428}]
[null,null,null,null,"21年起算",null,null,null,"25年起算"]
[null,null,null,"ROR",{"$f":"IRR(E30:AC30)","v":0.14527732472774257},null,null,"開発以降",{"$f":"IRR(I30:AC30)","v":0.31169679311210907}]
[null,null,null,"NPV　（借入金なし、百万ドル）",{"$f":"AF32","v":283.13063397509558}]
[null,null,null,"FIRR",{"$f":"IRR(E33:AC33)","v":0.19318623789954104},null,null,"開発以降",{"$f":"IRR(I33:AC33)","v":4.6135176217082137},null,"金利/収益比率",null,{"$f":"AF23/(AF23+AF33)","v":0.18309757815522892}]
[null,null,null,"NPV　（借入金あり、百万ドル）",{"$f":"AF35","v":266.61578556272428}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"投資回収期間（借入金あり）",null,null,null,null,null,"割引後"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"初年度から",null,null,{"$f":"8+(1-M34/M33)","v":8.7226841664426757},"年",{"$f":"9+(1-N36/N35)","v":9.0461516757156293},"年"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"開発開始以降",null,null,{"$f":"Q44-4","v":4.7226841664426757},"年",{"$f":"S44-4","v":5.0461516757156293},"年"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"生産開始以降",null,null,{"$f":"Q45-3","v":1.7226841664426757},"年",{"$f":"S45-3","v":2.0461516757156293},"年"]

{"sheet":"表8.2 ","index":6,"n_rows":78,"n_cols":33,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,9,1,20]]}
[null,"キャッシュフロー／採算計算(原油生産、廃山費用込みモデルケース) "]
[null,null,null,null,null,null,null,null,null,"表８．２　キャッシュフロー計算例　"]
[null,null,null,"探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：百万ドル"]
[null,null,null,2021,{"$f":"D4+1","v":2022},{"$f":"E4+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"AA4+1","v":2045},{"$f":"AB4+1","v":2046},"合計 (2046まで)"]
[null,null,null,null,null,null,null,null,null,null,"生産期間20年（2047年まで）"]
[null,"生産量","レート（1,000BPD)",null,null,null,null,null,null,null,{"$f":"生産と生産額!L22","v":15},{"$f":"生産と生産額!M22","v":30},{"$f":"生産と生産額!N22","v":28.8},{"$f":"生産と生産額!O22","v":26.496000000000002},{"$f":"生産と生産額!P22","v":24.376320000000003},{"$f":"生産と生産額!Q22","v":22.192608},{"$f":"生産と生産額!R22","v":19.447732800000004},{"$f":"生産と生産額!S22","v":24.317452880000001},{"$f":"生産と生産額!T22","v":21.059178948000003},{"$f":"生産と生産額!U22","v":17.900302105799998},{"$f":"生産と生産額!V22","v":14.666508786150002},{"$f":"生産と生産額!W22","v":11.5062234616125},{"$f":"生産と生産額!X22","v":9.0600581874093731},{"$f":"生産と生産額!Y22","v":6.7950436405570303},{"$f":"生産と生産額!Z22","v":5.0094690813822647},{"$f":"生産と生産額!AA22","v":3.609518607676335},{"$f":"生産と生産額!AB22","v":2.6038307134049972},{"$f":"生産と生産額!AC22","v":1.8226814993834979},0]
[null,null,"年生産量（百万バレル)",null,null,null,null,null,null,null,{"$f":"K6*365/1000","v":5.4749999999999996},{"$f":"L6*365/1000","v":10.95},10.512,9.6710400000000014,8.8973568000000007,8.1003019199999997,7.0984224720000011,8.8758703012000009,7.6866003160200007,6.5336102686169992,5.3532757069447507,4.1997715634885626,3.3069212384044211,2.4801909288033164,1.8284562147045267,1.3174742918018623,0.95039821039282402,0.66527874727497671,{"$f":"AC6*365/1000","v":0},{"$f":"SUM(D7:AC7)","v":103.90196897965225}]
[null,null,"実質原油価格（ドル/Bbl)",null,null,null,null,{"$f":"生産と生産額!I36","v":75},{"$f":"生産と生産額!J36","v":76.124999999999986},{"$f":"生産と生産額!K36","v":77.266874999999985},{"$f":"生産と生産額!L36","v":78.425878124999983},{"$f":"生産と生産額!M36","v":79.602266296874973},{"$f":"生産と生産額!N36","v":80.796300291328095},{"$f":"生産と生産額!O36","v":82.008244795698005},{"$f":"生産と生産額!P36","v":83.238368467633464},{"$f":"生産と生産額!Q36","v":84.486943994647959},{"$f":"生産と生産額!R36","v":85.754248154567676},{"$f":"生産と生産額!S36","v":87.040561876886187},{"$f":"生産と生産額!T36","v":88.346170305039465},{"$f":"生産と生産額!U36","v":89.671362859615044},{"$f":"生産と生産額!V36","v":91.016433302509256},{"$f":"生産と生産額!W36","v":92.381679802046889},{"$f":"生産と生産額!X36","v":93.767404999077584},{"$f":"生産と生産額!Y36","v":95.17391607406374},{"$f":"生産と生産額!Z36","v":96.601524815174685},{"$f":"生産と生産額!AA36","v":98.0505476874023},{"$f":"生産と生産額!AB36","v":99.521305902713323},{"$f":"生産と生産額!AC36","v":101.01412549125401},{"$f":"生産と生産額!AD36","v":102.52933737362281}]
[null,null,"名目原油価格（ドル/Bbl)",null,null,null,null,{"$f":"生産と生産額!I37","v":79.602266296874959},{"$f":"生産と生産額!J37","v":82.008244795697976},{"$f":"生産と生産額!K37","v":84.48694399464793},{"$f":"生産と生産額!L37","v":87.040561876886144},{"$f":"生産と生産額!M37","v":89.671362859615016},{"$f":"生産と生産額!N37","v":92.381679802046861},{"$f":"生産と生産額!O37","v":95.173916074063712},{"$f":"生産と生産額!P37","v":98.050547687402258},{"$f":"生産と生産額!Q37","v":101.01412549125396},{"$f":"生産と生産額!R37","v":104.06727743422711},{"$f":"生産と生産額!S37","v":107.21271089467659},{"$f":"生産と生産額!T37","v":110.45321508146816},{"$f":"生産と生産額!U37","v":113.7916635073055},{"$f":"生産と生産額!V37","v":117.23101653681377},{"$f":"生産と生産額!W37","v":120.77432401163895},{"$f":"生産と生産額!X37","v":124.42472795489071},{"$f":"生産と生産額!Y37","v":128.18546535732725},{"$f":"生産と生産額!Z37","v":132.05987104775244},{"$f":"生産と生産額!AA37","v":136.0513806501707},{"$f":"生産と生産額!AB37","v":140.16353363032209},{"$f":"生産と生産額!AC37","v":144.39997643429854},{"$f":"生産と生産額!AD37","v":148.76446572202519}]
[null,null,"総生産額（百万ドル）",null,null,null,null,null,null,null,{"$f":"K7*K9","v":476.54707627595161},{"$f":"L7*L9","v":981.90142331278435},971.11621807911661,920.43074930891328,872.39070721023279,818.24491466392544,738.71350073897634,951.60611654120169,849.00971795063822,743.47038117434147,627.56995292696354,507.22457158363517,411.46277545672041,317.92442838367481,241.46569193034134,179.24419637074922,133.21117152459252,96.066235428746296,0,{"$f":"SUM(D10:AC10)","v":10837.599828861506}]
[null,null,null,"サインボーナス",null,null,null,"商業発見ボーナス",null,null,"生産移行ボーナス"]
[null,"ボーナス",null,{"$f":"作業と支出!E30","v":10},null,null,null,{"$f":"作業と支出!I30","v":3},null,null,{"$f":"作業と支出!L30","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:AC12)","v":18}]
[null,"探鉱費","地震探鉱費ほか",{"$f":"IF(作業と支出!E31=0,\" \",作業と支出!E31)","v":15},{"$f":"IF(作業と支出!F31=0,\" \",作業と支出!F31)","v":" "},{"$f":"IF(作業と支出!G31=0,\" \",作業と支出!G31)","v":5},{"$f":"IF(作業と支出!H31=0,\" \",作業と支出!H31)","v":" "},{"$f":"IF(作業と支出!I31=0,\" \",作業と支出!I31)","v":" "},{"$f":"IF(作業と支出!J31=0,\" \",作業と支出!J31)","v":" "},{"$f":"IF(作業と支出!K31=0,\" \",作業と支出!K31)","v":" "},{"$f":"IF(作業と支出!L31=0,\" \",作業と支出!L31)","v":" "},{"$f":"IF(作業と支出!M31=0,\" \",作業と支出!M31)","v":" "},{"$f":"IF(作業と支出!N31=0,\" \",作業と支出!N31)","v":" "},{"$f":"IF(作業と支出!O31=0,\" \",作業と支出!O31)","v":" "},{"$f":"IF(作業と支出!P31=0,\" \",作業と支出!P31)","v":" "},{"$f":"IF(作業と支出!Q31=0,\" \",作業と支出!Q31)","v":" "},{"$f":"IF(作業と支出!R31=0,\" \",作業と支出!R31)","v":" "},{"$f":"IF(作業と支出!S31=0,\" \",作業と支出!S31)","v":" "},{"$f":"IF(作業と支出!T31=0,\" \",作業と支出!T31)","v":" "},{"$f":"IF(作業と支出!U31=0,\" \",作業と支出!U31)","v":" "},{"$f":"IF(作業と支出!V31=0,\" \",作業と支出!V31)","v":" "},{"$f":"IF(作業と支出!W31=0,\" \",作業と支出!W31)","v":" "},{"$f":"IF(作業と支出!X31=0,\" \",作業と支出!X31)","v":" "},{"$f":"IF(作業と支出!Y31=0,\" \",作業と支出!Y31)","v":" "},{"$f":"IF(作業と支出!Z31=0,\" \",作業と支出!Z31)","v":" "},{"$f":"IF(作業と支出!AA31=0,\" \",作業と支出!AA31)","v":" "},{"$f":"IF(作業と支出!AB31=0,\" \",作業と支出!AB31)","v":" "},{"$f":"IF(作業と支出!AC31=0,\" \",作業と支出!AC31)","v":" "},null,20]
[null,"（実質）","試掘井掘削費",{"$f":"IF(作業と支出!E32=0,\" \",作業と支出!E32)","v":" "},{"$f":"IF(作業と支出!F32=0,\" \",作業と支出!F32)","v":69.2},{"$f":"IF(作業と支出!G32=0,\" \",作業と支出!G32)","v":57.2},{"$f":"IF(作業と支出!H32=0,\" \",作業と支出!H32)","v":" "},{"$f":"IF(作業と支出!I32=0,\" \",作業と支出!I32)","v":" "},{"$f":"IF(作業と支出!J32=0,\" \",作業と支出!J32)","v":" "},{"$f":"IF(作業と支出!K32=0,\" \",作業と支出!K32)","v":" "},{"$f":"IF(作業と支出!L32=0,\" \",作業と支出!L32)","v":" "},{"$f":"IF(作業と支出!M32=0,\" \",作業と支出!M32)","v":" "},{"$f":"IF(作業と支出!N32=0,\" \",作業と支出!N32)","v":" "},{"$f":"IF(作業と支出!O32=0,\" \",作業と支出!O32)","v":" "},{"$f":"IF(作業と支出!P32=0,\" \",作業と支出!P32)","v":" "},{"$f":"IF(作業と支出!Q32=0,\" \",作業と支出!Q32)","v":" "},{"$f":"IF(作業と支出!R32=0,\" \",作業と支出!R32)","v":" "},{"$f":"IF(作業と支出!S32=0,\" \",作業と支出!S32)","v":" "},{"$f":"IF(作業と支出!T32=0,\" \",作業と支出!T32)","v":" "},{"$f":"IF(作業と支出!U32=0,\" \",作業と支出!U32)","v":" "},{"$f":"IF(作業と支出!V32=0,\" \",作業と支出!V32)","v":" "},{"$f":"IF(作業と支出!W32=0,\" \",作業と支出!W32)","v":" "},{"$f":"IF(作業と支出!X32=0,\" \",作業と支出!X32)","v":" "},{"$f":"IF(作業と支出!Y32=0,\" \",作業と支出!Y32)","v":" "},{"$f":"IF(作業と支出!Z32=0,\" \",作業と支出!Z32)","v":" "},{"$f":"IF(作業と支出!AA32=0,\" \",作業と支出!AA32)","v":" "},{"$f":"IF(作業と支出!AB32=0,\" \",作業と支出!AB32)","v":" "},{"$f":"IF(作業と支出!AC32=0,\" \",作業と支出!AC32)","v":" "},null,126.4]
[null,null,"評価井掘削費",{"$f":"IF(作業と支出!E33=0,\" \",作業と支出!E33)","v":" "},{"$f":"IF(作業と支出!F33=0,\" \",作業と支出!F33)","v":" "},{"$f":"IF(作業と支出!G33=0,\" \",作業と支出!G33)","v":" "},{"$f":"IF(作業と支出!H33=0,\" \",作業と支出!H33)","v":73.2},{"$f":"IF(作業と支出!I33=0,\" \",作業と支出!I33)","v":" "},{"$f":"IF(作業と支出!J33=0,\" \",作業と支出!J33)","v":" "},{"$f":"IF(作業と支出!K33=0,\" \",作業と支出!K33)","v":" "},{"$f":"IF(作業と支出!L33=0,\" \",作業と支出!L33)","v":" "},{"$f":"IF(作業と支出!M33=0,\" \",作業と支出!M33)","v":" "},{"$f":"IF(作業と支出!N33=0,\" \",作業と支出!N33)","v":" "},{"$f":"IF(作業と支出!O33=0,\" \",作業と支出!O33)","v":" "},{"$f":"IF(作業と支出!P33=0,\" \",作業と支出!P33)","v":" "},{"$f":"IF(作業と支出!Q33=0,\" \",作業と支出!Q33)","v":" "},{"$f":"IF(作業と支出!R33=0,\" \",作業と支出!R33)","v":" "},{"$f":"IF(作業と支出!S33=0,\" \",作業と支出!S33)","v":" "},{"$f":"IF(作業と支出!T33=0,\" \",作業と支出!T33)","v":" "},{"$f":"IF(作業と支出!U33=0,\" \",作業と支出!U33)","v":" "},{"$f":"IF(作業と支出!V33=0,\" \",作業と支出!V33)","v":" "},{"$f":"IF(作業と支出!W33=0,\" \",作業と支出!W33)","v":" "},{"$f":"IF(作業と支出!X33=0,\" \",作業と支出!X33)","v":" "},{"$f":"IF(作業と支出!Y33=0,\" \",作業と支出!Y33)","v":" "},{"$f":"IF(作業と支出!Z33=0,\" \",作業と支出!Z33)","v":" "},{"$f":"IF(作業と支出!AA33=0,\" \",作業と支出!AA33)","v":" "},{"$f":"IF(作業と支出!AB33=0,\" \",作業と支出!AB33)","v":" "},{"$f":"IF(作業と支出!AC33=0,\" \",作業と支出!AC33)","v":" "},null,73.2]
[null,null,"スタディ費",{"$f":"IF(作業と支出!E34=0,\" \",作業と支出!E34)","v":" "},{"$f":"IF(作業と支出!F34=0,\" \",作業と支出!F34)","v":0.5},{"$f":"IF(作業と支出!G34=0,\" \",作業と支出!G34)","v":0.5},{"$f":"IF(作業と支出!H34=0,\" \",作業と支出!H34)","v":1.5},{"$f":"IF(作業と支出!I34=0,\" \",作業と支出!I34)","v":" "},{"$f":"IF(作業と支出!J34=0,\" \",作業と支出!J34)","v":" "},{"$f":"IF(作業と支出!K34=0,\" \",作業と支出!K34)","v":" "},{"$f":"IF(作業と支出!L34=0,\" \",作業と支出!L34)","v":" "},{"$f":"IF(作業と支出!M34=0,\" \",作業と支出!M34)","v":" "},{"$f":"IF(作業と支出!N34=0,\" \",作業と支出!N34)","v":" "},{"$f":"IF(作業と支出!O34=0,\" \",作業と支出!O34)","v":" "},{"$f":"IF(作業と支出!P34=0,\" \",作業と支出!P34)","v":" "},{"$f":"IF(作業と支出!Q34=0,\" \",作業と支出!Q34)","v":" "},{"$f":"IF(作業と支出!R34=0,\" \",作業と支出!R34)","v":" "},{"$f":"IF(作業と支出!S34=0,\" \",作業と支出!S34)","v":" "},{"$f":"IF(作業と支出!T34=0,\" \",作業と支出!T34)","v":" "},{"$f":"IF(作業と支出!U34=0,\" \",作業と支出!U34)","v":" "},{"$f":"IF(作業と支出!V34=0,\" \",作業と支出!V34)","v":" "},{"$f":"IF(作業と支出!W34=0,\" \",作業と支出!W34)","v":" "},{"$f":"IF(作業と支出!X34=0,\" \",作業と支出!X34)","v":" "},{"$f":"IF(作業と支出!Y34=0,\" \",作業と支出!Y34)","v":" "},{"$f":"IF(作業と支出!Z34=0,\" \",作業と支出!Z34)","v":" "},{"$f":"IF(作業と支出!AA34=0,\" \",作業と支出!AA34)","v":" "},{"$f":"IF(作業と支出!AB34=0,\" \",作業と支出!AB34)","v":" "},{"$f":"IF(作業と支出!AC34=0,\" \",作業と支出!AC34)","v":" "},null,2.5]
[null,null,"現地管理費",{"$f":"IF(作業と支出!E35=0,\" \",作業と支出!E35)","v":1.5},{"$f":"IF(作業と支出!F35=0,\" \",作業と支出!F35)","v":2},{"$f":"IF(作業と支出!G35=0,\" \",作業と支出!G35)","v":2},{"$f":"IF(作業と支出!H35=0,\" \",作業と支出!H35)","v":2},{"$f":"IF(作業と支出!I35=0,\" \",作業と支出!I35)","v":" "},{"$f":"IF(作業と支出!J35=0,\" \",作業と支出!J35)","v":" "},{"$f":"IF(作業と支出!K35=0,\" \",作業と支出!K35)","v":" "},{"$f":"IF(作業と支出!L35=0,\" \",作業と支出!L35)","v":" "},{"$f":"IF(作業と支出!M35=0,\" \",作業と支出!M35)","v":" "},{"$f":"IF(作業と支出!N35=0,\" \",作業と支出!N35)","v":" "},{"$f":"IF(作業と支出!O35=0,\" \",作業と支出!O35)","v":" "},{"$f":"IF(作業と支出!P35=0,\" \",作業と支出!P35)","v":" "},{"$f":"IF(作業と支出!Q35=0,\" \",作業と支出!Q35)","v":" "},{"$f":"IF(作業と支出!R35=0,\" \",作業と支出!R35)","v":" "},{"$f":"IF(作業と支出!S35=0,\" \",作業と支出!S35)","v":" "},{"$f":"IF(作業と支出!T35=0,\" \",作業と支出!T35)","v":" "},{"$f":"IF(作業と支出!U35=0,\" \",作業と支出!U35)","v":" "},{"$f":"IF(作業と支出!V35=0,\" \",作業と支出!V35)","v":" "},{"$f":"IF(作業と支出!W35=0,\" \",作業と支出!W35)","v":" "},{"$f":"IF(作業と支出!X35=0,\" \",作業と支出!X35)","v":" "},{"$f":"IF(作業と支出!Y35=0,\" \",作業と支出!Y35)","v":" "},{"$f":"IF(作業と支出!Z35=0,\" \",作業と支出!Z35)","v":" "},{"$f":"IF(作業と支出!AA35=0,\" \",作業と支出!AA35)","v":" "},{"$f":"IF(作業と支出!AB35=0,\" \",作業と支出!AB35)","v":" "},{"$f":"IF(作業と支出!AC35=0,\" \",作業と支出!AC35)","v":" "},null,7.5]
[null,null,"（計）",{"$f":"SUM(D13:D17)","v":16.5},{"$f":"SUM(E13:E17)","v":71.7},64.7,76.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229.60000000000002]
[null,null,"（計：インフレ含む名目値）",{"$f":"D18*(1+生産と生産額!$O$31)^(D4-2021)","v":16.5},{"$f":"E18*(1+生産と生産額!$O$31)^(E4-2021)","v":72.775499999999994},{"$f":"F18*(1+生産と生産額!$O$31)^(F4-2021)","v":66.655557499999986},{"$f":"G18*(1+生産と生産額!$O$31)^(G4-2021)","v":80.203531362499973},{"$f":"H18*(1+生産と生産額!$O$31)^(H4-2021)","v":0},{"$f":"I18*(1+生産と生産額!$O$31)^(I4-2021)","v":0},{"$f":"J18*(1+生産と生産額!$O$31)^(J4-2021)","v":0},{"$f":"K18*(1+生産と生産額!$O$31)^(K4-2021)","v":0},{"$f":"L18*(1+生産と生産額!$O$31)^(L4-2021)","v":0},{"$f":"M18*(1+生産と生産額!$O$31)^(M4-2021)","v":0},{"$f":"N18*(1+生産と生産額!$O$31)^(N4-2021)","v":0},{"$f":"O18*(1+生産と生産額!$O$31)^(O4-2021)","v":0},{"$f":"P18*(1+生産と生産額!$O$31)^(P4-2021)","v":0},{"$f":"Q18*(1+生産と生産額!$O$31)^(Q4-2021)","v":0},{"$f":"R18*(1+生産と生産額!$O$31)^(R4-2021)","v":0},{"$f":"S18*(1+生産と生産額!$O$31)^(S4-2021)","v":0},{"$f":"T18*(1+生産と生産額!$O$31)^(T4-2021)","v":0},{"$f":"U18*(1+生産と生産額!$O$31)^(U4-2021)","v":0},{"$f":"V18*(1+生産と生産額!$O$31)^(V4-2021)","v":0},{"$f":"W18*(1+生産と生産額!$O$31)^(W4-2021)","v":0},{"$f":"X18*(1+生産と生産額!$O$31)^(X4-2021)","v":0},{"$f":"Y18*(1+生産と生産額!$O$31)^(Y4-2021)","v":0},{"$f":"Z18*(1+生産と生産額!$O$31)^(Z4-2021)","v":0},{"$f":"AA18*(1+生産と生産額!$O$31)^(AA4-2021)","v":0},{"$f":"AB18*(1+生産と生産額!$O$31)^(AB4-2021)","v":0},null,236.13458886249995]
[null,"開発費","FEED",{"$f":"IF(作業と支出!E53=0,\" \",作業と支出!E53)","v":" "},{"$f":"IF(作業と支出!F53=0,\" \",作業と支出!F53)","v":" "},{"$f":"IF(作業と支出!G53=0,\" \",作業と支出!G53)","v":" "},{"$f":"IF(作業と支出!H53=0,\" \",作業と支出!H53)","v":" "},{"$f":"IF(作業と支出!I53=0,\" \",作業と支出!I53)","v":10},{"$f":"IF(作業と支出!J53=0,\" \",作業と支出!J53)","v":" "},{"$f":"IF(作業と支出!K53=0,\" \",作業と支出!K53)","v":" "},{"$f":"IF(作業と支出!L53=0,\" \",作業と支出!L53)","v":" "},{"$f":"IF(作業と支出!M53=0,\" \",作業と支出!M53)","v":" "},{"$f":"IF(作業と支出!N53=0,\" \",作業と支出!N53)","v":" "},{"$f":"IF(作業と支出!O53=0,\" \",作業と支出!O53)","v":" "},{"$f":"IF(作業と支出!P53=0,\" \",作業と支出!P53)","v":" "},{"$f":"IF(作業と支出!Q53=0,\" \",作業と支出!Q53)","v":" "},{"$f":"IF(作業と支出!R53=0,\" \",作業と支出!R53)","v":" "},{"$f":"IF(作業と支出!S53=0,\" \",作業と支出!S53)","v":" "},{"$f":"IF(作業と支出!T53=0,\" \",作業と支出!T53)","v":" "},{"$f":"IF(作業と支出!U53=0,\" \",作業と支出!U53)","v":" "},{"$f":"IF(作業と支出!V53=0,\" \",作業と支出!V53)","v":" "},{"$f":"IF(作業と支出!W53=0,\" \",作業と支出!W53)","v":" "},{"$f":"IF(作業と支出!X53=0,\" \",作業と支出!X53)","v":" "},{"$f":"IF(作業と支出!Y53=0,\" \",作業と支出!Y53)","v":" "},{"$f":"IF(作業と支出!Z53=0,\" \",作業と支出!Z53)","v":" "},{"$f":"IF(作業と支出!AA53=0,\" \",作業と支出!AA53)","v":" "},{"$f":"IF(作業と支出!AB53=0,\" \",作業と支出!AB53)","v":" "},{"$f":"IF(作業と支出!AC53=0,\" \",作業と支出!AC53)","v":" "},{"$f":"IF(作業と支出!AE53=0,\" \",作業と支出!AE53)","v":" "},10]
[null,"（実質）","生産施設建設",{"$f":"IF(作業と支出!E54=0,\" \",作業と支出!E54)","v":" "},{"$f":"IF(作業と支出!F54=0,\" \",作業と支出!F54)","v":" "},{"$f":"IF(作業と支出!G54=0,\" \",作業と支出!G54)","v":" "},{"$f":"IF(作業と支出!H54=0,\" \",作業と支出!H54)","v":" "},{"$f":"IF(作業と支出!I54=0,\" \",作業と支出!I54)","v":" "},{"$f":"IF(作業と支出!J54=0,\" \",作業と支出!J54)","v":120},{"$f":"IF(作業と支出!K54=0,\" \",作業と支出!K54)","v":230},{"$f":"IF(作業と支出!L54=0,\" \",作業と支出!L54)","v":" "},{"$f":"IF(作業と支出!M54=0,\" \",作業と支出!M54)","v":" "},{"$f":"IF(作業と支出!N54=0,\" \",作業と支出!N54)","v":" "},{"$f":"IF(作業と支出!O54=0,\" \",作業と支出!O54)","v":" "},{"$f":"IF(作業と支出!P54=0,\" \",作業と支出!P54)","v":" "},{"$f":"IF(作業と支出!Q54=0,\" \",作業と支出!Q54)","v":" "},{"$f":"IF(作業と支出!R54=0,\" \",作業と支出!R54)","v":" "},{"$f":"IF(作業と支出!S54=0,\" \",作業と支出!S54)","v":" "},{"$f":"IF(作業と支出!T54=0,\" \",作業と支出!T54)","v":" "},{"$f":"IF(作業と支出!U54=0,\" \",作業と支出!U54)","v":" "},{"$f":"IF(作業と支出!V54=0,\" \",作業と支出!V54)","v":" "},{"$f":"IF(作業と支出!W54=0,\" \",作業と支出!W54)","v":" "},{"$f":"IF(作業と支出!X54=0,\" \",作業と支出!X54)","v":" "},{"$f":"IF(作業と支出!Y54=0,\" \",作業と支出!Y54)","v":" "},{"$f":"IF(作業と支出!Z54=0,\" \",作業と支出!Z54)","v":" "},{"$f":"IF(作業と支出!AA54=0,\" \",作業と支出!AA54)","v":" "},{"$f":"IF(作業と支出!AB54=0,\" \",作業と支出!AB54)","v":" "},{"$f":"IF(作業と支出!AC54=0,\" \",作業と支出!AC54)","v":" "},{"$f":"IF(作業と支出!AE54=0,\" \",作業と支出!AE54)","v":" "},350]
[null,null,"廃山費用",{"$f":"IF(作業と支出!E55=0,\" \",作業と支出!E55)","v":" "},{"$f":"IF(作業と支出!F55=0,\" \",作業と支出!F55)","v":" "},{"$f":"IF(作業と支出!G55=0,\" \",作業と支出!G55)","v":" "},{"$f":"IF(作業と支出!H55=0,\" \",作業と支出!H55)","v":" "},{"$f":"IF(作業と支出!I55=0,\" \",作業と支出!I55)","v":" "},{"$f":"IF(作業と支出!J55=0,\" \",作業と支出!J55)","v":" "},{"$f":"IF(作業と支出!K55=0,\" \",作業と支出!K55)","v":" "},{"$f":"IF(作業と支出!L55=0,\" \",作業と支出!L55)","v":" "},{"$f":"IF(作業と支出!M55=0,\" \",作業と支出!M55)","v":" "},{"$f":"IF(作業と支出!N55=0,\" \",作業と支出!N55)","v":" "},{"$f":"IF(作業と支出!O55=0,\" \",作業と支出!O55)","v":" "},{"$f":"IF(作業と支出!P55=0,\" \",作業と支出!P55)","v":" "},{"$f":"IF(作業と支出!Q55=0,\" \",作業と支出!Q55)","v":" "},null,{"$f":"IF(作業と支出!S55=0,\" \",作業と支出!S55)","v":" "},{"$f":"IF(作業と支出!T55=0,\" \",作業と支出!T55)","v":" "},{"$f":"IF(作業と支出!U55=0,\" \",作業と支出!U55)","v":" "},{"$f":"IF(作業と支出!V55=0,\" \",作業と支出!V55)","v":" "},{"$f":"IF(作業と支出!W55=0,\" \",作業と支出!W55)","v":" "},{"$f":"IF(作業と支出!X55=0,\" \",作業と支出!X55)","v":" "},{"$f":"IF(作業と支出!Y55=0,\" \",作業と支出!Y55)","v":" "},{"$f":"IF(作業と支出!Z55=0,\" \",作業と支出!Z55)","v":" "},{"$f":"IF(作業と支出!AA55=0,\" \",作業と支出!AA55)","v":" "},{"$f":"IF(作業と支出!AB55=0,\" \",作業と支出!AB55)","v":" "},{"$f":"IF(作業と支出!AC55=0,\" \",作業と支出!AC55)","v":" "},{"$f":"IF(作業と支出!AE55=0,\" \",作業と支出!AE55)","v":17.5},17.5]
[null,null,"生産井掘削",{"$f":"IF(作業と支出!E56=0,\" \",作業と支出!E56)","v":" "},{"$f":"IF(作業と支出!F56=0,\" \",作業と支出!F56)","v":" "},{"$f":"IF(作業と支出!G56=0,\" \",作業と支出!G56)","v":" "},{"$f":"IF(作業と支出!H56=0,\" \",作業と支出!H56)","v":" "},{"$f":"IF(作業と支出!I56=0,\" \",作業と支出!I56)","v":" "},{"$f":"IF(作業と支出!J56=0,\" \",作業と支出!J56)","v":48.6},{"$f":"IF(作業と支出!K56=0,\" \",作業と支出!K56)","v":131.4},{"$f":"IF(作業と支出!L56=0,\" \",作業と支出!L56)","v":28.8},{"$f":"IF(作業と支出!M56=0,\" \",作業と支出!M56)","v":" "},{"$f":"IF(作業と支出!N56=0,\" \",作業と支出!N56)","v":" "},{"$f":"IF(作業と支出!O56=0,\" \",作業と支出!O56)","v":" "},{"$f":"IF(作業と支出!P56=0,\" \",作業と支出!P56)","v":" "},{"$f":"IF(作業と支出!Q56=0,\" \",作業と支出!Q56)","v":" "},{"$f":"IF(作業と支出!R56=0,\" \",作業と支出!R56)","v":70.2},{"$f":"IF(作業と支出!S56=0,\" \",作業と支出!S56)","v":" "},{"$f":"IF(作業と支出!T56=0,\" \",作業と支出!T56)","v":" "},{"$f":"IF(作業と支出!U56=0,\" \",作業と支出!U56)","v":" "},{"$f":"IF(作業と支出!V56=0,\" \",作業と支出!V56)","v":" "},{"$f":"IF(作業と支出!W56=0,\" \",作業と支出!W56)","v":" "},{"$f":"IF(作業と支出!X56=0,\" \",作業と支出!X56)","v":" "},{"$f":"IF(作業と支出!Y56=0,\" \",作業と支出!Y56)","v":" "},{"$f":"IF(作業と支出!Z56=0,\" \",作業と支出!Z56)","v":" "},{"$f":"IF(作業と支出!AA56=0,\" \",作業と支出!AA56)","v":" "},{"$f":"IF(作業と支出!AB56=0,\" \",作業と支出!AB56)","v":" "},{"$f":"IF(作業と支出!AC56=0,\" \",作業と支出!AC56)","v":" "},{"$f":"IF(作業と支出!AE56=0,\" \",作業と支出!AE56)","v":" "},279]
[null,null,"改修費用",{"$f":"IF(作業と支出!E57=0,\" \",作業と支出!E57)","v":" "},{"$f":"IF(作業と支出!F57=0,\" \",作業と支出!F57)","v":" "},{"$f":"IF(作業と支出!G57=0,\" \",作業と支出!G57)","v":" "},{"$f":"IF(作業と支出!H57=0,\" \",作業と支出!H57)","v":" "},{"$f":"IF(作業と支出!I57=0,\" \",作業と支出!I57)","v":" "},{"$f":"IF(作業と支出!J57=0,\" \",作業と支出!J57)","v":" "},{"$f":"IF(作業と支出!K57=0,\" \",作業と支出!K57)","v":" "},{"$f":"IF(作業と支出!L57=0,\" \",作業と支出!L57)","v":" "},{"$f":"IF(作業と支出!M57=0,\" \",作業と支出!M57)","v":" "},{"$f":"IF(作業と支出!N57=0,\" \",作業と支出!N57)","v":" "},{"$f":"IF(作業と支出!O57=0,\" \",作業と支出!O57)","v":" "},{"$f":"IF(作業と支出!P57=0,\" \",作業と支出!P57)","v":34.799999999999997},{"$f":"IF(作業と支出!Q57=0,\" \",作業と支出!Q57)","v":" "},{"$f":"IF(作業と支出!R57=0,\" \",作業と支出!R57)","v":" "},{"$f":"IF(作業と支出!S57=0,\" \",作業と支出!S57)","v":" "},{"$f":"IF(作業と支出!T57=0,\" \",作業と支出!T57)","v":" "},{"$f":"IF(作業と支出!U57=0,\" \",作業と支出!U57)","v":" "},{"$f":"IF(作業と支出!V57=0,\" \",作業と支出!V57)","v":" "},{"$f":"IF(作業と支出!W57=0,\" \",作業と支出!W57)","v":" "},{"$f":"IF(作業と支出!X57=0,\" \",作業と支出!X57)","v":" "},{"$f":"IF(作業と支出!Y57=0,\" \",作業と支出!Y57)","v":" "},{"$f":"IF(作業と支出!Z57=0,\" \",作業と支出!Z57)","v":" "},{"$f":"IF(作業と支出!AA57=0,\" \",作業と支出!AA57)","v":" "},{"$f":"IF(作業と支出!AB57=0,\" \",作業と支出!AB57)","v":" "},{"$f":"IF(作業と支出!AC57=0,\" \",作業と支出!AC57)","v":" "},{"$f":"IF(作業と支出!AE57=0,\" \",作業と支出!AE57)","v":20.399999999999999},55.199999999999996]
[null,null,"現地管理費",{"$f":"IF(作業と支出!E58=0,\" \",作業と支出!E58)","v":" "},{"$f":"IF(作業と支出!F58=0,\" \",作業と支出!F58)","v":" "},{"$f":"IF(作業と支出!G58=0,\" \",作業と支出!G58)","v":" "},{"$f":"IF(作業と支出!H58=0,\" \",作業と支出!H58)","v":" "},{"$f":"IF(作業と支出!I58=0,\" \",作業と支出!I58)","v":2},{"$f":"IF(作業と支出!J58=0,\" \",作業と支出!J58)","v":2.5},{"$f":"IF(作業と支出!K58=0,\" \",作業と支出!K58)","v":2.5},{"$f":"IF(作業と支出!L58=0,\" \",作業と支出!L58)","v":1},{"$f":"IF(作業と支出!M58=0,\" \",作業と支出!M58)","v":" "},{"$f":"IF(作業と支出!N58=0,\" \",作業と支出!N58)","v":" "},{"$f":"IF(作業と支出!O58=0,\" \",作業と支出!O58)","v":" "},{"$f":"IF(作業と支出!P58=0,\" \",作業と支出!P58)","v":" "},{"$f":"IF(作業と支出!Q58=0,\" \",作業と支出!Q58)","v":" "},{"$f":"IF(作業と支出!R58=0,\" \",作業と支出!R58)","v":" "},{"$f":"IF(作業と支出!S58=0,\" \",作業と支出!S58)","v":" "},{"$f":"IF(作業と支出!T58=0,\" \",作業と支出!T58)","v":" "},{"$f":"IF(作業と支出!U58=0,\" \",作業と支出!U58)","v":" "},{"$f":"IF(作業と支出!V58=0,\" \",作業と支出!V58)","v":" "},{"$f":"IF(作業と支出!W58=0,\" \",作業と支出!W58)","v":" "},{"$f":"IF(作業と支出!X58=0,\" \",作業と支出!X58)","v":" "},{"$f":"IF(作業と支出!Y58=0,\" \",作業と支出!Y58)","v":" "},{"$f":"IF(作業と支出!Z58=0,\" \",作業と支出!Z58)","v":" "},{"$f":"IF(作業と支出!AA58=0,\" \",作業と支出!AA58)","v":" "},{"$f":"IF(作業と支出!AB58=0,\" \",作業と支出!AB58)","v":" "},{"$f":"IF(作業と支出!AC58=0,\" \",作業と支出!AC58)","v":" "},{"$f":"IF(作業と支出!AE58=0,\" \",作業と支出!AE58)","v":" "},8]
[null,null,"（計）",{"$f":"SUM(D20:D25)","v":0},{"$f":"SUM(E20:E25)","v":0},0,0,12,171.1,363.9,29.8,0,0,0,34.799999999999997,0,70.2,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC20:AC25)","v":37.9},719.69999999999993]
[null,null,"（計：インフレ含む名目値）",{"$f":"D26*(1+生産と生産額!$O$31)^(D4-2021)","v":0},{"$f":"E26*(1+生産と生産額!$O$31)^(E4-2021)","v":0},{"$f":"F26*(1+生産と生産額!$O$31)^(F4-2021)","v":0},{"$f":"G26*(1+生産と生産額!$O$31)^(G4-2021)","v":0},{"$f":"H26*(1+生産と生産額!$O$31)^(H4-2021)","v":12.736362607499993},{"$f":"I26*(1+生産と生産額!$O$31)^(I4-2021)","v":184.32329306461642},{"$f":"J26*(1+生産と生産額!$O$31)^(J4-2021)","v":397.90400374872655},{"$f":"K26*(1+生産と生産額!$O$31)^(K4-2021)","v":33.073378404473019},{"$f":"L26*(1+生産と生産額!$O$31)^(L4-2021)","v":0},{"$f":"M26*(1+生産と生産額!$O$31)^(M4-2021)","v":0},{"$f":"N26*(1+生産と生産額!$O$31)^(N4-2021)","v":0},{"$f":"O26*(1+生産と生産額!$O$31)^(O4-2021)","v":40.992623021538286},{"$f":"P26*(1+生産と生産額!$O$31)^(P4-2021)","v":0},{"$f":"Q26*(1+生産と生産額!$O$31)^(Q4-2021)","v":85.191381571148625},{"$f":"R26*(1+生産と生産額!$O$31)^(R4-2021)","v":0},{"$f":"S26*(1+生産と生産額!$O$31)^(S4-2021)","v":0},{"$f":"T26*(1+生産と生産額!$O$31)^(T4-2021)","v":0},{"$f":"U26*(1+生産と生産額!$O$31)^(U4-2021)","v":0},{"$f":"V26*(1+生産と生産額!$O$31)^(V4-2021)","v":0},{"$f":"W26*(1+生産と生産額!$O$31)^(W4-2021)","v":0},{"$f":"X26*(1+生産と生産額!$O$31)^(X4-2021)","v":0},{"$f":"Y26*(1+生産と生産額!$O$31)^(Y4-2021)","v":0},{"$f":"Z26*(1+生産と生産額!$O$31)^(Z4-2021)","v":0},{"$f":"AA26*(1+生産と生産額!$O$31)^(AA4-2021)","v":0},{"$f":"AB26*(1+生産と生産額!$O$31)^(AB4-2021)","v":0},{"$f":"AC26*(1+生産と生産額!$O$31)^(AC4-2021)","v":54.990828920691513},809.21187133869444]
[null,"投資合計（インフレ含む名目値）",null,{"$f":"D19+D27","v":16.5},{"$f":"E19+E27","v":72.775499999999994},66.655557499999986,80.203531362499973,12.736362607499993,184.32329306461642,397.90400374872655,33.073378404473019,0,0,0,40.992623021538286,0,85.191381571148625,0,0,0,0,0,0,0,0,0,0,0,54.990828920691513,1045.3464602011943]
[null,"操業費","生産操業費",null,null,null,null,null,null,null,{"$f":"作業と支出!L69","v":15.725000000000001},{"$f":"作業と支出!M69","v":18.87},{"$f":"作業と支出!N69","v":18.618400000000001},{"$f":"作業と支出!O69","v":18.135328000000001},{"$f":"作業と支出!P69","v":17.690901760000003},{"$f":"作業と支出!Q69","v":17.233050144},{"$f":"作業と支出!R69","v":16.657541310399999},{"$f":"作業と支出!S69","v":17.678559287173336},{"$f":"作業と支出!T69","v":16.995407852764},{"$f":"作業と支出!U69","v":16.333096674849401},{"$f":"作業と支出!V69","v":15.655078008829451},{"$f":"作業と支出!W69","v":14.992471519118089},{"$f":"作業と支出!X69","v":14.479592199960166},{"$f":"作業と支出!Y69","v":14.004694149970124},{"$f":"作業と支出!Z69","v":13.630318684063148},{"$f":"作業と支出!AA69","v":13.336795734742804},{"$f":"作業と支出!AB69","v":13.125936506243916},{"$f":"作業と支出!AC69","v":12.962155554370741},0,{"$f":"SUM(D29:AC29)","v":286.12432738648522}]
[null,null,"パイプライン使用料",null,null,null,null,null,null,null,{"$f":"作業と支出!L70","v":5.4749999999999996},{"$f":"作業と支出!M70","v":10.95},{"$f":"作業と支出!N70","v":10.512},{"$f":"作業と支出!O70","v":9.6710400000000014},{"$f":"作業と支出!P70","v":8.8973568000000007},{"$f":"作業と支出!Q70","v":8.1003019199999997},{"$f":"作業と支出!R70","v":7.0984224720000011},{"$f":"作業と支出!S70","v":8.8758703012000009},{"$f":"作業と支出!T70","v":7.6866003160200007},{"$f":"作業と支出!U70","v":6.5336102686169992},{"$f":"作業と支出!V70","v":5.3532757069447507},{"$f":"作業と支出!W70","v":4.1997715634885626},{"$f":"作業と支出!X70","v":3.3069212384044211},{"$f":"作業と支出!Y70","v":2.4801909288033164},{"$f":"作業と支出!Z70","v":1.8284562147045267},{"$f":"作業と支出!AA70","v":1.3174742918018623},{"$f":"作業と支出!AB70","v":0.95039821039282402},{"$f":"作業と支出!AC70","v":0.66527874727497671},{"$f":"作業と支出!AE70","v":0},103.90196897965225]
[null,null,"現地管理費",null,null,null,null,null,null,null,{"$f":"作業と支出!L71","v":7},{"$f":"作業と支出!M71","v":7},{"$f":"作業と支出!N71","v":7},{"$f":"作業と支出!O71","v":7},{"$f":"作業と支出!P71","v":7},{"$f":"作業と支出!Q71","v":7},{"$f":"作業と支出!R71","v":7},{"$f":"作業と支出!S71","v":7},{"$f":"作業と支出!T71","v":7},{"$f":"作業と支出!U71","v":7},{"$f":"作業と支出!V71","v":7},{"$f":"作業と支出!W71","v":7},{"$f":"作業と支出!X71","v":7},{"$f":"作業と支出!Y71","v":7},{"$f":"作業と支出!Z71","v":7},{"$f":"作業と支出!AA71","v":7},{"$f":"作業と支出!AB71","v":7},{"$f":"作業と支出!AC71","v":7},{"$f":"作業と支出!AE71","v":7},133]
[null,null,"（計）",null,null,null,null,null,null,null,{"$f":"SUM(K29:K31)","v":28.200000000000003},36.82,36.130400000000002,34.806368000000006,33.58825856,32.333352063999996,30.755963782400002,33.554429588373338,31.682008168784002,29.866706943466401,28.008353715774202,26.192243082606652,24.786513438364587,23.484885078773441,22.458774898767675,21.654270026544665,21.07633471663674,20.627434301645717,7,523.02629636613744]
[null,null,"（計：インフレ含む名目値）",null,null,null,null,null,null,null,{"$f":"SUM(K29:K31)*(1+生産と生産額!$O$31)^(K4-2021)","v":31.297626543830173},{"$f":"SUM(L29:L31)*(1+生産と生産額!$O$31)^(L4-2021)","v":41.477457038439155},{"$f":"SUM(M29:M31)*(1+生産と生産額!$O$31)^(M4-2021)","v":41.311137166983876},{"$f":"SUM(N29:N31)*(1+生産と生産額!$O$31)^(N4-2021)","v":40.394211034848936},{"$f":"SUM(O29:O31)*(1+生産と生産額!$O$31)^(O4-2021)","v":39.56525347988611},{"$f":"SUM(P29:P31)*(1+生産と生産額!$O$31)^(P4-2021)","v":38.658343271981664},{"$f":"SUM(Q29:Q31)*(1+生産と生産額!$O$31)^(Q4-2021)","v":37.323975016735986},{"$f":"SUM(R29:R31)*(1+生産と生産額!$O$31)^(R4-2021)","v":41.330860935645759},{"$f":"SUM(S29:S31)*(1+生産と生産額!$O$31)^(S4-2021)","v":39.609862548619354},{"$f":"SUM(T29:T31)*(1+生産と生産額!$O$31)^(T4-2021)","v":37.900419467281679},{"$f":"SUM(U29:U31)*(1+生産と生産額!$O$31)^(U4-2021)","v":36.075329020087331},{"$f":"SUM(V29:V31)*(1+生産と生産額!$O$31)^(V4-2021)","v":34.242183725482057},{"$f":"SUM(W29:W31)*(1+生産と生産額!$O$31)^(W4-2021)","v":32.890482482149267},{"$f":"SUM(X29:X31)*(1+生産と生産額!$O$31)^(X4-2021)","v":31.630735046598627},{"$f":"SUM(Y29:Y31)*(1+生産と生産額!$O$31)^(Y4-2021)","v":30.702444114586672},{"$f":"SUM(Z29:Z31)*(1+生産と生産額!$O$31)^(Z4-2021)","v":30.046679019841207},{"$f":"SUM(AA29:AA31)*(1+生産と生産額!$O$31)^(AA4-2021)","v":29.683428317822123},{"$f":"SUM(AB29:AB31)*(1+生産と生産額!$O$31)^(AB4-2021)","v":29.486975337083681},{"$f":"SUM(AC29:AC31)*(1+生産と生産額!$O$31)^(AC4-2021)","v":10.156617478755688},653.7840210466594]
[null,"支出合計（コスト回収対象費用：名目）",null,{"$f":"D28+D33","v":16.5},{"$f":"E28+E33","v":72.775499999999994},66.655557499999986,80.203531362499973,12.736362607499993,184.32329306461642,397.90400374872655,64.371004948303195,{"$f":"L19+L28+L33","v":41.477457038439155},41.311137166983876,40.394211034848936,80.557876501424403,38.658343271981664,122.51535658788461,41.330860935645759,39.609862548619354,37.900419467281679,36.075329020087331,34.242183725482057,32.890482482149267,31.630735046598627,30.702444114586672,30.046679019841207,29.683428317822123,29.486975337083681,65.147446399447205,1699.1304812478534]
[]
[null,null,"ロイヤリティ（生産額＊１０％）",null,null,null,null,null,null,null,{"$f":"K10*10%","v":47.654707627595165},98.190142331278437,97.111621807911661,92.043074930891336,87.239070721023282,81.824491466392544,73.871350073897631,95.160611654120174,84.900971795063825,74.347038117434153,62.756995292696359,50.722457158363518,41.146277545672042,31.792442838367482,24.146569193034136,17.924419637074923,{"$f":"AA10*10%","v":13.321117152459252},{"$f":"AB10*10%","v":9.6066235428746296},{"$f":"AC10*10%","v":0},{"$f":"SUM(D36:AC36)","v":1083.7599828861505}]
[null,"コスト回収"]
[null,null,"コスト回収原資（生産額＊３５％）",null,null,null,null,null,null,null,{"$f":"K10*プロジェクト収支!$G$5","v":166.79147669658306},{"$f":"L10*プロジェクト収支!$G$5","v":343.66549815947451},{"$f":"M10*プロジェクト収支!$G$5","v":339.89067632769081},{"$f":"N10*プロジェクト収支!$G$5","v":322.15076225811964},{"$f":"O10*プロジェクト収支!$G$5","v":305.33674752358144},{"$f":"P10*プロジェクト収支!$G$5","v":286.38572013237388},{"$f":"Q10*プロジェクト収支!$G$5","v":258.54972525864173},{"$f":"R10*プロジェクト収支!$G$5","v":333.0621407894206},{"$f":"S10*プロジェクト収支!$G$5","v":297.15340128272334},{"$f":"T10*プロジェクト収支!$G$5","v":260.21463341101952},{"$f":"U10*プロジェクト収支!$G$5","v":219.64948352443722},{"$f":"V10*プロジェクト収支!$G$5","v":177.52860005427229},{"$f":"W10*プロジェクト収支!$G$5","v":144.01197140985212},{"$f":"X10*プロジェクト収支!$G$5","v":111.27354993428618},{"$f":"Y10*プロジェクト収支!$G$5","v":84.512992175619459},{"$f":"Z10*プロジェクト収支!$G$5","v":62.735468729762225},{"$f":"AA10*プロジェクト収支!$G$5","v":46.62391003360738},{"$f":"AB10*プロジェクト収支!$G$5","v":33.623182400061204},{"$f":"AC10*プロジェクト収支!$G$5","v":0}]
[null,null,"Ａ．操業費（優先回収）",null,null,null,null,null,null,null,{"$f":"K33","v":31.297626543830173},41.477457038439155,41.311137166983876,40.394211034848936,39.56525347988611,38.658343271981664,37.323975016735986,41.330860935645759,39.609862548619354,37.900419467281679,36.075329020087331,34.242183725482057,32.890482482149267,31.630735046598627,30.702444114586672,30.046679019841207,{"$f":"AA33","v":29.683428317822123},{"$f":"AB33","v":29.486975337083681},{"$f":"AC33","v":10.156617478755688},{"$f":"SUM(D39:AC39)","v":653.7840210466594}]
[null,null,"投資回収充当原資",null,null,null,null,null,null,null,{"$f":"IF(K38-K39>0,K38-K39,0)","v":135.49385015275288},{"$f":"IF(L38-L39>0,L38-L39,0)","v":302.18804112103533},{"$f":"IF(M38-M39>0,M38-M39,0)","v":298.57953916070693},281.75655122327072,265.77149404369533,247.72737686039221,221.22575024190576,291.73127985377482,257.543538734104,222.31421394373785,183.57415450434988,143.28641632879024,111.12148892770286,79.64281488768755,53.81054806103279,32.688789709921018,16.940481715785257,4.1362070629775225,0]
[null,null,"投資回収残",{"$f":"D28","v":16.5},{"$f":"D41-D42+E28","v":89.275499999999994},155.93105749999998,236.13458886249995,248.87095146999994,433.19424453461636,831.09824828334285,{"$f":"J41-J42+K28","v":864.17162668781589},728.677776535063,426.48973541402768,127.91019625332075,40.992623021538286,0,85.191381571148625,0,0,0,0,0,0,0,0,0,0,0,54.990828920691513]
[null,null,"Ｂ．投資回収",null,null,null,null,null,null,null,{"$f":"IF(K41>K40,K40,K41)","v":135.49385015275288},{"$f":"IF(L41>L40,L40,L41)","v":302.18804112103533},298.57953916070693,127.91019625332075,40.992623021538286,0,85.191381571148625,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AC41-AC40>0,AC40,AC41)","v":0},{"$f":"SUM(D42:AC42)","v":990.35563128050285}]
[null,null,"コスト回収額（Ａ＋Ｂ）",null,null,null,null,null,null,null,{"$f":"IF(K39+K42>K38,K38,K39+K42)","v":166.79147669658306},{"$f":"IF(L39+L42>L38,L38,L39+L42)","v":343.66549815947451},339.89067632769081,168.30440728816967,80.557876501424403,38.658343271981664,122.51535658788461,41.330860935645759,39.609862548619354,37.900419467281679,36.075329020087331,34.242183725482057,32.890482482149267,31.630735046598627,30.702444114586672,30.046679019841207,29.683428317822123,29.486975337083681,0,1633.9830348484063]
[null,"プロフィット原油（総生産額‐ロイヤリティ‐コスト回収）",null,null,null,null,null,null,null,null,{"$f":"K10-K36-K43","v":262.10089195177341},{"$f":"L10-L36-L43","v":540.04578282203136},534.11391994351413,660.08326708985237,704.59375998778512,697.76207992555123,542.32679407719411,815.11464395143571,724.49888360695502,631.22292358962557,528.73762861417981,422.25993069978961,337.42601542889912,254.50125049870869,186.61667862272051,131.2730977138331,90.206626054311144,56.972636548787989,0,8119.8568111269497]
[null,null,"プロフィット原油取り分",null,null,null,null,null,null,null,{"$f":"IF(生産と生産額!L22>50,プロジェクト収支!L22*((生産と生産額!L22-50/生産と生産額!L22)*プロジェクト収支!$N$6+(50/生産と生産額!L22)*プロジェクト収支!$J$6),K44*プロジェクト収支!$J$6)","v":78.630267585532025},{"$f":"IF(生産と生産額!M22>50,プロジェクト収支!M22*((生産と生産額!M22-50/生産と生産額!M22)*プロジェクト収支!$N$6+(50/生産と生産額!M22)*プロジェクト収支!$J$6),L44*プロジェクト収支!$J$6)","v":162.0137348466094},{"$f":"IF(生産と生産額!N22>50,プロジェクト収支!N22*((生産と生産額!N22-50/生産と生産額!N22)*プロジェクト収支!$N$6+(50/生産と生産額!N22)*プロジェクト収支!$J$6),M44*プロジェクト収支!$J$6)","v":160.23417598305423},{"$f":"IF(生産と生産額!O22>50,プロジェクト収支!O22*((生産と生産額!O22-50/生産と生産額!O22)*プロジェクト収支!$N$6+(50/生産と生産額!O22)*プロジェクト収支!$J$6),N44*プロジェクト収支!$J$6)","v":198.02498012695571},{"$f":"IF(生産と生産額!P22>50,プロジェクト収支!P22*((生産と生産額!P22-50/生産と生産額!P22)*プロジェクト収支!$N$6+(50/生産と生産額!P22)*プロジェクト収支!$J$6),O44*プロジェクト収支!$J$6)","v":211.37812799633554},{"$f":"IF(生産と生産額!Q22>50,プロジェクト収支!Q22*((生産と生産額!Q22-50/生産と生産額!Q22)*プロジェクト収支!$N$6+(50/生産と生産額!Q22)*プロジェクト収支!$J$6),P44*プロジェクト収支!$J$6)","v":209.32862397766536},{"$f":"IF(生産と生産額!R22>50,プロジェクト収支!R22*((生産と生産額!R22-50/生産と生産額!R22)*プロジェクト収支!$N$6+(50/生産と生産額!R22)*プロジェクト収支!$J$6),Q44*プロジェクト収支!$J$6)","v":162.69803822315822},{"$f":"IF(生産と生産額!S22>50,プロジェクト収支!S22*((生産と生産額!S22-50/生産と生産額!S22)*プロジェクト収支!$N$6+(50/生産と生産額!S22)*プロジェクト収支!$J$6),R44*プロジェクト収支!$J$6)","v":244.5343931854307},{"$f":"IF(生産と生産額!T22>50,プロジェクト収支!T22*((生産と生産額!T22-50/生産と生産額!T22)*プロジェクト収支!$N$6+(50/生産と生産額!T22)*プロジェクト収支!$J$6),S44*プロジェクト収支!$J$6)","v":217.34966508208649},{"$f":"IF(生産と生産額!U22>50,プロジェクト収支!U22*((生産と生産額!U22-50/生産と生産額!U22)*プロジェクト収支!$N$6+(50/生産と生産額!U22)*プロジェクト収支!$J$6),T44*プロジェクト収支!$J$6)","v":189.36687707688768},{"$f":"IF(生産と生産額!V22>50,プロジェクト収支!V22*((生産と生産額!V22-50/生産と生産額!V22)*プロジェクト収支!$N$6+(50/生産と生産額!V22)*プロジェクト収支!$J$6),U44*プロジェクト収支!$J$6)","v":158.62128858425393},{"$f":"IF(生産と生産額!W22>50,プロジェクト収支!W22*((生産と生産額!W22-50/生産と生産額!W22)*プロジェクト収支!$N$6+(50/生産と生産額!W22)*プロジェクト収支!$J$6),V44*プロジェクト収支!$J$6)","v":126.67797920993688},{"$f":"IF(生産と生産額!X22>50,プロジェクト収支!X22*((生産と生産額!X22-50/生産と生産額!X22)*プロジェクト収支!$N$6+(50/生産と生産額!X22)*プロジェクト収支!$J$6),W44*プロジェクト収支!$J$6)","v":101.22780462866973},{"$f":"IF(生産と生産額!Y22>50,プロジェクト収支!Y22*((生産と生産額!Y22-50/生産と生産額!Y22)*プロジェクト収支!$N$6+(50/生産と生産額!Y22)*プロジェクト収支!$J$6),X44*プロジェクト収支!$J$6)","v":76.350375149612603},{"$f":"IF(生産と生産額!Z22>50,プロジェクト収支!Z22*((生産と生産額!Z22-50/生産と生産額!Z22)*プロジェクト収支!$N$6+(50/生産と生産額!Z22)*プロジェクト収支!$J$6),Y44*プロジェクト収支!$J$6)","v":55.985003586816156},{"$f":"IF(生産と生産額!AA22>50,プロジェクト収支!AA22*((生産と生産額!AA22-50/生産と生産額!AA22)*プロジェクト収支!$N$6+(50/生産と生産額!AA22)*プロジェクト収支!$J$6),Z44*プロジェクト収支!$J$6)","v":39.381929314149929},{"$f":"IF(生産と生産額!AB22>50,プロジェクト収支!AB22*((生産と生産額!AB22-50/生産と生産額!AB22)*プロジェクト収支!$N$6+(50/生産と生産額!AB22)*プロジェクト収支!$J$6),AA44*プロジェクト収支!$J$6)","v":27.061987816293342},{"$f":"IF(生産と生産額!AC22>50,プロジェクト収支!AC22*((生産と生産額!AC22-50/生産と生産額!AC22)*プロジェクト収支!$N$6+(50/生産と生産額!AC22)*プロジェクト収支!$J$6),AB44*プロジェクト収支!$J$6)","v":17.091790964636395},{"$f":"IF(生産と生産額!AD22>50,プロジェクト収支!AD22*((生産と生産額!AD22-50/生産と生産額!AD22)*プロジェクト収支!$N$6+(50/生産と生産額!AD22)*プロジェクト収支!$J$6),AC44*プロジェクト収支!$J$6)","v":0},2435.9570433380845]
[null,null,"石油収入税（５０％）",null,null,null,null,null,null,null,{"$f":"K45*Dashboard!$G$16","v":39.315133792766012},{"$f":"L45*Dashboard!$G$16","v":81.006867423304698},{"$f":"M45*Dashboard!$G$16","v":80.117087991527114},{"$f":"N45*Dashboard!$G$16","v":99.012490063477856},{"$f":"O45*Dashboard!$G$16","v":105.68906399816777},{"$f":"P45*Dashboard!$G$16","v":104.66431198883268},{"$f":"Q45*Dashboard!$G$16","v":81.349019111579111},{"$f":"R45*Dashboard!$G$16","v":122.26719659271535},{"$f":"S45*Dashboard!$G$16","v":108.67483254104324},{"$f":"T45*Dashboard!$G$16","v":94.683438538443838},{"$f":"U45*Dashboard!$G$16","v":79.310644292126966},{"$f":"V45*Dashboard!$G$16","v":63.33898960496844},{"$f":"W45*Dashboard!$G$16","v":50.613902314334865},{"$f":"X45*Dashboard!$G$16","v":38.175187574806301},{"$f":"Y45*Dashboard!$G$16","v":27.992501793408078},{"$f":"Z45*Dashboard!$G$16","v":19.690964657074964},{"$f":"AA45*Dashboard!$G$16","v":13.530993908146671},{"$f":"AB45*Dashboard!$G$16","v":8.5458954823181976},{"$f":"AC45*Dashboard!$G$16","v":0},1217.9785216690423,null,null,{"$f":"AD46*0.6","v":730.78711300142538}]
[null,"原油販売収入（税前）",null,null,null,null,null,null,null,null,{"$f":"K43+K45","v":245.42174428211507},{"$f":"L43+L45","v":505.6792330060839},500.12485231074504,366.32938741512538,291.93600449775994,247.98696724964702,285.2133948110428,285.86525412107648,256.95952763070585,227.26729654416937,194.69661760434127,160.92016293541894,134.11828711081898,107.98111019621123,86.687447701402832,69.428608333991136,56.745416134115466,46.57876630172008,0,{"$f":"SUM(D47:AC47)","v":4069.9400781864906}]
[null,"本社管理費",null,{"$f":"Dashboard!G32/1000","v":0.3},{"$f":"D48*(1+生産と生産額!$O$31)","v":0.30449999999999994},{"$f":"E48*(1+生産と生産額!$O$31)","v":0.30906749999999988},{"$f":"F48*(1+生産と生産額!$O$31)","v":0.31370351249999984},{"$f":"G48*(1+生産と生産額!$O$31)","v":0.31840906518749978},{"$f":"H48*(1+生産と生産額!$O$31)","v":0.32318520116531224},{"$f":"I48*(1+生産と生産額!$O$31)","v":0.3280329791827919},{"$f":"J48*(1+生産と生産額!$O$31)","v":0.33295347387053376},{"$f":"K48*(1+生産と生産額!$O$31)","v":0.33794777597859171},{"$f":"L48*(1+生産と生産額!$O$31)","v":0.34301699261827057},{"$f":"M48*(1+生産と生産額!$O$31)","v":0.3481622475075446},{"$f":"N48*(1+生産と生産額!$O$31)","v":0.35338468122015776},{"$f":"O48*(1+生産と生産額!$O$31)","v":0.35868545143846009},{"$f":"P48*(1+生産と生産額!$O$31)","v":0.36406573321003693},{"$f":"Q48*(1+生産と生産額!$O$31)","v":0.36952671920818747},{"$f":"R48*(1+生産と生産額!$O$31)","v":0.37506961999631022},{"$f":"S48*(1+生産と生産額!$O$31)","v":0.38069566429625484},{"$f":"T48*(1+生産と生産額!$O$31)","v":0.38640609926069863},{"$f":"U48*(1+生産と生産額!$O$31)","v":0.39220219074960905},{"$f":"V48*(1+生産と生産額!$O$31)","v":0.39808522361085313},{"$f":"W48*(1+生産と生産額!$O$31)","v":0.40405650196501591},{"$f":"X48*(1+生産と生産額!$O$31)","v":0.41011734949449113},{"$f":"Y48*(1+生産と生産額!$O$31)","v":0.41626910973690845},{"$f":"Z48*(1+生産と生産額!$O$31)","v":0.42251314638296206},{"$f":"AA48*(1+生産と生産額!$O$31)","v":0.42885084357870645},{"$f":"AB48*(1+生産と生産額!$O$31)","v":0.43528360623238699},9.4541906883915825]
[null,"収支（Net Cash Flow)",null,{"$f":"D47-(D12+D34+D48+D46)","v":-26.8},{"$f":"E47-(E12+E34+E48+E46)","v":-73.08},-66.964624999999984,-80.517234874999971,-16.054771672687494,-184.64647826578172,-398.23203672790936,136.40265206717532,382.85696076836143,378.35361015961576,226.57452406929104,105.33567931694762,104.30562653739423,80.984953378369028,121.89766987350717,108.29976292104695,94.302742874147611,78.924238192866284,62.946787414218846,50.215817090723988,37.771131072841285,27.58238444391359,19.274695547338055,13.108480761763708,8.1170446387394932,-65.582730005679593,1125.3768845812031]
[null,"現在価値（NPV：割引率５％）",null,{"$f":"D49/((1+Dashboard!$G$36*Dashboard!$J$36)^(D4-2021))","v":-26.8},{"$f":"E49/((1+Dashboard!$G$36*Dashboard!$J$36)^(E4-2021))","v":-69.599999999999994},{"$f":"F49/((1+Dashboard!$G$36*Dashboard!$J$36)^(F4-2021))","v":-60.738888888888873},{"$f":"G49/((1+Dashboard!$G$36*Dashboard!$J$36)^(G4-2021))","v":-69.553814814814785},{"$f":"H49/((1+Dashboard!$G$36*Dashboard!$J$36)^(H4-2021))","v":-13.208300387338603},{"$f":"I49/((1+Dashboard!$G$36*Dashboard!$J$36)^(I4-2021))","v":-144.67534726748957},{"$f":"J49/((1+Dashboard!$G$36*Dashboard!$J$36)^(J4-2021))","v":-297.16687724032897},{"$f":"K49/((1+Dashboard!$G$36*Dashboard!$J$36)^(K4-2021))","v":96.938818204376318},{"$f":"L49/((1+Dashboard!$G$36*Dashboard!$J$36)^(L4-2021))","v":259.13266107469985},{"$f":"M49/((1+Dashboard!$G$36*Dashboard!$J$36)^(M4-2021))","v":243.89011059208087},{"$f":"N49/((1+Dashboard!$G$36*Dashboard!$J$36)^(N4-2021))","v":139.09710324082755},{"$f":"O49/((1+Dashboard!$G$36*Dashboard!$J$36)^(O4-2021))","v":61.587590098469882},{"$f":"P49/((1+Dashboard!$G$36*Dashboard!$J$36)^(P4-2021))","v":58.081275782475338},{"$f":"Q49/((1+Dashboard!$G$36*Dashboard!$J$36)^(Q4-2021))","v":42.948049857562886},{"$f":"R49/((1+Dashboard!$G$36*Dashboard!$J$36)^(R4-2021))","v":61.566606597935795},{"$f":"S49/((1+Dashboard!$G$36*Dashboard!$J$36)^(S4-2021))","v":52.094037684222059},{"$f":"T49/((1+Dashboard!$G$36*Dashboard!$J$36)^(T4-2021))","v":43.201173066039431},{"$f":"U49/((1+Dashboard!$G$36*Dashboard!$J$36)^(U4-2021))","v":34.434383695757873},{"$f":"V49/((1+Dashboard!$G$36*Dashboard!$J$36)^(V4-2021))","v":26.15569032816046},{"$f":"W49/((1+Dashboard!$G$36*Dashboard!$J$36)^(W4-2021))","v":19.872104002136556},{"$f":"X49/((1+Dashboard!$G$36*Dashboard!$J$36)^(X4-2021))","v":14.235542057571477},{"$f":"Y49/((1+Dashboard!$G$36*Dashboard!$J$36)^(Y4-2021))","v":9.900486294734181},{"$f":"Z49/((1+Dashboard!$G$36*Dashboard!$J$36)^(Z4-2021))","v":6.589052188091399},{"$f":"AA49/((1+Dashboard!$G$36*Dashboard!$J$36)^(AA4-2021))","v":4.2677451986194148},{"$f":"AB49/((1+Dashboard!$G$36*Dashboard!$J$36)^(AB4-2021))","v":2.5168350688049439},{"$f":"AC49/((1+Dashboard!$G$36*Dashboard!$J$36)^(AC4-2021))","v":-19.366761946183175},475.39927448752223]
[null,"収支累計",null,{"$f":"+D49","v":-26.8},{"$f":"+D51+E49","v":-99.88},-166.84462499999998,-247.36185987499994,-263.41663154768742,-448.06310981346917,-846.29514654137847,-709.8924944742032,-327.03553370584177,51.318076453773983,277.89260052306503,383.22827984001265,487.53390637740688,568.51885975577591,690.4165296292831,798.71629255033008,893.01903542447769,971.94327361734395,1034.8900610315627,1085.1058781222866,1122.8770091951278,1150.4593936390413,1169.7340891863794,{"$f":"+Z51+AA49","v":1182.8425699481431},{"$f":"+AA51+AB49","v":1190.9596145868827},{"$f":"+AB51+AC49","v":1125.3768845812031}]
[null,null,"ROR",{"$f":"IRR(D49:AB49)","v":0.1459504277871122},"Onrward",{"$f":"IRR(F49:AB49)","v":0.19478965901905276},null,{"$f":"IRR(H49:AB49)","v":0.31258555446157965}]
[null,"Equity 原油取り分（百万バレル）",null,null,null,null,null,null,null,null,{"$f":"IF(K7>0,(K43+K45)/K9,0)","v":2.8196249999999998},5.6392499999999988,5.4136800000000003,3.8490523719760596,2.9774030985373936,2.4549731638385395,2.7406635576807914,2.6663373375746855,2.3264105752030617,1.9972227273888008,1.66079441564171,1.3324037559499085,1.0779070150705301,0.84238185581497282,0.65642535475486663,0.51031167785436238,0.40485149499569639,0.32256768631062244,0,{"$f":"SUM(D53:AC53)","v":39.692261088591998}]
[null,"プロジェクト会社の収支"]
[null,null,"原油販売収入（税前）",{"$f":"D47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"E47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"F47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"G47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"H47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"I47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"J47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"K47*Dashboard!$G$7*Dashboard!$J$7","v":147.25304656926903},{"$f":"L47*Dashboard!$G$7*Dashboard!$J$7","v":303.40753980365031},{"$f":"M47*Dashboard!$G$7*Dashboard!$J$7","v":300.07491138644701},{"$f":"N47*Dashboard!$G$7*Dashboard!$J$7","v":219.79763244907522},{"$f":"O47*Dashboard!$G$7*Dashboard!$J$7","v":175.16160269865597},{"$f":"P47*Dashboard!$G$7*Dashboard!$J$7","v":148.7921803497882},{"$f":"Q47*Dashboard!$G$7*Dashboard!$J$7","v":171.12803688662567},{"$f":"R47*Dashboard!$G$7*Dashboard!$J$7","v":171.51915247264589},{"$f":"S47*Dashboard!$G$7*Dashboard!$J$7","v":154.1757165784235},{"$f":"T47*Dashboard!$G$7*Dashboard!$J$7","v":136.36037792650163},{"$f":"U47*Dashboard!$G$7*Dashboard!$J$7","v":116.81797056260476},{"$f":"V47*Dashboard!$G$7*Dashboard!$J$7","v":96.55209776125136},{"$f":"W47*Dashboard!$G$7*Dashboard!$J$7","v":80.470972266491387},{"$f":"X47*Dashboard!$G$7*Dashboard!$J$7","v":64.788666117726734},{"$f":"Y47*Dashboard!$G$7*Dashboard!$J$7","v":52.012468620841695},{"$f":"Z47*Dashboard!$G$7*Dashboard!$J$7","v":41.657165000394677},{"$f":"AA47*Dashboard!$G$7*Dashboard!$J$7","v":34.047249680469278},{"$f":"AB47*Dashboard!$G$7*Dashboard!$J$7","v":27.947259781032049},{"$f":"AC47*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"SUM(D55:AC55)","v":2441.9640469118949}]
[null,null,"ボーナス",{"$f":"D12*Dashboard!$G$7*Dashboard!$J$7","v":6},{"$f":"E12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"F12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"G12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"H12*Dashboard!$G$7*Dashboard!$J$7","v":1.7999999999999998},{"$f":"I12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"J12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"K12*Dashboard!$G$7*Dashboard!$J$7","v":3},{"$f":"L12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"M12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"N12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"O12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"P12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Q12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"R12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"S12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"T12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"U12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"V12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"W12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"X12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Y12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Z12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AA12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AB12*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AC12*Dashboard!$G$7*Dashboard!$J$7","v":0},10.8]
[null,null,"探鉱・開発費",{"$f":"D28*Dashboard!$G$7*Dashboard!$J$7","v":9.9},{"$f":"E28*Dashboard!$G$7*Dashboard!$J$7","v":43.665299999999995},{"$f":"F28*Dashboard!$G$7*Dashboard!$J$7","v":39.993334499999989},{"$f":"G28*Dashboard!$G$7*Dashboard!$J$7","v":48.122118817499981},{"$f":"H28*Dashboard!$G$7*Dashboard!$J$7","v":7.6418175644999957},{"$f":"I28*Dashboard!$G$7*Dashboard!$J$7","v":110.59397583876985},{"$f":"J28*Dashboard!$G$7*Dashboard!$J$7","v":238.74240224923591},{"$f":"K28*Dashboard!$G$7*Dashboard!$J$7","v":19.844027042683809},{"$f":"L28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"M28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"N28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"O28*Dashboard!$G$7*Dashboard!$J$7","v":24.595573812922972},{"$f":"P28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Q28*Dashboard!$G$7*Dashboard!$J$7","v":51.114828942689172},{"$f":"R28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"S28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"T28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"U28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"V28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"W28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"X28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Y28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"Z28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AA28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AB28*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"AC28*Dashboard!$G$7*Dashboard!$J$7","v":32.994497352414903},627.20787612071661]
[null,null,"操業費",{"$f":"D33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"E33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"F33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"G33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"H33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"I33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"J33*Dashboard!$G$7*Dashboard!$J$7","v":0},{"$f":"K33*Dashboard!$G$7*Dashboard!$J$7","v":18.778575926298103},{"$f":"L33*Dashboard!$G$7*Dashboard!$J$7","v":24.886474223063491},{"$f":"M33*Dashboard!$G$7*Dashboard!$J$7","v":24.786682300190325},{"$f":"N33*Dashboard!$G$7*Dashboard!$J$7","v":24.236526620909363},{"$f":"O33*Dashboard!$G$7*Dashboard!$J$7","v":23.739152087931664},{"$f":"P33*Dashboard!$G$7*Dashboard!$J$7","v":23.195005963188997},{"$f":"Q33*Dashboard!$G$7*Dashboard!$J$7","v":22.394385010041592},{"$f":"R33*Dashboard!$G$7*Dashboard!$J$7","v":24.798516561387455},{"$f":"S33*Dashboard!$G$7*Dashboard!$J$7","v":23.765917529171613},{"$f":"T33*Dashboard!$G$7*Dashboard!$J$7","v":22.740251680369006},{"$f":"U33*Dashboard!$G$7*Dashboard!$J$7","v":21.645197412052397},{"$f":"V33*Dashboard!$G$7*Dashboard!$J$7","v":20.545310235289232},{"$f":"W33*Dashboard!$G$7*Dashboard!$J$7","v":19.734289489289559},{"$f":"X33*Dashboard!$G$7*Dashboard!$J$7","v":18.978441027959175},{"$f":"Y33*Dashboard!$G$7*Dashboard!$J$7","v":18.421466468752001},{"$f":"Z33*Dashboard!$G$7*Dashboard!$J$7","v":18.028007411904724},{"$f":"AA33*Dashboard!$G$7*Dashboard!$J$7","v":17.810056990693273},{"$f":"AB33*Dashboard!$G$7*Dashboard!$J$7","v":17.692185202250208},{"$f":"AC33*Dashboard!$G$7*Dashboard!$J$7","v":6.0939704872534124},392.27041262799554]
[null,null,"石油収入税（５０％）",{"$f":"D46*Dashboard!$G$7","v":0},{"$f":"E46*Dashboard!$G$7","v":0},{"$f":"F46*Dashboard!$G$7","v":0},{"$f":"G46*Dashboard!$G$7","v":0},{"$f":"H46*Dashboard!$G$7","v":0},{"$f":"I46*Dashboard!$G$7","v":0},{"$f":"J46*Dashboard!$G$7","v":0},{"$f":"K46*Dashboard!$G$7","v":23.589080275659608},{"$f":"L46*Dashboard!$G$7","v":48.604120453982816},{"$f":"M46*Dashboard!$G$7","v":48.070252794916264},{"$f":"N46*Dashboard!$G$7","v":59.40749403808671},{"$f":"O46*Dashboard!$G$7","v":63.413438398900659},{"$f":"P46*Dashboard!$G$7","v":62.798587193299603},{"$f":"Q46*Dashboard!$G$7","v":48.809411466947466},{"$f":"R46*Dashboard!$G$7","v":73.360317955629213},{"$f":"S46*Dashboard!$G$7","v":65.204899524625944},{"$f":"T46*Dashboard!$G$7","v":56.8100631230663},{"$f":"U46*Dashboard!$G$7","v":47.58638657527618},{"$f":"V46*Dashboard!$G$7","v":38.003393762981062},{"$f":"W46*Dashboard!$G$7","v":30.368341388600918},{"$f":"X46*Dashboard!$G$7","v":22.905112544883782},{"$f":"Y46*Dashboard!$G$7","v":16.795501076044847},{"$f":"Z46*Dashboard!$G$7","v":11.814578794244978},{"$f":"AA46*Dashboard!$G$7","v":8.1185963448880027},{"$f":"AB46*Dashboard!$G$7","v":5.1275372893909186},{"$f":"AC46*Dashboard!$G$7","v":0},730.78711300142538]
[null,null,"支出合計",{"$f":"SUM(D56:D59)","v":15.9},{"$f":"SUM(E56:E59)","v":43.665299999999995},39.993334499999989,48.122118817499981,9.4418175644999955,110.59397583876985,238.74240224923591,65.21168324464152,73.490594677046303,72.856935095106593,83.64402065899607,111.7481642997553,85.9935931564886,122.31862541967823,98.158834517016672,88.97081705379756,79.550314803435299,69.231583987328577,58.548703998270298,50.102630877890476,41.883553572842956,35.216967544796844,29.842586206149704,25.928653335581274,22.819722491641127,39.088467839668319,1761.0654017501377]
[null,null,"借入金返済原資",{"$f":"IF(D55-D56-D58-D59>0,D55-D56-D58-D59,0)","v":0},{"$f":"IF(E55-E56-E58-E59>0,E55-E56-E58-E59,0)","v":0},0,0,0,0,0,101.88539036731132,229.91694512660399,227.21797629134045,136.15361179007914,88.009012211823631,62.798587193299589,99.92424040963661,73.360317955629213,65.204899524625944,56.810063123066328,47.58638657527618,38.003393762981062,30.368341388600911,22.905112544883774,16.795501076044847,11.814578794244975,8.1185963448880027,5.1275372893909221,0]
[null,"出資",null,{"$f":"D60","v":15.9},{"$f":"E60","v":43.665299999999995},{"$f":"F60","v":39.993334499999989},{"$f":"G60","v":48.122118817499981},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D62:AC62)","v":147.68075331749998}]
[null,"借入れ","元本",{"$f":"IF(D60-D55-D62>0,D60-D55-D62,0)","v":0},{"$f":"IF(E60-E55-E62>0,E60-E55-E62,0)","v":0},{"$f":"IF(F60-F55-F62>0,F60-F55-F62,0)","v":0},{"$f":"IF(G60-G55-G62>0,G60-G55-G62,0)","v":0},{"$f":"H56+H57","v":9.4418175644999955},{"$f":"I56+I57","v":110.59397583876985},{"$f":"J56+J57","v":238.74240224923591},{"$f":"K56+K57","v":22.844027042683809},{"$f":"L56+L57","v":0},0,0,24.595573812922972,0,51.114828942689172,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D63:AC63)","v":457.33262545080174}]
[null,null,"金利",{"$f":"(D63)*Dashboard!G34*Dashboard!J34","v":0},{"$f":"(D67+E63)*Dashboard!$G$34*Dashboard!$J$34","v":0},{"$f":"(E67+F63)*Dashboard!$G$34*Dashboard!$J$34","v":0},{"$f":"(F67+G63)*Dashboard!$G$34*Dashboard!$J$34","v":0},{"$f":"(G67+H63)*Dashboard!$G$34*Dashboard!$J$34","v":0.47209087822499979},{"$f":"(H67+I63)*Dashboard!$G$34*Dashboard!$J$34","v":6.0253942140747432},{"$f":"(I67+J63)*Dashboard!$G$34*Dashboard!$J$34","v":18.263784037240278},{"$f":"(J67+K63)*Dashboard!$G$34*Dashboard!$J$34","v":20.319174591236482},{"$f":"(K67+L63)*Dashboard!$G$34*Dashboard!$J$34","v":17.835133320798306},{"$f":"(L67+M63)*Dashboard!$G$34*Dashboard!$J$34","v":15.226889986838223},{"$f":"(M67+N63)*Dashboard!$G$34*Dashboard!$J$34","v":12.488234486180133},{"$f":"(N67+O63)*Dashboard!$G$34*Dashboard!$J$34","v":10.842424901135288},{"$f":"(O67+P63)*Dashboard!$G$34*Dashboard!$J$34","v":7.8845461461920543},{"$f":"(P67+Q63)*Dashboard!$G$34*Dashboard!$J$34","v":7.6945855409711363},{"$f":"(Q67+R63)*Dashboard!$G$34*Dashboard!$J$34","v":4.5793148180196921},{"$f":"(R67+S63)*Dashboard!$G$34*Dashboard!$J$34","v":1.3082805589206772},{"$f":"(S67+T63)*Dashboard!$G$34*Dashboard!$J$34","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(D64:AC64)","v":122.939853479832}]
[null,"資金返済（金利含む7年均等返済）",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(H63:K64)*E66,-1)","v":70},{"$f":"IF(K67+L63+L64>$K$65,IF(L61>$K$65,$K$65,L61),IF(L61>K67+L63+L64,K67+L63+L64,L61))","v":70},{"$f":"IF(L67+M63+M64>$K$65,IF(M61>$K$65,$K$65,M61),IF(M61>L67+M63+M64,L67+M63+M64,M61))","v":70},70,70,62.798587193299589,70,70,27.47389173733422,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D65:AC65)","v":580.27247893063384}]
[null,null,"資本回収係数",null,{"$f":"Dashboard!G34*Dashboard!J34/(1-(1+Dashboard!G34*Dashboard!J34)^(-1*Dashboard!G35))","v":0.1728198184461707},null,null,null,null,null,null,null,null,null,"Debt Service Coverage Ratio",null,null,{"$f":"SUM(K61:R61)/SUM(K65:R65)","v":1.8438290273511722}]
[null,"年末借入残（金利含む）",null,null,null,null,null,{"$f":"G67+H63+H64-H65","v":9.9139084427249955},{"$f":"H67+I63+I64-I65","v":126.53327849556959},{"$f":"I67+J63+J64-J65","v":383.5394647820458},{"$f":"J67+K63+K64-K65","v":356.70266641596612},{"$f":"K67+L63+L64-L65","v":304.53779973676444},249.76468972360266,192.2529242097828,157.69092292384107,102.77688187673354,91.586296360393845,26.165611178413542,0,0]
[null,null,"Debt/Equity Ratio",null,null,null,null,{"$f":"H67/$AD$62","v":6.713067356455725E-2},0.85680276984729842,2.597084969884135,2.415363264359089,2.0621360122807357,1.6912473975984645,1.30181435218208]
[null,"本社管理費",null,{"$f":"D48","v":0.3},{"$f":"E48","v":0.30449999999999994},0.30906749999999988,0.31370351249999984,0.31840906518749978,0.32318520116531224,0.3280329791827919,0.33295347387053376,0.33794777597859171,0.34301699261827057,0.3481622475075446,0.35338468122015776,0.35868545143846009,0.36406573321003693,0.36952671920818747,0.37506961999631022,0.38069566429625484,0.38640609926069863,0.39220219074960905,0.39808522361085313,0.40405650196501591,0.41011734949449113,0.41626910973690845,0.42251314638296206,0.42885084357870645,0.43528360623238699,{"$f":"SUM(D69:AC69)","v":9.4541906883915825}]
[null,"プロジェクト会社のキャッシュフロー"]
[null,null,"借入金なし",{"$f":"D55-(D60+D69)","v":-16.2},{"$f":"E55-(E60+E69)","v":-43.969799999999992},-40.302401999999987,-48.435822329999979,-9.7602266296874944,-110.91716103993517,-239.07043522841869,81.708409850756979,229.5789973506254,226.87495929872216,135.80544954257161,63.060053717680503,62.439901741861135,48.445345733737398,72.990791236421032,64.829829904629634,56.429367458770074,47.199980476015483,37.611191572231455,29.970256164990055,22.501056042918762,16.385383726550359,11.398309684508064,7.6960831985050433,4.6986864458122142,-39.523751445900707,{"$f":"SUM(D71:AC71)","v":671.44445447336534}]
[null,null,"借入金あり",{"$f":"D55+D63-D60-D65-D69","v":-16.2},{"$f":"E55+E63-E60-E65-E69","v":-43.969799999999992},-40.302401999999987,-48.435822329999979,-0.31840906518749978,-0.32318520116531224,-0.3280329791827919,34.552436893440799,159.5789973506254,156.87495929872216,65.805449542571594,17.655627530603475,-0.35868545143845298,29.560174676426573,2.9907912364210256,37.355938167295413,56.429367458770074,47.199980476015483,37.611191572231455,29.970256164990058,22.501056042918762,16.385383726550359,11.398309684508064,7.6960831985050424,4.698686445812216,-39.523751445900707,{"$f":"SUM(D72:AC72)","v":548.50460099353302}]
[null,null,"収支累計",{"$f":"SUM($D$72:D72)","v":-16.2},{"$f":"SUM($D$72:E72)","v":-60.169799999999995},{"$f":"SUM($D$72:F72)","v":-100.47220199999998},{"$f":"SUM($D$72:G72)","v":-148.90802432999996},{"$f":"SUM($D$72:H72)","v":-149.22643339518746},{"$f":"SUM($D$72:I72)","v":-149.54961859635276},{"$f":"SUM($D$72:J72)","v":-149.87765157553554},{"$f":"SUM($D$72:K72)","v":-115.32521468209474},{"$f":"SUM($D$72:L72)","v":44.253782668530661},{"$f":"SUM($D$72:M72)","v":201.12874196725284},{"$f":"SUM($D$72:N72)","v":266.93419150982442},{"$f":"SUM($D$72:O72)","v":284.58981904042787},{"$f":"SUM($D$72:P72)","v":284.23113358898939},{"$f":"SUM($D$72:Q72)","v":313.79130826541598},{"$f":"SUM($D$72:R72)","v":316.78209950183702},{"$f":"SUM($D$72:S72)","v":354.13803766913242},{"$f":"SUM($D$72:T72)","v":410.56740512790248},{"$f":"SUM($D$72:U72)","v":457.76738560391794},{"$f":"SUM($D$72:V72)","v":495.37857717614941},{"$f":"SUM($D$72:W72)","v":525.34883334113943},{"$f":"SUM($D$72:X72)","v":547.8498893840582},{"$f":"SUM($D$72:Y72)","v":564.23527311060855},{"$f":"SUM($D$72:Z72)","v":575.63358279511658},{"$f":"SUM($D$72:AA72)","v":583.32966599362157},{"$f":"SUM($D$72:AB72)","v":588.02835243943377},{"$f":"SUM($D$72:AC72)","v":548.50460099353302}]
[null,"現在価値（割引率５％）",null,{"$f":"D72/((1+Dashboard!$G$36*Dashboard!$J$36)^(D4-2021))","v":-16.2},{"$f":"E72/((1+Dashboard!$G$36*Dashboard!$J$36)^(E4-2021))","v":-41.875999999999991},{"$f":"F72/((1+Dashboard!$G$36*Dashboard!$J$36)^(F4-2021))","v":-36.555466666666653},{"$f":"G72/((1+Dashboard!$G$36*Dashboard!$J$36)^(G4-2021))","v":-41.84068444444442},{"$f":"H72/((1+Dashboard!$G$36*Dashboard!$J$36)^(H4-2021))","v":-0.26195592592592576},{"$f":"I72/((1+Dashboard!$G$36*Dashboard!$J$36)^(I4-2021))","v":-0.25322406172839484},{"$f":"J72/((1+Dashboard!$G$36*Dashboard!$J$36)^(J4-2021))","v":-0.24478325967078168},{"$f":"K72/((1+Dashboard!$G$36*Dashboard!$J$36)^(K4-2021))","v":24.55577181066759},{"$f":"L72/((1+Dashboard!$G$36*Dashboard!$J$36)^(L4-2021))","v":108.00934675997486},{"$f":"M72/((1+Dashboard!$G$36*Dashboard!$J$36)^(M4-2021))","v":101.12299749526035},{"$f":"N72/((1+Dashboard!$G$36*Dashboard!$J$36)^(N4-2021))","v":40.398837629392396},{"$f":"O72/((1+Dashboard!$G$36*Dashboard!$J$36)^(O4-2021))","v":10.322879752968172},{"$f":"P72/((1+Dashboard!$G$36*Dashboard!$J$36)^(P4-2021))","v":-0.19972948071684055},{"$f":"Q72/((1+Dashboard!$G$36*Dashboard!$J$36)^(Q4-2021))","v":15.676391759713377},{"$f":"R72/((1+Dashboard!$G$36*Dashboard!$J$36)^(R4-2021))","v":1.5105528076161043},{"$f":"S72/((1+Dashboard!$G$36*Dashboard!$J$36)^(S4-2021))","v":17.968844973698154},{"$f":"T72/((1+Dashboard!$G$36*Dashboard!$J$36)^(T4-2021))","v":25.850943411549149},{"$f":"U72/((1+Dashboard!$G$36*Dashboard!$J$36)^(U4-2021))","v":20.59319513698269},{"$f":"V72/((1+Dashboard!$G$36*Dashboard!$J$36)^(V4-2021))","v":15.628226952439977},{"$f":"W72/((1+Dashboard!$G$36*Dashboard!$J$36)^(W4-2021))","v":11.860248064974183},{"$f":"X72/((1+Dashboard!$G$36*Dashboard!$J$36)^(X4-2021))","v":8.4804113761120572},{"$f":"Y72/((1+Dashboard!$G$36*Dashboard!$J$36)^(Y4-2021))","v":5.8814083803573753},{"$f":"Z72/((1+Dashboard!$G$36*Dashboard!$J$36)^(Z4-2021))","v":3.8965106962544755},{"$f":"AA72/((1+Dashboard!$G$36*Dashboard!$J$36)^(AA4-2021))","v":2.5056238564579667},{"$f":"AB72/((1+Dashboard!$G$36*Dashboard!$J$36)^(AB4-2021))","v":1.4569118873264069},{"$f":"AC72/((1+Dashboard!$G$36*Dashboard!$J$36)^(AC4-2021))","v":-11.671473349867911},{"$f":"SUM(D74:AC74)","v":266.61578556272428}]
[null,null,"ROR",{"$f":"IRR(D71:AB71)","v":0.14527732472774257},null,null,"開発以降",{"$f":"IRR(H71:AB71)","v":0.31169679311210907}]
[null,null,"FIRR",{"$f":"IRR(D72:AB72)","v":0.19318623789954104},null,null,null,{"$f":"IRR(H72:AB72)","v":4.6135176217082137},null,null,"金利/収益比率",null,{"$f":"AD64/(AD64+AD72)","v":0.18309757815522892}]
[]
[null,"(注）本書の表８．２のうち、原油販売収入を税前に変更し、支出に石油収入税を加えてあります。"]

{"sheet":"グラフ","index":7,"n_rows":29,"n_cols":33,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"プロジェクト収支：廃山費を含まず。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"採算指標一覧（廃山費用を含む）"]
[null,"探鉱期間→","探鉱期間→",null,null,null,"開発期間→",null,null,"生産期間→"]
[null,null,2021,{"$f":"C4+1","v":2022},{"$f":"D4+1","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,{"$f":"Z4+1","v":2045},{"$f":"AA4+1","v":2046},null,null,"科　目","合計","備　考"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（プロジェクト全体の採算）",null,"百万ドル"]
[null,"売上高（税前）",{"$f":"プロジェクト収支!E25","v":0},{"$f":"プロジェクト収支!F25","v":0},{"$f":"プロジェクト収支!G25","v":0},{"$f":"プロジェクト収支!H25","v":0},{"$f":"プロジェクト収支!I25","v":0},{"$f":"プロジェクト収支!J25","v":0},{"$f":"プロジェクト収支!K25","v":0},{"$f":"プロジェクト収支!L25","v":245.42174428211507},{"$f":"プロジェクト収支!M25","v":505.6792330060839},{"$f":"プロジェクト収支!N25","v":500.12485231074504},{"$f":"プロジェクト収支!O25","v":366.32938741512538},{"$f":"プロジェクト収支!P25","v":291.93600449775994},{"$f":"プロジェクト収支!Q25","v":247.98696724964702},{"$f":"プロジェクト収支!R25","v":285.2133948110428},{"$f":"プロジェクト収支!S25","v":285.86525412107648},{"$f":"プロジェクト収支!T25","v":256.95952763070585},{"$f":"プロジェクト収支!U25","v":227.26729654416937},{"$f":"プロジェクト収支!V25","v":194.69661760434127},{"$f":"プロジェクト収支!W25","v":160.92016293541894},{"$f":"プロジェクト収支!X25","v":134.11828711081898},{"$f":"プロジェクト収支!Y25","v":107.98111019621123},{"$f":"プロジェクト収支!Z25","v":86.687447701402832},{"$f":"プロジェクト収支!AA25","v":69.428608333991136},{"$f":"プロジェクト収支!AB25","v":56.745416134115466},{"$f":"プロジェクト収支!AC25","v":46.57876630172008},{"$f":"プロジェクト収支!AD25","v":35.678626380746131},null,null,"生産総額",{"$f":"生産と生産額!AF38","v":10837.599828861506},"プロジェクト期間中の生産総額（産油国取り分を含む）"]
[null,"ＮＣＦ",{"$f":"プロジェクト収支!E28","v":-26.8},{"$f":"プロジェクト収支!F28","v":-73.08},{"$f":"プロジェクト収支!G28","v":-66.964624999999984},{"$f":"プロジェクト収支!H28","v":-80.517234874999971},{"$f":"プロジェクト収支!I28","v":-16.054771672687494},{"$f":"プロジェクト収支!J28","v":-184.64647826578172},{"$f":"プロジェクト収支!K28","v":-398.23203672790936},{"$f":"プロジェクト収支!L28","v":136.40265206717532},{"$f":"プロジェクト収支!M28","v":382.85696076836143},{"$f":"プロジェクト収支!N28","v":378.35361015961576},{"$f":"プロジェクト収支!O28","v":226.57452406929107},{"$f":"プロジェクト収支!P28","v":105.33567931694762},{"$f":"プロジェクト収支!Q28","v":104.30562653739423},{"$f":"プロジェクト収支!R28","v":80.984953378369056},{"$f":"プロジェクト収支!S28","v":121.8976698735072},{"$f":"プロジェクト収支!T28","v":108.29976292104695},{"$f":"プロジェクト収支!U28","v":94.302742874147583},{"$f":"プロジェクト収支!V28","v":78.92423819286627},{"$f":"プロジェクト収支!W28","v":62.946787414218832},{"$f":"プロジェクト収支!X28","v":50.215817090724002},{"$f":"プロジェクト収支!Y28","v":37.771131072841285},{"$f":"プロジェクト収支!Z28","v":27.58238444391359},{"$f":"プロジェクト収支!AA28","v":19.274695547338055},{"$f":"プロジェクト収支!AB28","v":13.108480761763708},{"$f":"プロジェクト収支!AC28","v":8.1170446387394932},{"$f":"プロジェクト収支!AD28","v":5.4485677948655109E-2},null,null,"売上総額",{"$f":"プロジェクト収支!AF25","v":4069.9400781864906},"プロジェクト会社の売上総額"]
[null,"操業費",{"$f":"プロジェクト収支!E17","v":0},{"$f":"プロジェクト収支!F17","v":0},{"$f":"プロジェクト収支!G17","v":0},{"$f":"プロジェクト収支!H17","v":0},{"$f":"プロジェクト収支!I17","v":0},{"$f":"プロジェクト収支!J17","v":0},{"$f":"プロジェクト収支!K17","v":0},{"$f":"プロジェクト収支!L17","v":31.297626543830173},{"$f":"プロジェクト収支!M17","v":41.477457038439155},{"$f":"プロジェクト収支!N17","v":41.311137166983876},{"$f":"プロジェクト収支!O17","v":40.394211034848936},{"$f":"プロジェクト収支!P17","v":39.56525347988611},{"$f":"プロジェクト収支!Q17","v":38.658343271981664},{"$f":"プロジェクト収支!R17","v":37.323975016735986},{"$f":"プロジェクト収支!S17","v":41.330860935645759},{"$f":"プロジェクト収支!T17","v":39.609862548619354},{"$f":"プロジェクト収支!U17","v":37.900419467281679},{"$f":"プロジェクト収支!V17","v":36.075329020087331},{"$f":"プロジェクト収支!W17","v":34.242183725482057},{"$f":"プロジェクト収支!X17","v":32.890482482149267},{"$f":"プロジェクト収支!Y17","v":31.630735046598627},{"$f":"プロジェクト収支!Z17","v":30.702444114586672},{"$f":"プロジェクト収支!AA17","v":30.046679019841207},{"$f":"プロジェクト収支!AB17","v":29.683428317822123},{"$f":"プロジェクト収支!AC17","v":29.486975337083681},{"$f":"プロジェクト収支!AD17","v":29.473348987028086},null,null,"支出総額",{"$f":"AF9+AF13","v":1726.5846719362455},"直接事業費＋本社管理費"]
[null,"Discounted NCF @5%",{"$f":"プロジェクト収支!E30","v":-26.8},{"$f":"プロジェクト収支!F30","v":-69.599999999999994},{"$f":"プロジェクト収支!G30","v":-60.738888888888873},{"$f":"プロジェクト収支!H30","v":-69.553814814814785},{"$f":"プロジェクト収支!I30","v":-13.208300387338603},{"$f":"プロジェクト収支!J30","v":-144.67534726748957},{"$f":"プロジェクト収支!K30","v":-297.16687724032897},{"$f":"プロジェクト収支!L30","v":96.938818204376318},{"$f":"プロジェクト収支!M30","v":259.13266107469985},{"$f":"プロジェクト収支!N30","v":243.89011059208087},{"$f":"プロジェクト収支!O30","v":139.09710324082755},{"$f":"プロジェクト収支!P30","v":61.587590098469882},{"$f":"プロジェクト収支!Q30","v":58.081275782475338},{"$f":"プロジェクト収支!R30","v":42.9480498575629},{"$f":"プロジェクト収支!S30","v":61.566606597935809},{"$f":"プロジェクト収支!T30","v":52.094037684222059},{"$f":"プロジェクト収支!U30","v":43.201173066039424},{"$f":"プロジェクト収支!V30","v":34.434383695757866},{"$f":"プロジェクト収支!W30","v":26.155690328160457},{"$f":"プロジェクト収支!X30","v":19.87210400213656},{"$f":"プロジェクト収支!Y30","v":14.235542057571477},{"$f":"プロジェクト収支!Z30","v":9.900486294734181},{"$f":"プロジェクト収支!AA30","v":6.589052188091399},{"$f":"プロジェクト収支!AB30","v":4.2677451986194148},{"$f":"プロジェクト収支!AC30","v":2.5168350688049439},{"$f":"プロジェクト収支!AD30","v":1.6089771716069491E-2},null,null,"直接事業費",{"$f":"AF10+AF11+AF12","v":1717.1304812478538},"探鉱費＋開発費＋生産費"]
[null,"Production（千BD)",0,0,0,0,0,0,0,{"$f":"生産と生産額!L22","v":15},{"$f":"生産と生産額!M22","v":30},{"$f":"生産と生産額!N22","v":28.8},{"$f":"生産と生産額!O22","v":26.496000000000002},{"$f":"生産と生産額!P22","v":24.376320000000003},{"$f":"生産と生産額!Q22","v":22.192608},{"$f":"生産と生産額!R22","v":19.447732800000004},{"$f":"生産と生産額!S22","v":24.317452880000001},{"$f":"生産と生産額!T22","v":21.059178948000003},{"$f":"生産と生産額!U22","v":17.900302105799998},{"$f":"生産と生産額!V22","v":14.666508786150002},{"$f":"生産と生産額!W22","v":11.5062234616125},{"$f":"生産と生産額!X22","v":9.0600581874093731},{"$f":"生産と生産額!Y22","v":6.7950436405570303},{"$f":"生産と生産額!Z22","v":5.0094690813822647},{"$f":"生産と生産額!AA22","v":3.609518607676335},{"$f":"生産と生産額!AB22","v":2.6038307134049972},{"$f":"生産と生産額!AC22","v":1.8226814993834979},{"$f":"生産と生産額!AD22","v":1.2758770495684484},null,null,"探鉱費",{"$f":"作業と支出!AF37+作業と支出!E30","v":246.13458886249995},"サインボーナスを含む"]
[null,"Equity oil（千BD)",0,0,0,0,0,0,0,{"$f":"プロジェクト収支!L35*1000/365","v":7.7249999999999996},{"$f":"プロジェクト収支!M35*1000/365","v":15.449999999999998},{"$f":"プロジェクト収支!N35*1000/365","v":14.832000000000001},{"$f":"プロジェクト収支!O35*1000/365","v":10.545348964317972},{"$f":"プロジェクト収支!P35*1000/365","v":8.1572687631161482},{"$f":"プロジェクト収支!Q35*1000/365","v":6.725953873530246},{"$f":"プロジェクト収支!R35*1000/365","v":7.5086672813172362},{"$f":"プロジェクト収支!S35*1000/365","v":7.3050338015744813},{"$f":"プロジェクト収支!T35*1000/365","v":6.3737276032960599},{"$f":"プロジェクト収支!U35*1000/365","v":5.4718430887364411},{"$f":"プロジェクト収支!V35*1000/365","v":4.5501216866896161},{"$f":"プロジェクト収支!W35*1000/365","v":3.650421249177831},{"$f":"プロジェクト収支!X35*1000/365","v":2.9531699043028223},{"$f":"プロジェクト収支!Y35*1000/365","v":2.3078954953834874},{"$f":"プロジェクト収支!Z35*1000/365","v":1.798425629465388},{"$f":"プロジェクト収支!AA35*1000/365","v":1.3981141859023627},{"$f":"プロジェクト収支!AB35*1000/365","v":1.109182178070401},{"$f":"プロジェクト収支!AC35*1000/365","v":0.88374708578252725},{"$f":"プロジェクト収支!AD35*1000/365","v":0.65707668052775081},null,null,"開発費",{"$f":"作業と支出!AF60+作業と支出!I30","v":812.21187133869444},"発見ボーナスを含む。廃山費用（＝施設撤去費＋廃坑費、将来価格＝5,500万ドル）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"生産費",{"$f":"作業と支出!AF73+作業と支出!L30","v":658.7840210466594},"生産開始ボーナスを含む"]
[null,"（注）本書の図８．３では税引き後売上高をリンクしていますので、税前売上高に修正します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"本社管理費",{"$f":"プロジェクト収支!AF26","v":9.4541906883915825},"プロジェクト検討の段階ではカウントしないことが多い。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NCF (Net Cash Flow)",{"$f":"プロジェクト収支!AF28","v":1125.3768845812035},"利益総額（名目値）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV（正味現在価値：割引き率＠５％)",{"$f":"プロジェクト収支!AF30","v":475.39927448752223},"事業着手以降のＮＣＦを年利５％で割り引いたプロジェクトの正味現在価値"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROR（割引現金収支利益率）",{"$f":"プロジェクト収支!E33","v":0.1459504277871122},"期待投資利回り：この率で割り引いたＮＰＶはゼロとなる"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payout（投資回収期間）","１０年","事業開始以降の収支累計が黒字になるまでの期間（Cash Flow Chartより手計算）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equity 原油取得量（百万バーレル）",{"$f":"プロジェクト収支!AF35","v":39.932094076984626},"コスト回収原油＋利益原油"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（６０％出資会社の採算）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"出資総額",{"$f":"'自社収支 '!AF21","v":147.68075331749998},"探鉱期間に発生する費用（本社管理費は除く）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"借入総額",{"$f":"'自社収支 '!AF24","v":580.27247893063384},"「開発投資＋金利」に充当"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NCF (Net Cash Flow)",{"$f":"'自社収支 '!AF33","v":548.50460099353302},"「借入～返済」の資金収支は含まない"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV（正味現在価値：割引き率＠５％)",{"$f":"'自社収支 '!AF32","v":283.13063397509558}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROR（割引現金収支利益率）",{"$f":"'自社収支 '!E38","v":0.14527732472774257},"上記のシェア100%の場合に比べ、本社管理費の負担率がやや上がる。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIRR（自己資本利益率）",{"$f":"'自社収支 '!E40","v":0.19318623789954104},"自己資本投資に対する利益率"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPV（正味現在価値：割引き率＠５％)",{"$f":"'自社収支 '!AF35","v":266.61578556272428},"借り入れを行うケース"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payout（投資回収期間）","9年/15年","自社投資は9年目で回収するが、借入金返済完了は15年目"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（注）本書のの表８．３では「生産総額」を「収入総額」と表記していますので、修正し、売上総額を追加します。"]