The example is ... an example. It relates nothing to my financial purchase at all. I was merely showing with a graphical representation what my goal is to achieve.

---

You were looking to achieve a $100,000 car?

Thanks for trying to help, greatly appreciate it.

---

Z-just trying to have fun in principle while we figure out how to help. Your example looks good, but I would add a column for your additional payments so that you can do a comparison between alternatives.

The amount of the payment going to interest would be calculated off of the interest rate and the principal balance.

Your principal should be calculated from your previous principal minus the difference between your interest owed from your previous payment and the total amount of your previous payment, with 100% of whatever extra payment you make coming off the principal.

So, principlely, I'd recaclulate the interest each payment, since the principal remaining would change each period. You would just have to modify your principal column to subtract out the additional payment in the previous row.

---

There's this thing called the "Internet." On the internet is an outfit called "Google."

You can then find something like this:

http://www.ezcalculator.com/paybreak.htm 

And yes, if you Wiki "Asshole" you'll find my picture there. 😛

---

I did check the internet, found several items, but none of which I'm seeking. How else do you think I found the graphic?


It's extremely insulting and offensive to be told to use the internet, especially when you're talking to a guy who once googled how to tie a tie half hour before a job interview.

---

I hope you had a suit to go along with the tie. 🙂

---

use a Pert formula, you should be able to create an algebraic expression to find the values you want.

Pert formula 

you will need a multi-line calculator and no how to compute logarithms.

---