- Basic notions of rates of return
- Mimimum aceptable rate of return
- Internal rate of return (IRR)
- Calculations of IRR
- Single, simple investment
- Consistencyof IRR with other economic comparison methods (note Figure 5.4 "Present worth of cash flow for the proposal ... at different interest rates" in Riggs et al. (1998, pg. 171).)
- IRR misconceptions
- ranking alternatives by individual IRR values (note Figure 5.5 "relationship of net worth and different discount rates" of Riggs et al. (1998, pg. 178).)
- Nonsimple investment - more than one possible rate of return (note Figure 5.6 "Net present worth of a proposal with multiple roots for PW" of Riggs et al. (1998, pg. 182).)
- Project Balance Method
- Alternatives with unequal lives
- Cost of capital concepts
The following exhibits show how to use the IRR function of Excel to calculate internal rate of return:
Exhibit 1: Spreadsheet figures and comments (note that the range of irr covers figures from time 0[now] to end of the period [year 5])
Exhibit 2: Online Excel help information on IRR
A class discussion question:
References
- Riggs, J.L., Bedworth, D.D. and Randhawa, S.U. (1998) "Chapter 5: Rate of Return Calculations" Engineering Economics, Mcgraw-Hill.
- Cost of capital: http://www.investopedia.com/terms/c/costofcapital.asp#axzz1moqEvtak
- Internal rate of return (video): http://www.youtube.com/watch?v=Mr8dpR0XmBc&feature=related
No comments:
Post a Comment