12234567899101112131415ANet Present Value-Unequal LivesDakota Mining Company has two competing proposals: a diamond core drill or a hydraulic excavator. The following data is provided:DATA2324Year1B234456784 (residual value)161718 Initial investment19 Minimum rate of returnNet Cash FlowDiamond Core Drill Hydraulic Excavator$308,000240,000240,000253,000270,000178,0002526 Net present value27139,000125,000125,000$335,000323,000313,000312,000$790,00010%2021 REQUIRED:22 Determine which equipment should be favored, comparing the net present values of the two proposals.EUsing formulas and cell references from the problem data, perform the required analysis.Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2for grading.Diamond Core Drill Hydraulic ExcavatorFFormulas

Answered: Image /qna-images/answer/e81f47d4-aa21-4711-9a03-c405be2fa44e.jpg

Dakota Mining Company has two competing proposals: a diamond core drill or a hydraulic excavator. The following data is provid DATA Year 1 2 3 445678 4 (residual value) Initial investment Minimum rate of return Net Cash Flow Diamond Core Drill Hydraulic Excavator $308,000 240,000 240,000 253,000 270,000 178,000 139,000 125,000 125,000 $335,000 323,000 313,000 312,000 $790,000 10%

Dakota Mining Company has two competing proposals: a diamond core drill or a hydraulic excavator. The following data is provid DATA Year 1 2 3 445678 4 (residual value) Initial investment Minimum rate of return Net Cash Flow Diamond Core Drill Hydraulic Excavator $308,000 240,000 240,000 253,000 270,000 178,000 139,000 125,000 125,000 $335,000 323,000 313,000 312,000 $790,000 10%

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

