# 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: https://youtu.be/DQHO7LuUiZQ

Talk to me on my SubReddit: https://www.reddit.com/r/BurkeyAcademy/

## Thanks for watching the Union Home Mortgage Review video!

Watch the Union Home Mortgage Review video on Youtube

Share

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