Lynda com Excel 2010 Financial Functions in Depth | F4A7167E00104B7EF02CB8BAB2D06B7CC46E91DF

Lynda com Excel 2010 Financial Functions in Depth

Name	Lynda.com.Excel.2010.Financial.Functions.in.Depth	DOWNLOAD Copy Link
Total Size	193.0 MB
Total Files	100
Hash	F4A7167E00104B7EF02CB8BAB2D06B7CC46E91DF

/00 Introduction/
83199_00_01_SC03_Welcome.mov	5.4 MB
83199_00_02_SC11_exerfiles.mov	678.6 KB
83199_00_03_SC11_dontsueus.mov	511.0 KB
/01 Analyzing Loans, Payments, and Interest/
83199_01_01_SC11_pmt.mov	5.8 MB
83199_01_02_SC11_ppmt.mov	7.2 MB
83199_01_03_SC11_cumprinc.mov	6.1 MB
83199_01_04_SC11_ispmt.mov	2.9 MB
83199_01_05_SC11_nom.mov	4.7 MB
83199_01_06_SC11_accrued.mov	5.5 MB
83199_01_07_SC11_rate.mov	5.1 MB
83199_01_08_SC11_nper.mov	4.6 MB
/02 Calculating Depreciation/
83199_02_01_SC11_straightline.mov	2.4 MB
83199_02_02_SC11_declining.mov	4.1 MB
83199_02_03_SC11_doubledown.mov	4.3 MB
83199_02_04_SC11_syd.mov	2.9 MB
83199_02_05_SC11_vdb.mov	4.3 MB
83199_02_06_SC11_coeff.mov	3.3 MB
83199_02_07_SC11_french.mov	3.7 MB
/03 Determining Values and Rates of Return/
83199_03_01_SC11_fv.mov	3.6 MB
83199_03_02_SC11_fvsched.mov	3.0 MB
83199_03_03_SC11_pv.mov	4.8 MB
83199_03_04_SC11_npv.mov	4.4 MB
83199_03_05_SC11_irr.mov	3.5 MB
83199_03_06_SC11_xnpv.mov	3.3 MB
83199_03_07_SC11_xirr.mov	2.5 MB
83199_03_08_SC11_mirr.mov	2.8 MB
83199_03_09_SC11_disc.mov	4.1 MB
/04 Calculating Bond Coupon Dates and Security Durations/
83199_04_01_SC11_coupdaybs.mov	4.1 MB
83199_04_02_SC11_daysinpd.mov	3.6 MB
83199_04_03_SC11_daystocoup.mov	3.9 MB
83199_04_04_SC11_nextdate.mov	3.6 MB
83199_04_05_SC11_numcoup.mov	3.8 MB
83199_04_06_SC11_prevcoupdate.mov	4.0 MB
83199_04_07_SC11_duration.mov	4.4 MB
83199_04_08_SC11_mduration.mov	4.4 MB
/05 Calculating Security Prices and Yields/
83199_05_01_SC11_convertval.mov	3.4 MB
83199_05_02_SC11_intrate.mov	3.7 MB
83199_05_03_SC11_received.mov	3.7 MB
83199_05_04_SC11_pricing.mov	4.4 MB
83199_05_05_SC11_pricedisc.mov	3.7 MB
83199_05_06_SC11_pricemat.mov	2.6 MB
83199_05_07_SC11_tbilleq.mov	2.5 MB
83199_05_08_SC11_tbillprice.mov	2.0 MB
83199_05_09_SC11_tbillyield.mov	2.2 MB
83199_05_10_SC11_yield.mov	3.9 MB
83199_05_11_SC11_yielddisc.mov	2.8 MB
83199_05_12_SC11_yieldmat.mov	3.0 MB
/06 Calculating Prices and Yields of Securities with Odd Periods/
83199_06_01_SC11_oddfprice.mov	4.4 MB
83199_06_02_SC11_oddfyield.mov	4.1 MB
83199_06_03_SC11_oddlprice.mov	3.7 MB
83199_06_04_SC11_oddlyield.mov	3.9 MB
/07 Conclusion/
83199_07_01_SC11_goodbye.mov	1.4 MB
/Exercise Files/Chapter01/
Accrued Interest.xlsx	9.3 KB
CUMPRINC and CUMIPMT.xlsx	9.4 KB
ISPMT.xlsx	9.3 KB
Loan Payment.xlsx	9.3 KB
NOMINAL and EFFECTIVE.xlsx	9.0 KB
Number of Periods.xlsx	8.3 KB
PPMT and IPMT.xlsx	9.4 KB
Rate.xlsx	9.3 KB
/Exercise Files/Chapter02/
Declining.xlsx	10.4 KB
Depreciation Coefficient.xlsx	9.3 KB
Depreciation for Each Accounting Period.xlsx	9.3 KB
Doubledown.xlsx	9.5 KB
Straightline.xlsx	8.5 KB
Sum of Years.xlsx	9.3 KB
Variable Declining Balance.xlsx	9.4 KB
/Exercise Files/Chapter03/
Discount Rate.xlsx	9.4 KB
Futureval.xlsx	10.5 KB
FV Schedule.xlsx	9.3 KB
IRR.xlsx	9.6 KB
Irregular IRR Schedule.xlsx	8.4 KB
Irregular NPV Schedule.xlsx	8.3 KB
Mixed Cash Flows.xlsx	8.5 KB
Npv.xlsx	8.6 KB
Pv.xlsx	10.6 KB
/Exercise Files/Chapter04/
Calculating Duration.xlsx	9.2 KB
Calculating Modified Duration.xlsx	9.2 KB
Coupon Days Between Beginning and Settlement.xlsx	9.1 KB
Date Next Coupon is Due.xlsx	9.1 KB
Days in Settlement Period.xlsx	9.1 KB
Days to Next Coupon.xlsx	9.1 KB
Number of Coupons.xlsx	9.1 KB
Previous Coupon Date.xlsx	9.1 KB
/Exercise Files/Chapter05/
Bond Equivalent Yield.xlsx	9.2 KB
Convert Between Fractional and Decimal Dollars.xlsx	9.3 KB
Discounted Security Price.xlsx	9.3 KB
Discounted Security Yield.xlsx	9.3 KB
Find Interest Rate.xlsx	9.4 KB
Find Value at Maturity.xlsx	9.4 KB
Mature Pricing.xlsx	9.3 KB
Pricing.xlsx	10.6 KB
T-bill Yield.xlsx	9.3 KB
T. Bill Price.xlsx	9.3 KB
Yield at Maturity.xlsx	8.9 KB
Yield.xlsx	10.6 KB
/Exercise Files/Chapter06/
Odd First Price.xlsx	9.5 KB
Odd First Yield.xlsx	9.4 KB
Odd Last Price.xlsx	9.4 KB
Odd Last Yield.xlsx	9.4 KB
Total files 100