Sale Price of Home:

282000 (e.g.)

Percentage Down:

10 (%) (e.g.)

Length of Mortgage:

30 (years)

Annual Interest Rate:

6 (%)

Mortgage Payment Information

Down Payment:

€28,200.00

Amount Financed:

€253,800.00

Monthly Payment:

€1,521.66
(Principal & Interest ONLY)

Since you are putting LESS than 20% down, you will need to pay PMI (Private Mortgage Insurance), which tends to be about €55 per month for every €100,000 financed (until you have paid off 20% of your loan). This could add €139.59 to your monthly payment.

Monthly Payment:

€1,661.25
(Principal & Interest, and PMI)

Residential (or Property) Taxes are a little harder to figure out... In Massachusetts, the average resedential tax rate seems to be around $14 per year for every $1,000 of your property's assessed value.

Let's say that your property's assessed value is 85% of what you actually paid for it - €239,700.00. This would mean that your yearly residential taxes will be around €3,355.80 This could add €279.65 to your monthly payment.

TOTAL Monthly Payment:

€1,940.90
(including PMI and residential tax)

1

The down payment = The price of the home multiplied by the percentage down divided by 100 (for 5% down becomes 5/100 or 0.05)

€28,200.00 = €282,000.00 X (10 / 100)

2

The interest rate = The annual interest percentage divided by 100

0.06 = 6% / 100

The monthly factor = The result of the following formula:

3

The monthly interest rate = The annual interest rate divided by 12 (for the 12 months in a year)

0.005 = 0.06 / 12

4

The month term of the loan in months = The number of years you've taken the loan out for times 12

360 Months = 30 Years X 12

5

The montly payment is figured out using the following formula:
Monthly Payment = 25380000 * (00050 / (1 - ((1 + 00050)^-(360))))

The amortization breaks down how much of your monthly payment goes towards the bank's interest, and how much goes into paying off the principal of your loan.

Month

Interest Paid

Principal Paid

Remaing Balance

1

€1,269.00

€252.66

€253,547.34

2

€1,267.74

€253.92

€253,293.42

3

€1,266.47

€255.19

€253,038.23

4

€1,265.19

€256.47

€252,781.76

5

€1,263.91

€257.75

€252,524.01

6

€1,262.62

€259.04

€252,264.97

7

€1,261.32

€260.33

€252,004.63

8

€1,260.02

€261.64

€251,743.00

9

€1,258.71

€262.94

€251,480.05

10

€1,257.40

€264.26

€251,215.79

11

€1,256.08

€265.58

€250,950.21

12

€1,254.75

€266.91

€250,683.31

Totals for year 1

You will spend €18,259.91 on your house in year 1
€15,143.22 will go towards INTEREST
€3,116.69 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

13

€1,253.42

€268.24

€250,415.06

14

€1,252.08

€269.58

€250,145.48

15

€1,250.73

€270.93

€249,874.55

16

€1,249.37

€272.29

€249,602.26

17

€1,248.01

€273.65

€249,328.61

18

€1,246.64

€275.02

€249,053.60

19

€1,245.27

€276.39

€248,777.21

20

€1,243.89

€277.77

€248,499.43

21

€1,242.50

€279.16

€248,220.27

22

€1,241.10

€280.56

€247,939.71

23

€1,239.70

€281.96

€247,657.75

24

€1,238.29

€283.37

€247,374.38

Totals for year 2

You will spend €18,259.91 on your house in year 2
€14,950.99 will go towards INTEREST
€3,308.92 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

25

€1,236.87

€284.79

€247,089.59

26

€1,235.45

€286.21

€246,803.38

27

€1,234.02

€287.64

€246,515.74

28

€1,232.58

€289.08

€246,226.66

29

€1,231.13

€290.53

€245,936.13

30

€1,229.68

€291.98

€245,644.16

31

€1,228.22

€293.44

€245,350.72

32

€1,226.75

€294.91

€245,055.81

33

€1,225.28

€296.38

€244,759.43

34

€1,223.80

€297.86

€244,461.57

35

€1,222.31

€299.35

€244,162.22

36

€1,220.81

€300.85

€243,861.37

Totals for year 3

You will spend €18,259.91 on your house in year 3
€14,746.90 will go towards INTEREST
€3,513.01 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

37

€1,219.31

