Forum Discussion
FIguring loan term left, and amortization of loan value remaining
Hey Guys What I'm looking for is an easy way to take a list of date that has a recorded date (title), and recorded loan amount to figure out how much loan amount "should be" remaining in order to...
Tell me are you looking for loan amortization process and finally wanna to mail all about remaining amount ?
Yes.
What i want to do is pull information from lets say a loan that was recorded on 2017 with a loan amount of 150,000$, have excel figure out what the amortized amount remaining would be today, and put that on a word postcard mailer...but have it autonomously do it for 1700 other line items as well