17BII, 27S: doing TVM calculations inside solver equations

05012019, 02:28 PM
(This post was last modified: 05012019 02:36 PM by Csaba Tizedes.)
Post: #6




RE: 17BII, 27S: doing TVM calculations inside solver equations
(05012019 12:58 PM)Dave Britten Wrote: I'll explain the specific problem in more detail, in case there's an easier way to do it that doesn't involve TVM. Two notes to this:
Therefore in real life the good solution to calculate the required periods to reduce the PV below your monthly payment, and then you can pay the whole PV. So, you need to make a table: 1st Coloumn: Your prepayment (eg. in every 6 periods or every 12 periods), 2nd Coloumn: The required N for reducing PV<=PMT With this table you can easily decide what is the preferred prepayment or N for you. Csaba 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)