home *** CD-ROM | disk | FTP | other *** search
/ Software Du Jour / SoftwareDuJour.iso / BUSINESS / LOTUS / TUTDOC1.ARC / 3809.PRN < prev    next >
Encoding:
Text File  |  1985-02-25  |  896 b   |  38 lines
  1.  
  2. Problem  Generates a yearly of monthly amortization schedule based on
  3.          loan amount, int rate, pymts per yr, and number of yrs.
  4.          Will do up to 360 periods.  Macros generate an excellent graph
  5.          of resulting schedule showing breakdown of int and prin pymts.
  6.  
  7. Block Diagram
  8.                ___________________
  9.               |                   |
  10.               |  Macros           |
  11.               |___________________|
  12.               |                   |
  13.               |  Inputs           |
  14.               |___________________|
  15.               |                   |
  16.               |  Schedule         |
  17.               |___________________|
  18.  
  19.  
  20. Tips
  21.          Macro that generates graph C29
  22.          Build schedule macro A41
  23.          Advanced formulas in C72..G73 including @PV formula.
  24.          @PMT formula D60
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.