Mortgage Calculator

Hi,

I’m trying to set up your mortgage calculator, I have used my own formulas in the “Advanced settings” part of the app and added my own formula but this hasn’t given the price we are expected to see.

We have tried the following formulas –

[86]([87]/1200)(1+[87]/1200)^(12[88])/(1+[87]/1200)^(12[88]-1)

[86]((([87]/1200)))(1+[87]/1200)^((12[88]))/((1+[87]/1200))^(12[88])-1

[86]((([87]/1200)))(1+[87]/1200)^((12[88]))/((1+[87]/1200))^(12[88]-1)

[86]((([87]/1200)))((1+[87]/1200))^(12[88])/((1+[87]/1200))^(12[88])-1

[86]([87]/1200)((1+[87]/1200))^(((12[88])))/((1+[87]/1200))^(((12[88])))-1

and none of these have given us the expected figures that we need/want to see.

The figures we expect to see are as follows –

<u>95% LTV</u>

Loan amount: ￡247,000

Deposit: ￡13,000

4.89% - 31 years

Wellesley Calculator -?￡1,221.52 (￡74.59 less)

Mortgage Illustration - ￡1,296.11?

<u>90% LTV</u>

Loan amount: ￡270,000

Deposit: ￡30,000

4.94% - 35 years

Wellesley Calculator -?￡1,202.08 (￡144.72 less)

Mortgage Illustration - ￡1,346.80?

<u>85% LTV</u>

Loan amount: ￡243,350

Deposit: ￡43,160

4.69% - 40 years

Wellesley Calculator -?￡927.18 (￡201.34 less)

Mortgage Illustration - ￡1,128.52?

<u>75% LTV</u>

Loan amount: ￡210,000

Deposit: ￡70,000

4.43% - 34 years

Wellesley Calculator -?￡664.62 (￡326.78 less)

Mortgage Illustration - ￡991.40?

<u>56% LTV - BTL</u>

Loan amount: ￡155,500

Deposit: ￡119,500

3.75% - 21 years

Wellesley Calculator -?￡206.44 (same result as before)

Mortgage Illustration - ￡490.61

Do you have any advice on how we can get this to work?

Many thanks

The page I need help with: [log in to see the link]