debt

[jonah2.0]

Beer drenched approval follows.

Rate​

16%​

Initial Balance​

10,595​

​

Month​	Payment​	Interest​	Payment after Interest​	Ending Balance​
1​	250​	141.27​	108.73​	10486.27​
2​	250​	139.82​	110.18​	10376.09​
3​	250​	138.35​	111.65​	10264.44​

I thought to show my calculation for the first three months before I do it in the excel. What do you think of it?

It's all good.
I'll show you the so called Retrospective method of determining the outstanding balance at the end of the nth payment period in just a few minutes.

 

[jonah2.0]

Beer assisted reckoning follows.

Rate​

16%​

Initial Balance​

10,595​

​

Month​	Payment​	Interest​	Payment after Interest​	Ending Balance​
1​	250​	141.27​	108.73​	10486.27​
2​	250​	139.82​	110.18​	10376.09​
3​	250​	138.35​	111.65​	10264.44​

I thought to show my calculation for the first three months before I do it in the excel. What do you think of it?

If you implement the the odd-add rule of rounding in your excel spreadsheet, you'll find that the outstanding balance you get will correspond exactly with the theoretical balance of the Retrospective method. Well, almost, I think. I can't remember anymore. Alzheimer's is beginning to takeover my mind.

 

[logistic_guy]

Come on man

You're super Genius. Even if I read the chapter, I would not be able to come up with this shortcut formula.

SoooooooooO beautiful Sir jona\(\displaystyle 2.0\)

The idea is just to set up this formula and solve for \(\displaystyle x\). I'll let \(\displaystyle \text{W|A}\) do the calculations!

\(\displaystyle 10595\left(1+\frac{0.16}{12}\right)^{x}-250\left[\left(1+\frac{0.16}{12}\right)^{x}-1\right]\frac{12}{0.16}=0\)

\(\displaystyle x \approx 63 \ \text{months}\)

I will still do it with the excel and compare. I know that they should give the same result. Soon, I'll show you a screenshot!

 

[jonah2.0]

Beer assisted reckoning follows.

Come on man

You're super Genius. Even if I read the chapter, I would not be able to come up with this shortcut formula.

SoooooooooO beautiful Sir jona\(\displaystyle 2.0\)

The idea is just to set up this formula and solve for \(\displaystyle x\). I'll let \(\displaystyle \text{W|A}\) do the calculations!

\(\displaystyle 10595\left(1+\frac{0.16}{12}\right)^{x}-250\left[\left(1+\frac{0.16}{12}\right)^{x}-1\right]\frac{12}{0.16}=0\)

\(\displaystyle x \approx 63 \ \text{months}\)

I will still do it with the excel and compare. I know that they should give the same result. Soon, I'll show you a screenshot!

Thou art correct Mario.
That is just as beautiful.
62 months of 250 plus a smaller payment for the 63rd month.
I hope you've realized how much more detailed it is to work with Zima and Brown's books.
It's slightly easier with the amortization equation.

 

[jonah2.0]

Beer drenched ramblings follows.

Beer assisted reckoning follows.


Thou art correct Mario.
That is just as beautiful.
62 months of 250 plus a smaller payment for the 63rd month.
I hope you've realized how much more detailed it is to work with Zima and Brown's books.
It's slightly easier with the amortization equation.

View attachment 39185

It's strange that Maple gives a slightly different value from my Desmos reckoning.
Maybe it's because I used a fraction for the interest period.

 

[jonah2.0]

Beer drenched ramblings follows.

...
It's strange that Maple gives a slightly different value from my Desmos reckoning.
Maybe it's because I used a fraction for the ...

Freaking Maple calculator!