Header Banner
Gadget HacksNext RealityFood HacksNull ByteThe Secret YumiverseInvisiverseMacgyverismsMind HacksMad ScienceLock PickingDriverless

How to Manage loans with an amortization table in Excel

Jan 18, 2010 06:09 PM
Microsoft Excel tutorial on managing loans with an amortization table, part 1.

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.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!