Lynda – Excel 2013: Financial Functions in Depth-0daytown

Lynda – Excel 2013: Financial Functions in Depth

Analyzing financial data can seem intimidating, but Excel 2013 has a wide range of functions that you can use to perform these analyses quickly and easily. This course shows users how and when to use each of the functions available to them in Excel 2013. Learn how to evaluate cash flows; calculate depreciation; determine rates of return, bond coupon dates, and security durations; and more.

Topics include:

* Analyzing loans, payments, and interest
* Calculating depreciation
* Determining values and rates of return
* Calculating bond coupon dates and security durations
* Calculating security prices and yields
* Calculating prices and yields of securities with odd periods
* Analyzing simulation results