Home Forums Pension The demise of compound interest tables

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #5679
    Richard Purvey
    Participant

      Back in the 1980s and 1990s in an Edinburgh pensions and life company, I had to look up tables of (1+i) to the power of n (they referred to these as “compound interest tables”).  To do this using excel, put whatever value you have for i into cell A2 and whatever value you have for n into cell B2, and into cell C2, put the formula =(1+A2)^B2

       

       

      #24443
      James Whetzel
      Blocked

        Thanks for the recommendation!

      Viewing 2 posts - 1 through 2 (of 2 total)
      • You must be logged in to reply to this topic.