1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide to Excel for Finance: Annuities
  5. Guide To Excel For Finance: Valuation Methods
  6. Guide To Excel For Finance: Goal Seek
  7. Guide To Excel For Finance: HLookup And VLookup
  8. Guide To Excel For Finance: Ratios
  9. Guide To Excel For Finance: Technical Indicators
  10. Guide To Excel For Finance: Advanced Calculations
  11. Guide To Excel For Finance: Conclusion

The Goal Seek function is a valuable feature that lets the user back into the value for an unknown variable in an equation. For example, the typical financing arrangement for leasing a car will usually provide an interest rate and lease term, such as 6% over 60 months for a car valued at $25,000. Using the PMT formula in Excel, the estimated payment for these lease terms is $483.32.

Here is the layout of the key variables, as well as the output provided by Goal Seek:

Car Loan Repayment Schedule

Interest Rate

0.06

Loan Duration

60

Total Loan Amount

25000

Payment

$483.32 

 

But let's say you have a few extra dollars and are interested in knowing how long the loan will last when you spend $500 a month for the same 6% interest rate. Using Goal Seek, here is what the inputs would look like:

 

 

According to Goal Seek, upping the monthly payment slightly would shave more than two months off the loan duration. Here are the outputs:

Car Loan Repayment Schedule

Interest Rate

0.06

Loan Duration

57.6801385

Total Loan Amount

25000

Payment

$500.00 

 

 


Guide To Excel For Finance: HLookup And VLookup
Related Articles
  1. Personal Finance

    Personal Loans vs. Car Loans

    How to tell whether a personal loan or a car loan is better for you.
  2. Personal Finance

    Make the Right Choice: Buying or Leasing a Car

    Ask yourself these questions before deciding between leasing or buying a car.
  3. Retirement

    Business Owners: A Guide To Qualified Retirement Plan Loans

    Thinking of adding a loan feature to your company's plan? Here's what you need to know.
  4. Trading

    Car Title Loans: Good Option For Fast Cash?

    These loans provide fast cash, but they could leave you deeper in debt - and without a car.
  5. Personal Finance

    Simple Interest Loans: Do They Exist?

    Yes, they do. Here is what they are – and how to use them to your advantage.
  6. Personal Finance

    8 Top Alternatives to Car Title Loans

    Before you sign up for a car title loan, investigate these 8 alternate strategies.
  7. Personal Finance

    How to Get Your Student Loans Forgiven

    The prospect of debt forgiveness may seem like a dream come true. In reality, though, not that many people end up being eligible.
  8. Personal Finance

    How To Apply For a Personal Loan

    Learn about different avenues for applying for a personal loan, and learn valuable tips to help you get your personal loan application approved.
Frequently Asked Questions
  1. China vs Hong Kong stock: Is H-shares and A-shares the same?

    Learn what the difference between A-shares and H-shares of publicly listed companies in China and Hong Kong stock exchange. ...
  2. Why does time value of money (TVM) assume that a dollar today is worth more than a dollar tomorrow?

    Learn about time value of money, or TVM, and how a present value calculator is used to determine the value of money received ...
  3. Is a private company required to show financial information?

    Understand whether a private company is required to disclose financial information to the public. Learn what is required ...
  4. Is savings and loan company different from commercial banks?

    Find out how a savings and loan (S&L) company, sometimes also known as a thrift or savings institution, focuses on different ...
Trading Center