Calculate Loan Terms using Goal Seek in Microsoft Excel

Posted: January 28, 2011 in Power of Microsoft Office
Tags: , ,

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s