Lynda - Excel 2016 - Financial Functions in Depth
File List
| File | Size |
|---|---|
| 0. Introduction/504663_00_01_WX30_intro.mp4 | 4.68 MB |
| 0. Introduction/504663_00_02_XR15_disclaimer.mp4 | 1.22 MB |
| 0. Introduction/504663_00_03_XR15_exerfiles.mp4 | 1.15 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_06_XR15_accrued.mp4 | 9.37 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_02_XR15_ppmt.mp4 | 8.59 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_03_XR15_cumprinc.mp4 | 7.74 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_01_XR15_pmt.mp4 | 7.24 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_05_XR15_apr.mp4 | 6.41 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_07_XR15_rate.mp4 | 5.96 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_09_XR15_nper.mp4 | 4.61 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_08_XR15_duration.mp4 | 3.54 MB |
| 1. Analyzing Loans, Payments, and Interest/504663_01_04_XR15_int.mp4 | 3.27 MB |
| 2. Calculating Depreciation/504663_02_03_XR15_ddb.mp4 | 8.13 MB |
| 2. Calculating Depreciation/504663_02_05_XR15_vdb.mp4 | 7.4 MB |
| 2. Calculating Depreciation/504663_02_07_XR15_linear.mp4 | 6.65 MB |
| 2. Calculating Depreciation/504663_02_02_XR15_db.mp4 | 6.58 MB |
| 2. Calculating Depreciation/504663_02_06_XR15_french.mp4 | 6.1 MB |
| 2. Calculating Depreciation/504663_02_01_XR15_straightline.mp4 | 5.57 MB |
| 2. Calculating Depreciation/504663_02_04_XR15_syd.mp4 | 5.16 MB |
| 3. Determining Values and Rates of Return/504663_03_04_XR15_npv.mp4 | 9.58 MB |
| 3. Determining Values and Rates of Return/504663_03_06_XR15_irr.mp4 | 7.56 MB |
| 3. Determining Values and Rates of Return/504663_03_03_XR15_pv.mp4 | 7.31 MB |
| 3. Determining Values and Rates of Return/504663_03_01_XR15_fv.mp4 | 6.93 MB |
| 3. Determining Values and Rates of Return/504663_03_07_XR15_xirr.mp4 | 6.06 MB |
| 3. Determining Values and Rates of Return/504663_03_05_XR15_xnpv.mp4 | 5.96 MB |
| 3. Determining Values and Rates of Return/504663_03_08_XR15_mirr.mp4 | 5.4 MB |
| 3. Determining Values and Rates of Return/504663_03_09_XR15_disc.mp4 | 4.95 MB |
| 3. Determining Values and Rates of Return/504663_03_02_XR15_sched.mp4 | 2.92 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_08_XR15_mduration.mp4 | 8.34 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_07_XR15_duration.mp4 | 7.93 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_05_XR15_coupnum.mp4 | 7.39 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_06_XR15_couppcd.mp4 | 6.69 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_04_XR15_coupncd.mp4 | 6.42 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_01_XR15_coupdaybs.mp4 | 5.54 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_02_XR15_doupdays.mp4 | 5.22 MB |
| 4. Calculating Bond Coupon Dates and Security Durations/504663_04_03_XR15_coupdaysnc.mp4 | 4.88 MB |
| 5. Calculating Security Prices and Yields/504663_05_01_XR15_dollarde.mp4 | 6.46 MB |
| 5. Calculating Security Prices and Yields/504663_05_05_XR15_pricedisc.mp4 | 5.7 MB |
| 5. Calculating Security Prices and Yields/504663_05_10_XR15_yield.mp4 | 5.69 MB |
| 5. Calculating Security Prices and Yields/504663_05_03_XR15_received.mp4 | 5.68 MB |
| 5. Calculating Security Prices and Yields/504663_05_04_XR15_price.mp4 | 5.64 MB |
| 5. Calculating Security Prices and Yields/504663_05_02_XR15_intrate.mp4 | 5.33 MB |
| 5. Calculating Security Prices and Yields/504663_05_12_XR15_yieldmat.mp4 | 5.06 MB |
| 5. Calculating Security Prices and Yields/504663_05_06_XR15_pricemat.mp4 | 4.95 MB |
| 5. Calculating Security Prices and Yields/504663_05_09_XR15_tbillyield.mp4 | 4.61 MB |
| 5. Calculating Security Prices and Yields/504663_05_08_XR15_tbillprice.mp4 | 4.49 MB |
| 5. Calculating Security Prices and Yields/504663_05_07_XR15_tbilleq.mp4 | 4.36 MB |
| 5. Calculating Security Prices and Yields/504663_05_11_XR15_yielddisc.mp4 | 4.32 MB |
| 6. Calculating Prices and Yields of Securities with Odd Periods/504663_06_02_XR15_oddfyield.mp4 | 6.74 MB |
| 6. Calculating Prices and Yields of Securities with Odd Periods/504663_06_01_XR15_oddfprice.mp4 | 6.42 MB |
| 6. Calculating Prices and Yields of Securities with Odd Periods/504663_06_04_XR15_oddlyield.mp4 | 5.77 MB |
| 6. Calculating Prices and Yields of Securities with Odd Periods/504663_06_03_XR15_oddlprice.mp4 | 5.57 MB |
| 7. Conclusion/504663_07_01_XR15_goodbye.mp4 | 2.32 MB |
| Exercise Files/Chapter01/AccruedInterest_01_06.xlsx | 9.53 KB |
| Exercise Files/Chapter01/NominalAndEffective_01_05.xlsx | 8.8 KB |
| Exercise Files/Chapter01/Cumulative_01_03.xlsx | 8.61 KB |
| Exercise Files/Chapter01/PrincipalAndInterest_01_02.xlsx | 8.61 KB |
| Exercise Files/Chapter01/Rate_01_07.xlsx | 8.57 KB |
| Exercise Files/Chapter01/LoanPayment_01_01.xlsx | 8.55 KB |
| Exercise Files/Chapter01/InterestInPeriod_01_04.xlsx | 8.52 KB |
| Exercise Files/Chapter01/NumberOfPeriods_01_09.xlsx | 8.5 KB |
| Exercise Files/Chapter01/Duration_01_08.xlsx | 8.44 KB |
| Exercise Files/Chapter02/DecliningBalance_02_02.xlsx | 10.58 KB |
| Exercise Files/Chapter02/DoubleDeclining_02_03.xlsx | 9.72 KB |
| Exercise Files/Chapter02/DepreciationCoefficient_02_06.xlsx | 9.06 KB |
| Exercise Files/Chapter02/Straightline_02_01.xlsx | 8.66 KB |
| Exercise Files/Chapter02/VariableDecliningBalance_02_05.xlsx | 8.58 KB |
| Exercise Files/Chapter02/SpecifiedPeriod_02_04.xlsx | 8.5 KB |
| Exercise Files/Chapter02/EachPeriod_02_07.xlsx | 8.49 KB |
| Exercise Files/Chapter03/PV_03_03.xlsx | 9.83 KB |
| Exercise Files/Chapter03/FV_03_01.xlsx | 9.71 KB |
| Exercise Files/Chapter03/DiscountRate_03_09.xlsx | 9.56 KB |
| Exercise Files/Chapter03/IRR_03_06.xlsx | 8.8 KB |
| Exercise Files/Chapter03/NPV_03_04.xlsx | 8.78 KB |
| Exercise Files/Chapter03/MixedCashFlows_03_08.xlsx | 8.67 KB |
| Exercise Files/Chapter03/IrregularIRRSchedule_03_07.xlsx | 8.6 KB |
| Exercise Files/Chapter03/IrregularNPVSchedule_03_05.xlsx | 8.57 KB |
| Exercise Files/Chapter03/FVSchedule_03_02.xlsx | 8.47 KB |
| Exercise Files/Chapter04/CalculatingDuration_04_07.xlsx | 8.39 KB |
| Exercise Files/Chapter04/CalculatingModifiedDuration_04_08.xlsx | 8.39 KB |
| Exercise Files/Chapter04/NumberOfCoupons_04_05.xlsx | 8.34 KB |
| Exercise Files/Chapter04/CouponDays_04_01.xlsx | 8.33 KB |
| Exercise Files/Chapter04/DaysInSettlementPeriod_04_02.xlsx | 8.33 KB |
| Exercise Files/Chapter04/DaysToNextCoupon_04_03.xlsx | 8.33 KB |
| Exercise Files/Chapter04/PreviousCouponDate_04_06.xlsx | 8.32 KB |
| Exercise Files/Chapter04/DateNextCouponIsDue_04_04.xlsx | 8.32 KB |
| Exercise Files/Chapter05/YieldWithPeriodicInterest_05_10.xlsx | 9.81 KB |
| Exercise Files/Chapter05/BondPrice_05_04.xlsx | 9.75 KB |
| Exercise Files/Chapter05/TBillYield_05_09.xlsx | 9.47 KB |
| Exercise Files/Chapter05/InterestAtMaturity_05_06.xlsx | 8.6 KB |
| Exercise Files/Chapter05/InterestRate_05_02.xlsx | 8.57 KB |
| Exercise Files/Chapter05/YieldAtMaturity_05_12.xlsx | 8.56 KB |
| Exercise Files/Chapter05/DiscountedSecurityYield_05_11.xlsx | 8.55 KB |
| Exercise Files/Chapter05/ValueAtMaturity_05_03.xlsx | 8.52 KB |
| Exercise Files/Chapter05/Convert_05_01.xlsx | 8.52 KB |
| Exercise Files/Chapter05/DiscountedSecurityPrice_05_05.xlsx | 8.52 KB |
| Exercise Files/Chapter05/TBillPrice_05_08.xlsx | 8.49 KB |
| Exercise Files/Chapter05/BondEquivalentYield_05_07.xlsx | 8.36 KB |
| Exercise Files/Chapter06/OddFirstPrice_06_01.xlsx | 8.65 KB |
| Exercise Files/Chapter06/OddLastPrice_06_03.xlsx | 8.64 KB |
Trackers
No trackers found.