Lynda.com.Excel.2010.Financial.Functions.in.Depth/00 Introduction/83199_00_01_SC03_Welcome.mov |
5.1 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/00 Introduction/83199_00_02_SC11_exerfiles.mov |
663 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/00 Introduction/83199_00_03_SC11_dontsueus.mov |
499 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_01_SC11_pmt.mov |
5.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_02_SC11_ppmt.mov |
6.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_03_SC11_cumprinc.mov |
5.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_04_SC11_ispmt.mov |
2.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_05_SC11_nom.mov |
4.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_06_SC11_accrued.mov |
5.3 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_07_SC11_rate.mov |
4.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/01 Analyzing Loans, Payments, and Interest/83199_01_08_SC11_nper.mov |
4.3 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_01_SC11_straightline.mov |
2.3 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_02_SC11_declining.mov |
3.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_03_SC11_doubledown.mov |
4.1 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_04_SC11_syd.mov |
2.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_05_SC11_vdb.mov |
4.1 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_06_SC11_coeff.mov |
3.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/02 Calculating Depreciation/83199_02_07_SC11_french.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_01_SC11_fv.mov |
3.4 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_02_SC11_fvsched.mov |
2.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_03_SC11_pv.mov |
4.6 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_04_SC11_npv.mov |
4.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_05_SC11_irr.mov |
3.4 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_06_SC11_xnpv.mov |
3.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_07_SC11_xirr.mov |
2.3 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_08_SC11_mirr.mov |
2.7 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/03 Determining Values and Rates of Return/83199_03_09_SC11_disc.mov |
3.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_01_SC11_coupdaybs.mov |
3.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_02_SC11_daysinpd.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_03_SC11_daystocoup.mov |
3.7 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_04_SC11_nextdate.mov |
3.4 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_05_SC11_numcoup.mov |
3.6 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_06_SC11_prevcoupdate.mov |
3.8 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_07_SC11_duration.mov |
4.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/04 Calculating Bond Coupon Dates and Security Durations/83199_04_08_SC11_mduration.mov |
4.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_01_SC11_convertval.mov |
3.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_02_SC11_intrate.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_03_SC11_received.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_04_SC11_pricing.mov |
4.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_05_SC11_pricedisc.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_06_SC11_pricemat.mov |
2.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_07_SC11_tbilleq.mov |
2.4 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_08_SC11_tbillprice.mov |
1.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_09_SC11_tbillyield.mov |
2.1 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_10_SC11_yield.mov |
3.7 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_11_SC11_yielddisc.mov |
2.7 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/05 Calculating Security Prices and Yields/83199_05_12_SC11_yieldmat.mov |
2.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/06 Calculating Prices and Yields of Securities with Odd Periods/83199_06_01_SC11_oddfprice.mov |
4.2 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/06 Calculating Prices and Yields of Securities with Odd Periods/83199_06_02_SC11_oddfyield.mov |
3.9 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/06 Calculating Prices and Yields of Securities with Odd Periods/83199_06_03_SC11_oddlprice.mov |
3.5 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/06 Calculating Prices and Yields of Securities with Odd Periods/83199_06_04_SC11_oddlyield.mov |
3.7 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/07 Conclusion/83199_07_01_SC11_goodbye.mov |
1.3 MB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/Accrued Interest.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/CUMPRINC and CUMIPMT.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/ISPMT.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/Loan Payment.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/NOMINAL and EFFECTIVE.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/Number of Periods.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/PPMT and IPMT.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter01/Rate.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Declining.xlsx |
10 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Depreciation Coefficient.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Depreciation for Each Accounting Period.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Doubledown.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Straightline.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Sum of Years.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter02/Variable Declining Balance.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Discount Rate.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Futureval.xlsx |
10 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/FV Schedule.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/IRR.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Irregular IRR Schedule.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Irregular NPV Schedule.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Mixed Cash Flows.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Npv.xlsx |
8 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter03/Pv.xlsx |
10 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Calculating Duration.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Calculating Modified Duration.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Coupon Days Between Beginning and Settlement.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Date Next Coupon is Due.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Days in Settlement Period.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Days to Next Coupon.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Number of Coupons.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter04/Previous Coupon Date.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Bond Equivalent Yield.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Convert Between Fractional and Decimal Dollars.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Discounted Security Price.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Discounted Security Yield.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Find Interest Rate.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Find Value at Maturity.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Mature Pricing.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Pricing.xlsx |
10 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/T-bill Yield.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/T. Bill Price.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Yield at Maturity.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter05/Yield.xlsx |
10 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter06/Odd First Price.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter06/Odd First Yield.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter06/Odd Last Price.xlsx |
9 KB |
Lynda.com.Excel.2010.Financial.Functions.in.Depth/Exercise Files/Chapter06/Odd Last Yield.xlsx |
9 KB |