Lynda Excel 2016 Financial Functions in Depth

/0. Introduction/

504663_00_01_WX30_intro.mp4

504663_00_02_XR15_disclaimer.mp4

504663_00_03_XR15_exerfiles.mp4

/1. Analyzing Loans, Payments, and Interest/

504663_01_06_XR15_accrued.mp4

504663_01_02_XR15_ppmt.mp4

504663_01_03_XR15_cumprinc.mp4

504663_01_01_XR15_pmt.mp4

504663_01_05_XR15_apr.mp4

504663_01_07_XR15_rate.mp4

504663_01_09_XR15_nper.mp4

504663_01_08_XR15_duration.mp4

504663_01_04_XR15_int.mp4

/2. Calculating Depreciation/

504663_02_03_XR15_ddb.mp4

504663_02_05_XR15_vdb.mp4

504663_02_07_XR15_linear.mp4

504663_02_02_XR15_db.mp4

504663_02_06_XR15_french.mp4

504663_02_01_XR15_straightline.mp4

504663_02_04_XR15_syd.mp4

/3. Determining Values and Rates of Return/

504663_03_04_XR15_npv.mp4

504663_03_06_XR15_irr.mp4

504663_03_03_XR15_pv.mp4

504663_03_01_XR15_fv.mp4

504663_03_07_XR15_xirr.mp4

504663_03_05_XR15_xnpv.mp4

504663_03_08_XR15_mirr.mp4

504663_03_09_XR15_disc.mp4

504663_03_02_XR15_sched.mp4

/4. Calculating Bond Coupon Dates and Security Durations/

504663_04_08_XR15_mduration.mp4

504663_04_07_XR15_duration.mp4

504663_04_05_XR15_coupnum.mp4

504663_04_06_XR15_couppcd.mp4

504663_04_04_XR15_coupncd.mp4

504663_04_01_XR15_coupdaybs.mp4

504663_04_02_XR15_doupdays.mp4

504663_04_03_XR15_coupdaysnc.mp4

/5. Calculating Security Prices and Yields/

504663_05_01_XR15_dollarde.mp4

504663_05_05_XR15_pricedisc.mp4

504663_05_10_XR15_yield.mp4

504663_05_03_XR15_received.mp4

504663_05_04_XR15_price.mp4

504663_05_02_XR15_intrate.mp4

504663_05_12_XR15_yieldmat.mp4

504663_05_06_XR15_pricemat.mp4

504663_05_09_XR15_tbillyield.mp4

504663_05_08_XR15_tbillprice.mp4

504663_05_07_XR15_tbilleq.mp4

504663_05_11_XR15_yielddisc.mp4

/6. Calculating Prices and Yields of Securities with Odd Periods/

504663_06_02_XR15_oddfyield.mp4

504663_06_01_XR15_oddfprice.mp4

504663_06_04_XR15_oddlyield.mp4

504663_06_03_XR15_oddlprice.mp4

/7. Conclusion/

504663_07_01_XR15_goodbye.mp4

/Exercise Files/Chapter01/

AccruedInterest_01_06.xlsx

NominalAndEffective_01_05.xlsx

Cumulative_01_03.xlsx

PrincipalAndInterest_01_02.xlsx

Rate_01_07.xlsx

LoanPayment_01_01.xlsx

InterestInPeriod_01_04.xlsx

NumberOfPeriods_01_09.xlsx

Duration_01_08.xlsx

/Exercise Files/Chapter02/

DecliningBalance_02_02.xlsx

DoubleDeclining_02_03.xlsx

DepreciationCoefficient_02_06.xlsx

Straightline_02_01.xlsx

VariableDecliningBalance_02_05.xlsx

SpecifiedPeriod_02_04.xlsx

EachPeriod_02_07.xlsx

/Exercise Files/Chapter03/

PV_03_03.xlsx

FV_03_01.xlsx

DiscountRate_03_09.xlsx

IRR_03_06.xlsx

NPV_03_04.xlsx

MixedCashFlows_03_08.xlsx

IrregularIRRSchedule_03_07.xlsx

IrregularNPVSchedule_03_05.xlsx

FVSchedule_03_02.xlsx

/Exercise Files/Chapter04/

CalculatingDuration_04_07.xlsx

CalculatingModifiedDuration_04_08.xlsx

NumberOfCoupons_04_05.xlsx

CouponDays_04_01.xlsx

DaysInSettlementPeriod_04_02.xlsx

DaysToNextCoupon_04_03.xlsx

PreviousCouponDate_04_06.xlsx

DateNextCouponIsDue_04_04.xlsx

/Exercise Files/Chapter05/

YieldWithPeriodicInterest_05_10.xlsx

BondPrice_05_04.xlsx

TBillYield_05_09.xlsx

InterestAtMaturity_05_06.xlsx

InterestRate_05_02.xlsx

YieldAtMaturity_05_12.xlsx

DiscountedSecurityYield_05_11.xlsx

ValueAtMaturity_05_03.xlsx

Convert_05_01.xlsx

DiscountedSecurityPrice_05_05.xlsx

TBillPrice_05_08.xlsx

BondEquivalentYield_05_07.xlsx

/Exercise Files/Chapter06/

OddFirstPrice_06_01.xlsx

OddLastPrice_06_03.xlsx

OddFirstYield_06_02.xlsx

OddLastYield_06_04.xlsx

Total files 102