Rate of Return Analysis - Engineering Economics
Rate of Return Analysis - Engineering Economics
Rate of Return Analysis - Engineering Economics
Engineering Economics
Rate-of-Return Analysis
http://www.stellman-greene.com
www.hoasen.edu.vn
Road Map
Chapter 6 Rate-of-Return Analysis Rate of Return Methods for Finding Rate of Return Internal-Rate-of-Return Criterion Incremental Analysis for Comparing Mutually Exclusive Alternatives
Return on Investment
Definition 1- Rate of return is the interest earned on the unpaid balance of amortized loan Example: Suppose that a bank lends $10,000, which is repaid in installments of $4,021 at the end of each year for three years. How would you determine the interest rate that the bank charges on this transaction? 10,000 = 4,021(P/A,i,3) i = 10%
www.hoasen.edu.vn
Return on Investment
Unpaid balance at beginning of the year Return on unpaid balance (10%) Payment received Unpaid balance at End of the year -10,000 -6,979
Year
0 1 2 3
-10,000 -6,979
-1,000 -698
4,021 4,021
www.hoasen.edu.vn
Return on Investment
When the last payment is made, the outstanding principal is eventually reduced to zero. If we calculate the PW of the loan transaction at its rate of return (10%). we see that PW(10%) = -$10.000 + $4,021(P/A. 10%, 3) = 0 i.e. the bank can break even at a 10% rate of interest
www.hoasen.edu.vn
Return on Investment
Definition 2- Rate of return is the break-even interest rate i* at which the present worth of the project is zero or
A0 An A1 PW (i*) ... * 0 * 1 * n (1 i ) (1 i ) (1 i )
www.hoasen.edu.vn
Investment project can be views as analogous to bank loan A projects return is referred to as internal rate of return (IRR), or the Yield promised by an investment project over its useful life Definition 3: The internal rate of return is the interest rate charges on the unrecovered project balance of the investment such that, when the project terminates, the unrecovered project balance is zero.
www.hoasen.edu.vn
Suppose a company invest 10,000 in a computer with a three-year useful life and equivalent annual labor savings 4,021. Here, we may view the investment firm as the lender and the project as the borrower. The cashflow transaction between them would be identical to the amortized loan described above:
Year Beginning project balance -10,000 -10,000 Return on invested capital (10%) 0 -1,000 Cash generated from project 0 Project balance at End of the year -10,000
0 1
2
3
www.hoasen.edu.vn 9
Road Map
Chapter 6 Rate-of-Return Analysis Rate of Return Methods for Finding Rate of Return Internal-Rate-of-Return Criterion Incremental Analysis for Comparing Mutually Exclusive Alternatives
10
www.hoasen.edu.vn
11
Investment Classification
Year 0 1 Project A -1,000 -500 Project B -1,000 3,900 Project C 1,000 -4,50
2
3 4
800
1,500 2,000
-5,030
2,145
-450
-450
Given: Cash flow sequences provided in the foregoing table. Find: Classify the sequences as either simple or non-simple investments.
www.hoasen.edu.vn
12
Computational Methods
There are several ways to determine rate of return. Three most practical methods: direct-solution method, trial-and-error method, and Excel method.
www.hoasen.edu.vn
13
Finding i* by Direct
n
0 1
2 3 4
www.hoasen.edu.vn
14
Finding i* by Direct
Project 1: FW(i*) = -1,000(F/P,i*,4) + 1,500 = 0 -1,000*(1+i)4 + 1,500 = 0 (1+i)4 = 1.5 i = (1.5)1/4 1 = 10.67% Project 2: FW(i) = -2000(F/P,i,2) + 1,300(F/P,i,1) + 1,500 = 0
www.hoasen.edu.vn 15
Finding i* by Direct
www.hoasen.edu.vn
16
The first step in the trial-and-error method is to make an estimated guess at the value of i*. For a simple investment, we use the guessed interest rate to compute the present worth of net cash flows and observe whether the result is positive, negative, or zero: Case 1: PW(i) < 0. Since we are aiming for a value of i that makes PW(i) = 0, we must raise the present worth of the cash flow. To do this, we lower the interest rate and repeat the process. Case 2: PW(i) > 0. We raise the interest rate in order to lower PW(i). The process is continued until PW(i) is approximately equal to zero Whenever we reach the point where PW(i) is bounded by one negative value and one positive value. we use linear interpolation to approximate i*.
www.hoasen.edu.vn
17
Agdist Corporation distributes agricultural equipment. The board of directors is considering a proposal to establish a facility to manufacture an electronically controlled "intelligent" crop sprayer invented by a professor at a local university. This crop-sprayer project would require an investment of $10 million in assets and would produce an annual after-tax net benefit of $1.8 million over a service life of eight years. All costs and benefits are included in these figures. When the project terminates, the net proceeds from the sale of the assets would be $1 million. Compute the rate of return of this project
www.hoasen.edu.vn
18
Given: Find: i*
0 10m 1
2 ... 7
www.hoasen.edu.vn
19
www.hoasen.edu.vn
20
Road Map
Chapter 6 Rate-of-Return Analysis Rate of Return Methods for Finding Rate of Return Internal-Rate-of-Return Criterion Incremental Analysis for Comparing Mutually Exclusive Alternatives
21
PW analysis is dependent on the rate of interest used for the PW computation. A different rate may change a project from being considered acceptable to being considered unacceptable, or it may change the ranking of several projects. For the simple project: Interest rates below i*: project accepted, as PW > 0; Interest rates above i*: it should be rejected. For the simple project: there are regions of (+) and (-) not clear which i* to use to make an accept-or-reject decision i* value fails to provide an appropriate measure of profitability for an investment project
www.hoasen.edu.vn 22
www.hoasen.edu.vn
23
Merco, lnc., a machinery builder Invest: 1,250,000 increased fabricated-steel production: 2,000 tons/year: average sales price per ton of fabricated steel: $2,566.50 labor rate: $10.50/hour tons of steel produced in a year: 15,000 cost of steel per ton (2.205 Ib): $1,950: number of workers on layout, hole making, sawing, and material handling: 17; additional maintenance cost: $128,500/year direct-labor cost of fabricating1 lb at 10 cents $226,000 in corporate income taxes
www.hoasen.edu.vn
24
Cost to produce 1 ton of steel Total Cost = raw material cost + labor cost Total cost = $1,950 + 0.1*2205 = 2,170.5 Profit per ton = price per ton cost per ton Profit per ton = 2,566.5 - 2,170.5 = 396 Total projected profit per year = 2,000 * 396 = 792,000 Benefits: Additional labor saving of using a new system:
17 * 10.5 * 40 * 50 = 294,000
After-tax salvage value: 80,000 Other costs: Additional Maintenance cost: $128,500/year Corporate Tax: 226,000/year
www.hoasen.edu.vn 25
1. What is the projected IRR on this investment? 2. If Merco's MARR is known to be 18%, is this investment justifiable? Solution: 1. IRR?
a. b. Simple or non-simple PW(i)
www.hoasen.edu.vn
26
Simple project: IRR provides unambiguous criterion for measuring profitability When multi rate occurs: none of them is an accurate portray of projects acceptability or profitability External Rate of return allows us to calculate a single true rate of return
www.hoasen.edu.vn
27
By outbidding its competitors, Trane Image Processing (TIP), a defense contractor, has received a contract worth $7,300,000 to build navy flight simulators for U.S. Navy pilot training over two years. For some defense contracts, the U.S. government makes an advance payment when the contract is signed. but in this case, the government will make two progressive payments: $4,300,000 at the end of the first year and the $3,000,000 balance at the end of the second year. The expected cash outflows required in order to produce these simulators are estimated to be $1,000,000 now, $2,000,000 during the first year, and $4,320,000 during the second year. The expected net cash flows from this project are summarized as follows:
www.hoasen.edu.vn
28
Cash Inflow
Cash Outflow
1,000,000 2,000,000 4,320,000
a) Compute the values of the i*'s for this project. b) Make an accept-or-reject decision, based on the results of part (a). Assume that the contractor's MARR is 15%.
www.hoasen.edu.vn
29
Tutorial
Do end chapter problems: 7.2, 7.3, 7.4, 7.5, 7.6, 7.7, 7.8, 7.11, 7.12
www.hoasen.edu.vn
30