How to Manage loans with an amortization table in Excel

In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:

Part 1: Create a mortgage (loan) payment calculator with an amortization table (payment schedule) for detailed payment information.

Part 2: Use IF functions to hide negatives in the amortization table if/when you make extra payments and pay off the loan sooner than planned.

Part 3: Using IF function to zero out remaining rows when the loan is paid off early.

(1) Part 1 of 3 - How to Manage loans with an amortization table in Excel, (2) Part 2 of 3 - How to Manage loans with an amortization table in Excel, (3) Part 3 of 3 - How to Manage loans with an amortization table in Excel

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest