PC Review


Reply
Thread Tools Rate Thread

calculate weighted average effective interest rate

 
 
GK
Guest
Posts: n/a
 
      23rd Jun 2008
how do you calculate weighted average effective interest rate for small
businesses who have multiple number of overdrafts, overdrafts and other
liabilities.
 
Reply With Quote
 
 
 
 
Sam Wilson
Guest
Posts: n/a
 
      23rd Jun 2008
Add up the interest charge for each liability, divide this figure by the
total liabilty...

So if you've got £100 at 5%, and £200 at 7% the effective rate is
(5+14)/300, which is 6 and a bit.

Sam

"GK" wrote:

> how do you calculate weighted average effective interest rate for small
> businesses who have multiple number of overdrafts, overdrafts and other
> liabilities.

 
Reply With Quote
 
Jim
Guest
Posts: n/a
 
      23rd Jun 2008
So, what if the 100 was last year and the 200 was today?

"Sam Wilson" wrote:

> Add up the interest charge for each liability, divide this figure by the
> total liabilty...
>
> So if you've got £100 at 5%, and £200 at 7% the effective rate is
> (5+14)/300, which is 6 and a bit.
>
> Sam
>
> "GK" wrote:
>
> > how do you calculate weighted average effective interest rate for small
> > businesses who have multiple number of overdrafts, overdrafts and other
> > liabilities.

 
Reply With Quote
 
Sam Wilson
Guest
Posts: n/a
 
      23rd Jun 2008
I don't quite see what you're getting at - The weighted average is always
going to be the total interest charge over the total liability. Whether it's
an average over several liabilities, several years or both shouldn't matter?


"Jim" wrote:

> So, what if the 100 was last year and the 200 was today?
>
> "Sam Wilson" wrote:
>
> > Add up the interest charge for each liability, divide this figure by the
> > total liabilty...
> >
> > So if you've got £100 at 5%, and £200 at 7% the effective rate is
> > (5+14)/300, which is 6 and a bit.
> >
> > Sam
> >
> > "GK" wrote:
> >
> > > how do you calculate weighted average effective interest rate for small
> > > businesses who have multiple number of overdrafts, overdrafts and other
> > > liabilities.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Effective rate of Interest and Copounding Interest =?Utf-8?B?am5vcnRvbg==?= Microsoft Excel Worksheet Functions 3 13th Apr 2005 03:11 AM
Effective Annual Interest Rate John Microsoft Excel Worksheet Functions 2 3rd Apr 2005 04:52 PM
How do you calculate effective interest Connie Walsh Microsoft Excel Discussion 5 29th Aug 2004 03:56 PM
How to calculate compound interest given table of dates/interest rate Mike Deblis Microsoft Excel New Users 1 4th Feb 2004 04:27 AM
How to calculate compound interest given table of dates/interest rate Mike Deblis Microsoft Excel Misc 1 4th Feb 2004 04:27 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:42 PM.