HOUSE MC Additional Values PP DP Given Values $445,544.00 15% $66,831.60 PV $378,71 i 0.02193 1/...

Transcribed Image Text:

HOUSE MC Additional Values PP DP Given Values $445,544.00 15% $66,831.60 PV $378,71 i 0.02193 1/ 12 0.00362 t 22 years 264 n j 4.3876% n 60 m. 2 5 years me 12 After 5 Years j i 4.3176% 0.021588000 0.003566057 Scenario PMT Size Principal Balance Result PMT $2,230.78 Statement The size of the monthly payment is $223 new n 264.000114992 204.000114992 PV $321,285.33189 n The principal balance at the end of five years is: PMT, New $321,285.33 $2,219.33 n 203.9996025394 New PMT The size of the new mortgage payment for the r the term is $2219.33. n 0.999602539 PV3 $2,210.56647 $2,210.57 Final Payment The size of the final payment is $2218. I PMT3 $7.88302 $7.88 $2,218.45 Total Cost of Financing $207,876.76 The total cost of financing my house mortgage is $20 Checking AMORTIZATION SCHEDULE Payment Amount Interest Principal Balance 0.003623353 0 $378,712.40 1 $2,230.78 $1,372.21 $858.57 $377,853.83 2 $2,230.78 $1,369.10 $861.68 $376,992.15 3 $2,230.78 $1,365.98 $864.80 $376,127.35 4 $2,230.78 $1,362.84 $867.94 $375,259.41 5 $2,230.78 $1,359.70 $871.08 $374,388.33 6 $2,230.78 $1,356.54 $874.24 $373,514.09 7 $2,230.78 $1,353.37 $877.41 $372.636.68 69 8 $2,230.78 $1,350.19 $880.59 $371,756.09 $2,230.78 $1,347.00 $883.78 $370,872.31 10 $2,230.78 $1,343.80 $886.98 $369,985.33 11 $2,230.78 $1,340.59 $890.19 $369,095.14 60 09 $2,230.78 NEW i $1,167.98 0.003566057 $1,062.80 $321,285.31 61 $2,219.33 $1,145.72 $1,073.61 $320,211.70 62 $2,219.33 $1,141.89 $1,077.44 $319,134.26 63 $2,219.33 $1,138.05 $1,081.28 $318,052.98 64 $2,219.33 $1,134.19 $1,085.14 $316,967.84 65 $2,219.33 $1,130.33 $1,089.00 $315,878.84 66 $2,219.33 $1,126.44 $1,092.89 $314,785.95 67 $2,219.33 $1,122.54 $1,096.79 $313,689.16 68 $2,219.33 $1,118.63 $1,100.70 $312,588.46 69 $2,219.33 $1,114.71 $1,104.62 $311,483.84 HOUSE MC Additional Values PP DP Given Values $445,544.00 15% $66,831.60 PV $378,71 i 0.02193 1/ 12 0.00362 t 22 years 264 n j 4.3876% n 60 m. 2 5 years me 12 After 5 Years j i 4.3176% 0.021588000 0.003566057 Scenario PMT Size Principal Balance Result PMT $2,230.78 Statement The size of the monthly payment is $223 new n 264.000114992 204.000114992 PV $321,285.33189 n The principal balance at the end of five years is: PMT, New $321,285.33 $2,219.33 n 203.9996025394 New PMT The size of the new mortgage payment for the r the term is $2219.33. n 0.999602539 PV3 $2,210.56647 $2,210.57 Final Payment The size of the final payment is $2218. I PMT3 $7.88302 $7.88 $2,218.45 Total Cost of Financing $207,876.76 The total cost of financing my house mortgage is $20 Checking AMORTIZATION SCHEDULE Payment Amount Interest Principal Balance 0.003623353 0 $378,712.40 1 $2,230.78 $1,372.21 $858.57 $377,853.83 2 $2,230.78 $1,369.10 $861.68 $376,992.15 3 $2,230.78 $1,365.98 $864.80 $376,127.35 4 $2,230.78 $1,362.84 $867.94 $375,259.41 5 $2,230.78 $1,359.70 $871.08 $374,388.33 6 $2,230.78 $1,356.54 $874.24 $373,514.09 7 $2,230.78 $1,353.37 $877.41 $372.636.68 69 8 $2,230.78 $1,350.19 $880.59 $371,756.09 $2,230.78 $1,347.00 $883.78 $370,872.31 10 $2,230.78 $1,343.80 $886.98 $369,985.33 11 $2,230.78 $1,340.59 $890.19 $369,095.14 60 09 $2,230.78 NEW i $1,167.98 0.003566057 $1,062.80 $321,285.31 61 $2,219.33 $1,145.72 $1,073.61 $320,211.70 62 $2,219.33 $1,141.89 $1,077.44 $319,134.26 63 $2,219.33 $1,138.05 $1,081.28 $318,052.98 64 $2,219.33 $1,134.19 $1,085.14 $316,967.84 65 $2,219.33 $1,130.33 $1,089.00 $315,878.84 66 $2,219.33 $1,126.44 $1,092.89 $314,785.95 67 $2,219.33 $1,122.54 $1,096.79 $313,689.16 68 $2,219.33 $1,118.63 $1,100.70 $312,588.46 69 $2,219.33 $1,114.71 $1,104.62 $311,483.84