+ Reply to Thread
Results 1 to 3 of 3

Creating an Amortization schedule ?

  1. #1
    Joveni
    Guest

    Creating an Amortization schedule ?

    Anyone know how to do this in Excel??

  2. #2
    Gary Brown
    Guest

    Re: Creating an Amortization schedule ?

    ASSUME MONTHLY AMORTIZATION TABLE
    A1 = "Principal"
    B1 = The amount to be amortized [assume $100,000]
    A2 = "Annual Rate"
    B2 = Annual Percentage rate of loan [assume 10%]
    A3 = "Period in Years"
    B3 = Period in years over which loan will be amortized [assume 30 years]
    A5 = "Period"
    B5 = "Payment"
    C5 = "Interest"
    D5 = "Principal"
    E5 = "Add'l Payments"
    F5 = "Balance"
    F6 formula =B1
    A7 thru A366 = 1 to 360 [# of periods in amortization of 30yrs x 12 months]
    B7 thru B366 formula =-PMT($B$2/12,$B$3*12,$B$1,0)
    C7 thru C366 formula =ROUND(F6*($B$2/12),2)
    D7 thru D366 formula =B7-C7
    F7 thru F366 formula =F6-D7-E7


    HTH,
    Gary Brown


    "Joveni" <Joveni@discussions.microsoft.com> wrote in message
    news:68187563-7665-4B56-92B0-8FECDB5E3893@microsoft.com...
    > Anyone know how to do this in Excel??




  3. #3
    Gord Dibben
    Guest

    Re: Creating an Amortization schedule ?

    Joveni

    There is a downloadable loan amortization template at the MS template gallery.

    http://office.microsoft.com/en-us/te...CT011377171033


    Gord Dibben Excel MVP

    On Fri, 21 Jan 2005 18:15:02 -0800, Joveni <Joveni@discussions.microsoft.com>
    wrote:

    >Anyone know how to do this in Excel??



+ 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