Lynda com Excel 2010 Financial Functions in Depth QUASAR | 0690002C6DD9AB0CE543C5D61303C711D9BE21FE

Lynda com Excel 2010 Financial Functions in Depth QUASAR

Name	Lynda.com.Excel.2010.Financial.Functions.in.Depth-QUASAR	DOWNLOAD Copy Link
Total Size	192.9 MB
Total Files	54
Hash	0690002C6DD9AB0CE543C5D61303C711D9BE21FE

/00 Introduction/
0001 Welcome.mov	5.4 MB
0002 Using the exercise files.mov	678.6 KB
0003 Disclaimer.mov	511.0 KB
/01 Analyzing Loans, Payments, and Interest/
0102 PPMT and IPMT Calculating principal and interest per loan payment.mov	7.2 MB
0103 CUMPRINC and CUMIPMT Calculating cumulative principal and interest paid between periods.mov	6.1 MB
0101 PMT Calculating a loan payment.mov	5.8 MB
0106 ACCRINT and ACCRINTM Calculating accrued interest for investments.mov	5.5 MB
0107 RATE Discovering the interest rate of an annuity.mov	5.1 MB
0105 EFFECT and NOMINAL Finding nominal and effective interest rates.mov	4.7 MB
0108 NPER Calculating the number of periods in an investment.mov	4.6 MB
0104 ISPMT Calculating interest paid during a specific period.mov	2.9 MB
/02 Calculating Depreciation/
0205 VDB Calculating declining balance depreciation for a partial period.mov	4.3 MB
0203 DDB Calculating depreciation using the double-declining balance method.mov	4.3 MB
0202 DB Calculating depreciation using the declining balance method.mov	4.1 MB
0207 AMORLINC Calculating depreciation for each accounting period.mov	3.7 MB
0206 AMORDEGRC Calculating depreciation using a depreciation coefficient.mov	3.3 MB
0204 SYD Calculating depreciation for a specified period.mov	2.9 MB
0201 SLN Calculating depreciation using the straight-line method.mov	2.4 MB
/03 Determining Values and Rates of Return/
0303 PV Calculating the present value of an investment.mov	4.8 MB
0304 NPV Calculating the net present value of an investment.mov	4.4 MB
0309 DISC Calculating the discount rate of a security.mov	4.1 MB
0301 FV Calculating the future value of an investment.mov	3.6 MB
0305 XNPV Calculating net present value given irregular inputs.mov	3.5 MB
0306 IRR Calculating internal rate of return.mov	3.3 MB
0302 FVSCHEDULE Calculating the future value of an investment with variable returns.mov	3.0 MB
0308 MIRR Calculating internal rate of return for mixed cash flows.mov	2.8 MB
0307 XIRR Calculating internal rate of return for irregular cash flows.mov	2.5 MB
/04 Calculating Bond Coupon Dates and Security Durations/
0408 MDURATION Calculating the duration of a security using the modified Macauley method.mov	4.4 MB
0407 DURATION Calculating the annual duration of a security.mov	4.4 MB
0401 COUPDAYBS Calculating total days between coupon beginning and settlement.mov	4.1 MB
0406 COUPPCD Calculating the date of a coupon due immediately before settlement.mov	4.0 MB
0403 COUPDAYSNC Calculating days from the settlement date to the next coupon date.mov	3.9 MB
0405 COUPNUM Calculating the number of coupons between settlement and maturity.mov	3.8 MB
0402 COUPDAYS Calculating days in the settlement date's coupon period.mov	3.6 MB
0404 COUPNCD Calculating the next coupon date after the settlement date.mov	3.6 MB
/05 Calculating Security Prices and Yields/
0504 PRICE Calculating the price of a security that pays periodic interest.mov	4.4 MB
0510 YIELD Calculating the yield of a security that pays periodic interest.mov	3.9 MB
0505 PRICEDISC Calculating the price of a discounted security.mov	3.7 MB
0502 INTRATE Calculating the interest rate of a fully invested security.mov	3.7 MB
0503 RECEIVED Calculating the value at maturity of a fully invested security.mov	3.7 MB
0501 DOLLARDE and DOLLARFR Converting between fractional prices and decimal prices.mov	3.4 MB
0512 YIELDMAT Calculating the annual yield of a security that pays interest at maturity.mov	3.0 MB
0511 YIELDDISC Calculating the annual yield for a discounted security.mov	2.8 MB
0506 PRICEMAT Calculating the price of a security that pays interest at maturity.mov	2.6 MB
0507 TBILLEQ Calculating the bond-equivalent yield for a Treasury bill.mov	2.5 MB
0509 TBILLYIELD Calculating the yield of a Treasury bill.mov	2.2 MB
0508 TBILLPRICE Calculating the price for a Treasury bill.mov	2.0 MB
/06 Calculating Prices and Yields of Securities with Odd Periods/
0601 ODDFPRICE Calculating the price of a security with an odd first period.mov	4.4 MB
0602 ODDFYIELD Calculating the yield of a security with an odd first period.mov	4.1 MB
0604 ODDLYIELD Calculating the yield of a security with an odd last period .mov	3.9 MB
0603 ODDLPRICE Calculating the price of a security with an odd last period.mov	3.7 MB
/07 Conclusion/
0701 Additional resources.mov	1.4 MB
/Exercise Files/
Ex_Files_Ex10_Fin_ID.zip	317.9 KB
/
quasar.nfo	3.2 KB
Total files 54