Question

EXCEL Complete probleman Unexcell Annual property taxes 47. Lb.2 & LO.3 (NPV; Pl; sensitivity analysis) Westside Warehouse is
Chapter 15 Capital Budgeting c. Compute the profitability index (Round to two decimal points.) d. Assume Westsides managers
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: af step 1: Computation of Annual Cash Inflows: $ q 50 000 Annual Labox cost savings Less: Expenses C All Cost:9: :) AProfibbility Index = Pxesent Value of cash inflau Cash out flave 1. Present value of = $4,677,716 $ 5.000.000 = 0.93Present Value of gpecabing cash flows = 8,38 m 5.582 = $ 4.677,716 Step 3. computation Net present Value of NPY = Present val

Present Value of gpecabing cash flows = 8,38 m 5.582 = $ 4.677,716 Step 3. computation Net present Value of NPY = Present value of Total Cash inflow - Total cash out Flow ( Initial investment $4,677, 716 = $5,000,000 = 3,22, 284 Based on company since the is negative the should NPV the NPV as computed above, the invest in the new equipment is positive. Where the NPY investor shouldn't matre the investment Notes: since Taxes are ignoxed Considered depreciation needn't be

Add a comment
Know the answer?
Add Answer to:
EXCEL Complete probleman Unexcell Annual property taxes 47. Lb.2 & LO.3 (NPV; Pl; sensitivity analysis) Westside...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • EXCEL Complete probleman Onexcell Annual property taxes 47. Lb.2 & LO.3 (NPV; Pl; sensitivity analysis) Westside...

    EXCEL Complete probleman Onexcell Annual property taxes 47. Lb.2 & LO.3 (NPV; Pl; sensitivity analysis) Westside Warehouse is considering peengineering some production operations with automated equipment. The new equipment would have an initial cost of $5,000,000 including installation. The vendor has indicated that the equipment has an expected life of seven years with an estimated salvage value of $400,000. Estimates of annual labor savings and incremental costs associated with operating the new equipment follow. bonAnnual labor cost savings (14 workers)...

  • Chapter 15 Capital Budgeting 45. LO.2 & LO.3 (Time line; payback; NPV) Holly's Fashions is considering...

    Chapter 15 Capital Budgeting 45. LO.2 & LO.3 (Time line; payback; NPV) Holly's Fashions is considering expandi its building so it can stock additional merchandise for travelers and tourists. Store man ager Jill Eliason anticipates that building expansion costs would be $190,000. Th firm's suppliers are willing to provide inventory on a consignment basis so there would be no additional working capital needed upon expansion. Annual incremental fixed cash costs for the store expansion are expected to be as follows:...

  • 2. Devon Corporation uses a discount rate of 8% in its capital budgeting. Partial analysis of...

    2. Devon Corporation uses a discount rate of 8% in its capital budgeting. Partial analysis of an investment in automated equipment with a useful life of 6 years has thus far yielded a net present value of -$502,141. This analysis did not include any estimates of the intangible benefits of automating this process nor did it include any estimate of the salvage value of the equipment. (Ignore income taxes.) Click here to view Exhibit 13B-1 and Exhibit 13B-2 to determine...

  • 2. Denny Corporation is considering replacing a technologically obsolete machine with a new state-of-the-art numerically controlled...

    2. Denny Corporation is considering replacing a technologically obsolete machine with a new state-of-the-art numerically controlled machine. The new machine would cost $310,000 and would have a ten-year useful life. Unfortunately, the new machine would have no salvage value. The new machine would cost $52,000 per year to operate and maintain, but would save $93,000 per year in labor and other costs. The old machine can be sold now for scrap for $31,000. The simple rate of return on the...

  • FCF for Year 0, 1, 2, 3, 4 and 5 NPV? PI? IRR? (Related to Checkpoint...

    FCF for Year 0, 1, 2, 3, 4 and 5 NPV? PI? IRR? (Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 31 percent marginal tax bracket with a required rate of return or discount rate of 11 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a...

  • (Ignore income taxes in this problem.) Farah Corporation has provided the following data concerning a proposed...

    (Ignore income taxes in this problem.) Farah Corporation has provided the following data concerning a proposed investment project: $ 760,000 8 years $ 30,000 $ 152,000 $ 108,000 Initial investment Life of the project Working capital required Annual net cash inflows Salvage value The company uses a discount rate of 11%. The working capital would be released at the end of the project. Required: Compute the net present value of the project. (Round "PV Factor" to 3 decimal places. Round...

  • Investment Evaluation Analysis Widget Company is considering upgrading its manufacturing equipment. The Vice-President of Production has...

    Investment Evaluation Analysis Widget Company is considering upgrading its manufacturing equipment. The Vice-President of Production has identified three possible actions Widget could take to accomplish the upgrade, though none is required. One option would upgrade their current equipment and the other two options would replace the existing equipment with purchases of new equipment. The review committee has asked you to review each of the options to identify relevant cost data and to prepare a schedule comparing the three options to...

  • Compute net present value, profitability C index, and internal rate of return. P12.3A (LO 2, 3,...

    Compute net present value, profitability C index, and internal rate of return. P12.3A (LO 2, 3, 4), AN Service Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its main- tenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to...

  • LO 2 8-47 Target costing Mercedes-Benz All Activity Vehicle (AAV)'3 Introduction During the recession beginning in...

    LO 2 8-47 Target costing Mercedes-Benz All Activity Vehicle (AAV)'3 Introduction During the recession beginning in the early 1990s, Mercedes-Benz (MB) struggled with product development, cost efficiency, material purchasing, and problems in adapting to changing mar- kets. In 1993, these problems caused the worst sales slump in decades, and the luxury car maker lost money for the first time in its history. Since then, MB has streamlined the core business, re- duced parts and system complexity, and established simultaneous engineering...

  • Because of its inability to control film and personnel costs in its radiology department, Sanger General...

    Because of its inability to control film and personnel costs in its radiology department, Sanger General Hospital wants to replace its existing picture archive and communication (PAC) system with a newer version. The existing system, which has a current book value of $2,250,000, was purchased three years ago for $3,600,000 and is being depreciated on a straight-line basis over an eight-year life to a salvage value of $0. This system could be sold for $800,000 today. The new PAC system...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT