Build an excel calculator for loan comparison rates

Build an excel calculator for loan comparison rates

Closed - This job posting has been filled.

Job Description

I need to build an excel calculator to replicate the web based calculator found here:
http://intranets.canstar.com.au/sgb/sgbaapr.php.

This will require excell skills and an understanding of maths to replicate the calculator.
I have attempted to do this and had some success with the standard variable loan option
but am unable to replicate for the fixed rates. I will attach the excel work thus far.

The scenario's required are: 1-5 year fixed rate only as have the standard variable working already.

Open Attachment