In this course, 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.
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
Learn more about lynda.com
Ready to join?
get started
Members who watched this also viewed
show more
Exercise files
The advantage of exercise files.
Exercise files are the identical files (documents, photos, and so on) the author uses throughout this course. The files will help you make the most of your learning experience because you open them in your own software and follow along with tutorials. Exercise files are available to Premium members only. Learn more.
