中文名: Lynda.com出品Excel 2010深入學習財務功能視頻教程
英文名: Lynda.com Excel 2010 Financial Functions in Depth
資源格式: 光盤鏡像
學校: Lynda.com
主講人: Curt Frye
發行日期: 2011年
對白語言: 英語
文字語言: 英文
簡介:

語言：英語
網址：http://www.lynda.com/Excel-2010- ... -Depth/83199-2.html
類別：教程
（xuehui@TLF）
Lynda.com 出品的時長2小時20分的Excel 2010: 深入學習財務功能視頻教程。由Curt Frye講述如何有效的使用Excel 2010中的許多財務功能來創建並快速進行大量的財務函數計算。教學詳細的講解了現金流量評估、折舊計算、確定收益率、債券息票日期和保證期限等等幾十個功能。本教程附帶練習文件。
Course name:
Excel 2010: Financial Functions in Depth
Author:
Curt Frye
Duration:
02h 20m
Released on:
6/28/2011
In Excel 2010: Financial Functions in Depth author Curt Frye shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010. The course details dozens of functions for evaluating cash flows; calculating depreciation; determining rates of return, bond coupon dates, and security durations; and more. Exercise files accompany the course.
Topics include:
Analyzing loans, payments, and interest
Discovering the interest rate of an annuity
Determining depreciation using the straight line, declining balance, double-declining balance, and other methods
Calculating the future value of an investment with variable returns
Finding the discount rate of a security
Converting between fractional prices and decimal prices
Determining the yield of securities that pay interest periodically
目錄:
Introduction
Welcome 01m 06s
Using the exercise files 00m 36s
Disclaimer 00m 29s
28m 32s
1. Analyzing Loans, Payments, and Interest PMT: Calculating a loan payment 03m 31s
PPMT and IPMT: Calculating principal and interest per loan payment 04m 18s
CUMPRINC and CUMIPMT: Calculating cumulative principal and interest paid between periods 04m 30s
ISPMT: Calculating interest paid during a specific period 02m 13s
EFFECT and NOMINAL: Finding nominal and effective interest rates 03m 31s
ACCRINT and ACCRINTM: Calculating accrued interest for investments 04m 15s
RATE: Discovering the interest rate of an annuity 02m 41s
NPER: Calculating the number of periods in an investment 03m 33s
19m 05s
2. Calculating Depreciation SLN: Calculating depreciation using the straight-line method 01m 48s
DB: Calculating depreciation using the declining balance method 03m 10s
DDB: Calculating depreciation using the double-declining balance method 03m 20s
SYD: Calculating depreciation for a specified period 02m 13s
VDB: Calculating declining balance depreciation for a partial period 03m 24s
AMORDEGRC: Calculating depreciation using a depreciation coefficient 02m 27s
AMORLINC: Calculating depreciation for each accounting period 02m 43s
24m 11s
3. Determining Values and Rates of Return FV: Calculating the future value of an investment 02m 48s
FVSCHEDULE: Calculating the future value of an investment with variable returns 02m 21s
PV: Calculating the present value of an investment 03m 44s
NPV: Calculating the net present value of an investment 03m 17s
XNPV: Calculating net present value given irregular inputs 02m 33s
IRR: Calculating internal rate of return 02m 32s
XIRR: Calculating internal rate of return for irregular cash flows 01m 48s
MIRR: Calculating internal rate of return for mixed cash flows 02m 02s
DISC: Calculating the discount rate of a security 03m 06s
24m 12s
4. Calculating Bond Coupon Dates and Security Durations COUPDAYBS: Calculating total days between coupon beginning and settlement 03m 02s
COUPDAYS: Calculating days in the settlement date's coupon period 02m 48s
COUPDAYSNC: Calculating days from the settlement date to the next coupon date 03m 01s
COUPNCD: Calculating the next coupon date after the settlement date 02m 43s
COUPNUM: Calculating the number of coupons between settlement and maturity 02m 55s
COUPPCD: Calculating the date of a coupon due immediately before settlement 03m 04s
DURATION: Calculating the annual duration of a security 03m 20s
MDURATION: Calculating the duration of a security using the modified Macauley method 03m 19s
28m 43s
5. Calculating Security Prices and Yields DOLLARDE and DOLLARFR: Converting between fractional prices and decimal prices 02m 36s
INTRATE: Calculating the interest rate of a fully invested security 02m 50s
RECEIVED: Calculating the value at maturity of a fully invested security 02m 46s
PRICE: Calculating the price of a security that pays periodic interest 03m 19s
PRICEDISC: Calculating the price of a discounted security 02m 48s
PRICEMAT: Calculating the price of a security that pays interest at maturity 01m 57s
TBILLEQ: Calculating the bond-equivalent yield for a Treasury bill 01m 50s
TBILLPRICE: Calculating the price for a Treasury bill 01m 31s
TBILLYIELD: Calculating the yield of a Treasury bill 01m 41s
YIELD: Calculating the yield of a security that pays periodic interest 02m 59s
YIELDDISC: Calculating the annual yield for a discounted security 02m 09s
YIELDMAT: Calculating the annual yield of a security that pays interest at maturity 02m 17s
12m 01s
6. Calculating Prices and Yields of Securities with Odd Periods ODDFPRICE: Calculating the price of a security with an odd first period 03m 17s
ODDFYIELD: Calculating the yield of a security with an odd first period 03m 03s
ODDLPRICE: Calculating the price of a security with an odd last period 02m 44s
ODDLYIELD: Calculating the yield of a security with an odd last period 02m 57s
01m 05s
Conclusion Additional resources 01m 05s
代碼

