case study solution (residence mtg tab) h. schwarz-lopes & a. santos

8

Click here to load reader

Upload: ucf-continuing-education

Post on 27-May-2015

61 views

Category:

Education


0 download

TRANSCRIPT

Page 1: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

Borrower: Residential Mortgage (30 year amortization)

Collateral: Assumes - in balance sheet loan at 80% of value

Loan Amount: $1,540,000.00 Amortization Period (Months): 360.00

Interest Rate: 3.250% Amortization Method: Mortgage

Interest Based on 365 Days per Year

Period Beginning Bal Principal Interest Total Pmt Due Ending Balance1 $1,540,000.00 $2,531.34 $4,170.83 $6,702.18 $1,537,468.662 1,537,468.66 2,538.20 4,163.98 6,702.18 1,534,930.463 1,534,930.46 2,545.07 4,157.10 6,702.18 1,532,385.384 1,532,385.38 2,551.97 4,150.21 6,702.18 1,529,833.425 1,529,833.42 2,558.88 4,143.30 6,702.18 1,527,274.546 1,527,274.54 2,565.81 4,136.37 6,702.18 1,524,708.737 1,524,708.73 2,572.76 4,129.42 6,702.18 1,522,135.978 1,522,135.97 2,579.73 4,122.45 6,702.18 1,519,556.249 1,519,556.24 2,586.71 4,115.46 6,702.18 1,516,969.53

10 1,516,969.53 2,593.72 4,108.46 6,702.18 1,514,375.8111 1,514,375.81 2,600.74 4,101.43 6,702.18 1,511,775.0712 1,511,775.07 2,607.79 4,094.39 6,702.18 1,509,167.28

Period 1-12 30,832.72 $49,593.41 $80,426.1312 1,509,167.28 2,614.85 4,087.33 6,702.18 1,506,552.4413 1,506,552.44 2,621.93 4,080.25 6,702.18 1,503,930.5014 1,503,930.50 2,629.03 4,073.15 6,702.18 1,501,301.4715 1,501,301.47 2,636.15 4,066.02 6,702.18 1,498,665.3216 1,498,665.32 2,643.29 4,058.89 6,702.18 1,496,022.0317 1,496,022.03 2,650.45 4,051.73 6,702.18 1,493,371.5818 1,493,371.58 2,657.63 4,044.55 6,702.18 1,490,713.9519 1,490,713.95 2,664.83 4,037.35 6,702.18 1,488,049.1220 1,488,049.12 2,672.04 4,030.13 6,702.18 1,485,377.0821 1,485,377.08 2,679.28 4,022.90 6,702.18 1,482,697.7922 1,482,697.79 2,686.54 4,015.64 6,702.18 1,480,011.2623 1,480,011.26 2,693.81 4,008.36 6,702.18 1,477,317.44

Period 13-24 31,849.84 $48,576.29 $80,426.13Period 1-24 62,682.56 98,169.70 160,852.26

24 1,477,317.44 2,701.11 4,001.07 6,702.18 1,474,616.3325 1,474,616.33 2,708.42 3,993.75 6,702.18 1,471,907.9126 1,471,907.91 2,715.76 3,986.42 6,702.18 1,469,192.1527 1,469,192.15 2,723.12 3,979.06 6,702.18 1,466,469.0328 1,466,469.03 2,730.49 3,971.69 6,702.18 1,463,738.5429 1,463,738.54 2,737.89 3,964.29 6,702.18 1,461,000.6630 1,461,000.66 2,745.30 3,956.88 6,702.18 1,458,255.3631 1,458,255.36 2,752.74 3,949.44 6,702.18 1,455,502.6232 1,455,502.62 2,760.19 3,941.99 6,702.18 1,452,742.4333 1,452,742.43 2,767.67 3,934.51 6,702.18 1,449,974.7634 1,449,974.76 2,775.16 3,927.01 6,702.18 1,447,199.6035 1,447,199.60 2,782.68 3,919.50 6,702.18 1,444,416.92

Period 25-36 32,900.52 $47,525.61 $80,426.13Period 1-36 95,583.08 145,695.31 241,278.38

