Calculate multiple results by using a data table in Excel.
Use Excel to create a loan amortization schedule. This is table to that shows each periodic payment on an amortizing loan (typically a mortgage or car loan).