Mortgage Calculator / Buy vs Rent Calculator
Amend yellow cells as appropriate
A B C Purchase price of property Deposit Size of mortgage =A-B. £180,000 £18,000 £162,000 25 R £0 2.00% 3.00% 1.00% % of house value % of house value % of house value "R" for repayment, "I" for interest only
For Buy vs Rent Calculator
O Annual Rent Use this to see difference between buying and renting in Table 2 below
Duration of Mortgage (in years) Repayment or Interest Only Mortgage payable at end of term D E F Buying costs (stamp duty and other fees) Selling costs (estate agents fee) Annual maintenance cost of ownership
Table 1: Position of Buyer
G=AxD Year Cost of Mortgage buying rate % house (3,600) 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% 6.00% H Annual mortgage payment 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 12,525 0 0 0 0 0 0 0 0 0 0 I. Of which: interest element (9,642) (9,464) (9,275) (9,074) (8,862) (8,636) (8,396) (8,141) (7,871) (7,583) (7,279) (6,955) (6,612) (6,247) (5,860) (5,448) (5,012) (4,549) (4,057) (3,534) (2,980) (2,391) (1,766) (1,102) (398) 0 0 0 0 0 0 0 0 0 0 =C-H+I J=FxA K Mortgage Annual Decrease/ remaining at maintenance Increase in end of year cost house prices % 159,116 156,055 152,804 149,354 145,690 141,800 137,671 133,287 128,632 123,690 118,444 112,874 106,960 100,681 94,016 86,939 79,426 71,449 62,980 53,989 44,444 34,310 23,550 12,127 0 0 0 0 0 0 0 0 0 0 0 (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) (1,800) 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
Total
313,130 (151,130)
Total Total mortgage interest paid payments to the required to mortgage purchase lender house