mortgage calculator

Howdy my name is Chadd I'm a mortgage loan officer. I am looking to create a Home Equity Line of Credit calculator. I need the ability to see the amortization / payment / payoff term given the rate adjusting throughout the term years. I've seen amortization templates however they come with...

Hi Everyone, With the way things have become over the past few years, I decided to use my time wisely and started to keep a tab on a few things, one of which is my mortgage. However, I wanted something much more in depth and struggled to find much, specially when it came to variable loan (with...

Hi there I cannot seem to get the mortgage/loan bank statement replicated in excel. Can someone please help? I think it has something to do with when they change rates based on the number of day. I think they use exact days. You can see at the top of the statement the rates and the date...

Here I have 3 pictures of a worksheet I'd like to create. The worksheet is on house mortgages I'm supposedly buying. I want to be able to delete them and put them in and have the ease of starting each one by buying and selling property at different months in the year period. Month 1: Imgur...

I'm trying to build a function to calculate the closing costs associated with certain loan parameters. Example here is 30yr loan, note rate is 4.125, APR is 4.198, loan amount $200,000. I can figure out the APR using the =RATE function, having the total closing costs already on hand. In this...

I know how to make a mortgage calculator for a fixed rate, but how would i go about making one if the rate changes every period (i already have these changing rates, the loan amount and the number of periods), what VBA codes would i write?

Hello! I am trying to make a mortgage calculator and I'm ok with most of it but I'm hoping someone can help me with something I'm stuck on. I need the user to choose what they are trying to find out. Either they want to find the amount they need to borrow or they want to find out the amount...