Bank ABC Energy Portfolio_Example Answer Task 2__

xlsx

School

North Carolina State University *

*We aren’t endorsed by this school

Course

MAE 308

Subject

Management

Date

Jan 9, 2024

Type

xlsx

Pages

14

Uploaded by svikram91

Report
Please populate this page and conduct the analyses here by company Baseline Data Units >> $ USD Portfolio Client Name Sector Category Total Corporate Lending Financing Best Oil Upstream 123,243,545 Prosperous Petroleum Upstream 89,212,216 Gas Ship Logistics Midstream 53,256,456 Octagon Downstream 246,872,238 Pointed Energy Integrated 97,000,342
$ USD tCO2e tCO2e tCO2e EVIC Scope 1 Emissions Scope 2 Emissions Scope 3 Emissions 23,215,122,156 10,792,564 301,425 161,423,442 15,211,684,315 941,353 98,421 47,001,354 26,369,523,657 7,904,325 95,051 6,645,227 16,235,714,168 13,684,522 1,924,865 86,552,454 59,112,751,273 15,792,532 2,035,112 165,211,562
Helper Calculations MBBL MJ Total Oil Production Total Oil Production 209,455 1,280,831,944,959 125,481 767,325,073,574 - - - - 381,524 2,333,045,890,375
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Outputs tCO2e tCO2e Total Emissions Absolute financed emissions 172,517,431 915,853.88 48,041,128 281,747.60 14,644,603 29,576.55 102,161,841 1,553,422.42 183,039,206 300,355.93
gCO2e/MJ gCO2e/MJ gCO2e/MJ gCO2e/MJ Physical Emissions Intensity Scope 1 PEI Scope 2 PEI Scope 3 PEI 134.69 8.43 0.24 126.03 62.61 1.23 0.13 61.25 - - - - - - - - 78.46 6.77 0.87 70.81
Please research conversion factors, calculate accordingly below add the final conver MJ/MBBL Crude oil 6,115,069.80 Assume 0.138 mmBtu / gallon Crude Oil Source: 42 gallons/BBL 1,055.05 MJ / 1 MMBtu Process Petroleum product(mmBtu / gall (MJ / gallon) Crude Oil 0.138 145.60
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
rsions factor value in the blue box. US EPA/EIA are good sources to start your search! https://www.epa.gov/system/files/documents/2022-10/Default%20Heat%20Content%20Ratios%20for%20Help% (MJ / MBBL) 6,115,070
%20and%20User%20Guide%20%281%29.pdf
This page intentionally blank
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
20XX data Client Name Sector Category Best Oil Upstream Prosperous Petroleum Upstream Gas Ship Logistics Midstream Octagon Downstream Pointed Energy Integrated
Total Corporate Lending Financing (USD) EVIC (USD) 123,243,545 23,215,122,156 89,212,216 15,211,684,315 53,256,456 26,369,523,657 246,872,238 16,235,714,168 97,000,342 59,112,751,273
20XX Data Client Name Best Oil 10,792,564.00 301,425.00 Prosperous Petroleum 941,353.00 98,421.00 Gas Ship Logistics 7,904,325.00 95,051.00 Octagon 13,684,522.00 1,924,865.00 Pointed Energy 15,792,532.00 2,035,112.00 Scope 1 Emissions (tCO₂e) Scope 2 Emissions (tCO₂e)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total Emissions 161,423,442.00 172,517,431.00 47,001,354.00 48,041,128.00 6,645,227.00 14,644,603.00 86,552,454.00 102,161,841.00 165,211,562.00 183,039,206.00 Scope 3 Emissions (tCO₂e)
20XX Production Data Client Name Total Oil Production (MBBL) Best Oil 209,455.00 Prosperous Petroleum 125,481.00 Gas Ship Logistics - Octagon - Pointed Energy 381,524.00

Related Documents

9453 ChengSITXHRM003 Assessment 1 -Short Answers (2) 3.docx
Week 1 - Quiz_ BUS357_ International Business (CCJ2401A).pdf
2. BSBSUS511 Project Portfolio.docx
LANG_promiscuity.Resume.docx
POLI_harmfulAgreement.docx
MBA_620_3_1_Milestone_One _Innovation_Approach_CGC.xlsx
Work in the real estate industry report.docx
Discussion Template [Ver. 1].pdf
assigment 3 brand you - Dimitra Katsaitis - 102660655.docx
ASSIGNMENT 3.docx
Case Study Analysis 102660655 Dimitra Katsaitis.docx
COmm1100 case study.docx
Recommended textbooks for you
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
SEE MORE TEXTBOOKS