• Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
Menu
  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
  • Latest News
    Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads
  • Latest News
    Excel To VCF Converter 1.1 – Excel To Vcard – 68,000 Downloads
  • Latest News
    Extract Web Page with Tables – Parse HTML Table – Data Mining Tool
  • Latest News
    Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook
  • Latest News
    Web Scraping – Extract Data from Website – To Excel VBA
  • Latest News
    VCF To Excel Converter – Open VCF File – Free 28,000+ Downloads
  • Latest News
    Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
  • Latest News
    Excel VBA – Import Data from Another Workbook – Macro to Query Excel
  • Latest News
    How to Telnet from Excel & Autorun Commands
  • Latest News
    Excel VBA – FTP Transfer – Files Download Upload
  • Latest News
    Microsoft Office – Communicator API – Verify Availability Status
  • Latest News
    Excel IP Address Lookup – Bulk GeoIP Lookup
  • Latest News
    Extract URL Links from Sitemap.xml file using Excel
  • Latest News
    Trace Lost Phone – Even Without Internet – Using SMS
  • Latest News
    Universal VCF to Excel and Excel to Vcard Converter
  • Latest News
    Download Facebook Videos – How To Get YouTube Video Downloader?
  • Latest News
    Block Game Requests On Facebook & Candy Crush Invites
  • Latest News
    How to Get stock prices in Excel? – Best Live Stock Ticker
  • Latest News
    How to Get Historical Stock Quotes In Excel – Google Finance
  • Latest News
    JSON Parser – Convert JSON To CSV – Excel VBA Macro
  • Latest News
    How To Screen Record – in IOS, iPhone, Android, Windows, Mac ?
  • Latest News
    How To Remove Duplicate Values in Excel, Google Sheets?
  • Latest News
    Best Bitcoin Trading Platforms – Cryptocurrency Market
  • Latest News
    Lock System at Scheduled Time with Excel
  • Latest News
    How to control Facebook Addiction? & Whatsapp Addcition
  • Latest News
    2018 – Hack Whatsapp Friends – Status Photos
  • Latest News
    Making SORT More Simple and Faster in Excel with Advanced Options
  • Latest News
    WordPress – Recent Posts Widget with Thumbnail – Without Plugins
  • Latest News
    Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
  • Latest News
    Display Related Posts with Thumbnails in WordPress without Plugins
  • Latest News
    Post to Facebook Timeline through Email
  • Latest News
    100 CryptoCurrency Price – Ticker in Excel – Using VBA
  • Latest News
    Engineering Unit Converter Download – Excel Table – Feet To Meters
  • Latest News
    Android ICS File Viewer – Calendar file View in Exce;
  • Latest News
    Download – Backup Facebook Twitter Gplus Linkedin – Data To PC
  • Latest News
    How to remove #n/a in Excel? – Fixing Vlookup #n/a
  • Latest News
    #NoForwardsDay – New WhatsApp Texting Pattern that Would Make You Go Crazy
  • Latest News
    Sudoku Excel Download – Puzzle Solver – Free Game Help
  • Latest News
    Top 4 Whatsapp Tips and Tricks You Didn’t know Existed
  • Latest News
    Mortgage Calculator – Loan EMI Scheduler
  • Latest News
    Learn How To Code JavaScript in VBA
  • Latest News
    How To Open VCF File – Online VCF Viewers – 4 Easy Ways
  • Latest News
    How To Block Unwanted Text Messages in Iphone?
  • Latest News
    How To Scrap A Website Keywords? – Keyword Scraping Excel
  • Latest News
    Login to Facebook, Twitter, Google+ in IE from Excel
  • Latest News
    Excel Instant Messenger – Microsoft Office Communicator API Library
  • Latest News
    Skyrocket Website Traffic With Reddit
  • Latest News
    Excel Games Free Download – 2048 Tile Game
  • Latest News
    How to Speed Up Google Chrome
  • Latest News
    VBA Code – Create Index of Worksheets – with Links to each Sheet

