USING EXCEL AND PLZ SHOW ALL FORMULAS DPP NPV AND IRR
Question 3: The Muscat Electric Company ventures to a new project in the eastern part of the capital city which is a 200-kilometer, 300 kV transmission lines. The company has to choose between an Overhead Cable Transmission System and Underground Cable Transmission System. Table Q3 shows the initial investment for each type, the expected revenues during its lifetime which includes the cost savings incurred by underground transmission system over the overhead transmission system. The company has estimated a salvage value for each type of transmission to be 5% of the initial investment. As a company cost of capital is 8% per year. Using the following techniques for capital investment appraisal, perform the following: (0) Discounted payback period; (ii) Net present value NPV; (iii) Internal rate of return IRR. (iv) Determine which of the alternative is acceptable to the company based on the above results. Table Q3: Revenue & Expenses in Million OMR Overhead Underground Items Cable Transmission Cable Transmission System System Initial Investment 12,735 (million OMR) 9,184 806 1277 Annual Revenue + cost savings (million OMR) Increases by 2% per year Increases by 2% per year First 10 years: First 10 years: 187 210 Annual Operating & Maintenance O&M Cost (million OMR) Succeeding years: 3% increase per year Succeeding years: 1.5% increase per year Annual taxes (million OMR) 10% of (Annual Revenue + cost savings) 10% of (Annual Revenue + cost savings) Life expectancy, years 50 40 Question 3: The Muscat Electric Company ventures to a new project in the eastern part of the capital city which is a 200-kilometer, 300 kV transmission lines. The company has to choose between an Overhead Cable Transmission System and Underground Cable Transmission System. Table Q3 shows the initial investment for each type, the expected revenues during its lifetime which includes the cost savings incurred by underground transmission system over the overhead transmission system. The company has estimated a salvage value for each type of transmission to be 5% of the initial investment. As a company cost of capital is 8% per year. Using the following techniques for capital investment appraisal, perform the following: (0) Discounted payback period; (ii) Net present value NPV; (iii) Internal rate of return IRR. (iv) Determine which of the alternative is acceptable to the company based on the above results. Table Q3: Revenue & Expenses in Million OMR Overhead Underground Items Cable Transmission Cable Transmission System System Initial Investment 12,735 (million OMR) 9,184 806 1277 Annual Revenue + cost savings (million OMR) Increases by 2% per year Increases by 2% per year First 10 years: First 10 years: 187 210 Annual Operating & Maintenance O&M Cost (million OMR) Succeeding years: 3% increase per year Succeeding years: 1.5% increase per year Annual taxes (million OMR) 10% of (Annual Revenue + cost savings) 10% of (Annual Revenue + cost savings) Life expectancy, years 50 40
