Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2021, 11:01 PM
hendrikbez hendrikbez is offline mortgage calculator excel sheet Windows 7 64bit mortgage calculator excel sheet Office 2016
Novice
mortgage calculator excel sheet
 
Join Date: Nov 2016
Posts: 11
hendrikbez is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 01-19-2021, 09:58 AM
Logit Logit is online now mortgage calculator excel sheet Windows 10 mortgage calculator excel sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Here are two versions to consider ...
Reply With Quote
  #3  
Old 01-19-2021, 10:01 AM
Logit Logit is online now mortgage calculator excel sheet Windows 10 mortgage calculator excel sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Here are two examples for consideration ...
Attached Files
File Type: zip LoanCalculator.zip (247.5 KB, 10 views)
File Type: zip Mortgage_Calculator.zip (338.1 KB, 12 views)
Reply With Quote
  #4  
Old 01-19-2021, 11:28 AM
hendrikbez hendrikbez is offline mortgage calculator excel sheet Windows 7 64bit mortgage calculator excel sheet Office 2016
Novice
mortgage calculator excel sheet
 
Join Date: Nov 2016
Posts: 11
hendrikbez is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 01-19-2021, 11:31 AM
Logit Logit is online now mortgage calculator excel sheet Windows 10 mortgage calculator excel sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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.
Reply With Quote
  #6  
Old 01-19-2021, 11:34 AM
hendrikbez hendrikbez is offline mortgage calculator excel sheet Windows 7 64bit mortgage calculator excel sheet Office 2016
Novice
mortgage calculator excel sheet
 
Join Date: Nov 2016
Posts: 11
hendrikbez is on a distinguished road
Default

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.
Reply With Quote
  #7  
Old 08-06-2023, 11:47 AM
Logit Logit is online now mortgage calculator excel sheet Windows 10 mortgage calculator excel sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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 ?
Reply With Quote
  #8  
Old 08-11-2023, 07:13 AM
xor xor is offline mortgage calculator excel sheet Windows 11 mortgage calculator excel sheet Office 2021
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

https://www.youtube.com/watch?v=Nv1I3eOmlXc
Reply With Quote
Reply

Tags
home loan

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mortgage calculator excel sheet 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 calculator excel sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft