I'm looking for a complete script in either ASP VBScript or VB to
calculate the interest repayable on a loan.

Here are the known inputs:
Nominal Interest Rate
Loan Amount (Principal)
APR
Term

I need to calculate:
Interest Repayable

Once I have this I can calculate:
Total Repayable (Principal + Interest Repayable)
Monthly Repayment (Total Repayable / Term)

To clarify, I am not interested in being told about functions within
VB or Excel that are related, nor links to similar scripts.  I am
looking for specifically a script that acommodates the above inputs.

If you require more information post here or email me at
craig.pollard@fundamentum.co.uk

Best regards,
CRAIG POLLARD

---

Request for Question Clarification by kyrie26-ga on 20 Aug 2002 15:13 PDT

I know where to find you some VB financial calculator programs, which
deal with the variables you mentioned (except for APR which is
derived). Would it be sufficient to point you to the script(s), I
mean, to what extent are you prepared to customize a script? You do
realize that it will be very hard to find a program that's a 100% fit
for what you're looking for. What is your lowest accepted "percentage
match"?

Thanks in advance,

kyrie26-ga

---

Request for Question Clarification by kyrie26-ga on 20 Aug 2002 15:34 PDT

pollard_craig-ga :

One more thing - most financial calculators will work with Total
Repayable, but not Interest Repayable since it can be derived from
(Total Repayable - Principal). Therefore, I can find you a program
that will input Nominal Interest Rate, Principal and Term, and output
Total Repayable. Is this acceptable?


Thanks,

kyrie26-ga

---

Clarification of Question by pollard_craig-ga on 21 Aug 2002 02:20 PDT

Hi, in answer to your questions:

1) Total Repayable (not interest repayable) is fine because as you
point out this can be derived.

2) 90% fit 

3) This is to support an web quotation tool and must be suitable for
this purpose.

4) Ideally, any script should meet the standards set out by the UK
Office of Fair Trading.  See
http://www.oft.gov.uk/NR/rdonlyres/e7b2kpq4tmeo6e6udzwxcw25s5a4kygku3obp3vtzcvbw5fgx2hv2mw2vykta7c3hropy776x56wg4jb222k6dku2kd/oft144.pdf
for more information.