Net Present Value-Unequal LivesDakota Mining Company has two competing proposals: a diamond core drill or a hydraulic excavator. Both pieces of equipmenthave an initial investment of $710,000. The net cash flows estimated for the two proposals are as follows:Net Cash FlowYearDiamond Core DrillNet Cash FlowHydraulic Excavator1$308,0002260,000$347,000315,0003260,000313,0004268,000318,0005177,0006142,0007139,0008139,000The estimated residual value of the diamond core drill at the end of Year 4 is $290,000.This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, andinput your answers in the questions below.Open spreadsheetDetermine which equipment should be favored, comparing the net present values of the two proposals and assuming aminimum rate of return of 6%. If required, round to the nearest dollar.Diamond Core DrillHydraulic ExcavatorNet present valueWhich project should be favored?Diamond Core DrillFeedbackCheck My WorkFor each proposal, multiply the present value factor for each year (Exhibit 2) by that year's net cash flow. Use the residual value of theProcessing Mill to equate the useful lives (Exhibit 2). Subtract the amount to be invested from the total present value of the net cashflow.

Net present value refers to the method of capital budgeting used for evaluating the viability of the…

Answered: Dakota Mining Company has two competing…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

4.
Net Present Value-Unequal Lives Dakota Mining Company has two competing proposals: a diamond core drill or a hydraulic excavator. Both pieces of equipment have an initial investment of $710,000. The net cash flows estimated for the two proposals are as follows: Year Net Cash Flow Diamond Core Drill Net Cash Flow Hydraulic Excavator 1 $317,000 $341,000 23 4569 7 8 256,000 317,000 256,000 312,000 257,000 319,000 170,000 138,000 147,000 147,000 The estimated residual value of the diamond core drill at the end of Year 4 is $280,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Determine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 12%. If required, round to the nearest dollar. Diamond Core Drill Net present value 592,850 X $ tA Hydraulic Excavator 271,980 V
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 firm’s current cost of capital is 13%. TO DO Create a spreadsheet to answer the following: Calculate the project’s net present value (NPV). Is the project acceptable under the NPV technique? Explain. \ Calculate the project’s internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain. 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…
The investment committee of Sentry Insurance Co. is evaluating two projects, office expansion and upgrade to computer servers. The projects have different useful lives, but each requires an investment of $1,104,000. The estimated net cash flows from each project are as follows: Net Cash Flow Year OfficeExpansion Server 1 $308,000 $407,000 2 308,000 407,000 3 308,000 407,000 4 308,000 407,000 5 308,000 6 308,000 The committee has selected a rate of 15% for purposes of net present value analysis. It also estimates that the residual value at the end of each project's useful life is $0, but at the end of the fourth year, the office expansion's residual value would be $385,000. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5…
Read the question carefully and give me right solution according to the question.
Windhoek Mines, Limited, of Namibia, is contemplating the purchase of equipment to exploit a mineral deposit on land to which the company has mineral rights. An engineering and cost analysis has been made, and it is expected that the following cash flows wou be associated with opening and operating a mine in the area: Cost of new equipment and timbers Working capital required Annual net cash receipts Cost to construct new roads in three years Salvage value of equipment in four years "Receipts from sales of ore, less out-of-pocket costs for salaries, utilities, insurance, and so forth. The mineral deposit would be exhausted after four years of mining. At that point, the working capital would be released for reinvestment elsewhere. The company's required rate of return is 18% Click here to view Exhibit 128-1 and Exhibit 12B-2. to determine the appropriate discount factor(s) using tables. Required: a. What is the net present value of the proposed mining project? b. Should the project be…
The net present value is incorrect I need help with this one.
Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. Both pieces of equipment have an initial investment of $665,159. The net cash flows estimated for the two proposals are as follows: Net Cash Flow Year Processing Mill Electric Shovel 1 $203,000 $254,000 2 181,000 235,000 3 181,000 217,000 4 144,000 223,000 5 110,000 6 91,000 7 79,000 8 79,000 The estimated residual value of the processing mill at the end of Year 4 is $250,000. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558…
of equipment have an initial investment of $728,831. The net cash flows estimated for the two proposals are as follows: Net Cash Flow Net Cash Flow Year Diamond Core Drill Hydraulic Excavator 1 $233,000 $291,000 23 4569 207,000 270,000 207,000 249,000 165,000 256,000 126,000 7 8 105,000 91,000 91,000 The estimated residual value of the diamond core drill at the end of Year 4 is $290,000. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 -0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 7 45 65 0.792 0.683 0.636 0.572 0.482 0.747 0.621 0.567 0.497 0.402 0.705 0.564 0.507 0.432 0.335 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Determine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 12%. Use the present value table appearing above. Diamond Core Drill Hydraulic…
Roberts Company is considering an investment in equipment that is capable of producing moreefficiently than the current technology. The outlay required is $2,293,200. The equipment isexpected to last five years and will have no salvage value. The expected cash flows associatedwith the project are as follows: Year Cash Revenues Cash Expenses 1 $2,981,160 $2,293,200 2 2,981,160 2,293,200 3 2,981,160 2,293,200 4 2,981,160 2,293,200 5 2,981,160 2,293,200 Required:1. Compute the project’s payback period.2. Compute the project’s accounting rate of return.3. Compute the project’s net present value, assuming a required rate of return of 10 percent.4. Compute the project’s internal rate of return.
Pitt Company is considering two alternative investments. The company requires a 12% return from its investments. Neither option has a salvage value. Project X Project Y Initial investment $244,049 $180,396 Net cash flows anticipated: Year 1 83,000 35,000 Year 2 59,000 56,000 Year 3 91,000 71,000 Year 4 82,000 68,000 Year 5 77,000 27,000 A. Compute the IRR for both projects using the IRR spreadsheet function. Project X fill in the blank 1% Project Y fill in the blank 2% B. Which project should be recommended.
Pitt Company is considering two alternative investments. The company requires a 12% return from its investments. Neither option has a salvage value. Project X Project Y Initial investment $254,976 $176,440 Net cash flows anticipated: Year 1 82,000 36,000 Year 2 60,000 56,000 Year 3 91,000 72,000 Year 4 81,000 67,000 Year 5 77,000 26,000 A. Compute the IRR for both projects using the IRR spreadsheet function. Project X fill in the blank 1% Project Y fill in the blank 2% B. Which project should be recommended. Project X

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS