Calculating Your Charged Interest Rate In Excel

Excel spreadsheets (.xls)

You would think that finding the interest rate being paid on a credit card or another type of loan would be easy right? I mean, the statements generally do include the interest rate that you are being charged. Of course, there are many different ways to present an interest rate and while the ideal and most representative way would be to always include the effective rate, it is not always in the advantage of the lender to present it that way. Why? Because that rate is generally higher and could encourage you to look for a better deal. The companies figure that consumers will not see the difference and in almost all cases they are correct.

Here is a simple way to calculate your charged interest rate, in this example we will use a simple loan but this could be adapted to a number of different situations. You will need a number of different information in order to make the calculation.

End of last period: August 25th
End of this period: September 23rd
Outstanding Loan at the last period: $18,575.00
Interest Rate Charged: $111

Let’s review the formula to calculate interest:

Interest = Loan Amount * Interest Rate * (nb days/365)

In this case, we are missing the interest rate so we will shuffle around the formula:

Interest Rate = Interest / (Loan Amount/ (nb days/365)

In our example that would be:

Interest Rate = $111/18575/(29/365) = 7,52%

See a chart here or you can even download the spreadsheet here


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


65 Feedbacks on "Calculating Your Charged Interest Rate In Excel"

seo packages

Hello there! I could have sworn I’ve been to your blog before but after looking at a few of the posts I realized it’s
new to me. Nonetheless, I’m definitelky pleased I came acoss it
and I’ll bbe book-marking it and checking back regularly!

how can you make money online for free

Hi i am kavin, its my first occasion to commenting anyplace, when i read
this post i thought i could also create comment due to this brilliant article.

8 ball pool adventure quest worlds cheats codes

all the time i used to read smaller posts which as well clear their motive,
and that is also happening with this article which I am
reading here.

John Zack black lace dress

If some one wishes expert view about blogging and site-building afterward i propose him/her to go to see this webpage, Keep up the pleasant work.


Simply wish to say your article is as astonishing.
The clearness in your post is just cool and i couldd assume you’re an expewrt on this subject.
Well with your permission allow me to grab your RSS feed to keep up to date with forthcoming post.
Thanks a million and please continue the rewarfding work.

vegetarian recipes

Excellent post. I will be experiencing some of these issues as well..

Terminology can differ extensigely on bridge loans having soure costs which might bee
high. If you’re currently creating a genuine effort to save cash,
bbut anyone are being spent by your partner into debts, the combat will be lost by you.
Should you cannot or don’t mmight like to do that,
contemplate marketing off additional assets or funding against ykur 401(k).
_ Bewade of hdden fees such as for instance credit insurance.
Spend it-how you’ll, but be sure to rspay it according to the arranged terms.

In light of this truth, don’t hurry the method
— look around until you locate a lender using suitable fasxcination rates.
and a uperior background – Examine when the loan will be immediately restored, to view if fee is nnot produced on the loan. None of this
transporting debt forever by spending minimal lowest monthly premiums that scarcely
make a dimple within the principal balance duee just as in credit cards.
Lowering will also let you save wwll on medical care expenses later onn
if ingexting or smoking can be your vice and doable allow you
to entitlled to reduced insurance fees. Contemplate
setting a loan that is personal up with a family or friend member.
Your ability to repay your current short tsrm debts could
be hampered by taking up addirional debt.
short term paday loans for bad credit (
Own it specifically transferred into your savings account or fund
that is mutual. Poular online lenders for individual loans contaon andd which equally link debtors that
are individual usding specific lenders. It could be refunded in installents or all
at one time. But that is precisely what you have to do.
Longer-terms provides you with a lower fee, nevertheless, you offten end up spending additional
in interest.

Your absolute best wager is alwqays to prevent setting yourself up for
this location within the first-place. Whatever your poor routine might be,
you know it could get expensive. Your credit will be looked at by
many payday lian organizations, however they will not
maintain it against you.- While looking for lenders that ofer qjickly cash loans to short-term, attempt staying with the world wide web.
There are a plethora of rapidxly funds lenders only itching to have you as
being a buyer, indicating when it comes to fees and interest you will end up offered a lot of
wonderful savings. Therefore, be sure you possesss a ayment strategy set uup beflre you take-out a loan.


You could definitely see your enthusiasm within the article you write.

The world hopes for more passionate writers such as you who are not afraid to mention how they
believe. All the time follow your heart.


Woah! I’m really digging the template/theme of this site.
It’s simple, yet effective. A lot of times it’s tough
to get that “perfect balance” between usability and appearance.
I must say you have done a superb job with this. Additionally, the blog loads
very fast for me on Safari. Excellent Blog!


Nice blog right here! Also your web site rather a lot up fast!
What web host are you the use of? Can I get your
associate hyperlink in your host? I desire my website loaded
up as fast as yours lol


It’s remarkable in favor of me to have a website,
which is good in support of my know-how. thanks admin


Excellent post. I was checking constantly this blog and I’m inspired!
Very useful information specifically the final part :) I
take care of such info a lot. I used to be seeking this certain information for a very lengthy time.
Thank you and best of luck.

customize your own black skateboard

customize your own black skateboard

Calculating Your Charged Interest Rate In Excel | Experiments in Finance

in the know

in the know

Calculating Your Charged Interest Rate In Excel | Experiments in Finance


thanks for this great info, excel is hard to work with, if there was no helpful info like yours.