Post Reply 
TVM solve for interest rate, revisited
06-26-2024, 02:31 PM (This post was last modified: 06-27-2024 10:22 AM by Albert Chan.)
Post: #54
RE: TVM solve for interest rate, revisited
Found a nice rate formula! https://brownmath.com/bsci/loan.htm#LoanInterest
Any clue how q-to-rate method is derived? Why log2?

fv = 0
i0 = pmt/-pv
q = log2(1+1/n)                    → i ≈ ((1+i0)^(1/q)-1)^q-1

Or, let Q = 1/q ≈ n*log(2)      → (1+i)^Q ≈ (1+i0)^Q - 1

Example from previous post

lua> n, pv, pmt, fv = 525600, 0, -1, 526038.2426000326
lua> 1/(600*n)                  -- true rate
3.1709791983764586e-09

lua> n, pv, fv = -n, -fv, -pv -- time reversal to match formula
lua> i0 = pmt/-pv
lua> q = log2(1+1/n)
lua> EFF(APR(i0,q)-1, q)
3.1710141058643196e-09

lua> i0 - 1/(i0*n^2)           -- compare to I ≈ 1/P - P/N^2
3.1714139412113494e-09
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: TVM solve for interest rate, revisited - Albert Chan - 06-26-2024 02:31 PM



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