+ Reply to Thread
Results 1 to 3 of 3

How to determine amount owed on a loan in future

  1. #1
    Registered User
    Join Date
    08-26-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    3

    How to determine amount owed on a loan in future

    Hi

    I have a 20 year loan on my house. I do monthly payment periods so 240 payment periods. I wish to determine how much I will still owe say x payment periods from now. Interest rate is constant.

    I'm not sure which Excel financial formula I need to use.

    Thanks in advance.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to determine amount owed on a loan in future

    Hi,

    With
    A1 - Loan Amount
    A2 - Monthly interest rate
    A3 - Monthly payment
    A4 - Number of periods

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or using Excel's FV function
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: How to determine amount owed on a loan in future

    As Richard noted, you must use the monthly interest rate. But usually, you are given only an annual interest.

    So you might wonder: how do you convert an annual rate to a monthly rate?

    In my experience working with other Australian loans, it is simply annualRate/12.

    If you have any doubt, you might confirm that with the lender.

    Another common method is (1+annualRate)^(1/12) - 1.

    And Canadians do things differently, as Canadians must (smile): (1+annulRate/2)^(1/6) - 1.
    Last edited by joeu2004; 03-09-2018 at 02:27 AM. Reason: removed unintended suggestion

+ 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. Required loan repayment amount
    By leviathanjc in forum Excel General
    Replies: 1
    Last Post: 01-11-2017, 09:40 PM
  2. Replies: 5
    Last Post: 10-29-2012, 06:14 AM
  3. Formula to calculate loan amount
    By MRoads in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-26-2012, 08:29 PM
  4. Calculate loan amount when payment known.
    By Gschwaller in forum Excel General
    Replies: 1
    Last Post: 07-05-2012, 06:38 PM
  5. [SOLVED] How to know the outstanding balance amount of a loan?
    By PRADEEPB270 in forum Excel General
    Replies: 3
    Last Post: 01-07-2012, 03:52 AM
  6. Looking for Excel Function to calculate amount owed
    By BlackMagic21 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2008, 03:53 PM
  7. [SOLVED] loan amount pay per share
    By investor420 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2006, 04:43 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