+ Reply to Thread
Results 1 to 5 of 5

loan sheet with past due functions

  1. #1
    Registered User
    Join Date
    06-15-2017
    Location
    ny
    MS-Off Ver
    2007
    Posts
    2

    Question loan sheet with past due functions

    Hi All,

    my first post here, if you're reading this - thank you

    looking to have the
    loan amount (no interest)
    expected payment dates (weekly) and amounts
    column to enter payment and their dates
    total amount past due if it is past due

    any help with this one is greatly appreciated

  2. #2
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92

    Re: loan sheet with past due functions

    Sounds like you want a loan amortization table? There are templates for these if you just do a search for loan amortization within Excel minus the whole past due column which should be easy enough to create in itself.
    Last edited by Xandler; 06-15-2017 at 01:56 PM.

  3. #3
    Registered User
    Join Date
    06-15-2017
    Location
    ny
    MS-Off Ver
    2007
    Posts
    2

    Re: loan sheet with past due functions

    thank you, i'm having a hard time finding one that has what i need, i'm even having a hard time trying to type up what i specifically need - oh well

    thank you for responding

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: loan sheet with past due functions

    .
    https://excel.tips.net/T011627_Creat..._Schedule.html


    http://www.excel-easy.com/vba/exampl...alculator.html <-- has workbook download for calculator


    Has more detailed version of amortization sheet:

    http://www.makeuseof.com/tag/debt-am...tion-schedule/



    With the above examples as a guide, you can put together the amt sheet you like. The formulas remain the same, just have to change the cell references for where your sheet needs them.

    Give it a shot. When you run into a question or a brick wall come back for answers. Describe what you've done / attempted / and what the problem is. There are folks here that will
    be willing to help.

    Cheers !

  5. #5
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: loan sheet with past due functions

    Mshchanin, if you can attach a sample workbook showing what you wish to achieve, this would greatly improve your odds of having someone assist on your posting.

+ 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. Select All Sheets - functions like past-special are greyed out
    By tufa4311 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2017, 05:41 PM
  2. Replies: 3
    Last Post: 07-24-2016, 07:33 PM
  3. Functions or Conditional Formatting for Approaching or Past Dates
    By censo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2016, 02:30 AM
  4. [SOLVED] VBA automatically Cut and Past (cut and past it into the different work sheet)
    By seifeddine87 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2016, 07:08 PM
  5. [SOLVED] Secondary Loan Pricing Calculation (price of loan being bought/sold)
    By Romsky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 07:02 PM
  6. [SOLVED] Seach for data from one sheet to another sheet and copy past adjacent columns
    By mahtabshaikh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2012, 10:19 AM
  7. [SOLVED] loan amortization template with loan start date AND first payment
    By Lisa W in forum Excel General
    Replies: 0
    Last Post: 01-30-2006, 06:30 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