36 1,444,416.92 2,790.21 3,911.96 6,702.18 1,441,626.7137 1,441,626.71 2,797.77 3,904.41 6,702.18 1,438,828.9438 1,438,828.94 2,805.35 3,896.83 6,702.18 1,436,023.5939 1,436,023.59 2,812.95 3,889.23 6,702.18 1,433,210.6440 1,433,210.64 2,820.57 3,881.61 6,702.18 1,430,390.0841 1,430,390.08 2,828.20 3,873.97 6,702.18 1,427,561.8742 1,427,561.87 2,835.86 3,866.31 6,702.18 1,424,726.0143 1,424,726.01 2,843.54 3,858.63 6,702.18 1,421,882.4644 1,421,882.46 2,851.25 3,850.93 6,702.18 1,419,031.2245 1,419,031.22 2,858.97 3,843.21 6,702.18 1,416,172.2546 1,416,172.25 2,866.71 3,835.47 6,702.18 1,413,305.5447 1,413,305.54 2,874.47 3,827.70 6,702.18 1,410,431.07

Period 37-48 33,985.86 $46,440.27 $80,426.13Period 1-48 129,568.93 192,135.58 321,704.51

48 1,410,431.07 2,882.26 3,819.92 6,702.18 1,407,548.8149 1,407,548.81 2,890.07 3,812.11 6,702.18 1,404,658.7450 1,404,658.74 2,897.89 3,804.28 6,702.18 1,401,760.8551 1,401,760.85 2,905.74 3,796.44 6,702.18 1,398,855.1052 1,398,855.10 2,913.61 3,788.57 6,702.18 1,395,941.4953 1,395,941.49 2,921.50 3,780.67 6,702.18 1,393,019.99

Page 2: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

54 1,393,019.99 2,929.41 3,772.76 6,702.18 1,390,090.5855 1,390,090.58 2,937.35 3,764.83 6,702.18 1,387,153.2356 1,387,153.23 2,945.30 3,756.87 6,702.18 1,384,207.9257 1,384,207.92 2,953.28 3,748.90 6,702.18 1,381,254.6458 1,381,254.64 2,961.28 3,740.90 6,702.18 1,378,293.3659 1,378,293.36 2,969.30 3,732.88 6,702.18 1,375,324.06

Period 49-60 35,107.00 45,319.13 80,426.13Period 1-60 164,675.94 237,454.70 402,130.64

60 1,375,324.06 2,977.34 3,724.84 6,702.18 1,372,346.7261 1,372,346.72 2,985.40 3,716.77 6,702.18 1,369,361.3262 1,369,361.32 2,993.49 3,708.69 6,702.18 1,366,367.8363 1,366,367.83 3,001.60 3,700.58 6,702.18 1,363,366.2364 1,363,366.23 3,009.73 3,692.45 6,702.18 1,360,356.5065 1,360,356.50 3,017.88 3,684.30 6,702.18 1,357,338.6266 1,357,338.62 3,026.05 3,676.13 6,702.18 1,354,312.5767 1,354,312.57 3,034.25 3,667.93 6,702.18 1,351,278.3268 1,351,278.32 3,042.47 3,659.71 6,702.18 1,348,235.8669 1,348,235.86 3,050.71 3,651.47 6,702.18 1,345,185.1570 1,345,185.15 3,058.97 3,643.21 6,702.18 1,342,126.1971 1,342,126.19 3,067.25 3,634.93 6,702.18 1,339,058.93

Period 61-72 36,265.13 44,161.00 80,426.13Period 1-72 200,941.07 281,615.70 482,556.77

72 1,339,058.93 3,075.56 3,626.62 6,702.18 1,335,983.3773 1,335,983.37 3,083.89 3,618.29 6,702.18 1,332,899.4974 1,332,899.49 3,092.24 3,609.94 6,702.18 1,329,807.2475 1,329,807.24 3,100.62 3,601.56 6,702.18 1,326,706.6376 1,326,706.63 3,109.01 3,593.16 6,702.18 1,323,597.6277 1,323,597.62 3,117.43 3,584.74 6,702.18 1,320,480.1878 1,320,480.18 3,125.88 3,576.30 6,702.18 1,317,354.3079 1,317,354.30 3,134.34 3,567.83 6,702.18 1,314,219.9680 1,314,219.96 3,142.83 3,559.35 6,702.18 1,311,077.1381 1,311,077.13 3,151.34 3,550.83 6,702.18 1,307,925.7982 1,307,925.79 3,159.88 3,542.30 6,702.18 1,304,765.9183 1,304,765.91 3,168.44 3,533.74 6,702.18 1,301,597.47

