{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cumprinc

cumprinc - Amount of Principal Repaid CUMPRINC The amount...

This preview shows pages 1–3. Sign up to view the full content.

Amount of Principal Repaid – CUMPRINC The amount of principal repaid, in a single payment or consecutive payments, can be calculated using Excel’s CUMPRINC function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. This function is included in the Analysis ToolPak. Syntax =CUMIPMT(rate,nper,present value,start period,end period,type) Rate – interest rate NPER – total number of payment periods Present Value – value of the investment today (0 if omitted) Start Period – the first period in the calculation. Payment periods are numbered beginning with 1. End Period – the last period in the calculation Type – when payment is to be made 0 – at end of period (assumed if left blank) 1 – at beginning of period General Example The following general example shows how the CUMPRINC function can be used. Notice that the CUMPRINC function appears in the formula bar. 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Using the CUMPRINC Function in a Spreadsheet To calculate the total amount of principal repaid between any two interest-payment periods, create a spreadsheet by following Steps 1 to 7. Or, to use the CUMPRINC function right away, open the CUMPRINC worksheet in the Excel Functions Templates workbook. All fields have been formatted for you (currency, percentage, number of decimals displayed). Step 1 : Enter CUMPRINC Function in cell A1. You will replace CUMPRINC Function with your project title when you use your spreadsheet for a particular question or situation.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern