#1
|
|||
|
|||
mortgage calculator excel sheet
Good day I am looking for a very good mortgage calculator excel sheet to use, I did get one from Mortgage Calculator But the only problem is, in our country the interest rate can change any month, so I need to get one that can let me change the interest rate at any date, and keep the info before that at old interest rate. |
#2
|
|||
|
|||
Here are two versions to consider ...
|
#3
|
|||
|
|||
Here are two examples for consideration ...
|
#4
|
|||
|
|||
Logit, thank you, but it still not let me change the Interest rate at any time i need to do it.
Busy trying to do it myself, but is takes long as i have to do a few columns with 240 cells each. |
#5
|
|||
|
|||
Both examples do allow for changing the interest rate at any time you desire. And, when you change the interest rate ... the changes in payments, etc are immediately reflected in all other locations as well.
|
#6
|
|||
|
|||
Yes that is the problem with it, if i change the rate, it changes it for all, it must only change from the date i need it to change, the above must still show old info.
|
#7
|
|||
|
|||
Ok ... I'm not an expert of Mortgage Calculators however, if you look at this calculator provided above as a download ( Mortgage_Calculator.zip ) in column C, it does appear to allow you to change the interest rate at any time.
I have not looked at the other download example but perhaps it does the same thing ? |
#8
|
|||
|
|||
|
Tags |
home loan |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to copy excel sheet withe HEADER and Paste into new sheet? | cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
Combinations calculator in excel??? Macro?? | mkuderik | Excel Programming | 1 | 01-27-2015 11:04 PM |
Mortgage repayment calculations | BritBiker2 | Excel | 2 | 10-14-2013 10:55 PM |
Excel eBay Fee Calculator Formula | rdonovan1 | Excel | 1 | 09-10-2012 07:37 PM |
Excel Calculator | Mandusin | Excel | 6 | 12-25-2010 07:34 AM |