+ Reply to Thread
Results 1 to 2 of 2

Calculate cumulative repayment for monthly given loan

  1. #1
    Registered User
    Join Date
    06-08-2019
    Location
    Egypt
    MS-Off Ver
    2013
    Posts
    1

    Calculate cumulative repayment for monthly given loan

    I need to create a function that calculates the monthly collected money (in row 24) from all previous months given loans (row 23), given that Every month (loan) is divided on 4 different plans

    Brief about the project/file:
    1- Every month we are giving customers new loans
    2- The next month the customer starts to repay the loan+interest
    3- Customers can pay on 4 different plans 1,3,6 &12 months, portions of these plans are in the Assumptions sheet
    4- Monthly given (loans - default + interest) calculated in row 23
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,878

    Re: Calculate cumulative repayment for monthly given loan

    Hello mouradashry and Welcome to Excel Forum.
    I feel as if I am missing something however based on my understanding of "a function that calculates the monthly collected money (in row 24) from all previous months given loans (row 23)" I would suggest pasting the following into B24 and dragging across: =SUM($B23:B23)
    If that does not produce the desired results then I suggest manually placing some expected results in row 24 and unless it is obvious as to how those values are derived include an explanation. Someone may then be able to replicate the manually placed values using formula/code.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Loan Repayment Schedule Help
    By vikas_newports in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2018, 01:56 PM
  2. [SOLVED] Calculate Loan Annual Interest with Monthly Deposits
    By bgates in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2018, 03:47 AM
  3. Replies: 5
    Last Post: 09-11-2017, 02:51 PM
  4. Replies: 3
    Last Post: 07-24-2016, 07:33 PM
  5. How can I can calculate loan repayment with some skips payments
    By hbsqn in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-16-2015, 06:30 AM
  6. 'How to calculate "Monthly Repayment"‏
    By yjohari in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2013, 12:38 AM
  7. [SOLVED] Loan Repayment Formula
    By rentb23 in forum Excel General
    Replies: 14
    Last Post: 11-04-2012, 01:23 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