+ Reply to Thread
Results 1 to 2 of 2

Issue with Mortgage Interest Calculator

  1. #1
    Registered User
    Join Date
    01-21-2011
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    9

    Issue with Mortgage Interest Calculator

    Hi,

    I'm stuck...

    I wanted to create a calculator that would show me the amount of outstanding mortgage I have over the course of its term. I benefit from a staff mortgage which gives me two interest rates - one at Bank of England base rate, and the other at ordinary rates.

    I have it all in place and it seems to be working fine, apart from when I change the interest rate mid-term, when I do this there is always an imbalance at the end of the mortgage term and I cant see where this is coming from... if anyone could have a look it would be much appreciated!

    thanks in advance

    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Issue with Mortgage Interest Calculator

    Hi Jason,

    Where you are changing the rate ? Also, whats your expected result ? thanks


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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