+ Reply to Thread
Results 1 to 5 of 5

Simple loan Calculator

  1. 03-01-2017, 08:44 AM #1
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Simple loan Calculator

    Trying to make a very simple Loan Calculator,here is my example.

    Thanks for any input
    Attached Files Attached Files
    Last edited by zplugger; 03-01-2017 at 11:54 AM.
    Reply With QuoteRegister To Reply
  2. 03-01-2017, 08:53 AM #2
    The_Snook
    The_Snook is offline
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Simple loan Calculator

    In D2: =PMT(B2/12,C2,-A2)
    In E2: =D2*C2

    Regards,

    Snook
    Reply With QuoteRegister To Reply
  3. 03-01-2017, 08:58 AM #3
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Simple loan Calculator

    Hi,

    This website explains how to do this.

    http://www.accountingweb.com/technol...ating-interest

    Cheers
    Reply With QuoteRegister To Reply
  4. 03-01-2017, 11:53 AM #4
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Simple loan Calculator

    Thanks for all your help guy's.
    Reply With QuoteRegister To Reply
  5. 03-01-2017, 02:41 PM #5
    southward
    southward is offline
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Simple loan Calculator

    You are very welcome. Glad I could be of some assistance.

    Cheers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help making a loan calculator
    By tiwas in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-29-2016, 02:57 PM
  2. Loan Calculator
    By Tordah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2015, 04:53 PM
  3. Loan Calculator
    By atmno in forum Excel General
    Replies: 0
    Last Post: 10-08-2013, 11:52 AM
  4. Loan Calculator
    By Sam Davis in forum Excel General
    Replies: 1
    Last Post: 05-02-2010, 07:18 PM
  5. [SOLVED] Loan Calculator for more than 30 years
    By Ray_Johnson in forum Excel General
    Replies: 1
    Last Post: 03-30-2005, 03:06 PM
  6. How do you set up a loan using the loan calculator w/odd payments.
    By rad in forum Excel General
    Replies: 0
    Last Post: 02-03-2005, 03:06 PM
  7. [SOLVED] Auto Loan Calculator
    By Robert in forum Excel General
    Replies: 5
    Last Post: 01-10-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1