Results 1 to 2 of 2

Calculate loan amortization from parameters

Threaded View

  1. 01-12-2014, 08:08 AM #1
    Faustocruz
    Faustocruz is offline
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2016 for MAC
    Posts
    117

    Calculate loan amortization from parameters

    I'M STRUGGLING TO HAVE THE RIGHT FORMULA FOR THE FOLLOWING:

    I WANT TO CALCULATE THE NUMBER INSTALMENTS AND ITS DATES BY USING SOME PARAMETERS LIKE:

    DESCRIPTION Enter values
    Loan amount $5.000.000,00
    Annual interest rate 14%
    Loan period in years 5
    Start date of loan 31/12/14
    NUMBER OF PAYMENTS P/PERIOD 12

    KING REGARDS
    FAUSTO
    Last edited by Faustocruz; 01-13-2014 at 02:03 AM. Reason: Change Title
    Fausto Cruz
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to insert pictures to " insert comment " or "Text box" in cell E5 and E15
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 08:10 PM
  2. [SOLVED] Count syntax for dividing # of "positive numbers" by "total numbers"
    By synses in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-18-2013, 09:06 PM
  3. [SOLVED] Disable "Right Click" ... or any ability to "cut", "insert", etc.
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2011, 09:26 AM
  4. Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"
    By lukasj13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 08:48 PM
  5. Insert "-" in text "1234567890" to have a output like this"123-456-7890"
    By Alwyn in forum Excel General
    Replies: 3
    Last Post: 10-25-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1