Question

(2) Given the data in the table below, choose the better alternative using Present Worth Analysis MARR is 7% Alternative A Alternative B Initial Cost Annual Benefits Annual Expenses Salvage Value Useful Life (Years) $12,000 S5,500 S2,500 $1,000 $8,000 $5,200 $2,200 $1,100 4 a) Solve the problem using compounding factors. Show all required compounding factors (XX, i%, n) Round the answer to zero decimal place b) Solve the problem using Excel. Take a screenshot of your excel worksheet and submit it with your solution. Do not upload the excel file

need help with a and b please

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
need help with a and b please (2) Given the data in the table below, choose...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • QUESTION 6 Data for two mutually exclusive alternatives are given below. Alternatives B $4,000 $800 А...

    QUESTION 6 Data for two mutually exclusive alternatives are given below. Alternatives B $4,000 $800 А Initial Cost $5,000 Annual Benefits (beginning at end of $1,500 year 1) Annual Costs (beginning at end of year $500 1) Salvage Value $500 Useful Life (years) 5 $200 $0 10 Compute the net present worth for each alternative and choose the better alternative. MARR = 8%

  • Can someone help me with part b? I can not seem to find the correct answer for present worth of B1 with 10 year plannin...

    Can someone help me with part b? I can not seem to find the correct answer for present worth of B1 with 10 year planning horizon or the present worth of B2 with 10 year planning horizon. Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds (after tax) from disposal of the assets if they are sold at the end of each year. Both projects B1 and B2 will be available (or can...

  • Question 1 The cash flows given in table below are for two different alternatives. MARR =10%...

    Question 1 The cash flows given in table below are for two different alternatives. MARR =10% Data IN Initial Cost Annual Benefits Salvage Value Useful Life in years M $20,000 $6,000 $5,000 $80,000 $10,000 $20,000 a) Determine the annual worth of alternative M b) Determine the annual worth of alternative N

  • Solve for A and B, Engineering Economy please solve it right! Question Help %) Problem 6-52 (algorithmic) Compare al...

    Solve for A and B, Engineering Economy please solve it right! Question Help %) Problem 6-52 (algorithmic) Compare alternatives A and B with the present worth method if the MARR is 15% per year. Which one would you recommend? Assume repeatability and a study period of 20 years. $40,000 $7,000 at end of year 1 and increasing by $700 per year thereafter $7,000 every 5 years $15,000 $14,000 at end of year 1 and increasing by $1,400 per year thereafter...

  • Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds...

    Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds (after tax) from disposal of the assets if they are sold at the end of each year. Both projects B1 and B2 will be available (or can be repeated) with the same costs and salvage values for an indefinite period. B Click the icon to view the additional data about the mutually exclusive projects. Click the icon to view the interest factors for discrete...

  • Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds...

    Consider the two mutually exclusive projects in the table below. Salvage values represent the net proceeds (after tax) from disposal of the assets if they are sold at the end of each year. Both projects B1 and B2 will be available (or can be repeated) with the same costs and salvage values for an indefinite period. Click the icon to view the additional data about the mutually exclusive projects. Click the icon to view the interest factors for discrete compounding...

  • I only need help with doing Part C manually 4-1 You are considering three mutually exclusive...

    I only need help with doing Part C manually 4-1 You are considering three mutually exclusive design alternatives. Do nothing is also an option. MARR is 15%. A B Category First cost, $ Annual Expense, $/yr Annual revenue, $/yr Salvage value, $ Useful life, yrs ROR 26,000 12,500 20,000 5,000 10 26.60% 52,000 12,000 25,000 9,000 10 22.13% 40,000 21,000 29,000 8,000 10 16.30% a. What is the present worth of each alternative? Which would you choose? b. Perform an...

  • A remotely located air sampling station can be powered by solar cells or by running an...

    A remotely located air sampling station can be powered by solar cells or by running an electric line to the site and using conventional power. Solar cells will cost $14,600 to install and will have a useful life of 4 years with no salvage value. Annual costs for inspection, cleaning, etc., are expected to be $1700. A new power line will cost $12,000 to install, with power costs expected to be $700 per year. Since the air sampling project will...

  • Given the financial data for four mutually exclusive alternatives in the table below, A B C D First cost $18,000 $40,000 $21,200 45,000 O &M Cost/ year 2,600 5,000...

    Given the financial data for four mutually exclusive alternatives in the table below, A B C D First cost $18,000 $40,000 $21,200 45,000 O &M Cost/ year 2,600 5,000 3,900 11,000 Benefit/year 7,500 16,000 11,500 25,000 Salvage value 2,000 6,000 6,000 12,000 Life in years                                4 Use a Rate of Return Analysis to solve for the following: Which alternative should be chosen using an MARR of 9%? Mathematical solution Create a choice table from 0 – 25%. Create a graphical...

  • 3. You are deciding between leasing or purchasing a car and you need the car for...

    3. You are deciding between leasing or purchasing a car and you need the car for the next four years. The details of these two alternatives are discussed below. Buy The initial cost will be $35,000. There will be major maintenance every two years, costing $2,000. The annual insurance on the car will cost $3,200 annual and the gas will cost $1,800 annually. You expect to sell the car for $8,000 dollars at the end of the four years. Lease...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT