How Do You Calculate Mortgage Payments
Q: I'm interested in knowing exactly how it is that mortgages are calculated. The internet is no help because all search attempts point to mortgage calculators, not the method of mortgage calculating.
Any explanation or comments for me???
A: If the interest is compounded monthly, the mortgage payment can be computed by: PMT = PV * r / (1 - 1/((1 + r)^n)) where PV is the loan amount, n is the length of the loan in months, and r is i/12, where i is the nominal annual interest rate (not the APR). In Excel, it is simply PMT(i/12, n,, -PV). The lender should always round __up__ PMT at least to cents to ensure that the last payment is no more than the others -- unless the lender chooses to disclose the difference. I believe that is the formula that most online mortgage calculators use. If the interest is compounded daily , the mortgage payment __should__ be computed as above, but r is (1 + i/365)^(365/12) - 1. In Excel: PMT((1 + i/365)^(365/12) - 1, n,, -LOAN). In Excel, r can also be computed using FV(i/365, 365/12,, -1) - 1. However, I cannot say if any lenders use the latter formulas to determine the payment when interest is compounded daily. Instead, the payment might still be determined by the compounded-monthly formula, and the daily interest rate might be as simple as i/365. Either or both can result in a larger last payment, which I believe the lender would have to disclose in the Reg Z statement . Even if the lender uses the more accurate compounded-daily formula, the last payment is likely to be slightly higher -- at least in amortization tables that I have created. This is because months contain 30, 31, 28 and 29 days, not 365/12 days. Since I do not recall seeing disclosure of a balloon payment in the conventional US mortgages that I have been involved in directly or indirectly, I wonder if the lender is prepared to simply eats the extra interest in the last period . Many mortgages are paid off before the last scheduled payment anyway. .
Discuss It!
Most Popular Articles
- Free Printable Power Of Attorney For
- Accurate Forex Trading Signals
- Florida Power Of Attorney Form Free
- Electrical Engineering Vs. Electrical Engineering Technology Salaries
- Is It Associates Degree Or Associate Degree
- How Early In Pregnancy Do You Get Heartburn
- Immigration Law For Students
- Prozac And Alcohol
- Free Texas Power Of Attorney Form
- What Is Major Medical Insurance?
- Reflux
- On All Three Credit Reports.
- Free Durable Power Of Attorney Forms
- Education Department
- Lawyers
- Accounting Degree Vs. Certificate ?
- Selexa Side Effects
- Heartburn
- Free Ged Study Guide
- Jewelry Design
Marketplace
Related Articles
- Loan Mortgage Second
- Summarises Uk Mortgage Rates
- Leaving The Mortgage Home Loan As Secondary?
- Calculate Mortgage Payment Refinance
- Mortgage
- How Are California Mortgages Different?
- Using Mortgage Calculators Effectively
- What Is A Mortgage Calculator?
- Payment Calculator Mortgage
- Researching A Finance Mortgage
- Payment Calculator Mortgage
- Mortgage Rate Refinance
- We Have Never Been Late On Any Mortgage Payments Excep
- Getting Your Mortgage Rate
- How To Use A Mortgage Calculator
- Rates Mortgage
- Calculator Consolidate Debt Mortgage?
- Depression Was Mortgage Rates Was Momentarily Verbal
- What A Mortgage Calculator Can Do For You
- Have Paid Down Some Of The Mortgage?
- What You Can Learn About Life Insurance Online
- Considerations In Refinancing An Auto Loan
- Insurance Mortgage Life
- Auto Payment Loan Calculator
- House Insurance Mortgage
- Best Bank For Home Equity Line Right Now
- Rate With An Rv Refinance Company?
- Finance Mortgage
- Spend For Rent Into Mortgage Payments ?
- Getting The Best Rates On A Home Improvement Loan
- Life Insurance Company
- Looking For A Great Life Insurance Rate?
- 2nd Mortgage To Negate Pmi Insurance More Options
- Mortgage Financing
- Life Insurance: The Insurance For Others
- Loan Amortization Calculator
- Child Degree Education Job Loan Mortgage
Related Categories
- Coupons
- Travel
- Alcohol
- Marketing
- Fashion
- Rehab
- Letterhead
- Jobs
- Apparel
- Security
- Back Pain
- Perfume
- Train
- Computers
- Rental
- Energy
- Gifts
- Christmas
- General Engineering
- Invest
Recently Added
- Research Funding Agencies In India
- Open Source Project Management Software
- Time Project Management Software
- Media Asset Management Software
- Free Forex Strategy
- Forex Rate Online
- Reserve Bank Of India Forex Rate
- Free Forex Trading Tutorial
- Auto Forex Trading System
- Forex Brokerage Firms
- Forex Trading Signals Software
- Swiss Forex Trader
- Forex Trading Mini Account
- Forex Software Trader
- Live Forex News
- Trading The Forex Market
- Best Forex Trading Signals
- Wall Street Forex India
- Forex Managed Funds
- Forex Broker Reviews