+ Reply to Thread
Results 1 to 3 of 3

Loan interest calculation

  1. 05-17-2013, 04:22 PM #1
    yoyo99 is offline
    Registered User
    Join Date
    01-04-2013
    Location
    st. Louis, MO
    MS-Off Ver
    Excel 2003
    Posts
    1

    Loan interest calculation

    How can I make a comparision table to see how much paying a loan weekly vs paying it monthly will save. The amount is 18,000, and the term is 72 months. I haven't been able to tweek the pmt function how I want.
    Reply With QuoteRegister To Reply
  2. 05-17-2013, 06:44 PM #2
    djapigo is offline
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Loan interest calculation

    Hi yoyo99,

    Is this what you are looking for?

    Let me know...

    Dennis
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-17-2013, 06:54 PM #3
    scott.s.fower is offline
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Loan interest calculation

    looks correct to me, simple and neat, good job djapigo
    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)

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