hi all,
i am new to iPhone
Can anyone tell me the math behind this MS Excel functions. I am writing software for iPhone and I am unable to use
Excel to calculate these but I still need the same result.
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
i am new to iPhone
Can anyone tell me the math behind this MS Excel functions. I am writing software for iPhone and I am unable to use
Excel to calculate these but I still need the same result.
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