Project Year Cash Flow from Investing Signature bonus Exploration & Predevelopment Upstream Development Pipeline/FSO/Export Total Investment Cash Flow from Operations Production (millions of bbls) Ol Price (S/bbl) Gross Revenue (millions of $) Unit Operating Cost (S/bbl) Total Operating Expense (millions of $) Net Operating Earnings Net (Free) Cash Flow 1 2 10 11 12 13 14 15 16 17 18 19 55.00 45.00 30.00 85.00 15.00 10.00 90.00 20.00 5.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 10.00 75.00 75.00 55.00 2.00 in ALL cells highlighted in ellow. 0.57 6.10 942 12.40 10.80 9.49 8.30 7.26 6.36 5.56 4.86 4.26 3.70 3.26 2.85 2.49 2.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 6.20 2.60 2.40 2.30 2.36 2.40 2.46 2.54 2.64 2.72 2.82 2.94 3.08 3.24 3.40 3.60 3.40 NPV (millionss, discount rate: 16.2%) IRR P ng nter duprecation.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Question

Please help with highlighted rows 1-3. Thank you. 

ICalendar Year
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Project Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Cash Flow from Investing
Signature bonus
Exploration & Predevelopment
Upstream Development
Pipeline/FSO/Export
Total Investment
Cash Flow from Operations
55.00
45.00
30.00
85.00
90.00
20.00
15.00
5.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
2.00
10.00
75.00
75.00
55.00
10.00
2.00
Fill in ALL cells highlighted in
yellow.
Production (millions of bbls)
0.57
6.10
9.42
12.40
10.80
9.49
8.30
7.26
6.36
5.56
4.86
4.26
3.70
3.26
2.85
2.49
2.00
Oil Price ($/bbl)
Gross Revenue (millions of $)
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
Unit Operating Cost ($/bbl)
Total Operating Expense (millions of $)
Net Operating Earnings
6.20
2.60
2.40
2.30
2.36
2.40
2.46
2,54
2.64
2.72
2.82
2.94
3.08
3.24
3.40
3.60
3.40
Net (Free) Cash Flow
NPV (millions$, discount rate: 16.2%)
Dames:
Pease note that bere numbers are presented in accounting format. Just remember:
) Cash flows fram investing are cash outflos.
2) Revenues are cash inflows.
p) Operating espars are caih cutflows.
4) There're noe depreciation or Net Working Captal to conider with this project.
bames:
IRR
This is a real enample from an energy testbeok, Please note that
korporate income tax is NOT appled here. The esact reason was
hot clear because the text didrnt dscuss about thik, but I susped
hat the company has a special arangement with the host
country (maybe even the home country as w?)
Transcribed Image Text:ICalendar Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Project Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Cash Flow from Investing Signature bonus Exploration & Predevelopment Upstream Development Pipeline/FSO/Export Total Investment Cash Flow from Operations 55.00 45.00 30.00 85.00 90.00 20.00 15.00 5.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 10.00 75.00 75.00 55.00 10.00 2.00 Fill in ALL cells highlighted in yellow. Production (millions of bbls) 0.57 6.10 9.42 12.40 10.80 9.49 8.30 7.26 6.36 5.56 4.86 4.26 3.70 3.26 2.85 2.49 2.00 Oil Price ($/bbl) Gross Revenue (millions of $) 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 Unit Operating Cost ($/bbl) Total Operating Expense (millions of $) Net Operating Earnings 6.20 2.60 2.40 2.30 2.36 2.40 2.46 2,54 2.64 2.72 2.82 2.94 3.08 3.24 3.40 3.60 3.40 Net (Free) Cash Flow NPV (millions$, discount rate: 16.2%) Dames: Pease note that bere numbers are presented in accounting format. Just remember: ) Cash flows fram investing are cash outflos. 2) Revenues are cash inflows. p) Operating espars are caih cutflows. 4) There're noe depreciation or Net Working Captal to conider with this project. bames: IRR This is a real enample from an energy testbeok, Please note that korporate income tax is NOT appled here. The esact reason was hot clear because the text didrnt dscuss about thik, but I susped hat the company has a special arangement with the host country (maybe even the home country as w?)
Expert Solution
Step 1

As per the requirements, the solution of 3 highlighted rows have been given. Those rows are row 8, 12, and 14.

NPV is the present worth of cash flows that are estimated to arise in the future. It is calculated by subtracting PV of outflows from PV of inflows.

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education