# Mortgage Payment Calculator - Excel Templates

Document Sample

```					To use this Mortgage Payment calculator, fill-in the yellow shaded cells. Your mortgage amortization schedule will complete auto

Rebuz Mortgage Payment Calculator                                     Mortgage Terms Glossary
Inputs                                           Key Loan Figures
Loan principal amount                   \$250,000.00                   Annual loan payments
Annual interest rate (x.xxx%)           7.000%                        Monthly payments
Loan period in years                    30                            Interest in first calendar year
Base year of loan                       2006                          Interest over term of loan
Base month of loan                      7                             Sum of all payments

Payments in First Year
Beginning        Mortgage                                      Cumulative     Cumulative
Year   Month                                            Principal     Interest
Balance          Payment                                       Principal Paid Interest
Paid
2006   Jan                \$250,000.00       \$1,663.26       \$204.93       \$1,458.33         \$204.93    \$1,458.33
Feb                \$249,795.07       \$1,663.26       \$206.12       \$1,457.14         \$411.05    \$2,915.47
Mar                \$249,588.95       \$1,663.26       \$207.32       \$1,455.94         \$618.37    \$4,371.41
Apr                \$249,381.63       \$1,663.26       \$208.53       \$1,454.73         \$826.90    \$5,826.14
May                \$249,173.10       \$1,663.26       \$209.75       \$1,453.51       \$1,036.65    \$7,279.65
Jun                \$248,963.35       \$1,663.26       \$210.97       \$1,452.29       \$1,247.62    \$8,731.94
Jul                \$248,752.38       \$1,663.26       \$212.20       \$1,451.06       \$1,459.82 \$10,183.00
Aug                \$248,540.18       \$1,663.26       \$213.44       \$1,449.82       \$1,673.26 \$11,632.82
Sep                \$248,326.74       \$1,663.26       \$214.69       \$1,448.57       \$1,887.95 \$13,081.39
Oct                \$248,112.05       \$1,663.26       \$215.94       \$1,447.32       \$2,103.89 \$14,528.71
Nov                \$247,896.11       \$1,663.26       \$217.20       \$1,446.06       \$2,321.09 \$15,974.77
Dec                \$247,678.91       \$1,663.26       \$218.47       \$1,444.79       \$2,539.56 \$17,419.56

Yearly Schedule of Balances and Payments
Beginning                                                Cumulative Cumulative                 Ending
Year                  Payment       Principal      Interest
Balance                                                  Principal      Interest Paid          Balance
2007     \$247,460.44     \$19,959.12      \$2,722.52 \$17,236.60 Paid \$5,262.08       \$34,656.16          \$244,737.92
2008     \$244,737.92     \$19,959.12      \$2,919.97 \$17,039.15        \$8,182.05     \$51,695.31          \$241,817.95
2009     \$241,817.95     \$19,959.12      \$3,131.05 \$16,828.07       \$11,313.10     \$68,523.38          \$238,686.90
2010     \$238,686.90     \$19,959.12      \$3,357.40 \$16,601.72       \$14,670.49     \$85,125.11          \$235,329.51
2011     \$235,329.51     \$19,959.12      \$3,600.10 \$16,359.02       \$18,270.60    \$101,484.12          \$231,729.40
2012     \$231,729.40     \$19,959.12      \$3,860.35 \$16,098.77       \$22,130.95    \$117,582.89          \$227,869.05
2013     \$227,869.05     \$19,959.12      \$4,139.42 \$15,819.70       \$26,270.37    \$133,402.59          \$223,729.63
2014     \$223,729.63     \$19,959.12      \$4,438.66 \$15,520.46       \$30,709.03    \$148,923.05          \$219,290.97
2015     \$219,290.97     \$19,959.12      \$4,759.53 \$15,199.59       \$35,468.56    \$164,122.64          \$214,531.44
2016     \$214,531.44     \$19,959.12      \$5,103.60 \$14,855.52       \$40,572.15    \$178,978.17          \$209,427.85
2017     \$209,427.85     \$19,959.12      \$5,472.54 \$14,486.58       \$46,044.69    \$193,464.75          \$203,955.31
2018     \$203,955.31     \$19,959.12      \$5,868.15 \$14,090.97       \$51,912.83    \$207,555.73          \$198,087.17
2019     \$198,087.17     \$19,959.12      \$6,292.35 \$13,666.77       \$58,205.19    \$221,222.49          \$191,794.81
2020     \$191,794.81     \$19,959.12      \$6,747.23 \$13,211.89       \$64,952.42    \$234,434.38          \$185,047.58
2021     \$185,047.58     \$19,959.12      \$7,234.99 \$12,724.13       \$72,187.40    \$247,158.52          \$177,812.60
2022     \$177,812.60     \$19,959.12      \$7,758.00 \$12,201.12       \$79,945.41    \$259,359.63          \$170,054.59
2023     \$170,054.59     \$19,959.12      \$8,318.83 \$11,640.29       \$88,264.24    \$270,999.92          \$161,735.76
2024     \$161,735.76     \$19,959.12      \$8,920.20 \$11,038.92       \$97,184.44    \$282,038.84          \$152,815.56
2025     \$152,815.56     \$19,959.12      \$9,565.04 \$10,394.08     \$106,749.48     \$292,432.92          \$143,250.52
2026     \$143,250.52     \$19,959.12     \$10,256.50    \$9,702.62   \$117,005.98     \$302,135.54          \$132,994.02
2027     \$132,994.02     \$19,959.12     \$10,997.94    \$8,961.18   \$128,003.92     \$311,096.72          \$121,996.08
2028     \$121,996.08     \$19,959.12     \$11,792.99    \$8,166.13   \$139,796.91     \$319,262.85          \$110,203.09
2029     \$110,203.09     \$19,959.12     \$12,645.50    \$7,313.62   \$152,442.41     \$326,576.47           \$97,557.59
2030       \$97,557.59    \$19,959.12     \$13,559.65    \$6,399.47   \$166,002.05     \$332,975.95           \$83,997.95
2031       \$83,997.95    \$19,959.12     \$14,539.87    \$5,419.25   \$180,541.93     \$338,395.19           \$69,458.07
2032       \$69,458.07    \$19,959.12     \$15,590.96    \$4,368.16   \$196,132.89     \$342,763.35           \$53,867.11
2033       \$53,867.11    \$19,959.12     \$16,718.03    \$3,241.09   \$212,850.92     \$346,004.44           \$37,149.08
2034       \$37,149.08    \$19,959.12     \$17,926.58    \$2,032.54   \$230,777.50     \$348,036.98           \$19,222.50
2035       \$19,222.50    \$19,959.12     \$19,222.50      \$736.62   \$250,000.00     \$348,773.60                \$0.00

Key Loan Figures
\$19,959.12
\$1,663.26
\$17,419.56
\$348,773.60
\$598,773.60

Ending
Balance
\$249,795.07
\$249,588.95
\$249,381.63
\$249,173.10
\$248,963.35
\$248,752.38
\$248,540.18
\$248,326.74
\$248,112.05
\$247,896.11
\$247,678.91
\$247,460.44

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 14 posted: 5/17/2012 language: English pages: 2
fanzhongqing http://