Required information PEMEX, Mexico's petroleum corporation, has an estimated budget for oil and gas exploration that includes equipment for three offshore platforms as shown. Use PW analysis to select the best alternative at a MARR of 11% per year. Platform First cost, $ million M & O, $ million per year Salvage value, $ million Estimated life, years million. X -300 -320 75 20 Select platform X, Y, or Z using single-cell spreadsheet functions. The spreadsheet function to find the present worth of platform X is [(Click to select) million. Y -450 -290 50 20 Z -510 -230 90 20 The spreadsheet function to find the present worth of platform Y is [(Click to select) $- million. The spreadsheet function to find the present worth of platform Z is [(Click to select) $- The platform selected based on the present worth is [(Click to select) and the present worth of platform X is and the present worth of platform Y is and the present worth of platform Z is

Required information PEMEX, Mexico's petroleum corporation, has an estimated budget for oil and gas exploration that includes equipment for three offshore platforms as shown. Use PW analysis to select the best alternative at a MARR of 11% per year. Platform First cost, $ million M & O, $ million per year Salvage value, $ million Estimated life, years million. X -300 -320 75 20 Select platform X, Y, or Z using single-cell spreadsheet functions. The spreadsheet function to find the present worth of platform X is [(Click to select) million. Y -450 -290 50 20 Z -510 -230 90 20 The spreadsheet function to find the present worth of platform Y is [(Click to select) $- million. The spreadsheet function to find the present worth of platform Z is [(Click to select) $- The platform selected based on the present worth is [(Click to select) and the present worth of platform X is and the present worth of platform Y is and the present worth of platform Z is

