One of Excel's most popular financial functions is the PMT function. The PMT function will calculate your payments for a loan based on the interest rate, loan amount, and the number of periods. You would use the PMT function to calculate a car or house loan.
Chris Menard's blog post
chrismenardtra...
PMT function arguments
*************
The PMT function has five arguments. Three of the five are required.
* rate - The interest rate for the loan.
* nper - The total number of payments for the loan
* pv - The present value, or the total value of all loan payments now.
* fv - [optional] The future value or a cash balance you want after the last payment is made. Defaults to 0 (zero).
* type - [optional] When payments are due. 0 = end of the period. 1 = beginning of the period. Default is 0.
Microsoft Excel Coach for PMT
support.conten...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtra...
○ Screenshots - Snagit - chrismenardtra...
○ KZitem keyword search - TubeBuddy - www.tubebuddy....
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Негізгі бет Excel PMT Function - house or car loan payment | Excel One Minute Quick Reference
No video
Пікірлер: 11