Welcome Guest
Log In | Register )
You last visited December 5, 2016, 1:37 pm
All times shown are
Eastern Time (GMT-5:00)

Loan Calculator

Topic closed. 6 replies. Last post 9 years ago by BevsPicks2.

Page 1 of 1
41
PrintE-mailLink
Avatar
EAST COAST, USA
United States
Member #49428
January 31, 2007
553 Posts
Offline
Posted: August 15, 2007, 10:37 am - IP Logged

I need a formula that will produce an amortization schedule with periodic payments (Excel).  Can anyone help me with this.  This is not for a mortage but for a personal loan made to someone.

    sysp34's avatar - Lottery-062.jpg
    Heroic City
    Indonesia
    Member #31689
    February 2, 2006
    1153 Posts
    Offline
    Posted: August 15, 2007, 10:52 am - IP Logged

    famous spreadsheet have build in template for loan

    you should click file - new - template - loan

    good luck

    Et erunt signa in sole.......Et luna et stellis.......Et presura gentium
    Prae confusione sonitus maris.


      Avatar
      Florida
      United States
      Member #51537
      April 13, 2007
      29 Posts
      Offline
      Posted: August 15, 2007, 11:38 am - IP Logged

      BevsPicks,

      In Excel the PMT function will provide what you want, I think.  You will find it in the pull down menu under Insert.  Then click function.  PMT is one of the functions and it will be described.

      Good Luck,

      Terry

        Avatar
        EAST COAST, USA
        United States
        Member #49428
        January 31, 2007
        553 Posts
        Offline
        Posted: August 15, 2007, 11:56 am - IP Logged

        famous spreadsheet have build in template for loan

        you should click file - new - template - loan

        good luck

        Thank you sysp34!

          Avatar
          EAST COAST, USA
          United States
          Member #49428
          January 31, 2007
          553 Posts
          Offline
          Posted: August 15, 2007, 11:56 am - IP Logged

          BevsPicks,

          In Excel the PMT function will provide what you want, I think.  You will find it in the pull down menu under Insert.  Then click function.  PMT is one of the functions and it will be described.

          Good Luck,

          Terry

          Thank you tben!

            SirMetro's avatar - center
            East of Atlanta
            United States
            Member #6191
            August 11, 2004
            1389 Posts
            Offline
            Posted: August 15, 2007, 12:21 pm - IP Logged

            You can also go to Microsoft's web site and download a variety of free spreadsheets that are designed to help those who are doing personal loans

              Avatar
              EAST COAST, USA
              United States
              Member #49428
              January 31, 2007
              553 Posts
              Offline
              Posted: August 16, 2007, 11:09 am - IP Logged

              You can also go to Microsoft's web site and download a variety of free spreadsheets that are designed to help those who are doing personal loans

              Thank you Sir Metro...I did go to their website but didn't find the one that I needed.