Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Total Premium $65156.40, downpayment $16289.10. Amount financed is $48867.30
and the finance charge is $1633.86. The payment amount is $5611.24 and the term is 9 months. The total of all payments is $50501.16. Does anyone know how the cost of credit figured as a yearly rate is determined for a scenario like this. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Use
=12*rate(9,-5611.24,48867.3) "Hottea11" wrote: Total Premium $65156.40, downpayment $16289.10. Amount financed is $48867.30 and the finance charge is $1633.86. The payment amount is $5611.24 and the term is 9 months. The total of all payments is $50501.16. Does anyone know how the cost of credit figured as a yearly rate is determined for a scenario like this. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello:
Almost. Since the rate that is computed is for a month to get the correct annual rate you should use: =(1+rate(9,-5611.24,48867.3))^12-1 If you want the rate of return on an annual basis. If you want the government required APR (which ignores inter-period compounding) then you multiple by 12. The difference is: the annual rate of return is 0.082507384 the APR is 0.079542468 Pieter Vandenberg Duke Carey wrote: : Use : =12*rate(9,-5611.24,48867.3) : "Hottea11" wrote: : Total Premium $65156.40, downpayment $16289.10. Amount financed is $48867.30 : and the finance charge is $1633.86. The payment amount is $5611.24 and the : term is 9 months. The total of all payments is $50501.16. Does anyone know : how the cost of credit figured as a yearly rate is determined for a scenario : like this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
how do I calculate a monthly payment based on a variable rate? | Excel Worksheet Functions | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
Calculate Interest Rate when payment changes! | Excel Worksheet Functions | |||
Calculate time and cost | Excel Worksheet Functions |