Please answer using excel showing equations. Problem 1- 10 pointsCompany A plans to replace with one of their current equipment with one of the three options shown inthe table.OptionInitial CostAnnual Operation CostSalvage ValueEstimated Life in YearPerform AW analysis to figure out which option should company A choose. The rate of return is 8% perAB200350475450275300756080202020year compounded Monthly.

The image below contains the formula behind the cells:

Company A plans to replace with one of their current equipment with one of the three options shown in the table. Option A В Initial Cost 200 350 475 Annual Operation Cost 450 Salvage Value 275 300 75 60 80 Estimated Life in Year 20 20 20 Perform AW analysis to figure out which option should company A choose. The rate of return is 8% per year compounded Monthly.

Company A plans to replace with one of their current equipment with one of the three options shown in the table. Option A В Initial Cost 200 350 475 Annual Operation Cost 450 Salvage Value 275 300 75 60 80 Estimated Life in Year 20 20 20 Perform AW analysis to figure out which option should company A choose. The rate of return is 8% per year compounded Monthly.

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

A firm is considering which of twodevices to install to reduce costs. Both devices have useful lives of 5 years and no salvage value. Device A costs $10,000 and can be expected to result in $3000 savings annually. Device B costs $13,500 and will provide cost savings of $3000 the first year but will increase $500 annually, making the second-year savings $3500, the third-year savings $4000, and so forth. For a 7% MARR, which device should the firm purchase?
Jean believes the batteries can be expected to last only for the guarantee period. She does not want to invest extra money in a battery unless she can expect a 40% rate of return. If she plans to keep her present car another 2 years, which battery should she buy? Two investment opportunities are as follows: A B First cost $200 $100 Uniform annual benefit 25 20 End-of-useful-life salvage value 45 Useful life, in years 15 10 At the end of 10 years, Alt. B is not replaced. Thus, the comparison is 15 years of A versus 10 years of B. If the MARR is 8%, which alternative should be selected?
Select the cost of the best alternative. MARR-10% per year. Use 2 decimal places after dot for the values you take from interest rate table. Initial Cost, $ Annual Cost, $/year Annual Revenue, $/year. Deposit Return, $ n, years. Select one: a. 40047 b. 39986 c. 35691 d. 41986 e. 42047 -27000 -9000 3200 5000 4 B -30000 -7000 1900 9000 4
A generator costs P 85,141 if paid in cash. On installment plan, a buyer should pay P 30,001 downpayment and 10 semi-annual installments, the 1st installment payment is due at the end of the 1st year after purchase. If the interest is 19 cpd. semi-annually, find the semi-annual payment.
A firm expects to install smog control equipment on the exhaust of a gasoline engine. The local smog control district has agreed to pay to the firm a lump sum of money to provide for the first cost of the equipment and maintenance during its 10-year useful life. At the end of 10 years the equipment, which initially cost $10,000, is valueless. The firm and the smog control district have agreed that the following are reasonable estimates of the end-of-year maintenance costs: Year 1 2 3 4 5 $75 100 125 150 175 Year 6 7 8 9 10 $200 225 250 275 300 Assuming interest at 6% per year, how much should the smog control district pay to the firm now to provide for the first cost of the equipment and its maintenance for 10 years?
6- Road Runner LLC (RRL) is considering three alternate routes in the desert. RRL uses a MARR of 5%. Using equivalent annual worth over the least common multiple horizon, which choice is best? 48 Route 105 Route 205 Route 305 А First cost $520,000 $460,000 $395,000 Savings/year 135,000 100,000 95,000 Life 7 6.
1 Uniform Annual Cash Flow An engineer has an Huct uating fut ure budget for the maint enance of a particular machine. During cach of the first 5 years, $10,000 per year will he budget ed. During the second 5 years, the annual budget will be $15,000 per year. In addition, $5000 will be budgeted for an overhaul (major repair) of the machine at end of the 4th year, and again at the end of the 8th year. What uniform annual expenditure (EUAC) would be equivalent, if interest rate is 8% per year?
An investment has the following cash flow series where interest is 7%: 2 3 4 5 6 7 Cash Flow ($) 150 300 450 0 -500 0 600 700 800 End of Year Part a 0 Click here to access the TVM Factor Table Calculator 1 Determine the present worth of the series. $ Save for Later Round entry to the nearest dollar. Tolerance is ±4. 8 Attempts: 0 of 5 used Part b The parts of this question must be completed in order. This part will be available when you complete the part above. Part c The parts of this question must be completed in order. This part will be available when you complete the part above. Submit Answer
Given the data below for two alternatives, find the better alternative using incremental IRR if MARR is 15%. Alternatives can be replaced at the end of their useful lives. Alt. A Alt. B Initial Cost $10,000 $25,000 Maintenance Cost / Year 1500 1200 Uniform Annual Benefit 4800 12000 Salvage Value 1600 5000 Life 12 Years 8 Years
Solve by using formulas. (Round your answer to the nearest cent.) Ordinary Annuity AnnuityPayment PaymentFrequency TimePeriod (years) NominalRate (%) InterestCompounded Future Valueof the Annuity (in $) $3,000 every 6 months 5 5.0 semiannually $
A concrete pavement on a street would cost 10,000 and wouldlast for 5 years with negligible repairs. At the end of each 5years, 1,000 would be spent to remove the old surface before10,000 is spent again to lay a new surface. Find the capitalizedcost of the pavement at 5%.
An investment has the following cash flow series where interest is 7%: End of Year 0 1 3 4 6 7 8 Cash Flow ($) 150 300 450 0 -500 0 600 700 800 Click here to access the TVM Factor Table Calculator Part a Determine the present worth of the series. $ Round entry to the nearest dollar. Tolerance is ±4.