+ Reply to Thread
Results 1 to 1 of 1

How to split a lump sum into a monthly payment given the month the payment should start?

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    61

    How to split a lump sum into a monthly payment given the month the payment should start?

    Please see attached

    I have a sheet for an estate agents

    Column B is the month and year _mm_yy format

    Column J, is the %fee
    Column U is the number of months,
    Column V to AG are the months

    Column F is the management type, L/O means that the total payment will be received in one lump sum and does not have to be split. R/C and F/M both have a % fee taken of the total amount split across the months,

    But the problem is how do i tell it when?

    E.g the FY is Apr13 (_04_13) to Mar14 (_03_14)
    If a property was listed as R/C on _09_13 for 12 months, 10% at total of 12000. how do i tell it to assign 1200 (10%) over the 12 months starting from _09_13.

    I need a formula i can enter in columns v to ag

    PS the dates have had to be _mm_yy as i want to use this as a pivot table BUT because im using data validation from another Data validation using the months.
    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. Replies: 3
    Last Post: 07-29-2013, 11:31 AM
  2. Loan/Mortgage Payment with a Skipped Payment
    By mbdoris in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-24-2012, 10:10 PM
  3. Payment of Invoices in comparison with the payment period
    By Renato Silva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2006, 06:50 PM
  4. [SOLVED] calculate payment with first payment due date variable?
    By Jody Solbach in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2005, 12:46 PM
  5. how do you get a positive number payment with a mortgage payment .
    By sam in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2005, 02:06 AM

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