+ Reply to Thread
Results 1 to 6 of 6

Mortgage calculation

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002
    Posts
    159

    Mortgage calculation

    I started with a vertex42 free canadian mortgage spreadsheet.
    See attached, -simplified!
    i need to know how much principal is paid off during the say 1 to 5 years of the mortgage.
    ideally in one cell! for each scenario
    Interest is just the rate times the reducing principle - or principal?
    so payment less interest will be the principle each month.
    Suggestions on doing this without a table for each calculation!
    thanks all
    tried various formulae on the internet- none worked
    CUMPRINC function etc just give nonsense numbers- maybe because it is a canadian mortgage!
    Attached Files Attached Files
    Last edited by anon125; 03-23-2023 at 07:46 PM.

  2. #2
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002
    Posts
    159

    Re: Mortgage calculation

    C'mom guys! Somebody must know!!
    thanks

  3. #3
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002
    Posts
    159

    Re: Mortgage calculation

    another forum solved it.

  4. #4
    Registered User
    Join Date
    04-12-2023
    Location
    India
    MS-Off Ver
    2019
    Posts
    3

    Re: Mortgage calculation

    Quote Originally Posted by anon125 View Post
    another forum solved it.
    can you share the link to that forum?

  5. #5
    Forum Contributor
    Join Date
    08-20-2013
    Location
    north america
    MS-Off Ver
    Excel 2002
    Posts
    159

  6. #6
    Registered User
    Join Date
    04-12-2023
    Location
    India
    MS-Off Ver
    2019
    Posts
    3

    Re: Mortgage calculation

    Thanks...much appreciated.

+ 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. Formula Mortgage calculation monthly
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2016, 06:09 PM
  2. Mortgage Calculation Help
    By garopro in forum Excel General
    Replies: 17
    Last Post: 11-21-2011, 04:11 PM
  3. [SOLVED] Mortgage calculation after a large extra payment
    By Gary Wachs in forum Excel General
    Replies: 6
    Last Post: 04-16-2006, 04:00 AM
  4. [SOLVED] Mortgage calculation after a large extra payment
    By Gary Wachs in forum Excel General
    Replies: 6
    Last Post: 04-16-2006, 04:00 AM
  5. [SOLVED] Mortgage calculation after a large extra payment
    By Gary Wachs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2006, 09:10 PM
  6. [SOLVED] Mortgage Calculation Question/s
    By Tywardreath in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-03-2005, 06:15 PM
  7. mortgage
    By eddie in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-24-2005, 06: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