Find interest rate on loan using VLOOKUP in Excel

20 pts.
Tags:
Microsoft Excel
VLOOKUP
I need to find the interest rate on a loan using vlookup in excel, selling price $250,000 on a 20 year loan.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

IS this a homework or business question? There are many web sites available that have amortization calculators.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Navigate to www.w3schools.com and you can get a good idea. Also look for MS help page which presents as .chm file through help menu.
    136,490 pointsBadges:
    report
  • ToddN2000
    The interest rate could be anything. There is not enough info on how to determine it. Are you using the Excel amortization template or something else?
    131,380 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: