/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Problem 21 Calculating NPV and IRR for a Re... [FREE SOLUTION] | 91影视

91影视

Log out

Learning Materials

Features

Discover

Chapter 6: Problem 21

Calculating NPV and IRR for a Replacement A firm is considering an investment in a new machine with a price of \(\$ 12\) million to replace its existing machine. The current machine has a book value of \(\$ 4\) million and a market value of \(\$ 3\) million. The new machine is expected to have a fouryear life, and the old machine has four years left in which it can be used. If the firm replaces the old machine with the new machine, it expects to save \(\$ 4.5\) million in operating costs each year over the next four years. Both machines will have no salvage value in four years. If the firm purchases the new machine, it will also need an investment of \(\$ 250,000\) in net working capital. The required return on the investment is 10 percent, and the tax rate is 39 percent. What are the NPV and IRR of the decision to replace the old machine?

Short Answer

Expert verified
The NPV and IRR for the decision to replace the old machine are approximately \$120,007.68 and 11.58%, respectively. Given the NPV is positive, the replacement is beneficial, and the IRR is higher than the required return on investment (10%), indicating a profitable investment.

Step by step solution

01

Calculate Initial Investment

To calculate the initial investment, we need to consider the purchase price of the new machine, the market value of the old machine, and the investment in net working capital. The initial investment is the cost of the new machine minus the market value of the old machine, plus the investment in net working capital. Initial Investment = (New Machine Price - Old Machine Market Value) + Net Working Capital Initial Investment = (\(12,000,000 - 3,000,000\) + \(250,000\)) Initial Investment = \(9,250,000\$)
02

Calculate Annual Operating Cost Savings

The annual operating cost savings will be the savings in operating costs for the new machine, multiplied by the tax rate. Annual Operating Cost Savings = (Operating Cost Savings) x (1 - Tax Rate) Annual Operating Cost Savings = (4500,000) x (1 - 0.39) Annual Operating Cost Savings = \(2,745,000\$)
03

Calculate Net Cash Flows

We need to find the net cash flows for each year of the investment, which includes the annual operating cost savings and the initial investment. Year 0: \(-9,250,000\$\) (Initial Investment) Year 1: \(2,745,000\$\) (Annual Operating Cost Savings) Year 2: \(2,745,000\$\) (Annual Operating Cost Savings) Year 3: \(2,745,000\$\) (Annual Operating Cost Savings) Year 4: \(2,745,000\$\) (Annual Operating Cost Savings)
04

Calculate NPV

Using the required investment return of 10% and the net cash flows, we can calculate the NPV. NPV = \(\sum_{i=0}^4 \frac{Net\: Cash\: Flow}{(1 + Required\: Return)^i}\) NPV = \(\frac{-9,250,000}{(1 + 0.10)^0} + \frac{2,745,000}{(1 + 0.10)^1} + \frac{2,745,000}{(1 + 0.10)^2} + \frac{2,745,000}{(1 + 0.10)^3} + \frac{2,745,000}{(1 + 0.10)^4}\) NPV =\(\approx \$120,007.68\)
05

Calculate IRR

IRR is the discount rate that makes the NPV of an investment equal to 0. To find the IRR, we need to iteratively test different discount rates until the NPV gets close to 0. Alternatively, financial calculators or spreadsheet software (like Excel) can be used to find the exact IRR. The IRR of this investment is approximately 11.58%.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91影视!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Internal Rate of Return (IRR)
The Internal Rate of Return (IRR) is an important measure in investment analysis. It helps investors understand what rate of return an investment will generate over its lifetime. In essence, the IRR is the discount rate that sets the net present value (NPV) of all cash flows from an investment to zero.
To calculate the IRR, investors usually try different discount rates until they find one that results in an NPV close to zero. However, tools like Excel can simplify this process by automatically calculating the IRR. In the context of a machine replacement decision, as presented in the exercise, the IRR was found to be around 11.58%.
A higher IRR indicates a more appealing investment. When comparing projects, choosing the one with the highest IRR typically means it's expected to generate more returns.
Capital Budgeting
Capital budgeting is a vital process for firms, helping them plan their long-term investments. Companies use it to evaluate potential expenses or investments that are substantial in size, like purchasing new machinery or launching a project.
The goal is to allocate resources to projects that increase the firm's value over time. In our exercise example, the firm must decide whether or not to replace an old machine with a new, more efficient one. This decision requires evaluating costs and benefits over several years.
Capital budgeting involves analyzing cash flows, projecting future earnings, and determining the best course of action using measures like NPV and IRR. This ensures the firm makes decisions that align with its financial goals and growth strategy.
Investment Analysis
Investment analysis is the comprehensive process of evaluating an investment opportunity to make informed decisions. It includes reviewing the potential costs, returns, and risks involved.
For the machine replacement exercise, the firm conducts an investment analysis to see if buying the new machine would be beneficial compared to keeping the old one.
This analysis considers operating costs savings, tax impacts, and changes in cash flow. By evaluating the Net Present Value (NPV) and Internal Rate of Return (IRR), the firm determines the profitability and financial viability of the investment. Regular investments analysis ensures a firm鈥檚 resources are effectively utilized.
Replacement Decisions
Replacement decisions are part of a broader investment strategy to maintain or improve company efficiency. These decisions involve assessing whether current assets should be replaced by new ones.
In the provided exercise, the firm considers replacing an old machine with a new one that offers better operational efficiency. Such decisions require careful evaluation of factors like cost savings, asset depreciation, and future operational benefits.
Key metrics like NPV and IRR are used to evaluate whether the replacement will add value to the firm over time. Replacement decisions are crucial to maintaining competitive advantage and operational reliability.

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Calculating Project NPV J. Smythe, Inc., manufactures fine furniture. The company is deciding whether to introduce a new mahogany dining room table set. The set will sell for \(\$ 5,600\), including a set of eight chairs. The company feels that sales will be 1,800, 1,950, 2,500, 2,350, and 2,100 sets per year for the next five years, respectively. Variable costs will amount to 45 percent of sales, and fixed costs are \(\$ 1.9\) million per year. The new tables will require inventory amounting to 10 percent of sales, produced and stockpiled in the year prior to sales. It is believed that the addition of the new table will cause a loss of 250 tables per year of the oak tables the company produces. These tables sell for \(\$ 4,500\) and have variable costs of 40 percent of sales. The inventory for this oak table is also 10 percent of sales. J. Smythe currently has excess production capacity. If the company buys the necessary equipment today, it will cost \(\$ 16\) million. However, the excess production capacity means the company can produce the new table without buying the new equipment. The company controller has said that the current excess capacity will end in two years with current production. This means that if the company uses the current excess capacity for the new table, it will be forced to spend the \(\$ 16\) million in two years to accommodate the increased sales of its current products. In five years, the new equipment will have a market value of \(\$ 3.1\) million if purchased today, and \(\$ 7.4\) million if purchased in two years. The equipment is depreciated on a seven-year MACRS schedule. The company has a tax rate of 40 percent, and the required return for the project is 14 percent. 1\. Should J. Smythe undertake the new project? 2\. Can you perform an IRR analysis on this project? How many IRRs would you expect to find? 3\. How would you interpret the profitability index?

