CFA考試
報考指南考試報名準(zhǔn)考證打印成績查詢備考資料考試題庫

重置密碼成功

請謹(jǐn)慎保管和記憶你的密碼,以免泄露和丟失

注冊成功

請謹(jǐn)慎保管和記憶你的密碼,以免泄露和丟失

當(dāng)前位置:首頁CFA考試視頻知識正文
當(dāng)前位置:首頁CFA考試CFA視頻正文

How to use PMT to calculate the amount of periodic payment?

幫考網(wǎng)校2020-11-30 15:16:01
|
To use the PMT function to calculate the amount of periodic payment, follow these steps:

1. Determine the interest rate per period and the number of periods. For example, if you have a loan with an interest rate of 5% per year and a term of 3 years, the interest rate per period would be 5%/12 (assuming monthly payments) and the number of periods would be 3*12 (36 months).

2. Determine the present value of the loan. This is the amount of money that you borrowed or the current value of the loan. For example, if you borrowed $10,000, the present value would be $10,000.

3. Determine the future value of the loan. This is the amount of money that you will owe at the end of the loan term, assuming no additional payments are made. For example, if the loan has a term of 36 months and the interest rate is 5% per year, the future value would be $10,000*(1+5%/12)^(36) = $11,528.94.

4. Use the PMT function in Excel or Google Sheets to calculate the periodic payment. The PMT function takes three arguments: the interest rate per period, the number of periods, and the present value of the loan. For example, the formula for the monthly payment in the above example would be =PMT(5%/12, 36, 10000). The result would be -$304.14, indicating that the monthly payment would be $304.14.

Note that the PMT function assumes that payments are made at the end of each period. If payments are made at the beginning of each period, you will need to adjust the formula accordingly. Additionally, the PMT function assumes that payments are made on a regular schedule. If payments are irregular, you will need to use a different formula to calculate the periodic payment.
幫考網(wǎng)校
|

推薦視頻

推薦文章

  • 暫無文章

推薦問答

  • 暫無問答
垦利县| 衡东县| 廉江市| 竹北市| 琼结县| 县级市| 大港区| 磐石市| 太仓市| 额济纳旗| 张家川| 遂平县| 台中市| 驻马店市| 瑞昌市| 即墨市| 兴业县| 贡山| 淳安县| 陆良县| 朝阳市| 肥城市| 同德县| 阳原县| 新余市| 海阳市| 宿松县| 九台市| 茌平县| 诏安县| 来宾市| 绵阳市| 彭山县| 嘉黎县| 措勤县| 康马县| 望谟县| 保靖县| 桑植县| 郸城县| 蕲春县|