Software For Calculating "accelerated" Mortgage Payment
Q: Does anyone know of software that can calculate "accelerated" mortgage payment? "Accelerated" means paying an additional amount towards the principle each month. What I want to know is how much additional payment I have to make in order to shorten the life of my mortgage loan by X number of years.
Any comments???
A: The expression to calculate loan/mortgage payments is: Payment = P*r/(1-(1+r)^(-n)) where: P = Principle amount (amount borrowed) r = rate of interest n = number of payments For example, if $125,000 is borrowed at 8% annual interest for 30 years and payed off monthly, then: Monthly payment = $125,000*(.08/12)/(1-(1+.08/12)^(-30*12) = $917.21 (Of this $917.21, the interest part is .08/12 times the present unpaid balance (which decreases every month), and the rest is principle paid. On the first payment, interest is $833.33.) To find how much more you'd have to pay per month to shorten the life of your mortgage by X years, calculate the payment for Y years, then calculate it again for (Y-X) years. Spreadsheet programs (Quattro Pro, Lotus 123, etc) have an @function to perform payment calculations. Try ( for the above example): .
Discuss It!
Most Popular Articles
- Free Printable Power Of Attorney Form
- Accurate Forex Signals
- Florida Power Of Attorney Form
- Electrical Engineering Vs. Electrical Engineering Technology Salaries
- Is It Associate Or Associates Degree?
- Heartburn In Early Pregnancy
- Immigration Law For Students
- Prozac And Alcohol
- Texas Power Of Attorney Form
- What Is Major Medical Insurance?
- Reflux
- On All Three Credit Reports.
- Free Durable Power Of Attorney Form
- Education
- Lawyer
- Accounting Degree Vs Certificate
- Celexia Side Effects
- Heartburn Gerd
- Free Ged Study Guide
- Jewelry
Marketplace
Related Articles
- Calculator Interest Mortgage Payment Uk
- Leaving The Mortgage Home Loan As Secondary?
- Interest?
- Mortgage Payment Calculator
- Mortgage Payment Calculator
- Calculator Mortgage Payment Repayment Schedule
- Getting Your Mortgage Rate
- Mortgage Rates Are Only Around 8%??
- The Idea Of The Mortgage Loan
- Finding A Good Mortgage Rate
- How Do You Calculate Monthly Mortgage Payments
- Summarises Uk Mortgage Rates ?
- Mortgage Payment Calculator Interest
- What Is A Mortgage Calculator?
- Understanding Mortgage Rates
- Find A Mortgage Loan
- Depression (was Mortgage Rates (was Momentarily Verbal)) ?
- Why Choose An Interest Only Mortgage?
- How Are California Mortgages Different?
- Refinance Mortgage Rates
- Rate With An Rv Refinance Company?
- Child Degree Education Job Loan Mortgage
- Auto Payment Loan Calculator
- Best Bank For Home Equity Line Right Now
- Mortgage Financing
- Spend For Rent Into Mortgage Payments
- Considerations In Refinancing An Auto Loan
- Getting The Best Rates On A Home Improvement Loan
- Mortgage Financing
- Calculator Loan Amortization
Related Categories
- Debt
- Travel
- Payday
- Gifts
- Merchant
- Printing
- Apparel
- Repo
- Invest
- Back Pain
- Letterhead
- Christmas
- Train
- Fashion
- Forex
- Glasses
- Hosting
- More
- Depression
Recently Added
- Funding Agencies in India
- Open Source Project Management Software
- Project Time Management
- Digital Media Asset Management
- Free Forex Strategies
- Forex Rates Online
- Reserve Bank Of India Forex Rate
- Free Forex Trading Tutorial
- Forex Auto Trading System
- Forex Brokerage Firms
- Free Forex Signals Software
- Swiss Forex Traders
- Forex Trading Mini Account
- Forex Software Trader
- Live Forex News
- Autopilot Robots Trading The Forex Market
- Best Forex Signals
- Wall Street Forex
- Managed Forex Funds
- Forex Broker Reviews