Posts

Showing posts with the label Loan calculator

How to create mortgage calculator in Excel - Video showcase

Image

How to create mortgage calculator in Excel

Image
In this tutorial I'm going to show you a step by step guide on how to create a mortgage calculator in Excel. Creating this mortgage calculator doesn't require any demanding skills, as long as you remember the formulas It's quite easy to create one.    1. Step one, under A1 write down "mortgage calculator" and continue writing down the cells as in the picture below:            A4: House Price                                    A12: Breakdown of Payments      A5: Down Payment                               A13: Payment Period      A6: Amount Borrowed                           A14: Principal Paid       A8: Monthly Payment       ...