Final Copy of Regency Petroleum Project 11-29

Final Copy of Regency Petroleum Project 11-29 - $ 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 Document Right 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 ion 315.6976 Total PW ($ in mil ions 310.282822 Price of Oil % 5.00% Internal Rate of Retu 62% Internal Rate of Retur 82% Cost of Oil % 3.00% Payback Period See further right for table Payback Period See further right for table Taxes % 25.00% BT MARR % 0.2 Payback Period ($ in M il 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 Yearolume (bar els/yr in mil ionPrice/bar el (US $Revenue/yr ($ in mil ionsCost/bar el (US $ COGS ($ in mil ions)Gross Margin ($ in mil ionExpenses/year ($ in mil ions BTCF ($ in mil ions) DepreciationTaxable Income Taxes ATCF Investments TCF (after investmen PW factor PW of cash flows BV Year PW factorBTCF with Investment PW Year BTCF w/ InvestmenSum of CF Payback YeaATCF w/ InvestmenSum of CFPayback Year Year BTCF w/ Investmen Sum of CFPayback YearATCF w/ Investment Sum of CFPayback Year Year BTCF w/ Investment Sum of CFPayback Year ATCF w/ InvestmentsSum 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.0929 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.1 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.6039 2 59.91 39.73Year 2 43.94 9.00Year 2 2 63.4841 66225 35.0172Year 2 44.1 48166225-0.61712 2 54.6257086725 41.4126Year 2 41.7454086725 15.2673 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.5481 3 64.88 104.61 47.47 56.47 3 75.5414906226 1 0.559 52.3413596101 51.7242 Year 3 3 53.3060157687 94.7186 40.6657400062 55.933 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.8842 4 70.26 174.88 51.32 107.79 4 89.8488704175 200.408 62.1332250227 1 3.857 4 52.0170425669 146.736 39.6240967426 95.5571 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.5349 5 75.98 250.86 55.39 163.18 5 106.725901671 307.133 73.6773799799 187.535 5 50.6580627578 197.394 38.5177097876 134.075 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.01 0.43 25.9447 3.382565 6 0.330....
View Full Document

{[ snackBarMessage ]}

Page1 / 10

Final Copy of Regency Petroleum Project 11-29 - $ 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