ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate the cost of credit figured as a yearly rate? (https://www.excelbanter.com/excel-worksheet-functions/81946-how-do-i-calculate-cost-credit-figured-yearly-rate.html)

Hottea11

How do I calculate the cost of credit figured as a yearly rate?
 
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.

Duke Carey

How do I calculate the cost of credit figured as a yearly rate?
 
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.


vandenberg p

How do I calculate the cost of credit figured as a yearly rate?
 
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.


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com