v

您的位置:VeryCD教育计算机


《Lynda.com出品Excel 2010深入学习财务功能视频教程》(Lynda.com Excel 2010 Financial Functions in Depth)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    主讲人Curt Frye
    发行日期2011年
    对白语言英语
    文字语言英文
  • 时间: 2011/07/12 23:55:29 发布 | 2011/07/13 00:21:09 更新
  • 分类: 教育  计算机 

MTina

精华资源: 3862

全部资源: 3863

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Lynda.com出品Excel 2010深入学习财务功能视频教程
英文名Lynda.com Excel 2010 Financial Functions in Depth
资源格式光盘镜像
学校Lynda.com
主讲人Curt Frye
发行日期2011年
对白语言英语
文字语言英文
简介

IPB Image


语言:英语
网址: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
未经过安装测试与安全检测,使用者后果自负与本论坛无关
软体版权归原作者及其公司所有,如果你喜欢,请购买正版

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有28网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。