Period 73-84 37,461.46 42,964.67 80,426.13Period 1-84 238,402.53 324,580.37 562,982.89

84 1,301,597.47 3,177.02 3,525.16 6,702.18 1,298,420.45

85 1,298,420.45 3,185.62 3,516.56 6,702.18 1,295,234.83

86 1,295,234.83 3,194.25 3,507.93 6,702.18 1,292,040.58

87 1,292,040.58 3,202.90 3,499.28 6,702.18 1,288,837.68

88 1,288,837.68 3,211.58 3,490.60 6,702.18 1,285,626.11

89 1,285,626.11 3,220.27 3,481.90 6,702.18 1,282,405.83

90 1,282,405.83 3,228.99 3,473.18 6,702.18 1,279,176.84

91 1,279,176.84 3,237.74 3,464.44 6,702.18 1,275,939.10

92 1,275,939.10 3,246.51 3,455.67 6,702.18 1,272,692.59

93 1,272,692.59 3,255.30 3,446.88 6,702.18 1,269,437.29

94 1,269,437.29 3,264.12 3,438.06 6,702.18 1,266,173.17

95 1,266,173.17 3,272.96 3,429.22 6,702.18 1,262,900.21

Period 85-96 38,697.26 41,728.87 80,426.13

Period 1-96 277,099.79 366,309.23 643,409.02

96 1,262,900.21 3,281.82 3,420.35 6,702.18 1,259,618.39

97 1,259,618.39 3,290.71 3,411.47 6,702.18 1,256,327.68

98 1,256,327.68 3,299.62 3,402.55 6,702.18 1,253,028.06

99 1,253,028.06 3,308.56 3,393.62 6,702.18 1,249,719.50

100 1,249,719.50 3,317.52 3,384.66 6,702.18 1,246,401.98

101 1,246,401.98 3,326.51 3,375.67 6,702.18 1,243,075.47

102 1,243,075.47 3,335.51 3,366.66 6,702.18 1,239,739.96

103 1,239,739.96 3,344.55 3,357.63 6,702.18 1,236,395.41

104 1,236,395.41 3,353.61 3,348.57 6,702.18 1,233,041.80

105 1,233,041.80 3,362.69 3,339.49 6,702.18 1,229,679.11

106 1,229,679.11 3,371.80 3,330.38 6,702.18 1,226,307.32

107 1,226,307.32 3,380.93 3,321.25 6,702.18 1,222,926.39

Period 97-108 39,973.82 40,452.30 80,426.13

Period 1-108 317,073.61 406,761.54 723,835.15

Page 3: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

108 1,222,926.39 3,390.09 3,312.09 6,702.18 1,219,536.30

109 1,219,536.30 3,399.27 3,302.91 6,702.18 1,216,137.04

110 1,216,137.04 3,408.47 3,293.70 6,702.18 1,212,728.56

111 1,212,728.56 3,417.70 3,284.47 6,702.18 1,209,310.86

112 1,209,310.86 3,426.96 3,275.22 6,702.18 1,205,883.90

113 1,205,883.90 3,436.24 3,265.94 6,702.18 1,202,447.66

114 1,202,447.66 3,445.55 3,256.63 6,702.18 1,199,002.11

115 1,199,002.11 3,454.88 3,247.30 6,702.18 1,195,547.23

116 1,195,547.23 3,464.24 3,237.94 6,702.18 1,192,082.99

117 1,192,082.99 3,473.62 3,228.56 6,702.18 1,188,609.37

118 1,188,609.37 3,483.03 3,219.15 6,702.18 1,185,126.35

119 1,185,126.35 3,492.46 3,209.72 6,702.18 1,181,633.89

Period 109-120 41,292.50 39,133.63 80,426.13

Period 1-120 358,366.11 445,895.16 804,261.28

120 1,181,633.89 3,501.92 3,200.26 6,702.18 1,178,131.97

121 1,178,131.97 3,511.40 3,190.77 6,702.18 1,174,620.56

122 1,174,620.56 3,520.91 3,181.26 6,702.18 1,171,099.65

123 1,171,099.65 3,530.45 3,171.73 6,702.18 1,167,569.20

124 1,167,569.20 3,540.01 3,162.17 6,702.18 1,164,029.19

125 1,164,029.19 3,549.60 3,152.58 6,702.18 1,160,479.59

126 1,160,479.59 3,559.21 3,142.97 6,702.18 1,156,920.38

127 1,156,920.38 3,568.85 3,133.33 6,702.18 1,153,351.53

128 1,153,351.53 3,578.52 3,123.66 6,702.18 1,149,773.01

129 1,149,773.01 3,588.21 3,113.97 6,702.18 1,146,184.80

130 1,146,184.80 3,597.93 3,104.25 6,702.18 1,142,586.88

131 1,142,586.88 3,607.67 3,094.51 6,702.18 1,138,979.21

Period 121-132 42,654.68 37,771.45 80,426.13

Period 1-132 401,020.79 483,666.61 884,687.41

132 1,138,979.21 3,617.44 3,084.74 6,702.18 1,135,361.76

133 1,135,361.76 3,627.24 3,074.94 6,702.18 1,131,734.52

134 1,131,734.52 3,637.06 3,065.11 6,702.18 1,128,097.46

135 1,128,097.46 3,646.91 3,055.26 6,702.18 1,124,450.55

136 1,124,450.55 3,656.79 3,045.39 6,702.18 1,120,793.76

137 1,120,793.76 3,666.69 3,035.48 6,702.18 1,117,127.06

138 1,117,127.06 3,676.62 3,025.55 6,702.18 1,113,450.44

139 1,113,450.44 3,686.58 3,015.59 6,702.18 1,109,763.86

140 1,109,763.86 3,696.57 3,005.61 6,702.18 1,106,067.29

141 1,106,067.29 3,706.58 2,995.60 6,702.18 1,102,360.71

142 1,102,360.71 3,716.62 2,985.56 6,702.18 1,098,644.09

143 1,098,644.09 3,726.68 2,975.49 6,702.18 1,094,917.41

Period 133-144 44,061.79 36,364.33 80,426.13

Period 1-144 445,082.59 520,030.94 965,113.53

144 1,094,917.41 3,736.78 2,965.40 6,702.18 1,091,180.63

145 1,091,180.63 3,746.90 2,955.28 6,702.18 1,087,433.74

146 1,087,433.74 3,757.04 2,945.13 6,702.18 1,083,676.69

147 1,083,676.69 3,767.22 2,934.96 6,702.18 1,079,909.47

148 1,079,909.47 3,777.42 2,924.75 6,702.18 1,076,132.05

149 1,076,132.05 3,787.65 2,914.52 6,702.18 1,072,344.40

150 1,072,344.40 3,797.91 2,904.27 6,702.18 1,068,546.49

151 1,068,546.49 3,808.20 2,893.98 6,702.18 1,064,738.29

152 1,064,738.29 3,818.51 2,883.67 6,702.18 1,060,919.78

153 1,060,919.78 3,828.85 2,873.32 6,702.18 1,057,090.93

154 1,057,090.93 3,839.22 2,862.95 6,702.18 1,053,251.70

155 1,053,251.70 3,849.62 2,852.56 6,702.18 1,049,402.08

Period 145-156 45,515.33 34,910.80 80,426.13

Page 4: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

Period 1-156 490,597.92 554,941.74 1,045,539.66

156 1,049,402.08 3,860.05 2,842.13 6,702.18 1,045,542.04

157 1,045,542.04 3,870.50 2,831.68 6,702.18 1,041,671.54

158 1,041,671.54 3,880.98 2,821.19 6,702.18 1,037,790.55

159 1,037,790.55 3,891.49 2,810.68 6,702.18 1,033,899.06

160 1,033,899.06 3,902.03 2,800.14 6,702.18 1,029,997.02

161 1,029,997.02 3,912.60 2,789.58 6,702.18 1,026,084.42

162 1,026,084.42 3,923.20 2,778.98 6,702.18 1,022,161.22

163 1,022,161.22 3,933.82 2,768.35 6,702.18 1,018,227.40

164 1,018,227.40 3,944.48 2,757.70 6,702.18 1,014,282.92

165 1,014,282.92 3,955.16 2,747.02 6,702.18 1,010,327.76

166 1,010,327.76 3,965.87 2,736.30 6,702.18 1,006,361.89

167 1,006,361.89 3,976.61 2,725.56 6,702.18 1,002,385.27

Period 157-168 47,016.81 33,409.32 80,426.13

Period 1-168 537,614.73 588,351.06 1,125,965.79

