Mohhamad Al Balushy the owner of Al Balushi Oil, is evaluating new oil production wells in Eastern part of Oman. Sara Al Farsi, the companys geologist, has just finished her analysis of the wells site. She has estimated that the well One would be productive for eight years, Two nine years, Three ten years. After which the oil will be fully produced. Sara has taken an estimate of the gold deposit to Zainab Al Amri, the companys financial officer. Sara asked Zainab to conduct an analysis of the new wells (One, Two and Three) and provide her recommendation on whether the company should open a new well and which project is better than others.

Zainab has used the estimates provided by Sara to determine the revenues that could be expected from the wells. She has also projected the expenses of opening the wells and the annual operating expenses. If the company opens well, it will have certain large expenses for the purchase and installation of equipment, and at the end of the project the company will incur some expenses associated with the liquidation of the wells. The expected cash flows each year from the well for project Well One, Well Two and Well Three are shown in the tables.

1. Calculate the payback period, modified internal rate of return (3 methods), net present value, profitability index of proposed projects. Determine which project is better and explain why.

3. If the company finds financial resources for the development of two wells, which two projects would you recommend. Provided that the required rate of return is reduced by 2%.

Question 1 1 0.12 0.12 2 CF Year CF Year Year 0 0 1 1 2 3 2 3 4 1 -505000 60000 90000 170000 230000 201000 140000 110000 75000 -800001 3 ICE 0 -655000 1 70000 2 90000 3 170000 4 230000 5 225000 6 6 140000 7 110000 8 15000 9 90000 10 80000 11 -70000 5 -555000 70000 90000 170000 230000 205000 140000 110000 175000 50000 -80000 S 6 6 7 7 8 8 9 9 10