+ Reply to Thread
Results 1 to 4 of 4

Calculating Installments Payments Dues

  1. #1
    Forum Contributor
    Join Date
    09-13-2013
    Location
    Saudi Arabia
    MS-Off Ver
    2010, 2013
    Posts
    192

    Calculating Installments Payments Dues

    Hello,

    I am looking for a help with formulas or VBA Macros on payment installment due. Details is mentioned below.

    User enter premiums in column A and effective date in column B and first premium received.
    Now the issue start from here. Is a user enter number of installments according to that number of installments it should calculate the installments due but remove first payment?

    For example: 3 installments it should calculate 3 due payments and 3 due date

    Sample file is attached for your understand.
    Attached Files Attached Files

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Calculating Installments Payments Dues

    Abdur,

    please see attached.

    I've added a third example of 12 instalments with formulas. I've changed the layout to make it easier to put in the formulas.

    Let me know if this helps or if you have questions.

    Cheers
    Attached Files Attached Files
    <-- If you're happy & you know it...click the star.:-)

  3. #3
    Forum Contributor
    Join Date
    09-13-2013
    Location
    Saudi Arabia
    MS-Off Ver
    2010, 2013
    Posts
    192

    Re: Calculating Installments Payments Dues

    That's perfect solution i will provide you feedback after revision of my boss

  4. #4
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Calculating Installments Payments Dues

    Glad I could help.

    Please mark the thread as SOLVED in the title if your boss is happy.

    Also please click on "* Add Reputation" below if you like.

    Cheers

+ 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. Calculating Bonus Payments
    By dan2188 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2013, 10:30 PM
  2. Calculating IRR From known variable payments
    By peterlloyd in forum Excel General
    Replies: 0
    Last Post: 12-13-2009, 06:15 PM
  3. Calculating payments in a month
    By blairy in forum Excel General
    Replies: 5
    Last Post: 02-21-2008, 03:59 PM
  4. Calculating annual payments
    By namrekka in forum Excel General
    Replies: 0
    Last Post: 10-11-2006, 11:11 AM
  5. [SOLVED] Calculating Due Dates Based on Payments
    By Eric Hanson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2005, 11:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1