A4Please complete the things I have not filled out. I believe the best way to complete this is using excel. Also make sure to do the part that says to perform the incremental IRR analysis for the remaning alternatives (The part that has The IRR delta (C - A = ?? %). Thank You! A plant is interested in acquiring a machine to produce a new product. Three altematives, A. B. and C. are being oonsidered. Which alternative should be recommended if the plant's MARRis 12% per year using (a) the IRR method and (b) the annual worthmethod?E Click the icon to view the description of the alternatives.- XMore infoE Click the icon to view the interest and annuity table for discrete compounding when the MDiscrete Compounding: =12%Single PaymentUniform SeriesUniform GradlentThe IRR AC - A )= %. (Round to one decimal place.)GradlentСompoundАmountUniformCompoundАmountSinkingFundCapitalRecoveryFactorGradientWhich alternative should be selected using the IRR method? Choose the correct answer belowPresentPresentPresentSeriesFactorTo Find FWorth FactorFactorWorth FactorFactorWorth FactorFactorTo Find AGiven GTo Find PTo Find FTo Find PTo Find AGiven FTo Find ATo Find PO A. Alternative CGiven PGiven FGiven AGiven AGiven PGiven GO B. Allernalive ANF/PPIEFIAPIAA/FA/PPIGA/GOC. Allernalive B11.12000.89291.00000.89291.00001.12000.00000.00001.25440.79722.12001.69010.47170.59170.79720.471731.40490.71183.37442.40180.29630.41632.22080.924Eb. The AW, is s 2525 (Round to tne nearest collar.)41.57350.63554.77933.03730.20020.32024.12731.356951.76230.56746.35283.60480.15740.27746.39701.7746The AW, is s -348. (Round to the nearesl doller.)61.97380.50668.11524.11140.12320.24328.93022.17200.21010 201372.21070.452310.08904.56380.000111.64432.5515The AW, is $ 821. (Round to the nearest dollar.)2.47600.403912.29974.9676O D81314.47142.9131Which alternative should be selected using the annual worth method? Choose the oorrect ans92.77310.360014.77575.32820.06770.187717.35633.2674103.10680.322017.54875.65020.05700.177020.25413.5847O A. Alternative CO B. Alternative AOC. Alternative BPrintDone A plant is interested in acquiring a machine to produce a new product. Three altematives, A. B. and C, are being considered. Which altermative should be recommended if the plant's MARR is 12% per year using (a) the IRR method and (b) the annual worthmethod?E Click the icon lo view the descriplion of the allernalives.E Click the icon to view the interest and annuity table for discrete compounding when the MARR is 12% per ycar.a. The IRR, is %. (Round to crie decirmal placs.)More infoThe IRR, is %. (Round lo one decimal place.)The IRR- is %. (Round lo one decirrial place.)Which allernative will you drop based on IRR values? Choose the correct answer below.BInvestment CostS31,000$20,800$10,000$1,000S16,000O A. Alurnalive CAnnual cash flows59,200S10,900Salvage valueLife in yearsO B. Alternative B$5,000s9,0003OC. Alternative AO D. None cr the abovePerform the incremental IRRAnalysis for the remaining aitematives.PrintDoneThe IRR A(C - A )- %. (Round to one decimal place.)Which alternative should be selected using the IRR method? Chocse the correct answer below.O A. Alternative C

A B C Investment Cost 20800 34000 16000 Annual cash flows 10000 9200 10900 Salvage value…

A plant is interested in acquiring a machine to produce a new product. Three altematives, A. B. and C. are being considered. Which alternative should be recommended if the plant's MARR is 12% per year using (a) the IRR method and (b) the annual worth method? m Click the icon to view the description of the atematives. More info E Click the icon to view the interest and annuity table for discrete compounding when the M Discrete Compounding: /= 12% Single Payment Uniform Series Uniform Gradient The IRR AC - A = S%. (Round to one decimal place.) Gradient Compound Amount Сompound Аmount Sinking Fund Capital Recovery Factor Gradient Present Worth Factor Uniform Series Present Present Worth Factor Factor To Find P which alternative shouid be selected using the IRR method? Chocse the comrect answer below Factor Worth Factor Factor Factor To Find F To Find P Given G To Find F To Find P Given F To Find A To Find A To Find A O A. Alternative C Given P Given A Given A Given F Given P Given G O B. Allornalivo A FP PIF FIA PIA AIF A/P PIG A/G 1.1200 0.8929 1.0000 0.8929 1.0000 1.1200 0.0000 0.0000 OC. Allernalive B 2 12544 0.7972 2.1200 1.6901 04717 0.5917 0.7972 04717 0.4163 0.3202 1.4049 0.7118 3.3744 2.4018 0.2963 2.2208 0.9246 b. The A, is s 2525 (Round to the nearest collar.) 0 2002 4 1.5735 0.6355 4.7793 1.3569 3.0373 3.0018 4.1273 6.3970 5 1.7623 0.5674 6.3528 0.1574 0.2774 1.7746 The AWg is S-348. (Round to the ncaresi dollar.) 6 1.9738 0.5066 8.1152 4.1114 0.1232 02432 2.1720 7 2.2107 0.4523 10.0890 4.5638 4 9676 0.0001 02101 11.6443 2.5515 The AW is $ 821 - (Round to the nearest dolar.) O DR13 O 2013 0 4039 0.3606 24760 12.2997 14 4714 29131 Which alternative shouid be selected using the annual worth method? Choose the correct ans 2.7731 14.7757 5.3282 0.0677 0.1877 17.3563 3.2574 10 3.1058 0.3220 17.5487 5.6502 0.0570 0.1770 20.2541 3.5847 OA. Alternative C O B. Alternative A OC. Alternalive B Print Done

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC