FIN 416Intermediate Financial Modeling

3 credits · Finance · Penn State

The topics covered in this course build on the foundations of corporate finance presented in FIN 301 , Corporate Finance. Specifically, the course focuses primarily on the development of spreadsheet applications and the use of the case method to apply decisionmaking procedures to real-world problems in finance areas. The primary objective of this course is to "marry" corporate finance theory with practice. Students should develop the ability to use finance concepts to solve practical finance problems. Throughout the course, students will be exposed to spreadsheets (e.g., Microsoft Excel) to develop models used in the financial decision-making process. The course will enable students to build a firm foundation in the principles of financial management and an understanding of how to apply concepts in financial management for the valuation process. Students will work as a group for a semester-long project, which will expose students to critical topics such as financial ratio analysis, financial forecasting, regression analysis, portfolio management, asset valuation, capital budgeting decisions via spreadsheets. Students will access market data through the internet and proprietary providers such as Bloomberg and Y-Charts.