Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculating term of financial transaction
If I know the amount financed is $1,000 and the interest is $268.91 and the
interest rate is 24% and that is all I know, how do I work out the term of the loan? In this example the answer is 24months but I would like to know how to use an excel function to achieve the result. I am assuming I don't know the instalment Regards -- bookman |
#2
|
|||
|
|||
You can use a combination of CUMIPMT and Goal Seek.
First, in, for example, a1, enter the formula: =CUMIPMT(24%/12,a2,1000,1,a2,0) When a2 has the correct term, this function will calculate the total interest of the loan. Use Goal Seek to vary a2 until a1 returns $268.91. -- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... If I know the amount financed is $1,000 and the interest is $268.91 and the interest rate is 24% and that is all I know, how do I work out the term of the loan? In this example the answer is 24months but I would like to know how to use an excel function to achieve the result. I am assuming I don't know the instalment Regards -- bookman |
#3
|
|||
|
|||
This should work in principle but I didn't get the expected result.
But anyway thanks for your help Bookman -- bookman "Fred Smith" wrote: You can use a combination of CUMIPMT and Goal Seek. First, in, for example, a1, enter the formula: =CUMIPMT(24%/12,a2,1000,1,a2,0) When a2 has the correct term, this function will calculate the total interest of the loan. Use Goal Seek to vary a2 until a1 returns $268.91. -- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... If I know the amount financed is $1,000 and the interest is $268.91 and the interest rate is 24% and that is all I know, how do I work out the term of the loan? In this example the answer is 24months but I would like to know how to use an excel function to achieve the result. I am assuming I don't know the instalment Regards -- bookman |
#4
|
|||
|
|||
What result did you get? Let us know so we can help you get what you want.
-- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... This should work in principle but I didn't get the expected result. But anyway thanks for your help Bookman -- bookman "Fred Smith" wrote: You can use a combination of CUMIPMT and Goal Seek. First, in, for example, a1, enter the formula: =CUMIPMT(24%/12,a2,1000,1,a2,0) When a2 has the correct term, this function will calculate the total interest of the loan. Use Goal Seek to vary a2 until a1 returns $268.91. -- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... If I know the amount financed is $1,000 and the interest is $268.91 and the interest rate is 24% and that is all I know, how do I work out the term of the loan? In this example the answer is 24months but I would like to know how to use an excel function to achieve the result. I am assuming I don't know the instalment Regards -- bookman |
#5
|
|||
|
|||
Actually I can't gwet it to work.
If I put the CUMIPMT function in Cell a1 with a reference to cell A2 then goal seek set a1 t0 -268.91 by changing cell A2 if iI leave A2 blank it won't work at all If I put a number (eg 10) in cell A2 I get a different result each time when I know in this case the correct solution is 24 Regards Bookman -- bookman "Fred Smith" wrote: What result did you get? Let us know so we can help you get what you want. -- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... This should work in principle but I didn't get the expected result. But anyway thanks for your help Bookman -- bookman "Fred Smith" wrote: You can use a combination of CUMIPMT and Goal Seek. First, in, for example, a1, enter the formula: =CUMIPMT(24%/12,a2,1000,1,a2,0) When a2 has the correct term, this function will calculate the total interest of the loan. Use Goal Seek to vary a2 until a1 returns $268.91. -- Regards, Fred Please reply to newsgroup, not e-mail "bookman3" wrote in message ... If I know the amount financed is $1,000 and the interest is $268.91 and the interest rate is 24% and that is all I know, how do I work out the term of the loan? In this example the answer is 24months but I would like to know how to use an excel function to achieve the result. I am assuming I don't know the instalment Regards -- bookman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
How do I change the "Project Type" in "law Firm Financial Analys.. | Excel Discussion (Misc queries) |