The author shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in excel 2010. The course has many functions for evaluating cash flows, calculating depreciation, determining rates of return, bond coupon dates, and security durations. There are exercise files with 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

Author:

He is the president of Technology and Society, Incorporated.

He is the author of more than 40 books. Microsoft excel step by step For Microsoft Press, I have created and recorded more than 60 courses. He has presented talks on topics such as Rhetorical Mathematics for Continuing Education credit at the Law and Magic conference, Business Storytelling Using Microsoft excel at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of the He performs in over 1,300 comedy shows with ComedySportz Portland and presents his Magic of the Mind show to corporate and theatrical audiences. He received his masters degree in political science from Syracuse University and his bachelor’s degree in political science from the University of Illinois.