15,611,970 members
Home / Discussions / Algorithms

# Algorithms

 Re: decimal to binary pattern using mantissa and exponents CPallini25-Mar-09 3:44 CPallini 25-Mar-09 3:44
 Re: boolean expression Luc Pattyn24-Mar-09 4:57 Luc Pattyn 24-Mar-09 4:57
 Re: boolean expression Roger Wright1-Apr-09 19:59 Roger Wright 1-Apr-09 19:59
 Re: logic diagram Alan Balkany24-Mar-09 3:49 Alan Balkany 24-Mar-09 3:49
 Code to find BER and MSE Reshma Naik24-Mar-09 2:27 Reshma Naik 24-Mar-09 2:27
 Maths behind CUMIPMT function of MS Excel Rupesh Kumar Swami21-Mar-09 21:30 Rupesh Kumar Swami 21-Mar-09 21:30
 hi all, Can anyone tell me the math behind this MS Excel functions. I am writing software for iPhone and I want to use the functionality like CUMIPMT function of Excel to calculate interest CUMIPMT(rate,nper,pv,start_period,end_period,type) Returns the cumulative interest paid on a loan between start_period and end_period. CUMIPMT(rate,nper,pv,start_period,end_period,type) Rate is the interest rate. Nper is the total number of payment periods. Pv is the present value. Start_period is the first period in the calculation. Payment periods are numbered beginning with 1. End_period is the last period in the calculation. Type is the timing of the payment. Type Timing 0 (zero) Payment at the end of the period 1 Payment at the beginning of the period Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11
 Re: Maths behind CUMIPMT function of MS Excel 73Zeppelin21-Mar-09 23:50 73Zeppelin 21-Mar-09 23:50
 Re: Maths behind CUMIPMT function of MS Excel Roger Wright22-Mar-09 18:36 Roger Wright 22-Mar-09 18:36
 Re: Maths behind CUMIPMT function of MS Excel 73Zeppelin22-Mar-09 21:52 73Zeppelin 22-Mar-09 21:52
 Re: Maths behind CUMIPMT function of MS Excel Roger Wright23-Mar-09 2:25 Roger Wright 23-Mar-09 2:25
 Re: Maths behind CUMIPMT function of MS Excel 73Zeppelin23-Mar-09 3:38 73Zeppelin 23-Mar-09 3:38
 Re: Maths behind CUMIPMT function of MS Excel Roger Wright23-Mar-09 19:28 Roger Wright 23-Mar-09 19:28
 Re: AI ? Arash Partow21-Mar-09 23:42 Arash Partow 21-Mar-09 23:42
 Re: AI ? jk chan23-Mar-09 0:13 jk chan 23-Mar-09 0:13
 Re: AI ? Alan Balkany23-Mar-09 3:42 Alan Balkany 23-Mar-09 3:42