Calculate the payback period for the project

Assignment Help Financial Management

Reference no: EM131081522

The Drillago Company is involved in searching for locations in which to drill for oil. The firm's current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table. Year Cash Inflows 1 $600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6 3,500,000 7 4,000,000 8 6,000,000 9 8,000,000 10 12,000,000 The firms current cost of capital is 13% Using Excel and explain what to enter in cell (calculation) A. Calculate the project's net present value (NPV). Is the project acceptable under the NPV technique? Explain B. Calculate the project's internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain C. In this case, did the two methods produce the same results? Generally, is there a preference between the NPV and IRR techniques? Explain D. Calculate the payback period for the project. If the firm usually accepts projects that have payback periods between 1 and 7 years, is this project acceptable?

Reference no: EM131081522

Questions Cloud

Write report about national resources for your illness group : Locate a minimum of three community or national resources for your illness group(cancer) chosen in Week 1, preferably in your community. Study these resources and write a report about them in a 4- to 5-page Microsoft Word document.

Change in nonverbal or verbal actions for the clients : Did certain questions or comments create a change in nonverbal or verbal actions for the clients - What open- and closed-ended questions did the counselor use?

Systems engineering and analysis : A used automobile can be purchased by a student to provide transportation to and from university for $12,000 as-is (i.e. without warranty). First year maintenance cost is expected to be $1,200 and the maintenance costs will increase by $120 per year ..

Determine the convergence or divergence of given series : Math 104: Homework 4. Determine the convergence or divergence of each of the following series defined for n ∈ N: ∑nn3/2n, and ∑n√(n + 1) - √n

Calculate the payback period for the project : The Drillago Company is involved in searching for locations in which to drill for oil. The firm's current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project ar..

What is the break-even EBIT : Rise Against Corporation is comparing two different capital structures: an all-equity plan (Plan I) and a levered plan (Plan II). Under Plan I, the company would have 200,000 shares of stock outstanding. Under Plan II, there would be 150,000 shares o..

What will be the swap rate on agreement to exchange currency : Suppose the U.S. yield curve is flat at 5% and the euro yield curve is flat at 4%. The current exchange rate is $1.25 per euro. What will be the swap rate on an agreement to exchange currency over a 3-year period? The swap will call for the exchange ..

Invest them in shortterm safe financial instruments : Money market mutual funds take in your dollars (like deposits) and invest them in shortterm “safe” financial instruments to earn you interest. Now assume there is a rule stating that MMMF’s could cash people out at $1 if (for instance) the value of t..

What is the book value per share of common stock : A corporation has total assets of $85 million and total liabilities of $5 million. If the corporation has 4 million shares of common stock outstanding, what is the book value per share of common stock?

User Account

All Pages