home *** CD-ROM | disk | FTP | other *** search
/ Software Du Jour / SoftwareDuJour.iso / BUSINESS / LOTUS / TUTDOC1.ARC / 3511.PRN < prev    next >
Encoding:
Text File  |  1985-02-26  |  1.1 KB  |  38 lines
  1.  
  2. Problem  Part of MACLIB disk (see app#'s 3515 and 3516 for general info)
  3.          Internal ROR calculator.  You enter 25 yrs of investment and
  4.          cash flow data and it uses a sophisticated @hlookup formula
  5.          to look up the IRR from a table of NPV calculations.
  6.  
  7.  
  8. Block Diagram
  9.                ___________________ ___________________ ______________
  10.               |                   |                   |              |
  11.               |    Inputs         |    NPV Lookup Tbl |              |
  12.               |___________________|___________________|              |
  13.               |                   |                   |    MACLIB    |
  14.               |    IRR Result     |                   |              |
  15.               |___________________|                   |              |
  16.               |                   |                   |              |
  17.               |    Intructions    |                   |______________|
  18.               |___________________|
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25. Tips
  26.          See NPV lookup table at D1..W12
  27.  
  28.          and HLOOKUP's at X6..X12
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.