01 - Introduction
Ex_Files_Excel_Financial_Functions_in_Depth_Q32021
02 - 1. Analyzing Loans, Payments, and Interest
-
01 - PMT Calculate a loan payment (4:02)
-
02 - PPMT and IPMT Calculate the principal and interest per loan payment (5:32)
-
03 - CUMPRINC and CUMIPMT Calculate cumulative principal and interest paid between periods (5:21)
-
04 - ISPMT Calculate the interest paid during a specific period (2:56)
-
05 - EFFECT and NOMINAL Find nominal and effective interest rates (2:26)
-
06 - ACCRINT and ACCRINTM Calculate accrued interest for investments (4:44)
-
07 - RATE Discover the interest rate of an annuity (3:19)
-
08 - PDURATION Calculate the number of periods to reach a specified value (2:06)
-
09 - NPER Calculate the number of periods in an investment (2:28)
03 - 2. Calculate Depreciation
-
01 - SLN Calculate depreciation using the straight line method (2:05)
-
02 - DB Calculate depreciation using the declining balance method (3:03)
-
03 - DDB Calculate depreciation using the double-declining balance method (3:21)
-
04 - SYD Calculate depreciation for a specified period (2:31)
-
05 - VDB Calculate declining balance depreciation for a partial period (4:30)
-
06 - AMORDEGRC Calculate depreciation using a depreciation coefficient (2:55)
-
07 - AMORLINC Calculate depreciation for each accounting period (3:32)
04 - 3. Determining Values and Rates of Return
-
01 - FV Calculate the future value of an investment (3:14)
-
02 - FVSCHEDULE Calculate the future value of an investment with variable returns (1:27)
-
03 - PV Calculate the present value of an investment (4:06)
-
04 - NPV Calculate the net present value of an investment (4:16)
-
05 - XNPV Calculate net present value given irregular inputs (2:40)
-
06 - IRR Calculate internal rate of return (2:50)
-
07 - XIRR Calculate internal rate of return for irregular cash flows (2:00)
-
08 - MIRR Calculate internal rate of return for mixed cash flows (2:09)
-
09 - RRI Calculate the interest rate for the growth of an investment (2:09)
05 - 4. Calculate Bond Coupon Dates and Security Durations
-
02 - COUPDAYS Calculate days in the settlement date’s coupon period (2:13)
-
01 - COUPDAYBS Calculate total days between coupon beginning and settlement (2:08)
-
03 - COUPDAYSNC Calculate days from the settlement date to the next coupon date (2:12)
-
04 - COUPNCD Calculate the next coupon date after the settlement date (2:13)
-
05 - COUPNUM Calculate the number of coupons between settlement and maturity (3:04)
-
06 - COUPPCD Calculate the coupon date due immediately before settlement (3:00)
-
07 - DURATION Calculate the annual duration of a security (3:29)
-
08 - MDURATION Calculate the duration of a security using the Macaulay method (3:20)
06 - 5. Calculate Security Prices and Rates
-
02 - INTRATE Calculate the interest rate of a fully invested security (2:39)
-
01 - DOLLARDE and DOLLARFR Convert between fractional prices and decimal prices (3:26)
-
03 - RECEIVED Calculate the value of a fully invested security at maturity (2:40)
-
04 - PRICE Calculate the price of a security that pays periodic interest (3:09)
-
05 - DISC Calculate the discount rate of a security (3:38)
-
06 - PRICEDISC Calculate the price of a discounted security (3:01)
-
07 - PRICEMAT Calculate the price of a security that pays interest at maturity (2:59)
-
08 - TBILLEQ Calculate the bond-equivalent yield for a Treasury bill (2:14)
-
09 - TBILLPRICE Calculate the price for a Treasury bill (2:51)
07 - 6. Calculate Security Yields
-
01 - TBILLYIELD Calculate the yield of a Treasury bill (1:56)
-
02 - YIELD Calculate the yield of a security that pays periodic interest (3:09)
-
03 - YIELDDISC Calculate the annual yield for a discounted security (2:36)
-
04 - YIELDMAT Calculate the annual yield of a security that pays interest at maturity (2:41)
08 - 7. Evaluate Securities with Odd First or Last Periods
-
02 - ODDFYIELD Calculate the yield of a security with an odd first period (3:57)
-
01 - ODDFPRICE Calculate the price of a security with an odd first period (3:18)
-
03 - ODDLPRICE Calculate the price of a security with an odd last period (3:47)
-
04 - ODDLYIELD Calculate the yield of a security with an odd last period (3:30)
09 - Conclusion
