Mortgage Calculator

Amortization Desk in Excel (Element one of five) – PMT Calculation and Amortization Row one

The limited video series demonstrating a solution to the further credit score problem posted to students (see video at — Producing an amortization plan in Excel that relies on IF features and Conditional Formatting.

This video commences the procedure and demonstrates how to produce the preliminary bank loan inputs, the PMT calculation, and the to start with row of the amortization desk.

Demo file:



  1. How to add outstanding balance to invoice in invoice report in MS Access

  2. kindly Mr Ralph , do you have video excel for bookkeeping , this will very kind from you , thanks alot


Leave a Reply