Excel Finance Trick #17: Amortization Table wx Column

See how to create an Amortization Table with an Additional Payment Column. Learn how an Amortization Table shows you how much of each payment (PMT) is consumed by Interest and how much is left for the Principal Reduction. See a trick for inventing complicated formulas. See how to correct formulas that do not evaluate to correct solutions. See how to edit complicated formulas. See how to use the IF function to fix an amortizations table problem. In ThisSeries learn 17

Read more ...