Name: Required informationPEMEX, Mexico's petroleum corporation, has an est
Uploaded: 2024-03-20T06:50:59.000Z
Channel: Bartleby
Description: Required informationPEMEX, Mexico's petroleum corporation, has an estimated budget for oil and gas exploration that includes equipment forthree offshore platforms as shown. Use PW analysis to select the best alternative at a MARR 11% per year.Platfo

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter10: The Basics Of Capital Budgeting: Evaluating Cash Flows

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Coffer Company is analyzing two potential investments. Cost of machine Project X $ 97,090 Net cash flow: Year 1 Year 2 Year 3 Year 4 Project Y $ 72,000 36,500 3,700 36,500 33,500 36,500 33,500 0 13,000 If the company is using the payback period method, and it requires a payback period of three years or less, which project(s) should be selected? Multiple Choice ○ Project Y. ○ Project X. Both X and Y are acceptable projects. Neither X nor Y is an acceptable project. Project Y because it has a lower Initial Investment.
Coffer Company is analyzing two potential investments. Project X Cost of machine Net cash flow: Year 1 Year 2 $ 85,470 Project Y $ 65,000 33,000 33,000 3,000 30,000 Year 3 Year 4 33,000 0 • 30,000 25,000 If the company is using the payback period méthod, and it requires a payback period of three years or less, which project(s) should be selected? Multiple Choice Project Y. Project X. Both X and Y are acceptable projects. Neither X nor Y is an acceptable project.
Chevron Corporation has a capital and exploratory budget for oil and gas production of $19.6 billion in one year. The Upstream Division has a project in Angola for which three offshore platform equipment alternatives are identiﬁed. Use the present worth method to select the best alternative at 12% per year. A B C initial cost -200 -350 -475 annual operating cost -450 -275 -400 ‘Salvage Value’ 75 50 90 life time 20 20 20 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
X construction is considering two projects to develop. The estimated net cash flow from each project is as follows:YearProject X ($)Project Y ($)1110,00075,000265,000150,0003100,00060,0004115,00055,000535,00060,000Total425,000400,000Each project requires an investment of $ 200,000. The cost of capital is 10%.Require toa) Calculate Net Present Value, Payback period, ARR and Profitability Index.b) Which Project is to be recommended to develop based on NPV, Profitability Index, Payback period and ARR? Suggest
The Ulmer Uranium Company is deciding whether or not to open a strip mine whose net cost is $4.4 million. Net cash inflows are expected to be $27.7 million, all coming at the end of Year 1. The land must be returned to its natural state at a cost of $25 million, payable at the end of Year 2. Plot the project’s NPV profile. Should the project be accepted if r = 8%? If r = 14%? Explain your reasoning. Can you think of some other capital budgeting situations in which negative cash flows during or at the end of the project’s life might lead to multiple IRRs? What is the project’s MIRR at r = 8%? At r = 14%? Does the MIRR method lead to the same accept-reject decision as the NPV method?
Required information [The following information applies to the questions displayed below.] Project Y requires a $331,500 investment for new machinery with a five-year life and no salvage value. The project yields the following annual results. Cash flows occur evenly within each year. (PV of $1. EV of $1. PVA of $1. and FVA of $1) Note: Use appropriate factor(s) from the tables provided. Annual Amounts Sales of new product Expenses Project Y Materials, labor, and overhead (except depreciation) Depreciation-Machinery Selling, general, and administrative expenses Income 3. Compute Project Y's accounting rate of return. Numerator: Accounting Rate of Return Denominator: Project Y $ 400,000 179,200 66,300 29,000 $ 125,500 Accounting Rate of Return
a) Use Repeatability Assumption to compare between three alternatives X, Y and Z at (MARR=18% per year). Project Investment cost Production rate per year 20,000 Price per unit Annual expenses Salvage value Useful life (years) A В C $90,000 $50,000 $35,000 24,000 18,000 $6 $2.8 $4 $6,000 $5,000 $4,000 $10,000 $18,000 3
7 independent project proposals from various departments of an enterprise has come. The budget allocated by the management for these projects is 600,000 TL. Current value identify the appropriate projects using the method. (I = 20% will be accepted and the first take p=0.2 for trial. ) Scrap Value (Thousand (Thousand TL) Cost Annual Smooth Useful Project TL) earnings (thousand TL) lifetime (year) 1 200 60 10 100 35 10 3 100 30 10 4 150 46 8. 250 75 10 10 6. 100 45 7 50 19 8.
Porter Company is analyzing two potential Investments. Project X $ 75,900 Initial investment Net cash flow: Year 1 Year 2 Year 3 Year 4 Multiple Choice O If the company is using the payback period method, and it requires a payback of three years or ess, which project(s) should be selected? Project Y. 26,000 26,000 26,000 0 Project X. Project Y $ 64,000 Both X and Y are acceptable projects. 4,400 28,000 28,000 20,000 Neither X nor Y is an acceptable project. Project Y because it has a lower Initial Investment.
Tiberius Manufacturing is considering two alternative investment proposals with the following data: Proposal X Investment $10,800,000 Useful life. Estimated annual net cash inflows for 5 years 5 years $2,160,000 Residual value $60,000 Depreciation method Straight-line Required rate of return 14% Calculate the accounting rate of return for Proposal Y. (Round any intermediate calculations and your final answer to two decimal places.) OA. 13.90% OB. 11.56% OC. 17.83% OD. 7.58% Proposal Y $440,000 5 years $99,000 $35,000 Straight-line 13%
In this assignment you will need to perform an analysis on a hypothetical discovery based on the following information: Field Size 1.4 Tcf Production/Reserve Ratio 7% of the original field size starting producing year 3 Gas Price $3.5/Mcf CapEx $1/Mcf capitalized in 5 years, straight-line depreciation Operating Cost $0.8/Mcf Royalty 10% Government Take 40% Cost recovery limit 60% of gross revenue Discount Rate 10% Income Tax Rate 33% Allow cost recovery carry forward 1. Evaluate the discovery – you need to calculate the total worth, worth to the company, government take, value in terms of entitlement interest and working interest. 2. Evaluate the producing gas reserve – total worth, worth to the company, government take, value in terms of entitlement interest and working interest.
U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Capital investment Annual net income: Year 1 2 3 4 Total Project Bono $163,200 14,280 14,280 14,280 14,280 14,280 $71,400 Project Edge Project Clayton $178,500 $204,000 18,360 17,340 16,320 12,240 9,180 $73,440 27,540 23,460 21,420 13,260 12,240 $97,920 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash Flows occur evenly throughout the year.)