Included Exercise Files
Skill Level : Intermediate
Released : 10/9/2016
Duration : 2h 38m
Language : English
Size : 248,08 Mb
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
