Rebuz-Excel-Mortgage-payment-calculator _1_

Reviews
Shared by: Dudi Einey
Categories
Tags
Stats
views:
27
rating:
not rated
reviews:
0
posted:
9/8/2008
language:
UNKNOWN
pages:
0
Rebuz Mortgage Payment Calculator Inputs Loan principal amount Annual interest rate (x.xxx%) Loan period in years Base year of loan Base month of loan Payments in First Year Year 2006 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Beginning Balance $250,000.00 $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 Mortgage Payment $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 $1,663.26 Principal $204.93 $206.12 $207.32 $208.53 $209.75 $210.97 $212.20 $213.44 $214.69 $215.94 $217.20 $218.47 $250,000.00 7.000% 30 2006 7 Mortgage Terms Glossary Key Loan Figures Annual loan payments Monthly payments Interest in first calendar year Interest over term of loan Sum of all payments Interest $1,458.33 $1,457.14 $1,455.94 $1,454.73 $1,453.51 $1,452.29 $1,451.06 $1,449.82 $1,448.57 $1,447.32 $1,446.06 $1,444.79 Cumulative Cumulative Principal Paid Interest Paid $204.93 $1,458.33 $411.05 $2,915.47 $618.37 $4,371.41 $826.90 $5,826.14 $1,036.65 $7,279.65 $1,247.62 $8,731.94 $1,459.82 $10,183.00 $1,673.26 $11,632.82 $1,887.95 $13,081.39 $2,103.89 $14,528.71 $2,321.09 $15,974.77 $2,539.56 $17,419.56 Yearly Schedule of Balances and Payments Year 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Beginning Cumulative Cumulative Payment Principal Interest Balance Principal Interest Paid $247,460.44 $19,959.12 $2,722.52 $17,236.60 Paid $5,262.08 $34,656.16 $244,737.92 $19,959.12 $2,919.97 $17,039.15 $8,182.05 $51,695.31 $241,817.95 $19,959.12 $3,131.05 $16,828.07 $11,313.10 $68,523.38 $238,686.90 $19,959.12 $3,357.40 $16,601.72 $14,670.49 $85,125.11 $235,329.51 $19,959.12 $3,600.10 $16,359.02 $18,270.60 $101,484.12 $231,729.40 $19,959.12 $3,860.35 $16,098.77 $22,130.95 $117,582.89 $227,869.05 $19,959.12 $4,139.42 $15,819.70 $26,270.37 $133,402.59 $223,729.63 $19,959.12 $4,438.66 $15,520.46 $30,709.03 $148,923.05 $219,290.97 $19,959.12 $4,759.53 $15,199.59 $35,468.56 $164,122.64 $214,531.44 $19,959.12 $5,103.60 $14,855.52 $40,572.15 $178,978.17 $209,427.85 $19,959.12 $5,472.54 $14,486.58 $46,044.69 $193,464.75 $203,955.31 $19,959.12 $5,868.15 $14,090.97 $51,912.83 $207,555.73 $198,087.17 $19,959.12 $6,292.35 $13,666.77 $58,205.19 $221,222.49 $191,794.81 $19,959.12 $6,747.23 $13,211.89 $64,952.42 $234,434.38 $185,047.58 $19,959.12 $7,234.99 $12,724.13 $72,187.40 $247,158.52 $177,812.60 $19,959.12 $7,758.00 $12,201.12 $79,945.41 $259,359.63 $170,054.59 $19,959.12 $8,318.83 $11,640.29 $88,264.24 $270,999.92 $161,735.76 $19,959.12 $8,920.20 $11,038.92 $97,184.44 $282,038.84 $152,815.56 $19,959.12 $9,565.04 $10,394.08 $106,749.48 $292,432.92 $143,250.52 $19,959.12 $10,256.50 $9,702.62 $117,005.98 $302,135.54 $132,994.02 $19,959.12 $10,997.94 $8,961.18 $128,003.92 $311,096.72 $121,996.08 $19,959.12 $11,792.99 $8,166.13 $139,796.91 $319,262.85 $110,203.09 $19,959.12 $12,645.50 $7,313.62 $152,442.41 $326,576.47 $97,557.59 $19,959.12 $13,559.65 $6,399.47 $166,002.05 $332,975.95 $83,997.95 $19,959.12 $14,539.87 $5,419.25 $180,541.93 $338,395.19 $69,458.07 $19,959.12 $15,590.96 $4,368.16 $196,132.89 $342,763.35 $53,867.11 $19,959.12 $16,718.03 $3,241.09 $212,850.92 $346,004.44 $37,149.08 $19,959.12 $17,926.58 $2,032.54 $230,777.50 $348,036.98 $19,222.50 $19,959.12 $19,222.50 $736.62 $250,000.00 $348,773.60 Ending Balance $244,737.92 $241,817.95 $238,686.90 $235,329.51 $231,729.40 $227,869.05 $223,729.63 $219,290.97 $214,531.44 $209,427.85 $203,955.31 $198,087.17 $191,794.81 $185,047.58 $177,812.60 $170,054.59 $161,735.76 $152,815.56 $143,250.52 $132,994.02 $121,996.08 $110,203.09 $97,557.59 $83,997.95 $69,458.07 $53,867.11 $37,149.08 $19,222.50 $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

Other docs by Dudi Einey
Sesame Street - 40th Anniversary
Views: 47  |  Downloads: 0
100 Outstanding Marketing Tips
Views: 60  |  Downloads: 2
Your Guide to Good Health Insurance
Views: 115  |  Downloads: 0
Timeless Sales Strategies
Views: 139  |  Downloads: 0
Selling Your First Million
Views: 153  |  Downloads: 0
ACORN Investigation Jarramt Arrest Warrant
Views: 31  |  Downloads: 1
United Nations Nations Unies
Views: 162  |  Downloads: 0
UNITED £% NATIONS O Security Council
Views: 114  |  Downloads: 0
Security Council
Views: 156  |  Downloads: 0
A S
Views: 107  |  Downloads: 0
S
Views: 106  |  Downloads: 0