company is planned to install new automated plastic molding press. Four different presses are available as follows: Press 1 Press 2 Press 3 Press 4 Capital Investment $24,000 $30,000 $49,000 $52,000 Useful Life (year) 5 5 5 5 Annual Expenses Power ($) Labor ($) Maintenance ($) Tax & Insurance ($) 2,720 26,400 1,600 480 2,720 24,000 1,800 608 4,800 16,800 2,600 992 4,800 14,800 2,000 1,040 Assume that each press has the same output capacity (120,000 units per year) and all units can be sold (the selling price is $0.375 per unit. Additional capital invested is expected to earn at least 10%. a) Sketch Cash Flow Diagram for the four choices b) Which press should be chosen (use Present Worth PW method?
Ella Ltd recently started to manufacture and sell productDG. The variable cost of product DG is £4 per unit and the totalweekly fixed costs are £18 000.The company has set the initial selling price of product DG byadding a mark up of 40 per cent to its total unit cost. It has assumedthat production and sales will be 3000 units per week.The company holds no stocks of product DG.Required:(a) Calculate for product DG:(i) the initial selling price per unit; and(ii) the resultant weekly profit. The management accountant has established that alinear relationship between the unit selling price (P in £)and the weekly demand (Q in units) for product DG isgiven by:P = 20 - 0:002QThe marginal revenue (MR in £ per unit) is related to weeklydemand (Q in units) by the equation:MR = 20 - 0:004Q(b) Calculate the selling price per unit for product DG that shouldbe set in order to maximize weekly profit. (c) Distinguish briefly between penetration and skimming pricingpolicies when launching a new…
A business invests $5000 and initially plans to achieve annual revenue of $1100/yr with $200/yr expenses (starting at the end of ar 1) for ten years. No market value if used for ten years. 1.If at the end of the sixth year, instead, the investment is sold for $1000, calculate the PW, FW and AW for a BTCF MARR of 12%. Is the investment a good one if used this way? Why?
3. The annual worth method An office supply company has purchased a light duty delivery truck for $15,000. It is anticipated that the purchase of the truck will increase the company’s revenue by $10,000 annually, whereas the associated operating expenses are expected to be $3,000 per year. The truck’s market value is expected to decrease by $2,500 each year it is in service. If the company plans to keep the truck for only 2 years, what is the annual worth of this investment? The MARR = 18% per year
Consider a project that will bring in upfront cash inflows for the first two yearsbut require paying some money to close the project in the third year. A0 A1 A2 $6500 $4500 $13000 This is a simple borrowing project. Determine the borrowing rate of return
A Company manufactures and sells one product. The product has the following cost and revenue data: Selling price Per Unit (AED) 70 Variable cost Per Unit (AED) 30 Total fixed expenses per month are as follows: Expenses types AED Advertising Rent Heating 263,069 100,000 100,000 The company produced and sold 10,000 units during the month and had no beginning or ending inventories. a. What is the break-even value in Dirhams?
A university is trying to determine how much it should charge for tickets to basketball games to help offset the expenses of the new arena. The cost to build the arena including labor, materials. e tc. was $92 million. Each year the maintenance cost is expected to increase by 5% as the building gets older. 1l1e maintenance cost for the first year is $150.000. Utilities arc expected to average about $200.000 per year and labor costs $300,000. The average attendance at basketball games over the year is expected to be J00.000 people (or 100.000 tickets sold to events). Assuming the arena has no other source of income besides regular ticket sales (not including student tickets) for basketball games, what should the university charge so that it can recover at least a 6% cost of borrowing on its investment? ll1c university expects the arena to be used for 40 years and 10 have no appreciable salvage value.
Siemens AG invests €80,000,000 to build a manufacturing plant to build wind turbines. The company predicts net cash flows of €16,000,000 per year for the next 8 years. Assume the company requires an 8% rate of return from its investments. (PV of $1. FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your present value factor to 4 decimals.) (1) What is the payback period of this investment? (2) What is the net present value of this investment? Complete this question by entering your answers in the tabs below. Required 1 Required 2 What is the payback period of this investment? Payback Period Choose Numerator: 1 1 Choose Denominator: ‒‒‒ www Next >
The following information relates to a project Year Cash flow Sh. 'Millions' (16) 1 3 4 18 16 5 O.C. O a. Optimum time is at the end of year 1 The cost of capital is 10% Advice management on the optimum time the project should be abandoned. Ob. Optimum time is at the end of year 4 Optimum time is at the end of year 3 Abandonment value Sh. 'Million' Od. Optimum time is at the end of year 2 12
PART 2 - с PROBLEM SOLVING PROBLEM NO.2 Compute the FW: $3500 market value productivity attributable to equipment për year (Opērating costs have already been deducted from the revenue) $8500 $8500 $8500 $8500 $8500 1 2 3 5 End of Year i= 25%/yr $23500 investment cost
Consider the following two mutually exclusive projects being considered by an agency. The agency's MARR is 5% per year and the projects have a service life of 5 years. Initial cost Annual revenues Present Worth (PW) Answer the following questions. Project 1 $14,200 $3,832 O A. No B. Yes $2,391 Project 2 $21,700 $5,608 $2,580 a. Based on the PW, the project that is more economical is Project b. Calculate the IRR of each alternative (use the trial-and-error method) % (Round to the nearest one decimal place) The IRR of Project 1 is The IRR of Project 2 is % (Round to the nearest one decimal place) (Enter the project number). c. Perform the incremental IRR analysis to determine the project that is more economical: Incremental IRR =% (Round to the nearest one decimal place); Therefore, based on the incremental IRR, Project is more economical. d. Do the two methods produce the same recomendation for the most economical project?
eBook Net Present Value Method—Annuity Take a Load Off Hotels is considering the construction of a new hotel for $12,000,000. The expected life of the hotel is 6 years with no residual value. The hotel is expected to earn revenues of $12,400,000 per year. Total expenses, including straight-line depreciation, are expected to be $10,000,000 per year. Take a Load Off's management has set a minimum acceptable rate of return of 12%. a. Determine the equal annual net cash flows from operating the hotel.$fill in the blank 1 b. Calculate the net present value of the new hotel, using the present value factor of an annuity of $1 table below. If required, round to the nearest dollar. If the net present value is negative, enter the amount using a minus sign. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589 5 4.212 3.791…