Calculate Loan Terms using Goal Seek in Microsoft Excel

Goal Seek feature in Microsoft Office Excel is used to find out the correct input value to a formula in order to get a desired formula result. This video shows how to use the Goal Seek feature to calculate loan period for a given monthly payment amount and interest rate.