Solving the TVM equation for the interest rate
12-05-2020, 04:31 PM (This post was last modified: 05-15-2022 02:58 PM by Albert Chan.)
Post: #27
 Albert Chan Senior Member Posts: 1,791 Joined: Jul 2018
RE: Solving the TVM equation for the interest rate
(04-15-2018 08:48 PM)Carsen Wrote:  Problem #1: n=32 PV=-6,000 FV=10,000 PMT=0 i=???

Problem #2: n=36 PV=13,000 PMT=-372.53 FV=0 i=???

Problem #3: n=36 PV=5,750 PMT=-176.89 FV=0 i=???

Problem #4: n=360 PV=75,000 PMT=-425.84 FV-0 i=???

I made function guess_i(n, pv, pmt, fv), fitting TVM of i as quadratics

lua> guess_i(32,-6000,0,10000) * 100
1.609567691201156
lua> guess_i(36,13000,-372.53,0) * 100
0.16925628259544864
lua> guess_i(36,5750,-176.89,0) * 100
0.5625600411596099
lua> guess_i(360,75000,-425.84,0) * 100
0.4601141074876585
 « Next Oldest | Next Newest »

 Messages In This Thread Solving the TVM equation for the interest rate - Dieter - 04-15-2018, 08:39 AM RE: Solving the TVM equation for the interest rate - Gamo - 04-15-2018, 10:46 AM RE: Solving the TVM equation for the interest rate - Dieter - 04-15-2018, 02:55 PM RE: Solving the TVM equation for the interest rate - Ángel Martin - 04-15-2018, 04:37 PM RE: Solving the TVM equation for the interest rate - ttw - 04-16-2018, 05:00 AM RE: Solving the TVM equation for the interest rate - Carsen - 04-15-2018, 05:30 PM RE: Solving the TVM equation for the interest rate - Dieter - 04-15-2018, 06:08 PM RE: Solving the TVM equation for the interest rate - Csaba Tizedes - 02-17-2020, 10:30 AM RE: Solving the TVM equation for the interest rate - Carsen - 04-15-2018, 08:48 PM RE: Solving the TVM equation for the interest rate - Dieter - 04-15-2018, 09:38 PM RE: Solving the TVM equation for the interest rate - Dieter - 04-16-2018, 06:34 PM RE: Solving the TVM equation for the interest rate - Jeff_Kearns - 04-19-2018, 02:56 PM RE: Solving the TVM equation for the interest rate - Dieter - 04-19-2018, 09:45 PM RE: Solving the TVM equation for the interest rate - Erwin - 02-13-2020, 06:00 AM RE: Solving the TVM equation for the interest rate - Albert Chan - 12-05-2020 04:31 PM RE: Solving the TVM equation for the interest rate - AndiGer - 04-16-2018, 03:44 AM RE: Solving the TVM equation for the interest rate - Gamo - 04-17-2018, 08:59 AM RE: Solving the TVM equation for the interest rate - Dieter - 04-17-2018, 06:50 PM RE: Solving the TVM equation for the interest rate - Gamo - 02-12-2020, 10:50 AM RE: Solving the TVM equation for the interest rate - Albert Chan - 02-12-2020, 12:31 PM RE: Solving the TVM equation for the interest rate - ttw - 02-12-2020, 03:41 PM RE: Solving the TVM equation for the interest rate - Albert Chan - 02-12-2020, 05:25 PM RE: Solving the TVM equation for the interest rate - ttw - 02-12-2020, 09:37 PM RE: Solving the TVM equation for the interest rate - Albert Chan - 02-12-2020, 11:40 PM RE: Solving the TVM equation for the interest rate - ttw - 02-12-2020, 09:54 PM RE: Solving the TVM equation for the interest rate - Gamo - 02-13-2020, 06:30 AM RE: Solving the TVM equation for the interest rate - Gamo - 02-13-2020, 10:42 AM

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