+ Reply to Thread
Results 1 to 7 of 7

Need "reverse" amortization; calculate loan amount

  1. #1
    Niek Otten
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    You also need the number of payments.
    Look in HELP for the PV() function

    --
    Kind regards,

    Niek Otten

    Microsoft MVP - Excel

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




  2. #2
    N Harkawat
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    Look at Help on PV function

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




  3. #3
    Niek Otten
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    You also need the number of payments.
    Look in HELP for the PV() function

    --
    Kind regards,

    Niek Otten

    Microsoft MVP - Excel

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




  4. #4
    N Harkawat
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    Look at Help on PV function

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




  5. #5
    MLSanders
    Guest

    Need "reverse" amortization; calculate loan amount

    I have fixed interest rate and monthly payment. How do I calculate loan
    amount?

  6. #6
    Niek Otten
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    You also need the number of payments.
    Look in HELP for the PV() function

    --
    Kind regards,

    Niek Otten

    Microsoft MVP - Excel

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




  7. #7
    N Harkawat
    Guest

    Re: Need "reverse" amortization; calculate loan amount

    Look at Help on PV function

    "MLSanders" <MLSanders@discussions.microsoft.com> wrote in message
    news:E269891C-DD6A-438F-B1EB-683D7F81803E@microsoft.com...
    >I have fixed interest rate and monthly payment. How do I calculate loan
    > amount?




+ 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