168 1,002,385.27 3,987.38 2,714.79 6,702.18 998,397.89

169 998,397.89 3,998.18 2,703.99 6,702.18 994,399.71

170 994,399.71 4,009.01 2,693.17 6,702.18 990,390.69

171 990,390.69 4,019.87 2,682.31 6,702.18 986,370.82

172 986,370.82 4,030.76 2,671.42 6,702.18 982,340.07

173 982,340.07 4,041.67 2,660.50 6,702.18 978,298.40

174 978,298.40 4,052.62 2,649.56 6,702.18 974,245.78

175 974,245.78 4,063.60 2,638.58 6,702.18 970,182.18

176 970,182.18 4,074.60 2,627.58 6,702.18 966,107.58

177 966,107.58 4,085.64 2,616.54 6,702.18 962,021.94

178 962,021.94 4,096.70 2,605.48 6,702.18 957,925.24

179 957,925.24 4,107.80 2,594.38 6,702.18 953,817.45

Period 169-180 48,567.83 31,858.30 80,426.13

Period 1-180 586,182.55 620,209.36 1,206,391.92

180 953,817.45 4,118.92 2,583.26 6,702.18 949,698.53

181 949,698.53 4,130.08 2,572.10 6,702.18 945,568.45

182 945,568.45 4,141.26 2,560.91 6,702.18 941,427.19

183 941,427.19 4,152.48 2,549.70 6,702.18 937,274.71

184 937,274.71 4,163.72 2,538.45 6,702.18 933,110.98

185 933,110.98 4,175.00 2,527.18 6,702.18 928,935.98

186 928,935.98 4,186.31 2,515.87 6,702.18 924,749.67

187 924,749.67 4,197.65 2,504.53 6,702.18 920,552.02

188 920,552.02 4,209.02 2,493.16 6,702.18 916,343.01

189 916,343.01 4,220.41 2,481.76 6,702.18 912,122.59

190 912,122.59 4,231.85 2,470.33 6,702.18 907,890.75

191 907,890.75 4,243.31 2,458.87 6,702.18 903,647.44

Period 181-192 50,170.01 30,256.12 80,426.13

Period 1-192 636,352.56 650,465.49 1,286,818.04

192 903,647.44 4,254.80 2,447.38 6,702.18 899,392.64

193 899,392.64 4,266.32 2,435.86 6,702.18 895,126.32

194 895,126.32 4,277.88 2,424.30 6,702.18 890,848.44

195 890,848.44 4,289.46 2,412.71 6,702.18 886,558.98

196 886,558.98 4,301.08 2,401.10 6,702.18 882,257.90

197 882,257.90 4,312.73 2,389.45 6,702.18 877,945.17

198 877,945.17 4,324.41 2,377.77 6,702.18 873,620.76

199 873,620.76 4,336.12 2,366.06 6,702.18 869,284.64

200 869,284.64 4,347.86 2,354.31 6,702.18 864,936.78

201 864,936.78 4,359.64 2,342.54 6,702.18 860,577.14

202 860,577.14 4,371.45 2,330.73 6,702.18 856,205.69

203 856,205.69 4,383.29 2,318.89 6,702.18 851,822.40

Page 5: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

Period 193-204 51,825.04 28,601.09 80,426.13

Period 1-204 688,177.60 679,066.57 1,367,244.17

204 851,822.40 4,395.16 2,307.02 6,702.18 847,427.24

205 847,427.24 4,407.06 2,295.12 6,702.18 843,020.18

206 843,020.18 4,419.00 2,283.18 6,702.18 838,601.18

207 838,601.18 4,430.97 2,271.21 6,702.18 834,170.22

208 834,170.22 4,442.97 2,259.21 6,702.18 829,727.25

209 829,727.25 4,455.00 2,247.18 6,702.18 825,272.25

210 825,272.25 4,467.06 2,235.11 6,702.18 820,805.19

211 820,805.19 4,479.16 2,223.01 6,702.18 816,326.03

212 816,326.03 4,491.29 2,210.88 6,702.18 811,834.73

213 811,834.73 4,503.46 2,198.72 6,702.18 807,331.27

214 807,331.27 4,515.66 2,186.52 6,702.18 802,815.62

215 802,815.62 4,527.89 2,174.29 6,702.18 798,287.73

Period 205-216 53,534.67 26,891.46 80,426.13

Period 1-216 741,712.27 705,958.03 1,447,670.30

