Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below is a snapshot of an Excel sheet Economic Service Life (ESL) analysis for two alternatives: Defender with remaining life of 3 years, and challenger

image text in transcribed
image text in transcribed
Below is a snapshot of an Excel sheet Economic Service Life (ESL) analysis for two alternatives: Defender with remaining life of 3 years, and challenger with 6-year life. Based on the Excel analysis, answer the following questions: (Note: for numbers don't put units ($ or years)) NH ESL Analysis of Challenger Interest rate 10% First cost $50,000 3 No of years Market value AOC Total AW of costs 4 40,000 -5,000 -20,000 2 32,000 -7,000 -19,524 6 3 25,600 -9,000 -19,245 7 4 20,480 -11,000 -19,123 8 5 16,384 -13,000 -19,126 9 6 13,107 -15,000 -19,229 11 ESL Analysis of Defender 12 Interest rate 10% Market value $15,000 13 No of years Market value AOC Total AW of costs 14 1 12,000 -20,000 -24,500 15 2 9,600 -8,000 -18,357 16 3 7,680 - 12,000 -17,307 For a replacement study of unlimited period IN u 1- What is the ESL of the defender? hp 2- What is the AW of the defender's ESL? 3- What is the ESL of the challenger? 4. What is the AW of the challenger's ESL? 5- Based on the ESL analysis shown in Excel, put "Yes" or "No" in fro of the suggested recommendations below: a. Keep defender for two years then replace it. b. Keep defender for three years then replace it. c. Replace defender with challenger immediately. For a replacement study over a specified period 1- If the study period is one year, should we choose defender or challenger? 2- If the study period is two years should we choose defender challenger? (hp

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Terms Dictionary Investment Terminology Explained

Authors: Thomas Herold, Wesley Crowder

1st Edition

1521725764, 978-1521725764

More Books

Students also viewed these Finance questions