【Lynda】Excel 2010: Financial Functions in Depth【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2010: Financial Functions in Depth
作者：Curt Frye
主题：Business, Finance
使用软件：Excel 2010, Office 2010
难度等级：中级
时长： 2h 20m
发布日期： Jun 28, 2011
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2010- Financial Functions in Depth[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
│ └─◇ 0003 Disclaimer.srt
├─◆1. Analyzing Loans, Payments, and Interest
│ └─◇ 0101 PMT- Calculating a loan payment.srt
│ └─◇ 0102 PPMT and IPMT- Calculating principal and interest per loan payment.srt
│ └─◇ 0103 CUMPRINC and CUMIPMT- Calculating cumulative principal and interest paid between periods.srt
│ └─◇ 0104 ISPMT- Calculating interest paid during a specific period.srt
│ └─◇ 0105 EFFECT and NOMINAL- Finding nominal and effective interest rates.srt
│ └─◇ 0106 ACCRINT and ACCRINTM- Calculating accrued interest for investments.srt
│ └─◇ 0107 RATE- Discovering the interest rate of an annuity.srt
│ └─◇ 0108 NPER- Calculating the number of periods in an investment.srt
├─◆2. Calculating Depreciation
│ └─◇ 0201 SLN- Calculating depreciation using the straight-line method.srt
│ └─◇ 0202 DB- Calculating depreciation using the declining balance method.srt
│ └─◇ 0203 DDB- Calculating depreciation using the double-declining balance method.srt
│ └─◇ 0204 SYD- Calculating depreciation for a specified period.srt
│ └─◇ 0205 VDB- Calculating declining balance depreciation for a partial period.srt
│ └─◇ 0206 AMORDEGRC- Calculating depreciation using a depreciation coefficient.srt
│ └─◇ 0207 AMORLINC- Calculating depreciation for each accounting period.srt
├─◆3. Determining Values and Rates of Return
│ └─◇ 0301 FV- Calculating the future value of an investment.srt
│ └─◇ 0302 FVSCHEDULE- Calculating the future value of an investment with variable returns.srt
│ └─◇ 0303 PV- Calculating the present value of an investment.srt
│ └─◇ 0304 NPV- Calculating the net present value of an investment.srt
│ └─◇ 0305 IRR- Calculating internal rate of return.srt
│ └─◇ 0306 XNPV- Calculating net present value given irregular inputs.srt
│ └─◇ 0307 XIRR- Calculating internal rate of return for irregular cash flows.srt
│ └─◇ 0308 MIRR- Calculating internal rate of return for mixed cash flows.srt
│ └─◇ 0309 DISC- Calculating the discount rate of a security.srt
├─◆4. Calculating Bond Coupon Dates and Security Durations
│ └─◇ 0401 COUPDAYBS- Calculating total days between coupon beginning and settlement.srt
│ └─◇ 0402 COUPDAYS- Calculating days in the settlement date’s coupon period.srt
│ └─◇ 0403 COUPDAYSNC- Calculating days from the settlement date to the next coupon date.srt
│ └─◇ 0404 COUPNCD- Calculating the next coupon date after the settlement date.srt
│ └─◇ 0405 COUPNUM- Calculating the number of coupons between settlement and maturity.srt
│ └─◇ 0406 COUPPCD- Calculating the date of a coupon due immediately before settlement.srt
│ └─◇ 0407 DURATION- Calculating the annual duration of a security.srt
│ └─◇ 0408 MDURATION- Calculating the duration of a security using the modified Macauley method.srt
├─◆5. Calculating Security Prices and Yields
│ └─◇ 0501 DOLLARDE and DOLLARFR- Converting between fractional prices and decimal prices.srt
│ └─◇ 0502 INTRATE- Calculating the interest rate of a fully invested security.srt
│ └─◇ 0503 RECEIVED- Calculating the value at maturity of a fully invested security.srt
│ └─◇ 0504 PRICE- Calculating the price of a security that pays periodic interest.srt
│ └─◇ 0505 PRICEDISC- Calculating the price of a discounted security.srt
│ └─◇ 0506 PRICEMAT- Calculating the price of a security that pays interest at maturity.srt
│ └─◇ 0507 TBILLEQ- Calculating the bond-equivalent yield for a Treasury bill.srt
│ └─◇ 0508 TBILLPRICE- Calculating the price for a Treasury bill.srt
│ └─◇ 0509 TBILLYIELD- Calculating the yield of a Treasury bill.srt
│ └─◇ 0510 YIELD- Calculating the yield of a security that pays periodic interest.srt
│ └─◇ 0511 YIELDDISC- Calculating the annual yield for a discounted security.srt
│ └─◇ 0512 YIELDMAT- Calculating the annual yield of a security that pays interest at maturity.srt
├─◆6. Calculating Prices and Yields of Securities with Odd Periods
│ └─◇ 0601 ODDFPRICE- Calculating the price of a security with an odd first period.srt
│ └─◇ 0602 ODDFYIELD- Calculating the yield of a security with an odd first period.srt
│ └─◇ 0603 ODDLPRICE- Calculating the price of a security with an odd last period.srt
│ └─◇ 0604 ODDLYIELD- Calculating the yield of a security with an odd last period.srt
├─◆Conclusion
│ └─◇ Additional resources.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