Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Mortgage interest rate calculations for several rows of individual data


I get data from title companies in Excel format to send direct mail to new clients.  There are certain rows with loan amounts and certain rows where new interest rates would fall under.  I want to create a macro to go row by row and calculate new payment amount in 30 year fixed rate loans.  My data sheets have 3,000 plus counts of individuals with an existing loan to refinance.  This spreadsheet will then be paired to a mail merge in Word documents.  I know the formulation from your video on Youtube called How to make a Fixed Rate Loan/Mortgage Calculator in Excel from 2008.  I think it is great that a video from so long ago is still very useful today.  Thank you for your knowledge.


Answer the Question

You must create an account to use the forum. Create an Account or Login