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 (Gl -OE) estimate is made for the first 3 years; it is zero in year 4 when each asset is sold. Alternative First Cost, $ Salvage $ GI-OE, $ per Year Recovery Period, Years Value, Year 4, X -8,000 0 3,500 3 -13,000 2,000 5,000 3 The PW for alternative X is determined to be $ The PW for alternative Yis determined to be $ Alternative (Click to select) is selected.

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 (Gl -OE) estimate is made for the first 3 years; it is zero in year 4 when each asset is sold. Alternative First Cost, $ Salvage $ GI-OE, $ per Year Recovery Period, Years Value, Year 4, X -8,000 0 3,500 3 -13,000 2,000 5,000 3 The PW for alternative X is determined to be $ The PW for alternative Yis determined to be $ Alternative (Click to select) is selected.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: Consider the following projects. The incremental ROR of the difference is most nearly. Most nearly…

A: Rate of return refers to the return earned by the investors on the investment made during the year…

Q: Joey has a new project has an initial cost of $190,000. The equipment will be depreciated on a…

A: Average accounting return is computed using formula = Average annual income / Average…

Q: Please use excel to answer 1. and 2. Consider commercial properties A and B for which the land value…

A: (a) Expected Value After 5 Years with Increasing Land and Structure PricesProperty A:Initial Land…

Q: A challenger asset with a maximum useful life of 6 years has a first cost of $43,000 and an…

A: Equivalent uniform annual cost comprise of annual equivalent uniform of first cost less annual…

Q: Annual Expenses Defender: Challenger: Alternative A Alternative B Labor $300,000 $250,000 Material…

A: The method by which a business assesses and chooses long-term investment initiatives is called…

Q: Perform a present worth analysis of equal-service machines that have the costs shown on the next…

A: Present worth analysis - it mean present value of total present and future outflow & inflow .…

Q: 3. Depreciation expenses is recognized as reimbursable cost by a number of payers who prospective…

A: Explanation of depreciation. Depreciation is the predicted decrease in value of a fixed asset over…

Q: Two mutually exclusive alternatives have the estimates shown below. Use annual worth analysis to…

A: Annual worth analysis: It is the computation of the equivalent annual worth of a project or an…

Q: Compare the alternatives below on the basis of their capitalized costs with adjustments made for…

A: Capitalized cost Capitalized cost refers to expenses that are summed to the cost basis of a fixed…

Q: Compare the alternatives C and D on the basis of a present worth analysis using an interest rate of…

A: Present worth refers to the method of capital budgeting used for evaluating the current value of an…

Q: Compare the alternatives shown on the basis of their capitalized costs using a MARR of 10% per year.…

A: The capitalized-equivalent-worth approach, also known as Capitalized Cost (CC) Analysis, determines…

Q: You are to create a year-by-year depreciation schedule for an asset that has a cost basis (B) of…

A: The salvage Value is $80,000 The price of the Equipment is $950,000 Project life is 10 years To…

Q: A special power tool for plastic products costs $400,000 and has a four-year useful life, no salvage…

A: The period in which the cost of asset including working capital investment is fully recovered from…

Q: A project has an asset valued at $200,000 and is subjected to an exposure factor of 45 percent. The…

A: “Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: A property has a potential gross income of $2,000,000. You estimate that vacancy should be 6% and…

A: OPEX ratio stands for operating expenses to sales ratio that is to be calculated by taking operating…

Q: A firm is considering an investment in new equipment that has the following information. Purchase…

A: Accounting Rate of Return is a capital budgeting method that is determined by dividing the average…

Q: Use Annual Cost Analysis to determine whether Alternative A or B should be chosen. The analysis…

A: Alternative A;Annual Worth = P ( A / P , i , n ) - A - F ( A/F , i ,n )= 1800( A/P , 6% , 5) - 150 -…

Q: 3. Depreciation expenses is recognized as reimbursable cost by a number of payers who prospective…

A: Depreciation The purpose of providing depreciation to charges which are incurred in the actual and…

Q: A commercial property has PGI of $5 million, expenses of 40% of EGI and the vacancy is underwritten…

A: "Since you have asked a question with sub-parts more than three, the first four sub-parts are…

Q: An 8-year project is estimated to cost $384,000 and have no residual value. If the straight-line…

A: Average investment amount is the average of initial investment and ending investment of the…

Question

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
First Cost, $
Salvage Value, Year 4,
$
GI-OE, $ per Year
Recovery Period, Years
X
-8,000
0
3,500
3
Y
-13,000
2,000
5,000
3
The PW for alternative X is determined to be $
The PW for alternative Yis determined to be $
Alternative (Click to select) is selected.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction

VIEW

Step 2: Calculation PW for alternative X

VIEW

Step 3: Calculation PW for alternative Y

VIEW

Solution

VIEW

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Using (incremental) benefit-cost ratio analysis OR (incremental) internal rate of return, determine which of the following three mutually exclusive alternatives should be selected. Each alternative has a 6-year useful life. Assume the MARR is 6%. First Cost Uniform Annual Benefit Salvage Value $560 $140 $40 A $340 $100 0 B $125 $40 0 C
Consider two air-conditioning systems with the cash flow estimates as given below. Use AW analysis to determine the sensitivity of the economic decision to MARR values of 4%, 6%, and 8% per year. Air-Conditioning System 1 System First cost, $ AOC, $ per year Salvage value, $ New compressor and motor cost at midlife, $ Life, years -10,000 -500 -100 -1,850 8 The annual worth of air-conditioning system 1 when the MARR is 4% is $ The annual worth of air-conditioning system 2 when the MARR is 4% is $ The annual worth of air-conditioning system 1 when the MARR is 6% is $ The annual worth of air-conditioning system 2 when the MARR is 6% is $ The annual worth of air-conditioning system 1 when the MARR is 8% is $ The annual worth of air-conditioning system 2 when the MARR is 8% is $ Air-Conditioning System 2 -14,000 -85 -300 -2,540 12
Consider the following proposed capital investment in an engineering project and determine its (a) year-by-year ATCF, (b) after-tax AW, and (c) annual equivalent EVA.
Compare the alternatives C and D on the basis of a present worth analysis using an interest rate of 10% per year and a study period of 10 years. Alternative C First Cost $-40,000 $-11,000 $-24,000 AOC, per Year Annual Increase in Operating Cost, per Year Salvage Value Life, Years $-2,000 $-200 $-500 $6,000 $200 10 The present worth of alternative C is $ and that of alternative D is $ (Click to select) voffers the lower present worth.
You are an investor buying an existing office building. You determine that year 1 NOI will be $44,000 and that you the going in CAP rate is 4.1%. Using the Direct Capitalization approach, what is the estimated value of the building? You also determine that the Effective Gross Income will be $80,000 and the Effective Gross Income Multiplier is 13. What is the value using the EGIM muliplier approach? You also determine that the Annual Debt Service is 35,000. What is the Debt Service Coverage Ratio?
Compare two alternatives, 1 and 2, on the basis of a present worth evaluation using 10% per year and a study period of 8 years. Alternative First Cost Annual Operating Cost Overhaul in Year 4 Salvage Value Life Answer to the nearest whole dollars for currency, and the nearest percentage (no decimals) for interest, and a whole number for the number of years. Do NOT enter commas. DO enter minus signs for negative values. 1) What is the Present Worth of Project 1? $ 1 2 ($13,000) ($49,000) ($6,000) ($5,000) $0 ($3,350) $1,800 $6,800 4 years 8 years
Compare three alternatives on the basis of their capitalized costs at /= 8% per year and select the best alternative. Alternative E F G $-460,000 $-30,000 $90,000 4 First Cost AOC, per Year Salvage Value Life, Years $-80,000 $-65,000 $40,000 2 The capitalized cost of alternative E is $ The best alternative is (Click to select) ▼ alternative F is $ $-960,000 $-3,000 $450,000 ∞0 and alternative G is $
Provide step by step manual solution, given, and depreciation table for below mentioned problem. Make sure yet that your answer is the same as the given answer before sending your solution. An asset costing P50,000 has a life expectancy of 6 years and an estimated salvage value of P8,000. Calculate the depreciation charge at the end of the fourth period using fixed-percentage method. Answer. P5,263.87
Two investment opportunities are as follows: A B First cost $150 $115 Uniform annual benefit $26 $20 End-of-useful-life salvage value $O SO Useful life, in years 10 10 If the MARR is 13%, which alternative should be selected?
Consider the following alternatives below.Based on a 7% interest rate, assuming both alternatives perform the same task and there is a continuing requirement, which alternative should be selected and what is its equivalent uniform annual cost?
Compare the following alternatives on the basis of their capitalized costs at i = 3% per year and select the best alternative. Alternative Alternative 1 Alternative 2 First Cost - $214353 - $761379 AOC, per year - $23334 - $14120 Salvage Value $55728 $175008 Life, years 8 Select one: a. Alternative 2 is selected, CC of selected alternative is $- 1232046 b. Alternative 1 is selected, CC of selected alternative is $-1232046 C. Alternative 1 is selected, CC of selected alternative is $-1218655 d. Alternative 2 is selected, CC of selected alternative is $–1218655 e. Alternative 1 is selected, CC of selected alternative is $-1276483
Consider an asset that costs $369,600 and is depreciated straight-line to zero over its 7-year tax life. The asset is to be used in a 4-year project; at the end of the project, the asset can be sold for $46,200. If the relevant tax rate is 23 percent, what is the aftertax cash flow from the sale of this asset? Multiple Choice $72,006.00 $35,574.00 $311,862.00 $68,405.70 $75,606.30

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS