+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : how to use pmt

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    Kansas
    Posts
    5

    how to use pmt

    Here is the problem I have and this is what I'm trying to figure out can someone please be of some help

    Interest rate 6.8%, Years of loan is 30, and total loan is 750,000 Figure the principal on payment number 60.

    using pmt and ppmt

    Ive read my college book I've used other examples I'm still not getting this

    I've attached what I tried to put together not sure if i even started in the right direction
    Attached Files Attached Files
    Last edited by usoldier07; 03-22-2011 at 09:11 PM. Reason: change title how to use pmt

  2. #2
    Registered User
    Join Date
    08-15-2008
    Location
    Mass
    MS-Off Ver
    2016, 64- Bit
    Posts
    28

    Re: Functions I'm lost

    check out the following link and download the Excel Amoratization template. The template should help you out. http://www.amortizationer.com/excel-amortization.html

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1