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

Guide To Excel For Finance: Goal Seek

The Goal Seek function is a great place to kick off the Excel guide for finance. Goal Seek 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: PV And FV Functions

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

    A rental agreement that obliges the lessee (the person making ...
  2. Closed-End Lease

    A rental agreement that puts no obligation on the lessee (the ...
  3. Car Title Loan

    A short-term loan in which the borrower's car title is used as ...
  4. Gap Amount

    Insurance will only cover a certain amount of coverage if leased ...
  5. Walk-Away Lease

    A common type of car lease in which the lessee returns the car ...
  6. Capitalized Lease Method

    An accounting approach that identifies a company's lease obligation ...
RELATED FAQS
  1. How have low interest rates affected lease rates in the automotive sector?

    Find out how and why lower interest rates for leasing new automobiles have helped spur more consumers to lease cars instead ... Read Answer >>
  2. Which is better, a fixed or variable rate loan?

    A variable interest rate loan is a loan in which the interest rate charged on the outstanding balance varies as market interest ... Read Answer >>
  3. Would it benefit us to take a 401k loan for a car instead of a car loan?

    My husband recently had a huge increase in his salary, we are paying a lot of taxes on it.  ... Read Answer >>
  4. What is the importance of residual value in an automobile lease?

    Find out how dealerships assign residual value and why this is an important factor in car leases. Learn about a tactic some ... Read Answer >>
  5. Which loan should I pay off first?

    I have a $33,000 mortgage at 4.5% interest due in June 2019. I also have $627 in monthly car loan payments for loans that ... Read Answer >>
  6. At the beginning of the year, HIJ Corp. began to lease new equipment ...

    The correct answer is: b) Total Lease Payment = Interest expense + Principal repayment Step 1: Interest expense = 8.5% of ... Read Answer >>
Hot Definitions
  1. Physical Capital

    Physical capital is one of the three main factors of production in economic theory. It consists of manmade goods that assist ...
  2. Reverse Mortgage

    A type of mortgage in which a homeowner can borrow money against the value of his or her home. No repayment of the mortgage ...
  3. Labor Market

    The labor market refers to the supply and demand for labor, in which employees provide the supply and employers the demand. ...
  4. Demand Curve

    The demand curve is a graphical representation of the relationship between the price of a good or service and the quantity ...
  5. Goldilocks Economy

    An economy that is not so hot that it causes inflation, and not so cold that it causes a recession. This term is used to ...
  6. White Squire

    Very similar to a "white knight", but instead of purchasing a majority interest, the squire purchases a lesser interest in ...
Trading Center