+ Reply to Thread
Results 1 to 1 of 1

Interest payment formula for uneven cash flows

  1. #1
    Registered User
    Join Date
    01-11-2016
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    11

    Interest payment formula for uneven cash flows

    I am attaching an excel file which explains my problem. IPMT returns interest payments for any period within a set of periods given rate of interest, present value, period and number of periods provided payments are constant over the period and I won't have to chart a amortisation chart for finding interest payments.

    Problem arises for uneven cash flows. IPMT does not work in this case. Inputs are highlighted in yellow. Also I added a amortisation table for a check. As can be seen when cash flows are even 1000 over 5 periods, this formula does the job. But when I vary this cash flow as given in scenario 2 interest payments don't flow. Please note I tackled finding present value. What is left is the interest part.

    Is there a function or workaround formula that fulfills my requirement without having to resort to a amortisation table?
    Attached Files Attached Files

+ 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. Deferred Payment Cash Flows with Dates
    By primeranetworks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2018, 03:59 PM
  2. [SOLVED] uncertain cash-flows timing. create monthly cash report
    By excobra in forum Excel General
    Replies: 3
    Last Post: 05-14-2014, 11:10 AM
  3. Replies: 9
    Last Post: 06-12-2012, 12:31 AM
  4. NPV Formula Using Uneven, Monthly Cash Flows
    By DanoT in forum Excel General
    Replies: 1
    Last Post: 02-20-2012, 05:02 PM
  5. Waterfall Cash Model, dividing up cash flows based on IRR
    By tomservo2009 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-21-2008, 05:57 PM
  6. PV of uneven stream of cash flows
    By PJF in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2005, 10:05 PM

Tags for this Thread

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