I have developed a simple Micsoft Excel based Home Loan Calculator (Amortization Schedule) and is available for download at https://www.freewebs.com/rajanpras/homeloancalc.htm . The reason why I am not attaching is that this could be revised based on inputs and / or feedback from Users.
This not only calculates the EMI applicable, but also gives the split of interest and Principal components of each EMI. In addition, this also takes care of Principal pre-payments made and also interest rate changes done for floating rates.
Do mail or reply to this thread with suggestions and / or issues if any.
Menu
Home Loan Planner - Excel based
Replies (11)
good work prasanth.
from income tax perspective, the users will be interested to know the principal and interest repayment during April-March period tll the loan is paid in full . for example, if loan is availed from 1 oct 08 for 15 years then summary of the interest & principal for April -Mar ( for the first year the summation will be from oct 08 to march 09 & similarly for the last year it will be from April xx to Sep xx) shall be listed.
Can this be attempted.
| Originally posted by :CA. Ravikumar | ||
| " | good work prasanth. from income tax perspective, the users will be interested to know the principal and interest repayment during April-March period tll the loan is paid in full . for example, if loan is availed from 1 oct 08 for 15 years then summary of the interest & principal for April -Mar ( for the first year the summation will be from oct 08 to march 09 & similarly for the last year it will be from April xx to Sep xx) shall be listed. Can this be attempted. |
" |
That is a good suggestion - let me try this. I will keep everyone posted.
| Originally posted by :Prasanth Rajan | ||
| " | Originally posted by :CA. Ravikumar " good work prasanth. from income tax perspective, the users will be interested to know the principal and interest repayment during April-March period tll the loan is paid in full . for example, if loan is availed from 1 oct 08 for 15 years then summary of the interest & principal for April -Mar ( for the first year the summation will be from oct 08 to march 09 & similarly for the last year it will be from April xx to Sep xx) shall be listed. Can this be attempted. " That is a good suggestion - let me try this. I will keep everyone posted. |
" |
Whew - "that" took some time and effort. It is now done and the tax area is also added on the same sheet. Download is available from the same URL - https://www.freewebs.com/rajanpras/homeloancalc.htm .
Regards.
Prasanth
great. Thanks.
Hi all,
Please note that there is a minor correction in Principal computation when there is repayment. This is now corrected and version 1.2 and the same is now available for download at the same URL - https://www.freewebs.com/rajanpras/homeloancalc.htm.
Regards.
Prasanth
Please forward the soft copy so that calculation can be done while learning .
Regards
Personal TDS calculation sheet is very useful. Thanks for the update.
Dear Prashanth Rajan!
Home loan calculator - Good effort indeed!
It will be still more nice, if the home loan calculator takes into account the lateral variations in the actual remittances into the Home loan account.
This is quite necessary since there will definitely be variations in the amount paid during the lateral years into the home loan A/c, as there would normally be increase in income in the case of any individual.
Good bye! Cheers!!
This will end your search for advance emi calculator
you would like to look at this, https://cpmlive.wordpress.com/2008/11/08/advance_loan_amortization_emi_calc/
That is a very useful mortgage calculator, another one can be found on this website and it allows you to calculate amortization quarterly, semi-annually and annually as well as provide different interest rates. It also calculates closing costs as a wholesum figure (e.g $3000) or a percentage of the mortgage (1%).
Hi Prashant, Great work ! This was exactly what I was looking at. Till now I was using Vertex calculator, which is good but lacks one feature about variable interest rates. Your calculator solved that.
I would like to see your calculator enhanced to show calculations based on variable disbursements. For my house, the bank disbursed money at different intervals.
I am too proficient in excel and can give my time for that. Please mail me at girishkamath _at_ yahoo _dot_ com
Recent Threads
- Exports against INR PO payable by Domestic Company
- Which websites are best for government exam prepar
- TDS on maturity payment of LIC of india
- ITR2 Gold ETF short and long term
- Query under faceless assessment
- Purchase of business
- Refund of ITC for advance paid to overseas supplie
- Clubbing query (when gifts given to multiple fami
- Transfer Pricing Audit Upload Form 3CEB - Income T
- Only a Few Pages Indexed by Google Despite Sitemap
Related Threads
CAclubindia
