|
|
| Line 1: |
Line 1: |
| {{Refimprove|date=February 2008}}
| | Hi there, I am Yoshiko Villareal but I by no means really favored that title. Her family lives in Idaho. One of my favorite hobbies is tenting and now I'm trying to make money with it. She is currently a cashier but quickly she'll be on her own.<br><br>My web site; extended auto warranty ([http://www.Focusd.co/UserProfile/tabid/61/userId/191/Default.aspx click this link here now]) |
| '''Mortgage calculators''' are used to help a current or potential real estate owner determine how much they can afford to borrow on a piece of real estate. Mortgage calculators can also be used to compare the costs, interest rates, payment schedules, or help determine the change in the length of the mortgage loan by making added principal payments.
| |
| | |
| A mortgage calculator is an automated tool that enables the user to quickly determine the financial implications of changes in one or more variables in a [[Mortgage loan|mortgage]] financing arrangement. The major variables include loan principal balance, periodic [[compound interest]] rate, number of payments per year, total number of payments and the regular payment amount.
| |
| | |
| Mortgage calculation capabilities can be found on financial handheld calculators such as the [[HP-12C]] or [[Texas Instruments]] TI BA II Plus. There are also multiple free online free mortgage calculators, and software programs offering financial and mortgage calculations.
| |
| | |
| ==Uses==
| |
|
| |
| When purchasing a new home, most buyers choose to finance a portion of the purchase price via the use of a mortgage. Prior to the wide availability of mortgage calculators, those wishing to understand the financial implications of changes to the five main variables in a mortgage transaction were forced to use [[compound interest]] rate tables. These tables generally required a working understanding of compound interest mathematics for proper use. In contrast, mortgage calculators make answers to questions regarding the impact of changes in mortgage variables available to everyone.
| |
|
| |
| Mortgage calculators can be used to answer such questions as:
| |
|
| |
| If one borrows $250,000 at a 7% annual interest rate and pays the loan back over thirty years, with $3,000 annual property tax payment, $1,500 annual property insurance cost and 0.5% annual private mortgage insurance payment, what will the monthly payment be? The answer is $2,142.42.
| |
| | |
| A potential borrower can use an online mortgage calculator to see how much property he or she can afford. A lender will compare the person's total monthly income and total monthly debt load. A mortgage calculator can help to add up all income sources and compare this to all monthly debt payments. It can also factor in a potential [[Mortgage loan|mortgage]] payment and other associated housing costs ([[property taxes]], homeownership dues, etc.). One can test different loan sizes and interest rates. Generally speaking, lenders do not like to see all of a borrower's debt payments (including property expenses) exceed around 40% of total monthly pretax income. Some mortgage lenders are known to allow as high as 55%.
| |
| | |
| == Monthly payment formula ==
| |
| {{See also|Compound interest#Monthly amortized loan or mortgage payments}}
| |
| | |
| The fixed monthly payment for a [[fixed rate mortgage]] is the amount paid by the borrower every month that ensures that the loan is paid off in full with interest at the end of its term. The monthly payment formula is based on the [[annuity formula]]. The monthly payment ''c'' depends upon:
| |
| | |
| * ''r'' - the monthly [[interest rate]], expressed as a [[decimal]], not a percentage. Since the quoted yearly percentage rate is not a compounded rate, the monthly percentage rate is simply the yearly percentage rate divided by 12; dividing the monthly percentage rate by 100 gives ''r'', the monthly rate expressed as a decimal.
| |
| * ''N'' - the number of monthly payments, called the ''loan's term'', and
| |
| * ''P'' - the amount borrowed, known as the ''loan's [[:wikt:principal|principal]]''.
| |
| | |
| In the standardized calculations used in the United States, ''c'' is given by the [[formula]]:<ref>Kohn, Robert. "A capital budgeting model of the supply and demand of loanable funds", ''Journal of Macroeconomics'' 12, Summer 1990, pp. 427-436 (specifically p. 430).</ref>
| |
| | |
| :<math>c = \frac{r P}{1-(1+r)^{-N}} = \frac {Pr(1+r)^N}{(1+r)^N-1}.</math>
| |
| | |
| For example, for a home loan for $200,000 with a fixed yearly interest rate of 6.5% for 30 years, the principal is <math>P=200000</math>, the monthly interest rate is <math>r=(6.5/12)/100</math>, the number of monthly payments is <math>N=30\cdot 12=360</math>, the fixed monthly payment equals $1,264.14. This formula is provided using the financial function <tt>PMT</tt> in a [[spreadsheet]] such as [[Microsoft Excel|Excel]]. In the example, the monthly payment is obtained by entering either of the these formulas:
| |
| | |
| :<tt>= PMT(6.5 / 100 / 12, 30 * 12, 200000)</tt>
| |
| :<tt>= ((6.5 / 100 / 12) * 200000) / (1 - ((1 + (6.5 / 100 / 12)) ^ (-30 * 12)))</tt>
| |
| :<tt>= 1264.14</tt>
| |
| | |
| The following derivation of this formula illustrates how fixed-rate mortgage loans work. The amount owed on the loan at the end of every month equals the amount owed from the previous month, plus the interest on this amount, minus the fixed amount paid every month. This fact results in the debt schedule:
| |
| | |
| ::Amount owed at initiation: <math>P</math>
| |
| ::Amount owed after 1 month: <math>(1+r)P-c</math>
| |
| ::Amount owed after 2 months: <math>(1+r)((1+r)P-c)-c = (1+r)^2P - (1+(1+r))c</math>
| |
| ::Amount owed after 3 months: <math>(1+r)((1+r)((1+r)P-c)-c)-c = (1+r)^3P - (1+(1+r)+(1+r)^2)c</math>
| |
| :: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
| |
| ::Amount owed after ''N'' months: <math>(1+r)^NP - (1+(1+r)+(1+r)^2+ \cdots +(1+r)^{N-1})c</math>
| |
| | |
| The [[polynomial]] <math>p_N(x)=1+x+x^2+ \cdots +x^{N-1}</math> appearing before the fixed monthly payment ''c'' (with <math>x=1+r</math>) is called a [[cyclotomic polynomial]]; it has a simple [[closed-form expression]] obtained from observing that <math>xp_N(x)-p_N(x)=x^N-1</math> because all but the first and last terms in this difference cancel each other out. Therefore, solving for <math>p_N(x)</math> yields the much simpler [[closed-form expression]]
| |
| | |
| :<math>p_N(x)=1+x+x^2+ \cdots +x^{N-1} = \frac{x^N-1}{x-1}.</math>
| |
| | |
| Applying this fact about [[cyclotomic polynomial]]s to the amount owed at the end of the ''N''th month gives (using <math>p_N</math> to succinctly denote the function value <math>p_N(x)</math> at argument value ''x'' = (1+''r'' )):
| |
| :Amount owed at end of month ''N''
| |
| | |
| :: <math>
| |
| \begin{align}
| |
| & {} = (1+r)^NP - p_Nc \\
| |
| & {} = (1+r)^NP - \frac{(1+r)^N-1}{(1+r)-1} c \\
| |
| & {} = (1+r)^NP - \frac{(1+r)^N-1}{r} c.
| |
| \end{align}
| |
| </math>
| |
| | |
| The amount of the monthly payment at the end of month ''N'' that is applied to principal paydown equals the amount ''c'' of payment minus the amount of interest currently paid on the pre-existing unpaid principal. The latter amount, the interest component of the current payment, is the interest rate ''r'' times the amount unpaid at the end of month ''N''–1. Since in the early years of the mortgage the unpaid principal is still large, so are the interest payments on it; so the portion of the monthly payment going toward paying down the principal is very small and equity in the property accumulates very slowly (in the absence of changes in the market value of the property). But in the later years of the mortgage, when the principal has already been substantially paid down and not much monthly interest needs to be paid, most of the monthly payment goes toward repayment of the principal, and the remaining principal declines rapidly.
| |
| | |
| The borrower's [[Equity (finance)|equity]] in the property equals the current market value of the property minus the amount owed according to the above formula.
| |
| | |
| With a [[fixed rate mortgage]], the borrower agrees to pay off the loan completely at the end of the loan's term, so the amount owed at month ''N'' must be zero. For this to happen, the monthly payment ''c'' can be obtained from the previous equation to obtain:
| |
| | |
| :<math>
| |
| \begin{align}
| |
| c & {} = \frac{r(1+r)^N}{(1+r)^N-1}P \\
| |
| & {} = \frac{r}{1-(1+r)^{-N}}P
| |
| \end{align}
| |
| </math> | |
| | |
| which is the formula originally provided. This derivation illustrates three key components of fixed-rate loans: (1) the fixed monthly payment depends upon the amount borrowed, the interest rate, and the length of time over which the loan is repaid; (2) the amount owed every month equals the amount owed from the previous month plus interest on that amount, minus the fixed monthly payment; (3) the fixed monthly payment is chosen so that the loan is paid off in full with interest at the end of its term and no more money is owed.
| |
| | |
| ==Adjustable Interest Rates==
| |
| | |
| While [[adjustable rate mortgages]] have been around for decades,<ref>{{cite web|url=http://www.loantech.com/Loantech_-_History_of_ARMs.html |title=History of ARMs |publisher=Loantech |date= |accessdate=2011-09-22}}</ref> from 2002 through 2005 [[adjustable-rate mortgages]] became more complicated as did the calculations involved.<ref>http://www.businessweek.com/magazine/content/06_37/b4000001.htm></ref> Lending became much more creative which complicated the calculations. Subprime lending and creative loans such as the “pick a payment”,<ref>{{cite news|url=http://www.usatoday.com/money/perfi/columnist/block/2005-07-18-pick-a-payment_x.htm |title='Pick-a-payment' mortgage risks are high |publisher=Usatoday.Com |date=2005-07-19 |accessdate=2011-09-22}}</ref> “pay option”,<ref>{{cite web|url=http://www.msnbc.msn.com/id/28035238/ |title='Pay option' loans could swell defaults - Business - Real estate - Mortgage Mess - msnbc.com |publisher=MSNBC |date= |accessdate=2011-09-22}}</ref> and “hybrid” loans brought on new era of mortgage calculations. The more creative adjustable mortgages meant some changes in the calculations to specifically handle these complicated loans. To calculate the [[annual percentage rate]]s (APR) many more variables needed to be added, including: the starting interest rate; the length of time at that rate; the recast; the payment change; the index; the margins; the periodic interest change cap; the payment cap; lifetime cap; the [[negative amortization]] cap; and others.<ref>{{cite web|url=http://mortgage-x.com/calculators/option_arm/pick_a_payment.asp |title=Pick-a-Payment ARM ~ Using Pay Option ARM Calculator |publisher=Mortgage-x.com |date= |accessdate=2011-09-22}}</ref> Many lenders created their own software programs, and [[World Savings]] even had contracted special calculators to be made by [[Calculated Industries]] specifically for their “pick a payment” program.<ref>[http://www.albion.edu/mathcs/MBollman/CI/Q+3px.htm ]{{dead link|date=September 2011}}</ref> However, by the late 2000s the Great Recession brought an end to many of the creative “pick-a-payment” type of loans which left many borrowers with higher loan balances over time, and owing more than their houses were worth.<ref>{{cite news|url=http://www.bizjournals.com/eastbay/stories/2008/06/30/daily8.html |title=Wachovia eliminates pick-a-payment mortgage loans - San Francisco Business Times |publisher=Bizjournals.com |date= 2008-06-30|accessdate=2011-09-22 |first=Will |last=Boye}}</ref> This also helped reduce the more complicated calculations that went along with these mortgages.
| |
| | |
| ==Mortgage Analyzer==
| |
| | |
| As a recent trend since 2007, in the wake of a financial crisis that was founded on many individuals' bad mortgage decision in residential borrowing, a new generation of mortgage calculation tools has emerged.{{Citation needed|date=April 2010}} They are better equipped to estimate the long-term cost and financial risk of various types of mortgages.{{Citation needed|date=April 2010}} Rather than "mortgage calculator", the new tools have become popularly known as "mortgage analyzers". Their main advantage is in the analysis of adjustable rate mortgages where the potential cost and amount owing on the mortgage are estimated under thousands, sometimes millions, of possible future mortgage rate scenarios, and then aggregate figures for average cost and risk based on all scenarios are estimated.{{Citation needed|date=April 2010}} Conventional mortgage calculators are capable of handling just a handful of scenarios.{{Citation needed|date=April 2010}}
| |
| | |
| ==Total Interest Paid Formula==
| |
| | |
| The total amount of interest <math>I</math> that will be paid over the lifetime of the loan is the difference of the total payment amount (<math>cN</Math>) and the loan principal (<math>P</math>):
| |
| | |
| :<math>I = cN - P </math>
| |
| where <math>c</math> is the fixed monthly payment, <math>N</math> is the number of payments that will be made, and <math>P</math> is the initial principal balance on the loan.
| |
| | |
| ==Outside the U.S.==
| |
| | |
| In the United Kingdom, the FCA - Financial Conduct Authority (formerly the FSA - Financial Services Authority) regulates loans secured on residential property. It does not prescribe any specific calculation method, however it does prescribe that for comparative purposes lenders must display an Annual Percentage Rate (as prominently as other rates).
| |
| | |
| In Spain, the regulatory authority has issued and enforced a standard calculation method, so Spanish mortgages from different lenders can be readily compared.{{Citation needed|date=February 2011}}
| |
| | |
| ==Calculation Sites==
| |
| [http://www.loanmodeler.com LoanModeler]
| |
| | |
| ==See also==
| |
| * [[Bridge financing]]
| |
| * [[Financing]]
| |
| * [[Fixed rate mortgage]]
| |
| * [[Adjustable rate mortgage]]
| |
| * [[Mortgage loan]]
| |
| * [[Promissory note]]
| |
| * [[Loan origination]]
| |
| * [[Subprime lending]]
| |
| | |
| ==References==
| |
| <!--- See http://en.wikipedia.org/wiki/Wikipedia:Footnotes on how to create references using <ref></ref> tags which will then appear here automatically -->
| |
| {{Reflist}}
| |
| | |
| ==External links==
| |
| {{Wiktionary}}
| |
| <!-- Please do NOT add your own mortgage calculator here, or links to sites that are part of or sponsored by mortgage companies. Any such links will be removed and you may be blocked for repeated addition of such links. -->
| |
|
| |
| * [http://www.dmoz.org/Business/Financial_Services/Mortgages/Calculators/ Mortgage Calculators] at the [[Open Directory Project]]
| |
| | |
| {{DEFAULTSORT:Mortgage Calculator}}
| |
| [[Category:Accounting software]]
| |
| [[Category:Basic financial concepts]]
| |
| [[Category:Mortgage]]
| |