216 798,287.73 4,540.15 2,162.03 6,702.18 793,747.58

217 793,747.58 4,552.44 2,149.73 6,702.18 789,195.14

218 789,195.14 4,564.77 2,137.40 6,702.18 784,630.37

219 784,630.37 4,577.14 2,125.04 6,702.18 780,053.23

220 780,053.23 4,589.53 2,112.64 6,702.18 775,463.70

221 775,463.70 4,601.96 2,100.21 6,702.18 770,861.73

222 770,861.73 4,614.43 2,087.75 6,702.18 766,247.31

223 766,247.31 4,626.92 2,075.25 6,702.18 761,620.38

224 761,620.38 4,639.46 2,062.72 6,702.18 756,980.93

225 756,980.93 4,652.02 2,050.16 6,702.18 752,328.91

226 752,328.91 4,664.62 2,037.56 6,702.18 747,664.29

227 747,664.29 4,677.25 2,024.92 6,702.18 742,987.03

Period 217-228 55,300.70 25,125.43 80,426.13

Period 1-228 797,012.97 731,083.46 1,528,096.43

228 742,987.03 4,689.92 2,012.26 6,702.18 738,297.11

229 738,297.11 4,702.62 1,999.55 6,702.18 733,594.49

230 733,594.49 4,715.36 1,986.82 6,702.18 728,879.13

231 728,879.13 4,728.13 1,974.05 6,702.18 724,151.00

232 724,151.00 4,740.94 1,961.24 6,702.18 719,410.07

233 719,410.07 4,753.78 1,948.40 6,702.18 714,656.29

234 714,656.29 4,766.65 1,935.53 6,702.18 709,889.64

235 709,889.64 4,779.56 1,922.62 6,702.18 705,110.08

236 705,110.08 4,792.50 1,909.67 6,702.18 700,317.58

237 700,317.58 4,805.48 1,896.69 6,702.18 695,512.09

238 695,512.09 4,818.50 1,883.68 6,702.18 690,693.59

239 690,693.59 4,831.55 1,870.63 6,702.18 685,862.05

Period 229-240 57,124.99 23,301.14 80,426.13

Period 1-240 854,137.95 754,384.60 1,608,522.56

240 685,862.05 4,844.63 1,857.54 6,702.18 681,017.41

241 681,017.41 4,857.76 1,844.42 6,702.18 676,159.66

242 676,159.66 4,870.91 1,831.27 6,702.18 671,288.74

243 671,288.74 4,884.10 1,818.07 6,702.18 666,404.64

244 666,404.64 4,897.33 1,804.85 6,702.18 661,507.31

245 661,507.31 4,910.60 1,791.58 6,702.18 656,596.71

246 656,596.71 4,923.89 1,778.28 6,702.18 651,672.82

247 651,672.82 4,937.23 1,764.95 6,702.18 646,735.59

248 646,735.59 4,950.60 1,751.58 6,702.18 641,784.99

249 641,784.99 4,964.01 1,738.17 6,702.18 636,820.98

250 636,820.98 4,977.45 1,724.72 6,702.18 631,843.53

Page 6: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

251 631,843.53 4,990.93 1,711.24 6,702.18 626,852.59

Period 241-252 59,009.46 21,416.67 80,426.13

Period 1-252 913,147.41 775,801.27 1,688,948.68

252 626,852.59 5,004.45 1,697.73 6,702.18 621,848.14

253 621,848.14 5,018.01 1,684.17 6,702.18 616,830.13

254 616,830.13 5,031.60 1,670.58 6,702.18 611,798.54

255 611,798.54 5,045.22 1,656.95 6,702.18 606,753.32

256 606,753.32 5,058.89 1,643.29 6,702.18 601,694.43

257 601,694.43 5,072.59 1,629.59 6,702.18 596,621.84

258 596,621.84 5,086.33 1,615.85 6,702.18 591,535.51

259 591,535.51 5,100.10 1,602.08 6,702.18 586,435.41

260 586,435.41 5,113.91 1,588.26 6,702.18 581,321.50

261 581,321.50 5,127.76 1,574.41 6,702.18 576,193.73

262 576,193.73 5,141.65 1,560.52 6,702.18 571,052.08

263 571,052.08 5,155.58 1,546.60 6,702.18 565,896.50

Period 253-264 60,956.09 19,470.04 80,426.13

