Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hottea11
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vandenberg p
 
Posts: n/a
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XNPV vs. NPV(quarterly) different results magis Excel Worksheet Functions 3 January 6th 06 05:21 PM
how do I calculate a monthly payment based on a variable rate? Chick N Egg Excel Worksheet Functions 1 November 17th 05 09:00 PM
Calculate the time an employee signed in and out plus rate per hr Allan Excel Discussion (Misc queries) 2 November 7th 05 11:01 PM
Calculate Interest Rate when payment changes! huntermcg Excel Worksheet Functions 2 October 25th 05 08:32 AM
Calculate time and cost Sjoestaal Excel Worksheet Functions 2 March 31st 05 01:47 PM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"