10.8 PetroGen Oil Field and Petroleum Refinery A $2.3 billion oil-field project, called PetroGen, is planned in Angola. The project consists of wells in the Atlantic Ocean, a pipeline to the coast, and a coastal re- finery. The project will require capital investment of $400 million in the first year, $800 million in the second year, and $600 million in the third year. The project production and refining are estimated to be sto per barrel The project is funded by a consortium of oil producers through a bond issue of $1.450 million with a coupon rate of 10% pa. The bonds are amortized (that is. repaid) over fourteen years. The equity contribution of the oil producers is 37% of the total requirement. The total requirement exceeds the fixed capital due to working capital requirements and the debt service reserve account. The debt service reserve is required by the bondholders to ensure that interest and principal payments can be met. In this case, it is equal to six months of the principal and interest that is required for the servicing the bonds 10.8.7 Project Financials The project financials, expenses, taxes, capital investment are prepared on the en- tity basis from its five components: revenue, expenses, tax, capital investment and change in working capital. The project financials for the expected life of 20 years is shown in Table 10.38 The revenue is calculated based on a price of $21 per barrel, and the costs are assumed to s9 per barrel. The fixed capital is depreciated over 15 years on a straight- line basis. Tax is charged as 35% of the operating income less depreciation. The 10 Table 10.38 Project financials for the Patron spportunity Year Revenue Operating Depreciation Tax Imetent Working Change in Free cash capital working low capital 0 400 1 - 400 27 -NOO 2 M -800 600 270 -870 3 1.OSO 450 120 278 -8 424 1.ON 464 122 174 286 8 435 5 477 181 295 147 1.147 492 187 304 -9 459 7 HIN 506 120 1944 313 -9 8 1.217 522 120 201 322 472 - 485 9 1.254 537 120 209 332 10 10 IN 553 120 216 -10 347 11 1.30 370 120 224 512 352 -10 1.370 587 120 202 526 163 --11 13 120 200 5d0 314 -11 1.453 120 249 555 385 15 1.407 120 257 -11 571 397 -12 16 1.542 661 93 276 S6 409 17 1.5 68 40 304 421 -12 18 1.636 701 0 327 592 19 722 0 337 4-46 595 11935 744 0 147 613 400 1.101 993 working capital is assumed to be 15% of the fixed capital. The free cash flow is the given by the expression: Free Cash Flow = Revenue - Expenses - Tax- Fixed Capital - A(Working Capital) (10.6) where A(Working Capital) is the change in working capital. In the last year of the project all the working capital is recovered. All prices and costs are assumed to rise with inflation at a rate of 3% pa. 10.8.2 Assessment The NPV of this opportunity is $1.609 billion at a discount rate of 10%, and the IRR is 19.3%. The project is a good investment. 10.8.3 Financing of the Project The project is financed through non-recourse finance, a topic that is discussed in further detail in Chapter 17. Non-recourse finance, also known as project finance, is a method of isolating the project risks so that the usage of debt is maximized. The debt is raised through the issue of 10% bonds with a maturity of 14 years. The principal repayment and the interest charged are given in Table 10.39. The schedule of repayment of the principal is defined by the conditions for the issue of the bonds. Interest is charged at 10% on the outstanding amount. In addition, the lenders require that six months of debt service be deposited in a debt service account. The calculation of the amounts in the debt service account and the amount required to fulfil this obligation are also shown in Table 10.39. The returns to the equity parties are given in Table 10.40. It is worthwile exam- ining the obligations of and the returns to the equity parties on their own. The operating income is the difference between the revenues and costs, and the change in working capital is as calculated before. The taxation paid is calculated from the following expression: Tar = Tax Rate(Revenue - Costs - Depreciation - Interest) (10.7) This means that the returns to the equity parties are not calculated on the entity basis, which is the basis for the project financials. The equity contribution to the investment activities is the balance of the $2.3 billion required for the project that is not contributed by debt. The interest and principal repayments and the debt service account requirements are the same as those in Table 10.39. Thus the net cash flow to the equity parties is given by the expression: Thble 10.39 Debt service -85 -84 Year Outstanding Interest Principal Debt Debt Funding to debi loan repayment service service service account account 0 1 800 80) 0 -720 2 1.450 145 0 --505 3 1.450 145 25 170 4 -85.00 1,425 143 25 168 1.25 5 1,400 140 50 190 -95 - 11.25 6 1.350 135 50 185 -93 2.50 7 1.300 130 75 205 - 103 8 -10.00 1,225 123 75 198 -99 3.75 9 1.150 115 100 215 108 10 -8.75 1.050 105 100 205 11 - 103 5.00 950 95 125 220 12 -110 - 7.50 825 83 125 208 13 -104 6.25 700 70 150 220 -110 14 -6.25 350 55 150 205 -- 103 IS 7.50 400 40 200 240 -120 16 --17.50 200 20 200 220 -110 17 0 10.00 0 0 0 0 18 110,00 0 0 0 0 19 0 0.00 0 0 0 0 0 20 0.00 0 0 0 0 0 0.00 Table 10.40 Returns to cquity parties Year Operating Increase in Taxation income working paid capital 0 1 2 3 1 5 6 7 315 0 0 0 60X0 618 637 656 675 696 716 738 760 783 806 831 855 881 908 935 963 992 10 11 12 13 14 15 16 17 18 19 20 Equity Interest Principal increase in Net cash investment paid repayments debt flow to service equity account 400 0 0 0 -400 230 80 0 0 -310 220 145 0 0 -635 0 145 2s 85 220 0 143 25 319 0 140 50 11 295 0 135 50 3 324 0 130 75 10 302 0 123 75 334 0 115 100 9 0 IOS 100 -5 348 0 95 125 8 0 83 125 -6 368 0 70 150 6 353 0 55 150 -8 392 0 40 18 343 0 20 200 -10 390 0 0 0 -110 702 0 0 0 0 595 0 0 0 0 613 0 0 0 0 1.104 0 0 270 8 8 9 9 9 9 10 10 10 11 11 11 12 12 12 13 13 460 0 0 0 117 124 132 140 149 159 169 180 191 203 216 229 243 269 304 327 337 347 200 Net Cash Flow to Equity Parties = Operating Income Tax - A(Working Capital) - Interest (10.8) - Principal Payments - Debt Service Account - Capital Investment The NPV of the equity cash flows should be discounted at the cost of equity. The weighted average cost of capital, WACC is given by Equations 8.17 and 8.18. The rearrangement of these two equations results in the following expression: E D WACC = RE+ RDB(1-7) (10.9) E+D E+D WACC is the discount rate and is equal to 10%. The equity contribution is 37% and the debt contribution is 63%. The debt carries interest of 10%, so that Ront, the cost of debt before tax, is equal to 10%. The tax rate is 35%. The substitution of these values in Equation 10.9 yields the following expression for the cost of equity. Re: 0.1 = (0.37) RE+ (0.63)0.1(1 -0.35) Rg = 15.95% The NPV of the cash flows to the equity parties is $696 million and the IRR is 27%. This suggests that this is a good project for the equity investors. 334 10 Case Studies on the Application of the Decision-making Criteria 10.10.7 Petroleum Field and Refinery 1. Create a spreadsheet application that replicates the project financials in Table 10.38. Determine the sensitivity of the NPV nd IRR of the project to the fol- lowing inputs: The oil price The costs of production (11) The inflation price (iv) The tax rate The discount rate (vi) The initial capital investment Draw a tornado diagram of the sensitivities. 2. The capital cost estimate is within 30%. How does this affect the sensitivity assessment? 3. Why would lenders require the debt service account? 4. Explain the change in working capital in year 20. 5. Explain the difference between the free cash flow and the net cash flow to equity partners. 2. 10.8 PetroGen Oil Field and Petroleum Refinery A $2.3 billion oil-field project, called PetroGen, is planned in Angola. The project consists of wells in the Atlantic Ocean, a pipeline to the coast, and a coastal re- finery. The project will require capital investment of $400 million in the first year, $800 million in the second year, and $600 million in the third year. The project production and refining are estimated to be sto per barrel The project is funded by a consortium of oil producers through a bond issue of $1.450 million with a coupon rate of 10% pa. The bonds are amortized (that is. repaid) over fourteen years. The equity contribution of the oil producers is 37% of the total requirement. The total requirement exceeds the fixed capital due to working capital requirements and the debt service reserve account. The debt service reserve is required by the bondholders to ensure that interest and principal payments can be met. In this case, it is equal to six months of the principal and interest that is required for the servicing the bonds 10.8.7 Project Financials The project financials, expenses, taxes, capital investment are prepared on the en- tity basis from its five components: revenue, expenses, tax, capital investment and change in working capital. The project financials for the expected life of 20 years is shown in Table 10.38 The revenue is calculated based on a price of $21 per barrel, and the costs are assumed to s9 per barrel. The fixed capital is depreciated over 15 years on a straight- line basis. Tax is charged as 35% of the operating income less depreciation. The 10 Table 10.38 Project financials for the Patron spportunity Year Revenue Operating Depreciation Tax Imetent Working Change in Free cash capital working low capital 0 400 1 - 400 27 -NOO 2 M -800 600 270 -870 3 1.OSO 450 120 278 -8 424 1.ON 464 122 174 286 8 435 5 477 181 295 147 1.147 492 187 304 -9 459 7 HIN 506 120 1944 313 -9 8 1.217 522 120 201 322 472 - 485 9 1.254 537 120 209 332 10 10 IN 553 120 216 -10 347 11 1.30 370 120 224 512 352 -10 1.370 587 120 202 526 163 --11 13 120 200 5d0 314 -11 1.453 120 249 555 385 15 1.407 120 257 -11 571 397 -12 16 1.542 661 93 276 S6 409 17 1.5 68 40 304 421 -12 18 1.636 701 0 327 592 19 722 0 337 4-46 595 11935 744 0 147 613 400 1.101 993 working capital is assumed to be 15% of the fixed capital. The free cash flow is the given by the expression: Free Cash Flow = Revenue - Expenses - Tax- Fixed Capital - A(Working Capital) (10.6) where A(Working Capital) is the change in working capital. In the last year of the project all the working capital is recovered. All prices and costs are assumed to rise with inflation at a rate of 3% pa. 10.8.2 Assessment The NPV of this opportunity is $1.609 billion at a discount rate of 10%, and the IRR is 19.3%. The project is a good investment. 10.8.3 Financing of the Project The project is financed through non-recourse finance, a topic that is discussed in further detail in Chapter 17. Non-recourse finance, also known as project finance, is a method of isolating the project risks so that the usage of debt is maximized. The debt is raised through the issue of 10% bonds with a maturity of 14 years. The principal repayment and the interest charged are given in Table 10.39. The schedule of repayment of the principal is defined by the conditions for the issue of the bonds. Interest is charged at 10% on the outstanding amount. In addition, the lenders require that six months of debt service be deposited in a debt service account. The calculation of the amounts in the debt service account and the amount required to fulfil this obligation are also shown in Table 10.39. The returns to the equity parties are given in Table 10.40. It is worthwile exam- ining the obligations of and the returns to the equity parties on their own. The operating income is the difference between the revenues and costs, and the change in working capital is as calculated before. The taxation paid is calculated from the following expression: Tar = Tax Rate(Revenue - Costs - Depreciation - Interest) (10.7) This means that the returns to the equity parties are not calculated on the entity basis, which is the basis for the project financials. The equity contribution to the investment activities is the balance of the $2.3 billion required for the project that is not contributed by debt. The interest and principal repayments and the debt service account requirements are the same as those in Table 10.39. Thus the net cash flow to the equity parties is given by the expression: Thble 10.39 Debt service -85 -84 Year Outstanding Interest Principal Debt Debt Funding to debi loan repayment service service service account account 0 1 800 80) 0 -720 2 1.450 145 0 --505 3 1.450 145 25 170 4 -85.00 1,425 143 25 168 1.25 5 1,400 140 50 190 -95 - 11.25 6 1.350 135 50 185 -93 2.50 7 1.300 130 75 205 - 103 8 -10.00 1,225 123 75 198 -99 3.75 9 1.150 115 100 215 108 10 -8.75 1.050 105 100 205 11 - 103 5.00 950 95 125 220 12 -110 - 7.50 825 83 125 208 13 -104 6.25 700 70 150 220 -110 14 -6.25 350 55 150 205 -- 103 IS 7.50 400 40 200 240 -120 16 --17.50 200 20 200 220 -110 17 0 10.00 0 0 0 0 18 110,00 0 0 0 0 19 0 0.00 0 0 0 0 0 20 0.00 0 0 0 0 0 0.00 Table 10.40 Returns to cquity parties Year Operating Increase in Taxation income working paid capital 0 1 2 3 1 5 6 7 315 0 0 0 60X0 618 637 656 675 696 716 738 760 783 806 831 855 881 908 935 963 992 10 11 12 13 14 15 16 17 18 19 20 Equity Interest Principal increase in Net cash investment paid repayments debt flow to service equity account 400 0 0 0 -400 230 80 0 0 -310 220 145 0 0 -635 0 145 2s 85 220 0 143 25 319 0 140 50 11 295 0 135 50 3 324 0 130 75 10 302 0 123 75 334 0 115 100 9 0 IOS 100 -5 348 0 95 125 8 0 83 125 -6 368 0 70 150 6 353 0 55 150 -8 392 0 40 18 343 0 20 200 -10 390 0 0 0 -110 702 0 0 0 0 595 0 0 0 0 613 0 0 0 0 1.104 0 0 270 8 8 9 9 9 9 10 10 10 11 11 11 12 12 12 13 13 460 0 0 0 117 124 132 140 149 159 169 180 191 203 216 229 243 269 304 327 337 347 200 Net Cash Flow to Equity Parties = Operating Income Tax - A(Working Capital) - Interest (10.8) - Principal Payments - Debt Service Account - Capital Investment The NPV of the equity cash flows should be discounted at the cost of equity. The weighted average cost of capital, WACC is given by Equations 8.17 and 8.18. The rearrangement of these two equations results in the following expression: E D WACC = RE+ RDB(1-7) (10.9) E+D E+D WACC is the discount rate and is equal to 10%. The equity contribution is 37% and the debt contribution is 63%. The debt carries interest of 10%, so that Ront, the cost of debt before tax, is equal to 10%. The tax rate is 35%. The substitution of these values in Equation 10.9 yields the following expression for the cost of equity. Re: 0.1 = (0.37) RE+ (0.63)0.1(1 -0.35) Rg = 15.95% The NPV of the cash flows to the equity parties is $696 million and the IRR is 27%. This suggests that this is a good project for the equity investors. 334 10 Case Studies on the Application of the Decision-making Criteria 10.10.7 Petroleum Field and Refinery 1. Create a spreadsheet application that replicates the project financials in Table 10.38. Determine the sensitivity of the NPV nd IRR of the project to the fol- lowing inputs: The oil price The costs of production (11) The inflation price (iv) The tax rate The discount rate (vi) The initial capital investment Draw a tornado diagram of the sensitivities. 2. The capital cost estimate is within 30%. How does this affect the sensitivity assessment? 3. Why would lenders require the debt service account? 4. Explain the change in working capital in year 20. 5. Explain the difference between the free cash flow and the net cash flow to equity partners. 2