[access-uk] Re: Calculating APR on a loan
- From: "Mike Moore" <mikeis@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 25 Apr 2012 21:44:31 +0100
Andy,
Try this site, it is accessible:
<http://www.efunda.com/formulae/finance/a.>
http://www.efunda.com/formulae/finance/a.
For the additional fee, this would apply to a setup fee etc. If not
applicible input 00.
Kind regards,
Mike
_____
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
david pritchard
Sent: 25 April 2012 21:30
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Calculating APR on a loan
Hi Andy,
You can use the PMT function in Excel. I can dig out an example if required.
Regards
Dave
From: ANDY COLLINS <mailto:Andy@xxxxxxxxxxxxxxxxxxx>
Sent: Wednesday, April 25, 2012 9:09 PM
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Calculating APR on a loan
Hi all -
Hope I'm ok asking this here. I've been looking on some websites, and
unfortunately their calculater tools for working out monthly repayments on a
loan with an APR, require the sliding of a graphical bar across a grid. So,
can anybody tell me how to work out monthly repayments using APR interest.
Let's work with an easy example, if one borrows 10 thousand pounds, and the
APR is 6 percent, how does one work out the monthly repayments over say 1
and 2 and 3 years? I can work out 6 percent of 10 grand, but it doesn't work
that way, so anybody help with this one?
Thanks -
Andy
Other related posts:
