Results 1 to 6 of 6

Complex Annuity Calculator is being weird

Threaded View

  1. #3
    Registered User
    Join Date
    05-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    69

    Re: Complex Annuity Calculator is being weird

    See the attached photo for outputs of Example 2 Inputs. In my inputs, I essentially said that I want a pay out period of 100 years with a delay of 5 years at the beginning.

    As none of the RMDs are above the scheduled payout, I do not understand why my calculator does not take the calculations out to Period 105. Instead, it stops at Period 68, thus I am short 37 periods short, or "significantly short". Sorry if I caused confusion earlier.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with annuity formula
    By kkundra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 11:37 AM
  2. Really Weird #REF Error in Complex Excel File?
    By cgmodzel in forum Excel General
    Replies: 4
    Last Post: 11-30-2006, 09:12 AM
  3. [SOLVED] pv of annuity
    By puertoricanninja in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-28-2006, 12:55 PM
  4. [SOLVED] Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1