Mortgage Calculations in Excel

This video is a live capture from one of my virtual classes in Engineering Economics. In the video, I demonstrate the use of the PV, FV, and PMT functions in Excel, for the purpose of solving a problem related to a mortgage: effective monthly interest rate; monthly payment; amortization; and term. I am using a Lightboard and OBS Studio.