{"id":556,"date":"2012-02-09T10:11:38","date_gmt":"2012-02-09T10:11:38","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=556"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"ppmt-financial-function-in-excel-2010","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/ppmt-financial-function-in-excel-2010\/","title":{"rendered":"PPMT Financial Function in Excel 2010"},"content":{"rendered":"

PPMT Financial Function in Excel 2010<\/p>\n

The PPMT function allows you to work out the principal payment based on the set criteria as outlined in the syntax below.<\/p>\n

Syntax<\/strong><\/p>\n

PPMT <\/strong>(rate<\/strong>,per<\/strong>,nper<\/strong>,pv<\/strong>,fv,type)<\/p>\n

Rate<\/strong>\u00a0\u00a0\u00a0\u00a0 is the interest rate per period.<\/p>\n

Per<\/strong>\u00a0\u00a0\u00a0\u00a0 specifies the period and must be in the range 1 to nper.<\/p>\n

Nper<\/strong>\u00a0\u00a0\u00a0\u00a0 is the total number of payment periods in an annuity.<\/p>\n

Pv<\/strong>\u00a0\u00a0\u00a0\u00a0 is the present value \u2014 the total amount that a series of future payments is worth now.<\/p>\n

Fv<\/strong>\u00a0\u00a0\u00a0\u00a0 is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.<\/p>\n

Type<\/strong>\u00a0\u00a0\u00a0\u00a0 is the number 0 or 1 and indicates when payments are due.<\/p>\n

The first thing you might want to do is set up your spread sheet and format accordingly.\u00a0 This is an example of how I would set up my spreadsheet and what it will end up looking like. Please note on my example I have used both the PPMT and the IPMT <\/a>functions.\u00a0 I have added a short blog on the IPMT <\/a>function on this site.<\/p>\n

\u00a0\"\"<\/a><\/p>\n

In the cell to the right of the PRICIPAL COMPONENT where you see \u201c\u00a33,190.42\u201d is where you will enter your PPMT function.\u00a0 This is what it will look like if you use your INSERT FUNCTION option;<\/p>\n

\u00a0\"\"<\/a><\/p>\n

You will notice that way I have suggested you set up your spread sheet mirrors the options shown in this box and that makes entering the correct information a pretty simple process.\u00a0\u00a0 Two things you need to remember are;<\/p>\n

    \n
  1. You have to divide the rate by 12 months, so it will look something like this \u201cB3\/12<\/li>\n
  2. Enter the PV as a negative as this is the amount of money that is being paid back, ie, if you borrow \u00a3500,000 for a mortgage then this is the amount of money that you are in debt for.<\/li>\n<\/ol>\n

    This completed function will look like this;<\/p>\n

    \u00a0\"\"<\/a><\/p>\n

    while the funtion on the screen would look like this;<\/p>\n

    \"\"<\/a><\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    PPMT Financial Function in Excel 2010 The PPMT function allows you to work out the principal payment based on the set criteria as outlined in the syntax below. Syntax PPMT (rate,per,nper,pv,fv,type) Rate\u00a0\u00a0\u00a0\u00a0 is the interest rate per period. Per\u00a0\u00a0\u00a0\u00a0 specifies the period and must be in the range 1 to nper. Nper\u00a0\u00a0\u00a0\u00a0 is the total […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[432,433],"class_list":["post-556","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-ppmt-financial-function-in-excel-2010","tag-pr"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=556"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/556\/revisions"}],"predecessor-version":[{"id":6731,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/556\/revisions\/6731"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}