+ Reply to Thread
Results 1 to 3 of 3

Formula Help for Amortization Schedule

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Formula Help for Amortization Schedule

    I have the following amortization schedule:

    Amortization Schedule.jpg

    Each month I record interest and principle payments based on the current month, in this example, I put in 8/1/17 in a cell. In another cell, I am trying to sum up the remaining interest but not all of the remaining interest, just the interest that follows 12 months from the date I put in which was 8/1/17.

    Is there a way to do this? Let me know if I need to provide more information.

    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Formula Help for Amortization Schedule

    This looks like a training assignment???
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-10-2017
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    4

    Re: Formula Help for Amortization Schedule

    No, not a training assignment but a task that no one in my team knows how to fix. I figured I could just do a vlookup on the date within the schedule but I don't know how to sum just the 12 months starting at the date that I enter.

+ 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. Need an excel amortization schedule formula with a grace period
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  2. Need an excel amortization schedule formula with a grace period
    By Grace period formula in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] Need an excel amortization schedule formula with a grace period
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] Need an excel amortization schedule formula with a grace period
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  5. Need an excel amortization schedule formula with a grace period
    By David McRitchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] Need an excel amortization schedule formula with a grace period
    By Grace period formula in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Need an excel amortization schedule formula with a grace period
    By Grace period formula in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  8. Need an excel amortization schedule formula with a grace period
    By Grace period formula in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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