Mortgage Calculator – Loan EMI Scheduler

  • Types of Mortgage Loan Interest Rates

    There are broadly two common types of interests in Mortgage Loans. In the first type, Interest is set to a Fixed rate of Loan Amount and in another the interest is set to a flexible or diminishing value. There are also other types available in market, but these two are the common ones.

    If it is a Fixed Interest, a percentage of the total loan amount is calculated as interest and the buyer has to pay the dues on his chosen number of Installments. The interest remains the same through out the Mortgage tenure.

    Also Read: Password Protect Excel 2010 & 2007 with Built in Option

    In Flexible Interest type, the Interest is calculated for the Loan Remaining Amount after every installment payment. Whether it is fixed or flexible, people will choose the Mortgage which charges them with less possible Interest Amount.

    Mortgage Repayment Calculator ( PITI Mortgage Calculator)

    Download Flexible Mortgage Repayment Calculator. Click Here Downloaded 245 Times

    As of now we got to know an overview about the Mortgage types, lets see how to generate the amortization schedule for a Mortgage repayment using our simple Excel template. Amortization Schedule refers to the table containing details like interest amount, reduced principle amount,property tax, insurance, etc., to be paid for each tenure.

    When choosing fixed interest mortgage loan, it is easier to calculate and understand the monthly payments. But with diminishing interest, it is little difficult to derive the complete loan payment scheduler. Our Simple Excel template can ease out this situation for you.

    Input Data Fields:

    1. Principle Amount: Mortgage Loan amount sought by individual
    2. Rate of Interest (in % per Year): Loan Interest Rate Opted by individual
    3. Loan Tenure Duration: Number of Payment installments given in Months
    4. Property Tax Amount, if any (per Year): As a owner of the property, tax paid for it
    5. Insurance Amount, if any ( per Year): It refers to Property Insurance or Private Mortgage Insurance.

    Output Amortization Schedule:

    1. Total Payment towards Mortgage Loan: Total payment amount calculated using the summation of total Loan amount and total Interest paid for the full tenure.
    2. Total Interest Amount: Total interest amount paid for the full tenure of the loan
    3. Total Tax & Insurance: Total amount spent for Tax and Insurance for the full loan tenure period

    Above details would be estimated and it would be shown after providing the correct input data of the chosen Mortgage loan. It will also list the monthly payment scheduler in a tabular format which is widely called as ‘Amortization Schedule’.

    In the Mortgage world, amortization schedule inclusive of Property Tax and Insurance added with Principle & Interest is also called as ‘PRINCIPAL, INTEREST, TAXES, INSURANCE – PITI Mortgage Schedule’.

    Hope you like our simple Excel PITI Mortgage Calculator, please let us know your feedback.

    Download Flexible Mortgage Repayment Calculator. Click Here Downloaded 245 Times

    Also Read: Find IP Address Location – GeoIP Lookup

    Author: Kumarapush

    Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.

    View all posts by Kumarapush | Website


    Previous Post: How to Generate QR code using Google Chart API
    Next Post: Best Trick to Speed up Phone Internet


    • morgan debra

      Hello,

      This is to inform the general public that Mrs , BRENDA HOPE a private loan lender has open up a financial opportunity for everyone in need of any financial help. We give out loan at 2% interest rate to individuals, firms and companies under a clear and understandable terms and condition From

      $20000 to $7000000 USD, Euro And Pounds Only. I give out Business Loans,

      Personal Loans, Student Loans,Car Loans And Loans To Pay Off Bills. contact us today by e-mail at: (brendahope816@gmail.com)

Post Categories
Popular Posts
Export Outlook Emails To Excel...
Excel To VCF Converter 1.1 –...
Extract Web Page with Tables –...
Send Mass Email from Excel VBA...
VCF To Excel Converter –...
Web Scraping – Extract Data...
Print Screen Automation –...
Excel VBA – Import Data from...
How to Telnet from Excel &...
Excel VBA – FTP Transfer...
Microsoft Office – Communicator...
Excel IP Address Lookup –...
Recent Posts
Enable Insert button in Excel greyed disabled show
Excel Insert Button is Disabled...
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates
Excel VBA - Find String in Range...
Excel VBA Convert Amount in Numbers to Words US Dollar Million Indian Rupee Lakhs Crores finance
Excel VBA Convert - Amount (Numbers)...
Excel VBA Code Get Names of All open workbook path Loop through
Excel VBA - Loop Through All Open...
Name Numerology Lucky Number Calculator Baby names Business name
Name Numerology Calculator - Lucky...
Similar Pages
  • Excel VBA Code Get Names of All open workbook path Loop through
    Excel VBA – Loop Through All...
  • Name Numerology Lucky Number Calculator Baby names Business name
    Name Numerology Calculator –...
  • How To type Subscript in Excel Superscript strikethrough underline font
    How To Type Subscript in Excel –...
  • Excel VBA Merge Cells Unmerge Range Selection objects
    Excel VBA – Merge Cells –...
  • Excel VBA Convert Column Letter Alphabet to Number
    Excel VBA – Convert Column...
  • Excel VBA Convert Column Number to Letter Formula
    Excel VBA – Convert Column...
Popular Tags
  • Email Marketing Block Apps in FaceBook Task Manager print screen VCF HTML Table Import Data Candy Crush Outlook Record Macro android app development SEO Convert URL to IP HTML/ Javascript QR Code Generation VCARD Timer in Excel Countif Google+ bitcoin vba color index vba color codes Data Mining Android social media Twitter bulk email Google Adsense Tips Excel VBA Calendar in Excel Excel Macro WhatsApp Facebook mass email outlook vba Wordpress
FREE Tech Updates

Home

  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling

Trending Topics

    • Learn How to Access WhatsApp in Web
    • Compare Data In Two Excel Sheets
    • Find IP Address Location – GeoIP Lookup
    • Lock a Folder In Windows Using This Simple Excel Macro Trick
    • Download Free Tool to Convert VCF Contacts to Excel

Join Us

Copyright © 2018 OfficeTricks.com