Please use excel and demonstrate the formulae used. A medium-sized industrial grade compressor can be purchased...

90.2K

Verified Solution

Question

Finance

Please use excel and demonstrate the formulae used.

A medium-sized industrial grade compressor can be purchased for$35,000. Annual O&M costs are expected to increase $1,300 everyyear, with a 1st year O&M cost of $2,000. (MARR = 16%, andplanning horizon is 10 years)

The compressor salvage value for a given periodt, is calculated based on the followingequation: Salvage value (t) = $30,000– $3,000 * t

a) Find the Optimum Replacement Interval for this Equipment

b) Find the Optimum Replacement Interval for this Equipment if theO&M costs is increased to $1,600/yr. What is yourconclusion?

c) Find the Optimum Replacement Interval for this Equipment if theinitial cost is reduced to $32,000. What is your conclusion?

Answer & Explanation Solved by verified expert
4.0 Ratings (626 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Please use excel and demonstrate the formulae used.A medium-sized industrial grade compressor can be purchased for$35,000. Annual O&M costs are expected to increase $1,300 everyyear, with a 1st year O&M cost of $2,000. (MARR = 16%, andplanning horizon is 10 years)The compressor salvage value for a given periodt, is calculated based on the followingequation: Salvage value (t) = $30,000– $3,000 * ta) Find the Optimum Replacement Interval for this Equipmentb) Find the Optimum Replacement Interval for this Equipment if theO&M costs is increased to $1,600/yr. What is yourconclusion?c) Find the Optimum Replacement Interval for this Equipment if theinitial cost is reduced to $32,000. What is your conclusion?

Other questions asked by students