+ Reply to Thread
Results 1 to 4 of 4

Loan with Increasing Lump Sum Payments

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Loan with Increasing Lump Sum Payments

    a lot of the inputs are actually required fields
    without them its hard to even start
    loan amount
    term
    annual interest rate
    majority of the inputs are to determine your monthly repayments

    i think what you are after is
    http://www.vertex42.com/ExcelTemplat...-schedule.html
    the additional repayments field would then be a calculated field instead of a manual input
    Last edited by humdingaling; 05-12-2015 at 12:43 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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 Payment Schedule with Interest-Only Payments & P & I Payments
    By Masscatz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-20-2014, 11:51 AM
  2. Replies: 5
    Last Post: 11-01-2012, 10:17 AM
  3. loan payments - Interest only?
    By Steach91 in forum Excel General
    Replies: 3
    Last Post: 07-01-2006, 09:00 PM
  4. [SOLVED] Add insurance to loan payments
    By VRhodes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2005, 05:45 PM
  5. Replies: 0
    Last Post: 02-03-2005, 03:06 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