- When to use EAWA
- The inclination to view a year's gains and lossess as a yardstick of progress.
- For complementary comparisons to improve analysis clarity.
- On the capital recovery factor (which converts a lump sum to an equivalent annuity) and capital recovery calculations
- Consideration of asset life
- Definitions of asset life
- Comparisons of assets with equal and unequal lives
- The case of perpetual life
- Use of a sinking fund: i.e. the sinking fund factor is applied to compute the annuity required to accumulate a certain future amount
- Equivalent uniform payments when interest rates vary
- Annuity contract for a guaranteed income: e.g. for a retirement plan with a guaranteed income
Exhibit 1: Use the =pmt function to calculate annuity in Excel; in this case interest rate is 10%; the number of payment is 5 and, finally, the present value is $100; the answer from the formula is -26.38
Exhibit 2: Information about the PMT formula in Excel from the online help of Excel (extracted)
Exhibit 3: To verify that the figure of 26.38 is correct withe the compound interest rate tables of the subject of Engineering Economics
References
- Riggs, J.L., Bedworth, D.D. and Randhawa, S.U. (1998) "Chapter 4: Equivalent annual-worth comparisons" Engineering Economics, McGraw-Hill.
- On annuity (video): http://www.youtube.com/watch?v=awvy-UrqZjM&feature=related
No comments:
Post a Comment