€302.35

€243,559.02

38

€1,217.80

€303.86

€243,255.15

39

€1,216.28

€305.38

€242,949.77

40

€1,214.75

€306.91

€242,642.86

41

€1,213.21

€308.44

€242,334.41

42

€1,211.67

€309.99

€242,024.43

43

€1,210.12

€311.54

€241,712.89

44

€1,208.56

€313.09

€241,399.80

45

€1,207.00

€314.66

€241,085.14

46

€1,205.43

€316.23

€240,768.90

47

€1,203.84

€317.81

€240,451.09

48

€1,202.26

€319.40

€240,131.68

Totals for year 4

You will spend €18,259.91 on your house in year 4
€14,530.22 will go towards INTEREST
€3,729.69 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

49

€1,200.66

€321.00

€239,810.68

50

€1,199.05

€322.61

€239,488.08

51

€1,197.44

€324.22

€239,163.86

52

€1,195.82

€325.84

€238,838.02

53

€1,194.19

€327.47

€238,510.55

54

€1,192.55

€329.11

€238,181.44

55

€1,190.91

€330.75

€237,850.69

56

€1,189.25

€332.41

€237,518.28

57

€1,187.59

€334.07

€237,184.22

58

€1,185.92

€335.74

€236,848.48

59

€1,184.24

€337.42

€236,511.06

60

€1,182.56

€339.10

€236,171.96

Totals for year 5

You will spend €18,259.91 on your house in year 5
€14,300.19 will go towards INTEREST
€3,959.73 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

61

€1,180.86

€340.80

€235,831.16

62

€1,179.16

€342.50

€235,488.65

63

€1,177.44

€344.22

€235,144.44

64

€1,175.72

€345.94

€234,798.50

65

€1,173.99

€347.67

€234,450.84

66

€1,172.25

€349.41

€234,101.43

67

€1,170.51

€351.15

€233,750.28

68

€1,168.75

€352.91

€233,397.37

69

€1,166.99

€354.67

€233,042.70

70

€1,165.21

€356.45

€232,686.25

71

€1,163.43

€358.23

€232,328.02

72

€1,161.64

€360.02

€231,968.00

Totals for year 6

You will spend €18,259.91 on your house in year 6
€14,055.96 will go towards INTEREST
€4,203.95 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

73

€1,159.84

€361.82

€231,606.19

74

€1,158.03

€363.63

€231,242.56

75

€1,156.21

€365.45

€230,877.11

76

€1,154.39

€367.27

€230,509.84

77

€1,152.55

€369.11

€230,140.73

78

€1,150.70

€370.96

€229,769.77

79

€1,148.85

€372.81

€229,396.96

80

€1,146.98

€374.67

€229,022.29

81

€1,145.11

€376.55

€228,645.74

82

€1,143.23

€378.43

€228,267.31

83

€1,141.34

€380.32

€227,886.99

84

€1,139.43

€382.22

€227,504.76

Totals for year 7

You will spend €18,259.91 on your house in year 7
€13,796.67 will go towards INTEREST
€4,463.24 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

85

€1,137.52

€384.14

€227,120.63

86

€1,135.60

€386.06

€226,734.57

87

€1,133.67

€387.99

€226,346.58

88

€1,131.73

€389.93

€225,956.66

89

€1,129.78

€391.88

€225,564.78

90

€1,127.82

€393.84

€225,170.95

91

€1,125.85

€395.80

€224,775.14

92

€1,123.88

€397.78

€224,377.36

93

€1,121.89

€399.77

€223,977.59

94

€1,119.89

€401.77

€223,575.81

95

€1,117.88

€403.78

€223,172.03

96

€1,115.86

€405.80

€222,766.23

Totals for year 8

You will spend €18,259.91 on your house in year 8
€13,521.38 will go towards INTEREST
€4,738.53 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

97

€1,113.83

€407.83

€222,358.41

98

€1,111.79

€409.87

€221,948.54

99

€1,109.74

€411.92

€221,536.62

100

€1,107.68

€413.98

€221,122.65

101

€1,105.61

€416.05

€220,706.60

102

€1,103.53

€418.13

€220,288.47

103

€1,101.44

€420.22

€219,868.26

104

€1,099.34

€422.32

€219,445.94

105

€1,097.23

€424.43

