A company that makes micro motion compact Coriolis meters purchased a new packaging system for $600,000. The estimated salvage value was $28,000 after 10 years. Currently the expected re­maining life is 7 years with an AOC of $27,000 per year and an estimated salvage value of $40,000. The company is considering early re­placement of the system with one that costs $370,000, has a 12-year economic service life, a $22,000 salvage value, and an estimated AOC of $50,000 per year. The MARR for the corporation is 12% per year. (a) Determine the minimum trade-in value necessary now to make the replace­ment economically advantageous. (b) Write the spreadsheet functions necessary to determine RV using Goal Seek.

What will be an ideal response?


(a) Relations to determine RV or minimum trade-in value

-RV(A/P,12%,7) – 27,000 + 40,000(A/F,12%,7) = -370,000(A/P,12%,12)
- 50,000 + 22,000(A/F,12%,12)

-RV(0.21912) – 27,000 + 40,000(0.09912) = -370,000(0.16144)
- 50,000 + 22,000(0.04144)

-RV(0.21912) = -108,821 + 23,035

RV = $391,502

(b) Spreadsheet functions:
AW for defender: = - PMT(12%,7,$B$1,40000) – 27000, if the RV value sought is in cell B1
AW for challenger: = - PMT(12%,12,-370000,22000) - 50000 displays $-108,821

Use Goal Seek to find RV = $391,501

Trades & Technology

You might also like to view...

On some vehicles, before a strut is removed from the steering knuckle what should be marked in relation to the strut mounting to avoid major alignment error?

What will be an ideal response?

Trades & Technology

List the building components in which cold-formed steel is used.

What will be an ideal response?

Trades & Technology

Which statement(s) is/are TRUE about included angle?

A) It is calculated by adding camber and SAI B) It is only measured on the front suspension C) Both A and B D) Neither A nor B

Trades & Technology

Which of the following formulas is the general voltage divider formula?

A.


B.


C.


D.


Trades & Technology