{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

chap6_ho4_amortization_solution (1)

chap6_ho4_amortization_solution (1) - A 1 2 3 4 5 6 7 8 9...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Amortization Schedule Enter Loan Parameters as Indicated Loan Summary Information Principal $400,000 Monthly Payment $2,462.87 Annual Interest 6.25% Scheduled Payments 360 Date of First Payment 2/1/2008 TRUE Normal Payoff Date 1/1/2038 Term of Loan (years) 30 Actual Number of Payments 294 Extra Payment Every Period $200 Actual Payoff Date 7/1/2032 Your Last Name Jinyao Zhao Total of Extra Payments $58,800.00 Purpose of Loan Mortgage Total of All Interest Payments $381,683.75 Date Interest Principal Extra Payment 1 2/1/2008 $400,000 $2,462.87 $2,083.33 $379.54 200 $399,420.46 2 3/1/2008 $399,420.46 $2,462.87 $2,080.31 $382.55 200 $398,837.91 3 4/1/2008 $398,837.91 $2,462.87 $2,077.28 $385.59 200 $398,252.32 4 5/1/2008 $398,252.32 $2,462.87 $2,074.23 $388.64 200 $397,663.68 5 6/1/2008 $397,663.68 $2,462.87 $2,071.17 $391.70 200 $397,071.98 6 7/1/2008 $397,071.98 $2,462.87 $2,068.08 $394.79 200 $396,477.20 7 8/1/2008 $396,477.20 $2,462.87 $2,064.99 $397.88 200 $395,879.31 8 9/1/2008 $395,879.31 $2,462.87 $2,061.87 $401.00 200 $395,278.31 9 10/1/2008 $395,278.31 $2,462.87 $2,058.74 $404.13 200 $394,674.19 10 11/1/2008 $394,674.19 $2,462.87 $2,055.59 $407.27 200 $394,066.91 11 12/1/2008 $394,066.91 $2,462.87 $2,052.43 $410.44 200 $393,456.48 12 1/1/2009 $393,456.48 $2,462.87 $2,049.25 $413.62 200 $392,842.86 13 2/1/2009 $392,842.86 $2,462.87 $2,046.06 $416.81 200 $392,226.05 14 3/1/2009 $392,226.05 $2,462.87 $2,042.84 $420.02 200 $391,606.02 15 4/1/2009 $391,606.02 $2,462.87 $2,039.61 $423.25 200 $390,982.77 16 5/1/2009 $390,982.77 $2,462.87 $2,036.37 $426.50 200 $390,356.27 17 6/1/2009 $390,356.27 $2,462.87 $2,033.11 $429.76 200 $389,726.50 18 7/1/2009 $389,726.50 $2,462.87 $2,029.83 $433.04 200 $389,093.46 19 8/1/2009 $389,093.46 $2,462.87 $2,026.53 $436.34 200 $388,457.12 20 9/1/2009 $388,457.12 $2,462.87 $2,023.21 $439.65 200 $387,817.47 21 10/1/2009 $387,817.47 $2,462.87 $2,019.88 $442.99 200 $387,174.48 22 11/1/2009 $387,174.48 $2,462.87 $2,016.53 $446.34 200 $386,528.15 23 12/1/2009 $386,528.15 $2,462.87 $2,013.17 $449.70 200 $385,878.44 24 1/1/2010 $385,878.44 $2,462.87 $2,009.78 $453.09 200 $385,225.36 25 2/1/2010 $385,225.36 $2,462.87 $2,006.38 $456.49 200 $384,568.87 26 3/1/2010 $384,568.87 $2,462.87 $2,002.96 $459.91 200 $383,908.97 27 4/1/2010 $383,908.97 $2,462.87 $1,999.53 $463.34 200 $383,245.62 28 5/1/2010 $383,245.62 $2,462.87 $1,996.07 $466.80 200 $382,578.83 29 6/1/2010 $382,578.83 $2,462.87 $1,992.60 $470.27 200 $381,908.55 30 7/1/2010 $381,908.55 $2,462.87 $1,989.11 $473.76 200 $381,234.79 31 8/1/2010 $381,234.79 $2,462.87 $1,985.60 $477.27 200 $380,557.52 32 9/1/2010 $380,557.52 $2,462.87 $1,982.07 $480.80 200 $379,876.72 33 10/1/2010 $379,876.72 $2,462.87 $1,978.52 $484.34 200 $379,192.38 34 11/1/2010 $379,192.38 $2,462.87 $1,974.96 $487.91 200 $378,504.47 35 12/1/2010 $378,504.47 $2,462.87 $1,971.38 $491.49 200 $377,812.98 36 1/1/2011 $377,812.98 $2,462.87 $1,967.78 $495.09 200 $377,117.89 37 2/1/2011 $377,117.89 $2,462.87 $1,964.16 $498.71 200 $376,419.17 38 3/1/2011 $376,419.17 $2,462.87 $1,960.52 $502.35 200 $375,716.82 39 4/1/2011 $375,716.82 $2,462.87 $1,956.86 $506.01 200 $375,010.81 40 5/1/2011 $375,010.81 $2,462.87 $1,953.18 $509.69 200 $374,301.12 41 6/1/2011 $374,301.12 $2,462.87 $1,949.49 $513.38 200 $373,587.74 42 7/1/2011 $373,587.74 $2,462.87 $1,945.77 $517.10 200 $372,870.64 43 8/1/2011 $372,870.64 $2,462.87 $1,942.03 $520.83 200 $372,149.81 44 9/1/2011 $372,149.81 $2,462.87 $1,938.28 $524.59 200 $371,425.22 45 10/1/2011 $371,425.22 $2,462.87 $1,934.51 $528.36 200 $370,696.86 46 11/1/2011 $370,696.86 $2,462.87 $1,930.71 $532.16 200 $369,964.70 47 12/1/2011 $369,964.70 $2,462.87 $1,926.90 $535.97 200 $369,228.73 48 1/1/2012 $369,228.73 $2,462.87 $1,923.07 $539.80 200 $368,488.93 49 2/1/2012 $368,488.93 $2,462.87 $1,919.21 $543.66 200 $367,745.27 50 3/1/2012 $367,745.27 $2,462.87 $1,915.34 $547.53 200 $366,997.74 51 4/1/2012 $366,997.74 $2,462.87 $1,911.45 $551.42 200 $366,246.32 52 5/1/2012 $366,246.32 $2,462.87 $1,907.53 $555.34 200 $365,490.98 53 6/1/2012 $365,490.98 $2,462.87 $1,903.60 $559.27 200 $364,731.71 54 7/1/2012 $364,731.71 $2,462.87 $1,899.64 $563.22 200 $363,968.49 55 8/1/2012 $363,968.49 $2,462.87 $1,895.67 $567.20 200 $363,201.29 56 9/1/2012 $363,201.29 $2,462.87 $1,891.67 $571.20 200 $362,430.10 57 10/1/2012 $362,430.10 $2,462.87 $1,887.66 $575.21 200 $361,654.88 58 11/1/2012 $361,654.88 $2,462.87 $1,883.62 $579.25 200 $360,875.63 59 12/1/2012 $360,875.63 $2,462.87 $1,879.56 $583.31 200 $360,092.33 60 1/1/2013 $360,092.33 $2,462.87 $1,875.48 $587.39 200 $359,304.94 61 2/1/2013 $359,304.94 $2,462.87 $1,871.38 $591.49 200 $358,513.45 62 3/1/2013 $358,513.45 $2,462.87 $1,867.26 $595.61 200 $357,717.84 63 4/1/2013 $357,717.84 $2,462.87 $1,863.11 $599.76 200 $356,918.08 64 5/1/2013 $356,918.08 $2,462.87 $1,858.95 $603.92 200 $356,114.16 65 6/1/2013 $356,114.16 $2,462.87 $1,854.76 $608.11 200 $355,306.05 66 7/1/2013 $355,306.05 $2,462.87 $1,850.55 $612.32 200 $354,493.74 67 8/1/2013 $354,493.74 $2,462.87 $1,846.32 $616.55 200 $353,677.19 68 9/1/2013 $353,677.19 $2,462.87 $1,842.07 $620.80 200 $352,856.39 69 10/1/2013 $352,856.39 $2,462.87 $1,837.79 $625.08 200 $352,031.32 70 11/1/2013 $352,031.32 $2,462.87 $1,833.50 $629.37 200 $351,201.94 71 12/1/2013 $351,201.94 $2,462.87 $1,829.18 $633.69 200 $350,368.25 72 1/1/2014 $350,368.25 $2,462.87 $1,824.83 $638.03 200 $349,530.22 73 2/1/2014 $349,530.22 $2,462.87 $1,820.47 $642.40 200 $348,687.82 74 3/1/2014 $348,687.82 $2,462.87 $1,816.08 $646.79 200 $347,841.03 75 4/1/2014 $347,841.03 $2,462.87 $1,811.67 $651.20 200 $346,989.83 76 5/1/2014 $346,989.83 $2,462.87 $1,807.24 $655.63 200 $346,134.20 77 6/1/2014 $346,134.20 $2,462.87 $1,802.78 $660.09 200 $345,274.12 78 7/1/2014 $345,274.12 $2,462.87 $1,798.30 $664.57 200 $344,409.55 79 8/1/2014 $344,409.55 $2,462.87 $1,793.80 $669.07 200 $343,540.48 80 9/1/2014 $343,540.48 $2,462.87 $1,789.27 $673.60 200 $342,666.89 81 10/1/2014 $342,666.89 $2,462.87 $1,784.72 $678.15 200 $341,788.74 82 11/1/2014 $341,788.74 $2,462.87 $1,780.15 $682.72 200 $340,906.02 83 12/1/2014 $340,906.02 $2,462.87 $1,775.55 $687.32 200 $340,018.71 84 1/1/2015 $340,018.71 $2,462.87 $1,770.93 $691.94 200 $339,126.77 85 2/1/2015 $339,126.77 $2,462.87 $1,766.29 $696.58 200 $338,230.18 86 3/1/2015 $338,230.18 $2,462.87 $1,761.62 $701.25 200 $337,328.93 87 4/1/2015 $337,328.93 $2,462.87 $1,756.92 $705.95 200 $336,422.98 88 5/1/2015 $336,422.98 $2,462.87 $1,752.20 $710.67 200 $335,512.32 89 6/1/2015 $335,512.32 $2,462.87 $1,747.46 $715.41 200 $334,596.91 90 7/1/2015 $334,596.91 $2,462.87 $1,742.69 $720.18 200 $333,676.73 91 8/1/2015 $333,676.73 $2,462.87 $1,737.90 $724.97 200 $332,751.76 92 9/1/2015 $332,751.76 $2,462.87 $1,733.08 $729.79 200 $331,821.98 93 10/1/2015 $331,821.98 $2,462.87 $1,728.24 $734.63 200 $330,887.35 94 11/1/2015 $330,887.35 $2,462.87 $1,723.37 $739.50 200 $329,947.85 95 12/1/2015 $329,947.85 $2,462.87 $1,718.48 $744.39 200 $329,003.46 96 1/1/2016 $329,003.46 $2,462.87 $1,713.56 $749.31 200 $328,054.15 97 2/1/2016 $328,054.15 $2,462.87 $1,708.62 $754.25 200 $327,099.90 98 3/1/2016 $327,099.90 $2,462.87 $1,703.65 $759.22 200 $326,140.67 99 4/1/2016 $326,140.67 $2,462.87 $1,698.65 $764.22 200 $325,176.45 100 5/1/2016 $325,176.45 $2,462.87 $1,693.63 $769.24 200 $324,207.21 101 6/1/2016 $324,207.21 $2,462.87 $1,688.58 $774.29 200 $323,232.92 Payment Number Beginning Balance Regular Payment Ending Balance A B C D E F G H I J K L M N O P 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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
102 7/1/2016 $323,232.92 $2,462.87 $1,683.50 $779.36 200 $322,253.56 103 8/1/2016 $322,253.56 $2,462.87 $1,678.40 $784.46 200 $321,269.10 104 9/1/2016 $321,269.10 $2,462.87 $1,673.28 $789.59 200 $320,279.50 105 10/1/2016 $320,279.50 $2,462.87 $1,668.12 $794.75 200 $319,284.76 106 11/1/2016 $319,284.76 $2,462.87 $1,662.94 $799.93 200 $318,284.83 107 12/1/2016 $318,284.83 $2,462.87 $1,657.73 $805.14 200 $317,279.69 108 1/1/2017 $317,279.69 $2,462.87 $1,652.50 $810.37 200 $316,269.32 109 2/1/2017 $316,269.32 $2,462.87 $1,647.24 $815.63 200 $315,253.69 110 3/1/2017 $315,253.69 $2,462.87 $1,641.95 $820.92 200 $314,232.77 111 4/1/2017 $314,232.77 $2,462.87 $1,636.63 $826.24 200 $313,206.53
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}