Financial Functions | MCQs

Explanation

The PMT function in Excel calculates the payment for a loan based on constant interest rates and payments, categorizing it under financial functions.

It uses inputs like rate (C10/12), number of periods (CB), and loan amount (C9) to compute the payment.

Explanation

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

Explanation

Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.

A list of Excel Financial Functions in Excel are:

⇒Investment value functions including

1. FV

2. FVSCHEDULE

3. NPV

4. PV

5. RECEIVED

6. XNPV

⇒Internal rate of return functions including

1. IRR

2. MIRR

3. XIRR

⇒Asset depreciation functions including

1. AMORDEGRC

2. AMORLINC

3. DB

4. DDB

5. SLN

6. SYD

7. VDB

⇒Payment functions including

1. CUMIPMT

2. CUMPRINC

3. IPMT

4. ISPMT

5. PMT

6. PPMT

⇒Dollar conversion including

1. DOLLARDE

2. DOLLARFR

⇒Yield functions including

1. YIELD

2. YIELDDISC

3. YIELDMAT

4. ODDFYIELD

5. ODDLYIELD

6. TBILLEO

7. TBILLYIELD

⇒Price functions including

1. PRICE

2. PRICEDISC

3. PRICEMAT

4. ODDFPRICE

5. ODDLPRICE

6. TBILLPRICE