79 upl nav model sample

377
Ultra Petroleum Corp. - Assumptions - NAV Model by Geography and Reserve ($ in Millions Except Per Share and Per Unit Data) Model-Wide Toggles & Assumptions: Company Name: Current Share Price: Bbl to Mcfe Conversion Factor: Units (for Conversions): Discount Rate: Allow Circular References: Price Deck Case: Long-Term Gas Price (for Strip Pricing); Long-Term Oil Price (for Strip Pricing): Drilling Schedule: Tax Depreciation Schedule (for Development CapEx): Most Recent Quarter End Date: Valuation Date: "Remainder Date" for NAV Model: End of Year 1 Fiscal Year: Year One Production Months: Adjustment Factor for Stub Period: Tax and DD&A Assumptions: Lower Initial Tax Rate: # of Effective Years for Initial Tax Rate: Statutory Tax Rate: NOL Carryforwards ($ in 000's): Leasehold CapEx: Proved Reserves (Mmcfe): Max Reserves to be Migrated to Proved (Mmcfe): F&D Cost per Mcfe for Migrated Reserves ($ as Stated): CapEx Associated with Unproved Reserves ($ in 000's): Intangible Drilling Costs (IDC) % Development CapEx (Expensed): Tangible Costs % Development CapEx (Capitalized): Net PP&E on Balance Sheet: DTL from Tax Depreciation and D&D Costs: Effective Tax Rate: Implied Accumulated DD&A - Tax Basis: Implied Tax Basis of Net PP&E - For Use in Cash Tax Calculation: Tax Depreciation Schedules (MACRS) - Development CapEx:

Upload: ahmadadam

Post on 10-Nov-2015

224 views

Category:

Documents


2 download

DESCRIPTION

ergsdgasdgadgsadgasdgasdagawegasdgasdghsdfhsdfhasdhasdgfsdfasffqwegasdegsdgsggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggwqgqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqweeeeeeeeeee

TRANSCRIPT

Assumptions

Ultra Petroleum Corp. - Assumptions - NAV Model by Geography and Reserve Type($ in Millions Except Per Share and Per Unit Data)Model-Wide Toggles & Assumptions:Production and Well Assumptions:Company Name:Ultra Petroleum Corp.Current Share Price:$18.83Universal Assumptions:Bbl to Mcfe Conversion Factor:6LOE per Mcfe:$0.37
Author: BIWS:Per pg. 21 of Q3 10-Q. Includes both normal LOE and Lease Agreement Expense.Gas % Diff. vs. Price Deck:94.0%
Author: BIWS:Pg. 8 of 8-K - expected 5-7% difference in Q4, and it was 7% for previous quarter.Units (for Conversions):1,000Production Taxes per Mcfe:0.31
Author: BIWS:Per pg. 21 of Q3 10-Q. Yes, technically there are only production taxes in WY and UT but just simplifying this.Oil % Diff. vs. Price Deck:93.0%
Author: BIWS:$7.00 difference stated on pg. 8 of 8-K, so approximating as 7% differential w/ ~$100 oil prices.