.– ░░░ –■. ▀ ▓▄■ ■ ▄░ ■▄░ ▀▄ zk ■
▄▓█████▓▄ ▀▄ – ▄▓ ▄███▄░ ▄▄▄▄████ ░▄███▄ ▀▓█▄▄▄▄▄▄░ –
████▀▀▀███▄ ██▄ ▄██ █████████▄ ▒█████▀▀██ ▄█████████▄ ██████████▄
▒███ ▓██░███ ███ ▓██▀ ▀██▓ ▓██▓ ▓██░███▀ ▓███ ███ ▀██▓
▓███ ▓██▓███░ ███░███░ ▓██░███░ ▄██▀ ██▓ ░███░███ ▓█▓
▓███ ▓██████░ ███████ ▀██████ ▀ ██▀ ███▓███░ ▄▓█▓
▓██▓ ███████░ ████████████████████████████████████████████████▀▀
▒██▓ ░▄ ███▓███░ ███░██▀▀▀▀▀▀▀██▓▀▀▀▀▀▀▀▀███▓██▀▀▀▀▀▀▀██▀███▀▀▀▀███▄
███▄ ▓█▄███░███░ ███░███░ ▓██░ ▄▄▄■ ███░██▓░ ░███ ▓██ ███░
▀█████████░ ███▓░ ▄███ ██▀ ▀██ ███ ░██▓ ██▀ ▓██ ▓██ ▓██▓
▀▀▓▓░███▄ ▀█████████▀ █▀ ▀█ ████▄▄▄███▒▄▀ ▀█▓███ ░███
▀██▄ ▀▀▓▓░▀▀ ▀ ▀ ▀▀█████▀▀ .░ ▓██
▀ .– ▄█▀
▀ ▀
QUASAR PROUDLY PRESENTS
– ───────────────────────────────────────────────────────────────────────── –
Excel 2010 Financial Functions in Depth
(c) Lynda.com
Supplier . : QUASAR Size ..... : 10 x 15MB
Cracker .. : QUASAR Protection : Condom
Packager . : QUASAR Type ..... : Brain Enhancement
Date ..... : 07-10-2011 OS ....... : Win/Mac
– ───────────────────────────────────────────────────────────────────────── –
♀Excel 2010 Financial Functions in Depth
♀Author: Curt Frye
♀In Excel 2010: Financial Functions in Depth author Curt Frye
♀shows how to perform a wide range of financial calculations
♀quickly and easily using the many financial functions found
♀in Excel 2010. The course details dozens of functions for
♀evaluating cash flows; calculating depreciation; determining
♀rates of return, bond coupon dates, and security durations;
♀and more. Exercise files accompany the course.
♀Topics include:
♀* Analyzing loans, payments, and interest
♀* Discovering the interest rate of an annuity
♀* Determining depreciation using the straight
♀ line, declining balance, double-declining
♀ balance, and other methods
♀* Calculating the future value of an investment
♀ with variable returns
♀* Finding the discount rate of a security
♀* Converting between fractional prices and
♀ decimal prices
♀* Determining the yield of securities that pay
♀ interest periodically
– ───────────────────────────────────────────────────────────────────────── –
INSTALLATION
────────────
Unpack, burn or mount and enjoy.
– ───────────────────────────────────────────────────────────────────────── –
GREETINGS
─────────
We salute our friends, our loyal members and our fair competitors.
– ───────────────────────────────────────────────────────────────────────── –
░▓██████████████▓░ ––– THE ALMIGHTY QUASAR – 2011 ––– ░▓██████████████▓░
– ───────────────────────────────────────────────────────────────────────── –

下載鏈接來自TLF
未經過安裝測試與安全檢測，使用者後果自負與本論壇無關
軟體版權歸原作者及其公司所有，如果你喜歡，請購買正版