+ Reply to Thread
Results 1 to 2 of 2

Amortization table dynamic start date

  1. #1
    Registered User
    Join Date
    01-29-2019
    Location
    Dublin, Ireland
    MS-Off Ver
    16.7
    Posts
    40

    Amortization table dynamic start date

    Hi everyone,

    I have a doubt with a model I need to built. So far I have been able to make amortizations in a way that they adjust to the number of periods but based on a first period 0, I just need to change the number of months and it will update automatically, this was easy because it always starts in period 0. I would choose the starting date and number of periods (50,60,70) and the table would update to that.

    Now I need to make the same, but the cashflows doesn't start with the beginning of the amortization but with the first prepayments (which vary between transactions and happen before the starting of amortization). Lets say that between the mortgage signing date and the money transfer one year goes by and there need to be a series of prepayments (this are variable between loans, so I need the model to update automatically.

    For example:
    In one case there is only 1 prepayment right when the contract is signed.
    In other the prepayment is in month 11
    In other takes 2 years from signature to money transfer but if I have 4 prepayments between every six months.

    Is it possible to make the model so it automatically adapts to these inputs?

    Thanks, hope I explained myself

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Amortization table dynamic start date

    Hi zumbito,
    There is a method to have a set 'autoupdate' or a 'rolling' x number of months.
    If that's what you mean, the below link may help.
    The method uses the OFFSET function in the chart metric definition and it updates automatically as you add or remove data.

    https://www.officetooltips.com/excel...ot_ranges.html
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic validation table IF start times & assignments
    By Olaura in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2019, 05:43 PM
  2. Dynamic ranges with different start date
    By SnilleMikke in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2015, 09:49 AM
  3. Replies: 2
    Last Post: 07-23-2014, 03:16 PM
  4. Replies: 1
    Last Post: 07-18-2014, 06:34 PM
  5. Dynamic Name range for a Table should start from Row #3
    By acsishere in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2013, 12:43 AM
  6. [SOLVED] Dynamic named range based on a start date and end date
    By Gary Lockton in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-06-2012, 07:26 PM
  7. [SOLVED] loan amortization template with loan start date AND first payment
    By Lisa W in forum Excel General
    Replies: 0
    Last Post: 01-30-2006, 06:30 PM

Tags for this Thread

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