Project Analysis Benson Enterprises is evaluating alternative uses for a three-story manufacturing and warehousing building that it has purchased for \(\$ 850,000\). The company can continue to rent the building to the present occupants for \(\$ 36,000\) per year. The present occupants have indicated an interest in staying in the building for at least another 15 years. Alternatively, the company could modify the existing structure to use for its own manufacturing and warehousing needs. Benson's production engineer feels the building could be adapted to handle one of two new product lines. The cost and revenue data for the two product alternatives are as follows: The building will be used for only 15 years for either product \(A\) or product \(B\). After 15 years the building will be too small for efficient production of either product line. At that time, Benson plans to rent the building to firms similar to the current occupants. To rent the building again, Benson will need to restore the building to its present layout. The estimated cash cost of restoring the building if product \(A\) has been undertaken is \(\$ \mathbf{2 9}, 000\). If product \(B\) has been manufactured, the cash cost will be \(\$ 35,000\). These cash costs can be deducted for tax purposes in the year the expenditures occur. Benson will depreciate the original building shell (purchased for \(\$ \mathbf{8 5 0 , 0 0 0}\) ) over a 30 -year life to zero, regardless of which alternative it chooses. The building modifications and equipment purchases for either product are estimated to have a 15-year life. They will be depreciated by the straight-line method. The firm's tax rate is 34 percent, and its required rate of return on such investments is 12 percent. For simplicity, assume all cash flows occur at the end of the year. The initial outlays for modifications and equipment will occur today (year 0 ), and the restoration outlays will occur at the end of year 15. Benson has other profitable ongoing operations that are sufficient to cover any losses. Which use of the building would you recommend to management?

Financial Break-Even Analysis The technique for calculating a bid price can be extended to many other types of problems. Answer the following questions using the same technique as setting a bid price; that is, set the project NPV to zero and solve for the variable in question. 1\. In the previous problem, assume that the price per carton is \(\$ \mathbf{1 4}\) and find the project NPV. What does your answer tell you about your bid price? What do you know about the number of cartons you can sell and still break even? How about your level of costs? 2\. Solve the previous problem again with the price still at \(\$ 14\)-but find the quantity of cartons per year that you can supply and still break even. (Hint: It's less than 130,000.) 3\. Repeat (b) with a price of \(\$ 14\) and a quantity of 130,000 cartons per year, and find the highest level of fixed costs you could afford and still break even. (Hint: It's more than \(\$ 210,000\).

Cash Flow Valuation Phillips Industries runs a small manufacturing operation. For this fiscal year, it expects real net cash flows of \(\$ 155,000\). Phillips is an ongoing operation, but it expects competitive pressures to erode its real net cash flows at 5 percent per year in perpetuity. The appropriate real discount rate for Phillips is 11 percent. All net cash flows are received at year-end. What is the present value of the net cash flows from Phillips's operations?

Calculating Project NPV Raphael Restaurant is considering the purchase of a \(\$ \mathbf{1 2 , 0 0 0}\) souffl茅 maker. The souffl茅 maker has an economic life of five years and will be fully depreciated by the straight-line method. The machine will produce 1,900 souffl茅s per year, with each costing \(\$ 2.20\) to make and priced at \$5. Assume that the discount rate is 14 percent and the tax rate is 34 percent. Should Raphael make the purchase?
See all solutions

Recommended explanations on Math Textbooks

Mechanics Maths

Read Explanation

Applied Mathematics

Read Explanation

Statistics

Read Explanation

Pure Maths

Read Explanation

Theoretical and Mathematical Physics

Read Explanation

Logic and Functions

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.