Final Final Regency Petroleum Project 11-29-11_MS-1

Final Final Regency Petroleum Project 11-29-11_MS-1 - $ in...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $ in millions Index Year Calendar Year Net Working Capital BTCF Net Gain on the Vehicle ($ in mil) Taxes Owed ATCF 2012 64.89 1 0.8 0.2 65.69 Regency Protoleum Company Option 2: Build and Operate New Facility After Taxes Before Taxes (Including Investments) Sales Volume Increase % 5.00% Total PW ($ in mil ions 315.6976 Total PW ($ in mil ions) 310.2828216 Price of Oil % 5.00% Internal Rate of Return 62% Internal Rate of Return 82% Cost of Oil % 3.00% Payback Period (years 2 Payback Period See further right for table Taxes % 25.00% BT MARR % 0.2 Payback Period ($ in Mil ions) AT MARR % 15.00% Operatinig Expense % 1.50% 0% Change Cost of Oil Change of +10% Cost of Oil Change of -10% Berfore Tax After Tax Berfore Tax After Tax Berfore Tax After Tax Index Year Calendar YearVolume (bar els/yr in mil ion Price/bar el (US $)Revenue/yr ($ in mil ions Cost/bar el (US $) COGS ($ in mil ions)Gross Margin ($ in mil ionsExpenses/year ($ in mil ions BTCF ($ in mil ions) Depreciation Taxable Income Taxes ATCF Investments TCF (after investment PW factor PW of cash flows BV Year PW factorBTCF with Investment PW Year BTCF w/ Investment Sum of CF Payback Yea ATCF w/ InvestmentsSum of CFPayback Year Year BTCF w/ InvestmentsSum of CFPayback Year ATCF w/ Investments Sum of CFPayback Year Year BTCF w/ Investments Sum of CFPayback Year ATCF w/ Investments Sum of CFPayback Year 2012 0.00 84.00 0.00 80 0.00 0.00 0.60-0.60-0.60-0.15-0.45 74.89-75.34 1.00-75.3400 10.45 1.00-75.49-75.49-75.49-75.49-75.34-75.34-81.79-81.79-81.64-81.64-69.19-69.19-69.04-69.04 1 2013 15.00 86.52 1297.80 82.40 1236.00 61.80 1.10 60.70 1.04 59.66 14.92 45.79 5.388535 40.40 0.87 35.1274 9.485 1 0.83 55.31 46.09289 1 55.31-20.18 40.40-34.94 1 53.323065-28.4669 36.908065-44.7319 1 55.976865-13.2131 42.561865-26.4781 2 2014 15.75 89.12 1403.57 84.87 1336.73 66.84 1.11 65.73 1.86 63.87 15.97 49.76 5.8195506025 43.94 0.76 33.2267 7.68 2 0.69 59.91 41.60392 2 59.91 39.73 Year 2 43.94 9.00 Year 2 2 63.4841166225 35.01718 Year 2 44.1148166225-0.61712 2 54.6257086725 41.41257 Year 2 41.7454086725 15.26727 Year 2 3 2015 16.54 91.79 1517.96 87.42 1445.68 72.28 1.12 71.17 1.532 69.64 17.41 53.76 6.2856939766 47.47 0.66 31.2149 6.212 3 0.58 64.88 37.54808 3 64.88 104.61 47.47 56.47 3 75.5414906226 110.5587 52.3413596101 51.72424 Year 3 3 53.3060157687 94.71859 40.6657400062 55.93301 4 2016 17.36 94.54 1641.68 90.04 1563.50 78.18 1.12 77.05 1.2632 75.79 18.95 58.10 6.7898280357 51.32 0.57 29.3396 5.02 4 0.48 70.26 33.88424 4 70.26 174.88 51.32 107.79 4 89.8488704175 200.4075 62.1332250227 113.8575 4 52.0170425669 146.7356 39.6240967426 95.55711 5 2017 18.23 97.38 1775.47 92.74 1690.93 84.55 1.13 83.42 1.04472 82.37 20.59 62.82 7.4350490206 55.39 0.50 27.5375 4.15223 5 0.40 75.98 30.53488 5 75.98 250.86 55.39 163.18 5 106.725901671 307.1334 73.6773799799 187.5348 5 50.6580627578 197.3937 38.5177097876 134.0748 6 2018 19.14 100.30 1920.17 95.52 1828.74 91.44 1.14 90.30 0.85124 89.45 22.36 67.94 7.9247055158 60.0160....
View Full Document

This note was uploaded on 12/05/2011 for the course IME 314 taught by Professor Franchi during the Fall '08 term at Cal Poly.

Page1 / 10

Final Final Regency Petroleum Project 11-29-11_MS-1 - $ in...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online