SEF-FIN8000 - Financial Analysis: Forecasting and Modeling with Excel

Course Description

Delving deep into financial analysis helps businesses understand current and past performance, predict future performance and make smarter overall decisions. This course helps you master the fundamentals of finance using Excel using common built-in functions, charts and other useful tools. Increase your financial skills by creating and understanding financial statements, performance evaluations, forecasting, valuation, capital budgeting and modern portfolio theory. An educational background in finance or accounting, plus intermediate Excel knowledge, is highly recommended.

Course Outline

1. Introduction to Excel 2019

2. The Basic Financial Statements

3. The Cash Budget

4. Financial Statement Analysis Tools

5. Financial Forecasting

6. Break-Even and Leverage Analysis

7. The Time Value of Money

8. Common Stock Valuation

9. Bond Valuation

10. The Cost of Capital

11. Capital Budgeting

12. Risk and Capital budgeting

13. Portfolio Statistics and Diversification

14. Writing User-Defined Functions with VBA

15. Analyzing Datasets with Tables and Pivot Tables

Learner Outcomes

Objectives -

Upon completion of this course students will be able to:

Demonstrate advanced spreadsheet techniques and tools in a financial context
Be proficient in using complex Excel formulas instead of a calculator to master corporate finance concepts and practices
Perform complex case scenario analysis and build financial models

Notes

Method of Instruction - Classroom lecture and computer labs.

Evaluation - Case scenario projects

Textbook Required