Period 1-264 974,103.50 795,271.31 1,769,374.81

264 565,896.50 5,169.54 1,532.64 6,702.18 560,726.96

265 560,726.96 5,183.54 1,518.64 6,702.18 555,543.42

266 555,543.42 5,197.58 1,504.60 6,702.18 550,345.84

267 550,345.84 5,211.66 1,490.52 6,702.18 545,134.18

268 545,134.18 5,225.77 1,476.41 6,702.18 539,908.41

269 539,908.41 5,239.93 1,462.25 6,702.18 534,668.48

270 534,668.48 5,254.12 1,448.06 6,702.18 529,414.37

271 529,414.37 5,268.35 1,433.83 6,702.18 524,146.02

272 524,146.02 5,282.62 1,419.56 6,702.18 518,863.40

273 518,863.40 5,296.92 1,405.26 6,702.18 513,566.48

274 513,566.48 5,311.27 1,390.91 6,702.18 508,255.21

275 508,255.21 5,325.65 1,376.52 6,702.18 502,929.56

Period 265-276 62,966.94 17,459.19 80,426.13

Period 1-276 1,037,070.44 812,730.50 1,849,800.94

276 502,929.56 5,340.08 1,362.10 6,702.18 497,589.48

277 497,589.48 5,354.54 1,347.64 6,702.18 492,234.95

278 492,234.95 5,369.04 1,333.14 6,702.18 486,865.90

279 486,865.90 5,383.58 1,318.60 6,702.18 481,482.32

280 481,482.32 5,398.16 1,304.01 6,702.18 476,084.16

281 476,084.16 5,412.78 1,289.39 6,702.18 470,671.38

282 470,671.38 5,427.44 1,274.73 6,702.18 465,243.93

283 465,243.93 5,442.14 1,260.04 6,702.18 459,801.79

284 459,801.79 5,456.88 1,245.30 6,702.18 454,344.91

285 454,344.91 5,471.66 1,230.52 6,702.18 448,873.25

286 448,873.25 5,486.48 1,215.70 6,702.18 443,386.77

287 443,386.77 5,501.34 1,200.84 6,702.18 437,885.44

Period 277-288 65,044.13 15,382.00 80,426.13

Period 1-288 1,102,114.56 828,112.50 1,930,227.07

288 437,885.44 5,516.24 1,185.94 6,702.18 432,369.20

289 432,369.20 5,531.18 1,171.00 6,702.18 426,838.02

290 426,838.02 5,546.16 1,156.02 6,702.18 421,291.86

291 421,291.86 5,561.18 1,141.00 6,702.18 415,730.68

292 415,730.68 5,576.24 1,125.94 6,702.18 410,154.44

293 410,154.44 5,591.34 1,110.83 6,702.18 404,563.10

294 404,563.10 5,606.49 1,095.69 6,702.18 398,956.62

295 398,956.62 5,621.67 1,080.51 6,702.18 393,334.95

296 393,334.95 5,636.90 1,065.28 6,702.18 387,698.05

297 387,698.05 5,652.16 1,050.02 6,702.18 382,045.89

Page 7: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

298 382,045.89 5,667.47 1,034.71 6,702.18 376,378.42

299 376,378.42 5,682.82 1,019.36 6,702.18 370,695.60

Period 289-300 67,189.83 13,236.29 80,426.13

Period 1-300 1,169,304.40 841,348.79 2,010,653.19

300 370,695.60 5,698.21 1,003.97 6,702.18 364,997.39

301 364,997.39 5,713.64 988.53 6,702.18 359,283.75

302 359,283.75 5,729.12 973.06 6,702.18 353,554.63

303 353,554.63 5,744.63 957.54 6,702.18 347,810.00

304 347,810.00 5,760.19 941.99 6,702.18 342,049.81

305 342,049.81 5,775.79 926.38 6,702.18 336,274.01

306 336,274.01 5,791.44 910.74 6,702.18 330,482.58

307 330,482.58 5,807.12 895.06 6,702.18 324,675.46

308 324,675.46 5,822.85 879.33 6,702.18 318,852.61

309 318,852.61 5,838.62 863.56 6,702.18 313,013.99

310 313,013.99 5,854.43 847.75 6,702.18 307,159.56

311 307,159.56 5,870.29 831.89 6,702.18 301,289.27

Period 301-312 69,406.33 11,019.80 80,426.13

