Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Manage Loans with an Amortization Table in Excel - Part 2

Loading...

Sign in or sign up now!
5,753
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 6, 2009

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

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 2 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • Also if you can post the excel practice files, it would be very helpful

  • Great tutorial. I wish if you could put a video for bond valuation and constructing effective and straight-line interest amortization tables. This would be great if you can do that. Thanks.

  • one of the best videos on YouTube

  • You are truly a community service RRPhillips! Your teaching skills and tuts far supercede the norm. I've also seen your website coding tuts and I want to thank you for sharing your vast wealth of knowledge. I am sincerely grateful!

  • You are my hero!!! thank you so much. I need this tutorial more than you will ever know.

  • rrphilips you legend

Loading...

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more