:Table financial function PPMT function calculation principal repayment amount during the specified period-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the principal repayment of an investment over a given period, based on a fixed interest rate and equal installments.

Grammar

PPMT(rate,per,nper,pv,fv,type)

rate: loan interest rate.

per: The number of periods used to calculate its principal amount, must be between 1 and nper.

nper: is the total investment period, that is, the total number of payment periods for the investment.

pv: It is the present value, that is, the amount of money that has been recorded from the beginning of the investment, or the cumulative sum of the current value of a series of future payments, also called the principal.

fv: is the future value, or the cash balance expected after the last payment.

If fv is omitted, its value is assumed to be zero, that is, the future value of a loan is zero.

type: A number 0 or 1, used to specify whether the payment time of each period is at the beginning or end of the period.

Description

The specified rate and nper units should be confirmed to be consistent. For example, for the same four-year loan with an annual interest rate of 12%,

If paying monthly, rate should be 12%/12 and nper should be 4*12;

If paid annually, rate would be 12% and nper would be 4.

We often use the PPMT function in financial investment and work Calculate the principal repayment of a loan or investment over a given period.
The following will give you an example of how to use this function.

￭First, position the cursor at C7 and click Insert Function-Financial-PPMT Function.
A dialog box will pop up with a total of six parameters:
"Interest rate" is the annual interest rate of the loan;
"Period" refers to the number of periods to be calculated;
"Total number of payments" is the total number of payments for the loan;
"Present value" refers to the amount loaned;
"Future value" refers to the balance available after the last repayment;
"Whether to pay at the beginning of the period" can be filled in with 1 or 0. For payment at the beginning of the period, fill in 1. For payment at the end of the period, fill in 0 or ignore it.

￭Fill in C2 in "Interest Rate", press the F4 shortcut key to add an absolute reference, and fill in B7 in "Number of Periods".
Fill in C3 in "Total number of payment periods" and press the F4 shortcut key to add an absolute reference.
Fill in C4 in "Current Value" and also press the F4 shortcut key to add an absolute reference.
Because our last repayment does not require a balance and is repaid at the end of the period, the "future value" and "whether to pay at the beginning of the period" are both 0.
Click OK to get the principal repayment amount for this period.
Place the cursor in the lower right corner of C7 and form a cross-shaped drop-down to fill in the formula to get the principal repayment amount for all periods.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-PPMT-han-shu-ji-suan-gui-ding-qi-jian-ben-jin-chang-huan-e.html

Table financial function PPMT function calculation principal repayment amount during the specified period

发表回复

评论列表（196条）

Table financial function PPMT function calculation principal repayment amount during the specified period

Related Suggestion

[Practical Tips] Illustrated Electrospinning Process: An Introductory Guide to PPT Scientific Research Drawing (016)

New version: PPT scientific research drawing complete guide and material collection

The most complete PPT scientific research drawing tutorial and materials in history (second edition)

"Scientific Research PPT Production Skills (001): Drawing a Photocatalytic Mechanism Diagram"

[Navigation] PPT scientific research illustration drawing tutorial list

发表回复

评论列表（196条）