### Description

**In this course, you will :**

- shows users how and when to use each of Excel's financial functions
- covers loan payments, depreciation, calculating rates of return, bond coupon dates, and security durations, calculating prices and yields, and more.

**Syllabus :**

1. Analyzing Loans, Payments, and Interest

- PMT: Calculate a loan payment
- PPMT and IPMT: Calculate the principal and interest per loan payment
- CUMPRINC and CUMIPMT: Calculate cumulative principal and interest paid between periods
- ISPMT: Calculate the interest paid during a specific period
- EFFECT and NOMINAL: Find nominal and effective interest rates
- ACCRINT and ACCRINTM: Calculate accrued interest for investments
- RATE: Discover the interest rate of an annuity
- PDURATION: Calculate the number of periods to reach a specified value
- NPER: Calculate the number of periods in an investment

2. Calculate Depreciation

- SLN: Calculate depreciation using the straight line method
- DB: Calculate depreciation using the declining balance method
- DDB: Calculate depreciation using the double-declining balance method
- SYD: Calculate depreciation for a specified period
- VDB: Calculate declining balance depreciation for a partial period
- AMORDEGRC: Calculate depreciation using a depreciation coefficient
- AMORLINC: Calculate depreciation for each accounting period

3. Determining Values and Rates of Return

- FV: Calculate the future value of an investment
- FVSCHEDULE: Calculate the future value of an investment with variable returns
- PV: Calculate the present value of an investment
- NPV: Calculate the net present value of an investment
- XNPV: Calculate net present value given irregular inputs
- IRR: Calculate internal rate of return
- XIRR: Calculate internal rate of return for irregular cash flows
- MIRR: Calculate internal rate of return for mixed cash flows
- RRI: Calculate the interest rate for the growth of an investment

4. Calculate Bond Coupon Dates and Security Durations

- COUPDAYBS: Calculate total days between coupon beginning and settlement
- COUPDAYS: Calculate days in the settlement date’s coupon period
- COUPDAYSNC: Calculate days from the settlement date to the next coupon date
- COUPNCD: Calculate the next coupon date after the settlement date
- COUPNUM: Calculate the number of coupons between settlement and maturity
- COUPPCD: Calculate the coupon date due immediately before settlement
- DURATION: Calculate the annual duration of a security
- MDURATION: Calculate the duration of a security using the Macaulay method

5. Calculate Security Prices and Rates

- DOLLARDE and DOLLARFR: Convert between fractional prices and decimal prices
- INTRATE: Calculate the interest rate of a fully invested security
- RECEIVED: Calculate the value of a fully invested security at maturity
- PRICE: Calculate the price of a security that pays periodic interest
- DISC: Calculate the discount rate of a security
- PRICEDISC: Calculate the price of a discounted security
- PRICEMAT: Calculate the price of a security that pays interest at maturity
- TBILLEQ: Calculate the bond-equivalent yield for a Treasury bill
- TBILLPRICE: Calculate the price for a Treasury bill

6. Calculate Security Yields

- TBILLYIELD: Calculate the yield of a Treasury bill
- YIELD: Calculate the yield of a security that pays periodic interest
- YIELDDISC: Calculate the annual yield for a discounted security
- YIELDMAT: Calculate the annual yield of a security that pays interest at maturity

7. Evaluate Securities with Odd First or Last Periods

- ODDFPRICE: Calculate the price of a security with an odd first period
- ODDFYIELD: Calculate the yield of a security with an odd first period
- ODDLPRICE: Calculate the price of a security with an odd last period
- ODDLYIELD: Calculate the yield of a security with an odd last period