Need Excel Help on a Loan Sheet

SIGforum

This topic can be found at:
https://sigforum.com/eve/forums/a/tpc/f/320601935/m/6440079254

February 03, 2019, 04:09 PM

Timdogg6

Need Excel Help on a Loan Sheet

I want to have a loan calculator where I can add in extra payments in a given month. All of the templates show me an extra payment which is then applied to every month.

I need to be able to have a column where if in a month my borrower makes an extra $150 payment, it will reduce principal and keep running. without me changing anything.

Anyone have something like this?

February 03, 2019, 04:14 PM

vthoky

I believe I have what you're looking for.
As the table populates, you can replace the math in the relevant "extra payment" cell with an actual value, and it will take that value and run with it. You've got email incoming.

Politicians seem to have forgotten that they work for us, not the other way around.
— — — — — — — — — — — —
God bless America.

February 03, 2019, 04:49 PM

Timdogg6

Tech for the WIN!

Thank you my man!!

February 03, 2019, 04:57 PM

SigSAC

I've been using this spreadsheet for several years.

https://www.vertex42.com/Calcu...gage-calculator.html

February 03, 2019, 04:59 PM

vthoky

Glad to help, Tim!

Politicians seem to have forgotten that they work for us, not the other way around.
— — — — — — — — — — — —
God bless America.

February 03, 2019, 10:20 PM

Edmond

quote:
Originally posted by SigSAC:
I've been using this spreadsheet for several years.

https://www.vertex42.com/Calcu...gage-calculator.html

Thank you for that, SigSAC.

We are in the process of looking for our first home. At the ripe age of 40, I will be a first time home buyer.

February 04, 2019, 12:56 AM

Rey HRH

quote:
Originally posted by Edmond:
quote:
Originally posted by SigSAC:
I've been using this spreadsheet for several years.

https://www.vertex42.com/Calcu...gage-calculator.html

Thank you for that, SigSAC.

We are in the process of looking for our first home. At the ripe age of 40, I will be a first time home buyer.

Local governments often have subsidies for first time home buyers. It wouldn’t hurt to look at those options if available.

And I actually like that excel file. The chart and the header blocks make it snazzy

"It did not really matter what we expected from life, but rather what life expected from us. We needed to stop asking about the meaning of life, and instead to think of ourselves as those who were being questioned by life – daily and hourly. Our answer must consist not in talk and meditation, but in right action and in right conduct. Life ultimately means taking the responsibility to find the right answer to its problems and to fulfill the tasks which it constantly sets for each individual." Viktor Frankl, Man's Search for Meaning, 1946.