2016 Excel has mortgage templates. Just pulled up two of them by searching for “mortgage” in the Template section. The second template I tried had an amortization schedule attached.
I have 2010, any idea where those templates are?
Not hard to build one, but a little harder to understand how the calculation actually works. Would suggest looking up instructions on using the pmt function.