Perform a present worth (PW)-based evaluation of the two alternatives below using a spreadsheet. The after-tax minimum acceptable rate of return (MARR) is 8% per year, Modified Accelerated Cost Recovery System (MACRS) depreciation applies, and Te = 40%. The (GI - OE) estimate is made for the first 3 years; it is zero in year 4 when each asset is sold. Alternative X Y First Cost, $ -8,000 -13,000 Salvage Value, Year 4, $ 0 2,000 GI-OE, $ per Year 3,500 5,000 Recovery Period, Years 3 3 The PW for alternative X is determined to be $ The PW for alternative Yis determined to be $
Perform a present worth (PW)-based evaluation of the two alternatives below using a spreadsheet. The after-tax minimum acceptable rate of return (MARR) is 8% per year, Modified Accelerated Cost Recovery System (MACRS) depreciation applies, and Te = 40%. The (GI - OE) estimate is made for the first 3 years; it is zero in year 4 when each asset is sold. Alternative X Y First Cost, $ -8,000 -13,000 Salvage Value, Year 4, $ 0 2,000 GI-OE, $ per Year 3,500 5,000 Recovery Period, Years 3 3 The PW for alternative X is determined to be $ The PW for alternative Yis determined to be $
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Question
None
![Perform a present worth (PW)-based evaluation of the two alternatives below using a
spreadsheet. The after-tax minimum acceptable rate of return (MARR) is 8% per year, Modified
Accelerated Cost Recovery System (MACRS) depreciation applies, and Te = 40%. The (GI - OE)
estimate is made for the first 3 years; it is zero in year 4 when each asset is sold.
Alternative
X
Y
First Cost, $
-8,000
-13,000
Salvage Value, Year 4, $
0
2,000
GI-OE, $ per Year
3,500
5,000
Recovery Period, Years
3
3
The PW for alternative X is determined to be $
The PW for alternative Yis determined to be $](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbacf2cb4-00fe-4e62-9ecf-49b3add5964a%2Fa8bd2df6-e5c9-4171-804e-bd42e41aca65%2F9gfnlwl_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Perform a present worth (PW)-based evaluation of the two alternatives below using a
spreadsheet. The after-tax minimum acceptable rate of return (MARR) is 8% per year, Modified
Accelerated Cost Recovery System (MACRS) depreciation applies, and Te = 40%. The (GI - OE)
estimate is made for the first 3 years; it is zero in year 4 when each asset is sold.
Alternative
X
Y
First Cost, $
-8,000
-13,000
Salvage Value, Year 4, $
0
2,000
GI-OE, $ per Year
3,500
5,000
Recovery Period, Years
3
3
The PW for alternative X is determined to be $
The PW for alternative Yis determined to be $
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education