168666 Convert Excel RATE() into Code

Closed

Description

We require a programmer to create a script that replicates the Excel function RATE(). The RATE() function is used in Excel to calculate the comparison rate (or effective interest rate) where the repayment value, no. of repayments and initial loan value are known.

We already have a loan calculator which can be seen at [url removed, login to view], (enter a loan amount and interest rate). You will see that the 'Comparison Rate' is currently not functioning.

The script must cater for loans of different duration and must include the loan costs (settlement fees) charged to the borrower.

For reference look at the website [url removed, login to view]

You must test the script you create against a range of different starting values to make sure that the correct result is achieved each time.

Finally insert the script into our existing loan calculator and output the result to the Loan Calculator MySQL DB(already created). You will need to use Ajax for data communication.

**To get this script right you will need to understand the simple maths behind the RATE() function**

Previous work: Provide only 1 example a of relevant project

Communication: Daily via email

Timeframe: Completion within 2-3 days of award

Thanks for Bidding!

Skills: AJAX, Anything Goes, Javascript, MySQL, PHP

See more: effective interest formula, www excel, www code org, rate of programmer, project calc, need of excel programmer, maths website, get right code, convert excel to website, convert excel calculator to html, code org 1, calculator programmer code, calculator html javascript code, repayment, rate, Maths project, loan calculator, excel tools, excel to html, excel html, excel function, excel formula, excel calculator, convert to ajax, calc

Project ID: #1914862

Awarded to:

tamilsweet

Hope you remember me!!!

$25 USD in 1 day
(43 Reviews)
4.5