EMI Chart Preparation for Home, Car & Personal Loan

It's a quick reference loan repayment EMI chart preparation tool to find a suitable monthly repayment for all personal, car (auto), educational and home loan obtainable in pdf, excel, printable and downloadable format. EMI chart is a table of monthly payment quick reference sheet for a range of interest rates and time periods for a certain loan amount. It is an improvised version and alternative to general EMI calculator to determine an affordable monthly payment to repay personal or car or home loan. The main purpose of this chart is to provide a quick reference for loan lenders or borrowers to figure out the variations on monthly payments based on the time period and interest rate variations for a certain loan amount

        Period     
x6.25% 6.5% 6.75% 7% 7.25% 7.5% 7.75% 8% 8.25% 8.5% 8.75% 9%
5 Years1944.931956.611968.351980.121991.942003.792015.72027.642039.632051.652063.722075.84
5Y 1M1917.761929.461941.2119531964.831976.711988.632000.592012.62024.652036.742048.87
5Y 2M1891.471903.191914.951926.761938.611950.511962.451974.431986.461998.532010.642022.8
5Y 3M1866.031877.761889.541901.371913.241925.151937.111949.111961.151973.251985.381997.56
5Y 4M1841.391853.141864.931876.771888.661900.591912.571924.591936.661948.771960.931973.13
5Y 5M1817.511829.281841.091852.951864.851876.81888.81900.841912.921925.061937.241949.46
5Y 6M1794.361806.141817.971829.851841.771853.741865.751877.821889.921902.081914.281926.52
5Y 7M1771.911783.711795.561807.451819.391831.381843.411855.491867.621879.81892.021904.29
5Y 8M1750.131761.941773.811785.721797.671809.681821.731833.831845.981858.181870.421882.72
5Y 9M1728.991740.821752.691764.621776.61788.621800.691812.821824.991837.21849.471861.78
5Y 10M1708.451720.31732.191744.141756.131768.171780.271792.411804.61816.841829.131841.46
5Y 11M1688.51700.371712.281724.241736.251748.311760.421772.591784.81797.061809.371821.73
6 Years1669.121680.991692.921704.91716.931729.011741.141753.321765.561777.841790.171802.55
6Y 1M1650.261662.161674.11686.11698.151710.251722.41734.61746.851759.161771.511783.92
6Y 2M1631.931643.841655.81667.811679.8816921704.171716.391728.671740.991753.371765.8
6Y 3M1614.091626.011637.991650.021662.111674.251686.441698.681710.971723.321735.721748.17
6Y 4M1596.721608.661620.661632.711644.811656.971669.181681.441693.761706.121718.551731.02
6Y 5M1579.811591.771603.781615.851627.971640.151652.381664.6616771689.391701.831714.33
6Y 6M1563.341575.321587.351599.431611.571623.771636.011648.321660.681673.091685.551698.07
6Y 7M1547.31559.291571.331583.441595.591607.811620.081632.41644.781657.211669.71682.24
6Y 8M1531.651543.661555.731567.851580.021592.261604.541616.891629.291641.741654.251666.82
6Y 9M1516.411528.431540.511552.651564.841577.11589.41601.771614.191626.671639.21651.79
6Y 10M1501.531513.581525.671537.831550.041562.311574.641587.031599.471611.971624.521637.14
6Y 11M1487.031499.081511.21523.371535.611547.91560.241572.651585.111597.631610.211622.85
7 Years1472.871484.941497.081509.271521.521533.831546.21558.621571.111583.651596.251608.91
Topics
How it differ from other traditional EMI calculators?

According to the different financial positions, people always would prefer to go for the suitable or affordable monthly repayments by changing the different available interest rates and tenures. A traditional EMI calculator generally allows user to calculate monthly repayment for one set of principal, interest rate and time period, thus the result is a single monthly payment. Every time user has to adjust the components of monthly payment calculation. In contrast, this EMI chart provides the matrix of monthly payments for the range of different interest rates and time periods, so it can reduce the frequency of using it multiple times to find the right EMI for a certain amount of loan. This EMI chart for loan borrowers is to help the users to make the comparison very simple, in the way it is provided.

Who can use this EMI chart to find a suitable monthly payment?
  1. Home loan buyers or lenders
  2. Auto or Car loan buyers or lenders
  3. Personal loan buyers or lenders
  4. Education loan buyers or lenders
  5. Any financial institution that offers loan based on EMI
How to Use this tool to prepare an EMI Chart?

To determine an affordable EMI or monthly payment for a certain amount of loan, follow the below steps to prepare an EMI chart based on the different percentage and time period ranges.

  1. Enter the Loan amount
  2. Select the percentage range
  3. Select the Time Period by date range
  4. Hit Generate table to get the EMI table generated
How to use this EMI chart?

The main purpose of this chart is to provide a better user experience to perform the comparison between the monthly repayments to select an affordable EMI. In the generated table of monthly repayments, look for suitable or affordable EMI and note down the percentage rate which is provided in the first row and time period in number of months provided in the first column of this chart.

Amortization

To add more insight to the desired monthly payment calculation, the amortization calculator is integrated with in the EMI chart. The generated EMI chart contains a matrix of monthly payments to select from. Hit on a desired monthly payment redirect the user to the respective amortization chart for more insight for the monthly repayment selected; where user may find detailed amortization chart or more information of how much principal and interest amount each EMI or monthly payment consist of to repay the loan.

How can loan lenders make use of it?

Any home loan or car loan or personal loan lenders or the financial institutions like citi bank, hdfc bank, sbi, Indian bank, Indian overseas bank etc may use this tool and prepare the EMI chart to explain to the borrowers about the variations on the monthly payment based on the different set of interest rates and time periods.

How can loan borrowers make use of it?

Any home loan or car loan or personal loan borrowers can pre calculate the suitable or affordable monthly payment based on their financial positions by referring the matrix of monthly payments based on the variations of interest rates and time periods.

How to download a copy of EMI chart in pdf?

This EMI chart is available in downloadable format. Users can download this EMI chart alone except other content of this page in the following way.

  1. Follow the above 4 steps given for How to Use this tool to prepare an EMI Chart?
  2. Click on the pdf button provided on the top left side corner of this page to get the EMI chart alone in pdf format
How to download a copy of EMI chart in Excel?

This EMI chart is also available in Excel format. Due to technical reasons, this excel format EMI chart only available for default values only. This format alone will not support user supplied values.

  1. Click on the Excel button provided on the top left side corner of this page to get the EMI chart in Excel format
How to get a print out of this EMI chart?

This EMI chart is also available in printable format. The print can be taken in many ways but using the above print button provided on the top left side corner of this page only print the EMI chart alone.

  1. Follow the above 4 steps given for How to Use this tool to prepare an EMI Chart?
  2. Click on the Print button to get the EMI chart alone