Mortgage Company Reviews

Union Home Mortgage Review – Mortgage Refinance Math 1: Make your own (or Download) an Amortization Table


Union Home Mortgage Review – Highest Rated?

Here we make an amortization table to help you understand the basics of Mortgage Math. IN the next videos we’ll add to this sheet to make what-if analysis for refinancing easier. Make your suggestions about what you’d like to see!!

Link to the old approximation video:

Excel Spreadsheet:

LibreOffice Sheet:

Download LibreOffice(Free):

My Website:
Support me on Patreon!
Talk to me on my SubReddit:
Buy me a cup of coffee on PayPal?

Thanks for watching the Union Home Mortgage Review video!

Watch the Union Home Mortgage Review video on Youtube



  1. Paul David
    July 26, 2021 at 10:16 pm

    How did you get $599.55? Yes, I know you used Excel and put: =pmt(.5,360,100000). But how is this calculated? is it: .5/360/100,000? This comes out to: .000000013. So that's not it. Why don't you tell us "how" you come to this number $599.55? You just plugged it in, assuming we know. Well, I don't know; so tell us.

    PS Multiplying the numbers do not work either.

  2. Akhil sapparla
    July 26, 2021 at 10:16 pm

    really liked the video clearly explained about EMI we pay every month and please make a video about refinancing table added to this table, so that we can clearly understand concept of refinancing and positive cashflow we make every month

  3. Yas Al
    July 26, 2021 at 10:16 pm

    Thank you Dr. How about if I already started in July 2016 and for sure did not have this Excel sheet. And now I want to do the calculation if I pay 100 dollars extra? In the principal field, do I add my original balance or the outstanding balance as of now? And I'm guessing here, that I will change the "Beginning month/year" field to the date when I will start the extra 100 dollars, correct?

    I would love to see the new edition to have a refinance version with all the cost addition, how long will take to break-even, and the possibility for 15 or 30 years fix interest rate, it will be awesome. Thank you so much for this educational video.

  4. Sa
    July 26, 2021 at 10:16 pm

    Yes I would like to see another area if we are thinking about refinancing