+ Reply to Thread
Results 1 to 2 of 2

Calculate loan amount when payment known.

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Ankeny, IA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculate loan amount when payment known.

    I am in auto sales and recently changed dealerships. I had found a loan calculator program that allowed me to do several things. One was to calculate a loan amount if I knew the payment, term and interest rate. That info was on my work computer and I don't have access to it anymore. I tried and have not been successful in finding that program back. Can anyone help me. We are using Excel 2003.
    Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculate loan amount when payment known.

    Present value?

    For a 5-year loan at 6% with $350/mo payments, =PV(6%/12, 60, -350) returns $18,103.95
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1