Faculty Publications - College of Business

Document Type

Article

Publication Date

2014

Abstract

Data Table, Charts, Scenario Manager, Goal Seek, and Solver are powerful Excel tools in solving financial problems. Incorporating these tools into finance teaching can help students understand finance concepts intuitively, and bridge the gap between financial theories and real-world applications. The learning goals defined for an Excel-integrated finance course have all been achieved. Students who took this course are more confident on their Excel skills and financial knowledge. This paper demonstrates how to effectively use Excel tools to teach key finance concepts, such as financial statement analysis, time value of money, stock and bond valuation, capital budgeting, portfolio theory, and financial derivatives. To prepare business students with Excel skills needed in the job market, business schools should promote to integrate Excel into other business core and major courses when appropriate.

Comments

Originally published in The Journal of Financial Education, 2014.

http://www.jfedweb.org/

Download

Included in

Business Commons

Share

COinS