Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to compute interest rate from principal and interest amount
Principal amount $100
interest amount $2 i need to repay $102 in 24 instalments i want the function in excel to compute the interest rate for the computing the interest rate one month so that the principal plus the interest for 24 months cumulates to $102 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
to compute interest rate from principal and interest amount
=RATE(24,102/24,-100,102)
-- Kind regards, Niek Otten "PVJ" wrote in message ... Principal amount $100 interest amount $2 i need to repay $102 in 24 instalments i want the function in excel to compute the interest rate for the computing the interest rate one month so that the principal plus the interest for 24 months cumulates to $102 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
to compute interest rate from principal and interest amount
PVJ,
Loan: $100 Interest rate: 1.91 % Term: 2 years Payments per year: 12 Number of payments: 24 Payment at end of period. Payment: $4.25 Total payments: $102 See my free Excel add-in "Calculate Payments". Provide any 3 and the fourth is calculated... amount, interest rate, term, payment. One click transfer to the worksheet. http://www.realezsites.com/bus/primitivesoftware Jim Cone San Francisco, USA "PVJ" wrote in message Principal amount $100 interest amount $2 i need to repay $102 in 24 instalments i want the function in excel to compute the interest rate for the computing the interest rate one month so that the principal plus the interest for 24 months cumulates to $102 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
to compute interest rate from principal and interest amount
try
=RATE(24,-102/24,100,0,1) "PVJ" wrote in message ... Principal amount $100 interest amount $2 i need to repay $102 in 24 instalments i want the function in excel to compute the interest rate for the computing the interest rate one month so that the principal plus the interest for 24 months cumulates to $102 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interest Functions | Excel Worksheet Functions | |||
Formula which splits principal & interest pmts on P&I Loan | Excel Worksheet Functions | |||
Function help with Calculating Interest for two different investme | Excel Worksheet Functions | |||
Extra Payments go toward principal or interest in template? | Excel Discussion (Misc queries) | |||
Data $9,620,320 principal, 360 # payments, 9 % rate, fv 0. Why do. | Excel Worksheet Functions |