+ Reply to Thread
Results 1 to 5 of 5

payment calculator

  1. #1
    Registered User
    Join Date
    03-24-2005
    Posts
    12

    payment calculator

    I need a spread sheet where I can enter the:

    Loan amount
    Rate
    Term in months
    Note date
    First payment date

    and excel calculate:

    monthly payment
    APR

    Is there any templets out there, I can't find one? The simplier the better.

    Thanks
    Last edited by BOC; 09-18-2008 at 10:09 AM.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    This link can probably help you out best. There is an additional link in there to download the templates.

    http://office.microsoft.com/en-us/ex...346401033.aspx

  3. #3
    Registered User
    Join Date
    03-24-2005
    Posts
    12
    I looked at that and it won't work for what I'm wanting.
    First It ask for the annual percent rate when I have the rate of the loan, I want it to figure the annual percent rate.

    Also the annual percent rate is effected by the first payment date from the original date. The first payment date may or may not be in 30 days.

    Thanks

  4. #4
    Registered User
    Join Date
    03-24-2005
    Posts
    12
    bump to the top

  5. #5
    Registered User
    Join Date
    03-24-2005
    Posts
    12
    Help please

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Payment Details- Invoice
    By Lame Brain in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-15-2008, 08:15 AM
  2. Repayment Calculator
    By messyhead in forum Excel General
    Replies: 2
    Last Post: 03-12-2008, 01:52 PM
  3. Flexitime / Work time calculator
    By Fluxcapacitorrr in forum Excel General
    Replies: 3
    Last Post: 10-02-2007, 06:43 AM
  4. Solve for Monthly Loan Payment Amount
    By ShaneBell in forum Excel General
    Replies: 1
    Last Post: 12-13-2006, 06:09 PM
  5. Payment Record
    By Edmund in forum Excel General
    Replies: 1
    Last Post: 11-07-2006, 08:42 AM

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