Period 1-312 1,238,710.73 852,368.60 2,091,079.32

312 301,289.27 5,886.19 815.99 6,702.18 295,403.09

313 295,403.09 5,902.13 800.05 6,702.18 289,500.96

314 289,500.96 5,918.11 784.07 6,702.18 283,582.85

315 283,582.85 5,934.14 768.04 6,702.18 277,648.71

316 277,648.71 5,950.21 751.97 6,702.18 271,698.50

317 271,698.50 5,966.33 735.85 6,702.18 265,732.17

318 265,732.17 5,982.49 719.69 6,702.18 259,749.68

319 259,749.68 5,998.69 703.49 6,702.18 253,750.99

320 253,750.99 6,014.94 687.24 6,702.18 247,736.06

321 247,736.06 6,031.23 670.95 6,702.18 241,704.83

322 241,704.83 6,047.56 654.62 6,702.18 235,657.27

323 235,657.27 6,063.94 638.24 6,702.18 229,593.33

Period 313-324 71,695.94 8,730.19 80,426.13

Period 1-324 1,310,406.67 861,098.78 2,171,505.45

324 229,593.33 6,080.36 621.82 6,702.18 223,512.97

325 223,512.97 6,096.83 605.35 6,702.18 217,416.14

326 217,416.14 6,113.34 588.84 6,702.18 211,302.80

327 211,302.80 6,129.90 572.28 6,702.18 205,172.90

328 205,172.90 6,146.50 555.68 6,702.18 199,026.40

329 199,026.40 6,163.15 539.03 6,702.18 192,863.25

330 192,863.25 6,179.84 522.34 6,702.18 186,683.41

331 186,683.41 6,196.58 505.60 6,702.18 180,486.84

332 180,486.84 6,213.36 488.82 6,702.18 174,273.48

333 174,273.48 6,230.19 471.99 6,702.18 168,043.29

334 168,043.29 6,247.06 455.12 6,702.18 161,796.23

335 161,796.23 6,263.98 438.20 6,702.18 155,532.25

Period 325-336 74,061.08 6,365.05 80,426.13

Period 1-336 1,384,467.75 867,463.83 2,251,931.58

336 155,532.25 6,280.94 421.23 6,702.18 149,251.31

337 149,251.31 6,297.96 404.22 6,702.18 142,953.35

338 142,953.35 6,315.01 387.17 6,702.18 136,638.34

339 136,638.34 6,332.12 370.06 6,702.18 130,306.23

340 130,306.23 6,349.26 352.91 6,702.18 123,956.96

341 123,956.96 6,366.46 335.72 6,702.18 117,590.50

342 117,590.50 6,383.70 318.47 6,702.18 111,206.80

343 111,206.80 6,400.99 301.19 6,702.18 104,805.81

344 104,805.81 6,418.33 283.85 6,702.18 98,387.48

Page 8: Case study solution (Residence Mtg tab)  H. Schwarz-Lopes & A. Santos

345 98,387.48 6,435.71 266.47 6,702.18 91,951.77

346 91,951.77 6,453.14 249.04 6,702.18 85,498.63

347 85,498.63 6,470.62 231.56 6,702.18 79,028.01

Period 337-348 76,504.25 3,921.88 80,426.13

Period 1-348 1,460,971.99 871,385.71 2,332,357.71

348 79,028.01 6,488.14 214.03 6,702.18 72,539.86

349 72,539.86 6,505.72 196.46 6,702.18 66,034.15

350 66,034.15 6,523.33 178.84 6,702.18 59,510.81

351 59,510.81 6,541.00 161.18 6,702.18 52,969.81

352 52,969.81 6,558.72 143.46 6,702.18 46,411.09

353 46,411.09 6,576.48 125.70 6,702.18 39,834.61

354 39,834.61 6,594.29 107.89 6,702.18 33,240.32

355 33,240.32 6,612.15 90.03 6,702.18 26,628.17

356 26,628.17 6,630.06 72.12 6,702.18 19,998.11

357 19,998.11 6,648.02 54.16 6,702.18 13,350.10

358 13,350.10 6,666.02 36.16 6,702.18 6,684.07

359 6,684.07 6,684.07 18.10 6,702.18 0.00

Period 349-360 79,028.01 1,398.12 80,426.13

Period 1-360 $1,540,000.00 $872,783.83 $2,412,783.83