168666 Convert Excel RATE() into Code

This project was awarded to tamilsweet for $25 USD.

Get free quotes for a project like this
Project Budget
Total Bids
Project 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!

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online