Section 1 : Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 2 What you should know 0:51
Lecture 3 Disclaimer 0:26

Section 2 : Analyzing Loans, Payments, and Interest

Lecture 4 PMT Calculate a loan payment 4:1
Lecture 5 PPMT and IPMT Calculate the principal and interest per loan payment 5:32
Lecture 6 CUMPRINC and CUMIPMT Calculate cumulative principal and interest paid between periods 5:21
Lecture 7 ISPMT Calculate the interest paid during a specific period 2:56
Lecture 8 EFFECT and NOMINAL Find nominal and effective interest rates
Lecture 9 ACCRINT and ACCRINTM Calculate accrued interest for investments 4:44
Lecture 10 RATE Discover the interest rate of an annuity 3:18
Lecture 11 PDURATION Calculate the number of periods to reach a specified value 2:6
Lecture 12 NPER Calculate the number of periods in an investment 2:28

Section 3 : Calculate Depreciation

Lecture 13 SLN Calculate depreciation using the straight line method 2:5
Lecture 14 DB Calculate depreciation using the declining balance method 3:3
Lecture 15 DDB Calculate depreciation using the double-declining balance method 3:21
Lecture 16 SYD Calculate depreciation for a specified period 2:31
Lecture 17 VDB Calculate declining balance depreciation for a partial period 4:30
Lecture 18 AMORDEGRC Calculate depreciation using a depreciation coefficient 2:55
Lecture 19 AMORLINC Calculate depreciation for each accounting period 3:32

Section 4 : Determining Values and Rates of Return

Lecture 20 FV Calculate the future value of an investment 3:14
Lecture 21 FVSCHEDULE Calculate the future value of an investment with variable returns 1:27
Lecture 22 PV Calculate the present value of an investment
Lecture 23 NPV Calculate the net present value of an investment 4:16
Lecture 24 XNPV Calculate net present value given irregular inputs 2:40
Lecture 25 IRR Calculate internal rate of return
Lecture 26 XIRR Calculate internal rate of return for irregular cash flows 2:0
Lecture 27 MIRR Calculate internal rate of return for mixed cash flows 2:9
Lecture 28 RRI Calculate the interest rate for the growth of an investment

Section 5 : Calculate Bond Coupon Dates and Security Durations

Lecture 29 COUPDAYBS Calculate total days between coupon beginning and settlement 2:7
Lecture 30 COUPDAYS Calculate days in the settlement date’s coupon period 2:13
Lecture 31 COUPDAYSNC Calculate days from the settlement date to the next coupon date 2:12
Lecture 32 COUPNCD Calculate the next coupon date after the settlement date 2:13
Lecture 33 COUPNUM Calculate the number of coupons between settlement and maturity 3:4
Lecture 34 COUPPCD Calculate the coupon date due immediately before settlement 3:0
Lecture 35 DURATION Calculate the annual duration of a security 3:29
Lecture 36 MDURATION Calculate the duration of a security using the Macaulay method 3:20

Section 6 : Calculate Security Prices and Rates

Lecture 37 DOLLARDE and DOLLARFR Convert between fractional prices and decimal prices 3:26
Lecture 38 INTRATE Calculate the interest rate of a fully invested security 2:39
Lecture 39 RECEIVED Calculate the value of a fully invested security at maturity 2:40
Lecture 40 PRICE Calculate the price of a security that pays periodic interest 3:9
Lecture 41 DISC Calculate the discount rate of a security 3:38
Lecture 42 PRICEDISC Calculate the price of a discounted security 3:1
Lecture 43 PRICEMAT Calculate the price of a security that pays interest at maturity 2:59
Lecture 44 TBILLEQ Calculate the bond-equivalent yield for a Treasury bill 2:13
Lecture 45 TBILLPRICE Calculate the price for a Treasury bill

Section 7 : Calculate Security Yields

Lecture 46 TBILLYIELD Calculate the yield of a Treasury bill 1:55
Lecture 47 YIELD Calculate the yield of a security that pays periodic interest 3:9
Lecture 48 YIELDDISC Calculate the annual yield for a discounted security 2:36
Lecture 49 YIELDMAT Calculate the annual yield of a security that pays interest at maturity 2:41

Section 8 : Evaluate Securities with Odd First or Last Periods

Lecture 50 ODDFPRICE Calculate the price of a security with an odd first period 3:18
Lecture 51 ODDFYIELD Calculate the yield of a security with an odd first period 3:57
Lecture 52 ODDLPRICE Calculate the price of a security with an odd last period 3:47
Lecture 53 ODDLYIELD Calculate the yield of a security with an odd last period 3:30