Excel tutorial: Creating a loan amortization table in Excel 2010
Download excel file: http://www.codible.com/pages/59
When repaying a loan (e.g. car loan) with a fixed monthly payment, this video shows you how to detail the principal and interest components of the payments over the period of repayment. Follow us on twitter: / codible
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
http://amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
http://amzn.to/2uaCyo6