€219,021.51

106

€1,095.11

€426.55

€218,594.96

107

€1,092.97

€428.68

€218,166.27

108

€1,090.83

€430.83

€217,735.45

Totals for year 9

You will spend €18,259.91 on your house in year 9
€13,229.12 will go towards INTEREST
€5,030.79 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

109

€1,088.68

€432.98

€217,302.46

110

€1,086.51

€435.15

€216,867.32

111

€1,084.34

€437.32

€216,429.99

112

€1,082.15

€439.51

€215,990.49

113

€1,079.95

€441.71

€215,548.78

114

€1,077.74

€443.92

€215,104.86

115

€1,075.52

€446.13

€214,658.73

116

€1,073.29

€448.37

€214,210.36

117

€1,071.05

€450.61

€213,759.76

118

€1,068.80

€452.86

€213,306.90

119

€1,066.53

€455.12

€212,851.77

120

€1,064.26

€457.40

€212,394.37

Totals for year 10

You will spend €18,259.91 on your house in year 10
€12,918.83 will go towards INTEREST
€5,341.08 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

121

€1,061.97

€459.69

€211,934.68

122

€1,059.67

€461.99

€211,472.70

123

€1,057.36

€464.30

€211,008.40

124

€1,055.04

€466.62

€210,541.78

125

€1,052.71

€468.95

€210,072.83

126

€1,050.36

€471.30

€209,601.54

127

€1,048.01

€473.65

€209,127.89

128

€1,045.64

€476.02

€208,651.87

129

€1,043.26

€478.40

€208,173.47

130

€1,040.87

€480.79

€207,692.68

131

€1,038.46

€483.20

€207,209.48

132

€1,036.05

€485.61

€206,723.87

Totals for year 11

You will spend €18,259.91 on your house in year 11
€12,589.41 will go towards INTEREST
€5,670.50 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

133

€1,033.62

€488.04

€206,235.83

134

€1,031.18

€490.48

€205,745.35

135

€1,028.73

€492.93

€205,252.42

136

€1,026.26

€495.40

€204,757.02

137

€1,023.79

€497.87

€204,259.14

138

€1,021.30

€500.36

€203,758.78

139

€1,018.79

€502.87

€203,255.91

140

€1,016.28

€505.38

€202,750.54

141

€1,013.75

€507.91

€202,242.63

142

€1,011.21

€510.45

€201,732.18

143

€1,008.66

€513.00

€201,219.18

144

€1,006.10

€515.56

€200,703.62

Totals for year 12

You will spend €18,259.91 on your house in year 12
€12,239.66 will go towards INTEREST
€6,020.25 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

145

€1,003.52

€518.14

€200,185.48

146

€1,000.93

€520.73

€199,664.75

147

€998.32

€523.34

€199,141.41

148

€995.71

€525.95

€198,615.46

149

€993.08

€528.58

€198,086.88

150

€990.43

€531.22

€197,555.65

151

€987.78

€533.88

€197,021.77

152

€985.11

€536.55

€196,485.22

153

€982.43

€539.23

€195,945.99

154

€979.73

€541.93

€195,404.06

155

€977.02

€544.64

€194,859.42

156

€974.30

€547.36

€194,312.06

Totals for year 13

You will spend €18,259.91 on your house in year 13
€11,868.35 will go towards INTEREST
€6,391.56 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

157

€971.56

€550.10

€193,761.96

158

€968.81

€552.85

€193,209.11

159

€966.05

€555.61

€192,653.50

160

€963.27

€558.39

€192,095.11

161

€960.48

€561.18

€191,533.92

162

€957.67

€563.99

€190,969.93

163

€954.85

€566.81

€190,403.12

164

€952.02

€569.64

€189,833.48

165

€949.17

€572.49

€189,260.99

166

€946.30

€575.35

€188,685.63

167

€943.43

€578.23

€188,107.40

168

€940.54

€581.12

€187,526.28

Totals for year 14

You will spend €18,259.91 on your house in year 14
€11,474.13 will go towards INTEREST
€6,785.78 will go towards PRINCIPAL

Month

Interest Paid

Principal Paid

Remaing Balance

169

€937.63

€584.03

€186,942.25

170

€934.71

€586.95

€186,355.30

171

€931.78

€589.88

€185,765.42

172

€928.83