1 / 57

Chapter 7 Rate of Return Analysis

Chapter 7 Rate of Return Analysis. Chapter Contents. Internal Rate of Return Rate of Return Calculations Plot of NPW versus interest rate i Fees or Discounts Examples Incremental Analysis Using Spreadsheet. Rate of Return Analysis.

cneal
Download Presentation

Chapter 7 Rate of Return Analysis

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 7Rate of Return Analysis

  2. Chapter Contents • Internal Rate of Return • Rate of Return Calculations • Plot of NPW versus interest rate i • Fees or Discounts • Examples • Incremental Analysis • Using Spreadsheet Engineering Economics

  3. Rate of Return Analysis • Rate of return analysis is the most frequently used exact analysis technique in industry. • Major advantages • Rate of return is a single figure of merit that is readily understood. • Calculation of rate of return is independent from the minimum attractive rate of return (MARR). Engineering Economics

  4. Internal Rate of Return What is the internal rate of return (IRR)? IRR is the interest rate at which present worth or equivalent uniform annual worth is equal to 0. In other words, the internal rate of return is the interest rate at which the benefits are equivalent to the costs. Engineering Economics

  5. Internal Rate of Return • Internal rate of return is commonly used to evaluate the desirability of investments or projects. • IRR can be used to rank multiple prospective projects. • Because the internal rate of return is a rate quantity, it is an indicator of the efficiency, quality, or yield of an investment. • To decide how to proceed, IRR will be compared to preselected minimum attractive rate of return (Chapter 8) Engineering Economics

  6. Internal Rate of Return (IRR) Given a cash flow stream, IRR is the interest rate iwhich yields a zero NPW (i.e., the benefits are equivalent to the costs), or a zero worth at any point in time. This can be expressed in 5 different ways as follows. • NPW = 0 • PW of benefits – PW of costs = 0 • PW of benefits = PW of costs • PW of benefits/PW of costs = 1 • EUAB – EUAC = 0 Engineering Economics

  7. Example A person invests $1000 at the end of each year. If the person would like to have $80,000 in savings at EOY 26 what interest rate should he select? Checking the Tables 26 yrs @ 6%, F/A = 59.15626 yrs @ 10%, F/A = 109.18226 yrs @ 8%, F/A = 79.954 When the compound interest tables are visited the value of i where (F/A, i%, 26)=80 is found as 8%, so i=8% Engineering Economics

  8. Checking the Tables 26 yrs @ 6%, F/A = 59.15626 yrs @ 10%, F/A = 109.18226 yrs @ 8%, F/A = 79.954 Example A person invests $1000 at the end of each year. If the person would like to have $80,000 in savings at EOY 26 what interest rate should he select? When the compound interest tables are visited the value of i where (F/A, i%, 26)=80 is found as 8%, so i=8% Engineering Economics

  9. Example – EXCEL solution RATE(n, A, P, F, type, guess) rate(26, 1000, 0, -80000) = 8% rate (26, -1000, 0, 80000) = 8% A, P, F must have different signs (+ or –)! IRR(value range, guess) value range = the cash flow stream Engineering Economics

  10. Example Cash flows for an investment are shown in the following figure. What is the IRR to obtain these cash flows? Engineering Economics

  11. EXAMPLE CONTINUES -8.85 Engineering Economics

  12. QUESTION CONTINUES -8.85 Engineering Economics

  13. INTERPOLATION 5% 30.95 5-X 30.95 10 X% 39.80 0 15% -8.85 Engineering Economics

  14. INTERPOLATION 5% 30.95 5-X 30.95 -10 X% 39.80 0 15% -8.85 Engineering Economics

  15. INTERPOLATION 12% 3.350 12-X 3.350 -3 X% 12.200 0 15% -8.850 Engineering Economics

  16. INTERPOLATION 12% 3.350 12-X 3.350 -3 X% 12.200 0 15% -8.850 Engineering Economics

  17. EXCEL solution IRR(C1:C5) = 12.83% C1 ~ C5 stores the stream of the 5 cash flows: -500, 100, 150, 200, 250 Engineering Economics

  18. Example A student, who will graduate after 4 years, borrows $10,000 per year at 5% interest rate at the beginning of each year. No interest is charged till graduation. If the student makes five equal annual payments after the graduation (end-of-period payments). a) What is each payment after the graduation? b) Calculate IRR of loan? (hint: use cash flow from when the student started borrowing the money to when it is all paid back) c) Is the loan attractive to the student? Engineering Economics

  19. EXAMPLE CONTINUES a) b) Engineering Economics

  20. INTERPOLATION: c) Since the rate is low, the loan looks like a good choice. Engineering Economics

  21. INTERPOLATION: c) Since the rate is low, the loan looks like a good choice Engineering Economics

  22. EXCEL Solution a) pmt(5%, 5, -40000) = $9,238.99 per month. b) irr(g1:g10) = 2.66%. c) Since the rate is low, the loan looks like a good choice. Engineering Economics

  23. Plot of NPW versus Interest Rate Borrowing Cases p. 218 Engineering Economics

  24. Plot of NPW versus Interest RateInvestment Cases Engineering Economics

  25. Fees or Discounts • Question: Option 1: If a property is financed through a loan provided by a seller, its price is $200,000 with 10% down payment and five annual payments at 10%. Option 2: If a property is financed through the same seller in cash, the seller will accept 10% less. However, the buyer does not have $180,000 in cash. What is the IRR for the loan offered by seller? Engineering Economics

  26. QUESTION CONTINUES Engineering Economics

  27. QUESTION CONTINUES INTERPOLATION: Engineering Economics

  28. QUESTION CONTINUES INTERPOLATION: This is a relatively high rate of interest, so that borrowing from a bank and paying cash to the property owner is better. Engineering Economics

  29. EXCEL Solution Combined cash flows (difference between options 1 & 2): At time 0: -$160,000 EOY 1-5: $47,484 IRR = rate(5, 47484, -160000) = 14.78% per year IRR = irr(a1:a6) = 14.78% per year Engineering Economics

  30. Loan and Investments are Everywhere • Question: A student will decide whether to buy weekly parking permit or summer semester parking permit from USF. The former costs $16 weekly; the latter costs $100 due May 17th 2010; in both cases the duration is 12 weeks. Assuming that the student pay the weekly fee on every Monday: a) What is the rate of return for buying the weekly permit? b) Is weekly parking attractive to student? *Total 12 weeks Engineering Economics

  31. QUESTION CONTINUES Effective annual interest= (1+.15)^52 – 1 = 1432% ! a) To find IRR%, set cash flows equal in PW terms– 100 = – 16 – 16 (P/A,i%,11)(P/A,i%,11) = (100 - 16) / 16 (P/A,i%,11) = 5.25 Looking in the table for the above value: IRR = 15% b) Nominal interest rate for 52 weeksIRR ≈ 15%/week or 15*52 = 780%/yr Since the rate is high, paying the semester fee looks like a good choice. Engineering Economics

  32. EXCEL Solution Combined cash flows (difference between the 2 options): At time 0: -$84 EOM 1~11: $16 IRR = rate(11, 16, -84) = 14.92% per month IRR = irr(C1: C12) = 14.92% per month Engineering Economics

  33. Rate Of Return Calculations Question: There are two options for an equipment: Buy or Lease for 24 months. The equipment might be either leased for $2000 per month or bought for $30,000. If the plan is to buy the equipment, the salvage value of the equipment at EOM 24 is $3,000. What is the IRR or cost of the lease? Engineering Economics

  34. QUESTION CONTINUES To find IRR%, set cash flows of Buy and Lease options equal in PW terms Engineering Economics

  35. Try i = 5% 28000 – 3000(0.3101) – 20000(13.489) = 91.7 Try i = 4% 28000 – 3000(0.3477) – 2000(14.148) = -1339.1 i ≈ 5% per month Engineering Economics

  36. EXCEL Solution Combined cash flows (difference of buy & lease): At time 0: -$28000 EOM 1~23: $2000 EOM 24: $3000 IRR = irr(e1:e25) = 4.97% per month Engineering Economics

  37. Incremental Analysis When there are two alternatives, rate of return analysis is often performed by computing the incremental rate of return, ΔIRR, on the difference between the two alternatives. Engineering Economics

  38. Incremental Analysis • The cash flow for the difference between alternatives is calculated by taking the higher initial-cost alternative minus the lower initial-cost alternative. • The following decision path is made for incremental rate of return (ΔIRR) on difference between alternatives: Engineering Economics

  39. Incremental Analysis • Question: If any money not invested here may be invested elsewhere at the MARR of 6% which alternative (1 or 2) given below should you select using the internal rate of return (IRR) analysis? Engineering Economics

  40. Effective annual interest(P/F,i,1) = 1/(1+i) = 0.833 1+i =1/0.833 = 1.2000 i = 20% Question Continues Engineering Economics

  41. Incremental Analysis • Question: When an equipment is installed it will save $800 per year in costs. The equipment has an estimated useful life of 5 years and no salvage value. Two suppliers are willing to install the equipment Supplier1will provide the equipment in return for three beginning-of-year annual payments of $500 each. Supplier 2will provide the equipment for $1345. If the MARR is 15%, which supplier should be selected? Engineering Economics

  42. QUESTION CONTINUES Engineering Economics

  43. QUESTION CONTINUES EXCEL Solution: IRR = rate(2, 500, -845) = 12.00% per year Engineering Economics

  44. Think-Pair-Share The company uses a MARR of 14%. Based on the rate of return, which is the most desirable alternative for a 10-yr analysis period? (Use incremental ROR analysis to choose a better alternative) Try i= 25% Engineering Economics

  45. Solution Require an incremental ROR analysis to choose a better alternative between the two given alternatives. Year Alt B- Alt A 0 -$165,000 1-10 $78,000 10 $20,000 PW of incremental costs – PW of incremental benefits = 165,000 – (78,000(P/A, i, 10) + 20,000(P/F,i, 10)) = 0 You want it to be higher than 14% which is MARR Try 15% 165,000 – (78,000(5.019) + 20,000(0.2472)) = – 231,426 Try 50% 165,000 – [78,000(1.965) + 20,000(0.0173)] = 11,384 MARR < 15% < ΔIRR < 50%. Choose Alternative B. Engineering Economics

  46. EXCEL Solution IRR = rate(10,78000,-165000,20000, ,0.4) = 46.35%/yr IRR = irr(a1:a11) = 46.35% per year Engineering Economics

  47. Think-Pair- Share Fancy Gadgets, Inc. has developed a new Thing-A-May-Jig at a cost of $2,000,000. Projected profits from the sale of Thing-A-May-Jigs for the next five years are: $300,000, $400,000, $500,000, $600,000, and $250,000. At the end of the fifth year, the production equipment associated with the Thing-A-May-Jig project will be disposed of for $750,000. Determine the rate of return for the Thing-A-May-Jig project. Try i= 10 and i=12 Engineering Economics

  48. EXCEL Solution: IRR = irr(a1:a6) = 10.16% per year Engineering Economics

  49. Think-Pair- Share Assuming that alternatives are replaced at the end of their useful life, determine the better alternative using annual cash flow analysis at an interest rate of 10%. Engineering Economics

  50. Engineering Economics

More Related