Capital (PPMT)
Syntax: PPMT(Interest; Period; Time; Loan; Future; Type)
The PPMT function returns the amount of original capital that you need to pay back in a given accounting period when you borrow money. For example, if you borrow $1,000,000 (loan) at an interest rate of 7.25% for 25 years and want to know how much capital you have to pay back within the first month, you can find that out with this formula:
=PPMT(7.25%/12; 1; 25*12; 1,000,000)
The answer is –$1,186.40.
Figure 8-12. Sample result of the PPMT function
The interest argument is the interest rate at which money is borrowed.
The period argument is the number of the chosen accounting ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
