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.61Do 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]