How can you find the principal balance at a given period for a loan calculated in Excel?

I'm trying to work on a spreadsheet for a few home loan options. I'd like some way to calculate the principal balance at the end of a few periods such as after 5, 10 , 15, %26amp; 20 years. I'm not quite sure how do do it though. If possible, I'd like to avoid creating a whole amortization table but any advice would be appreciated.





Thanks!|||If you want to do in in excel, you can use start from the file you can find in this page: http://www.vertex42.com/ExcelTemplates/a鈥?/a>





Depending on the options you are considering, you could also find useful this free online advanced calculator: http://www.mortgagecalculator3.com/|||When you contract a loan with any lender, say a bank, they normally provide you a schedule of payment as part of the terms and conditions of your loan. The lender normally dictates the terms of any loan transactions unless you are a prime customer of the bank then maybe you can strike a term at your own convenience. Normally, the bank uses a declining balance method of amortization for any term loan. I the loan is for business or for particular project, the estimated future cash in flows of the project are important in determining whether your loan is going to be favorably approved. But since your problem is simply to know the principal balance at the end of a period, then all you need to do is determine first the amount you will be able to remit to pay the principal. By the way, the principal is normally divided equally over the number of payment periods agreed upon mutually between you the borrower and the lender. The principal balance then should be zero at the end of the period agreed upon.