Financial Modeling in Corporate Financial Analysis Using Excel
In this lab-based course, gain expertise in the quantitative methods used by securities analysts to evaluate and to value publicly traded securities. After a brief review of present value, accounting, and statistics, learn how to make investment decisions based upon present value and other quantitative techniques. Use Excel formats and layouts to create discounted cash flow and relative valuation models. Receive instruction against the backdrop of current market trends; financial news; and other factors that affect stock valuation, specifically, the interaction of quantitative models with changes in security or market attributes.
You'll Walk Away with
- Expertise in the quantitative methods used by securities analysts to evaluate and value publicly traded securities
- The ability to use Excel formats and layouts to create discounted cash flow and relative valuation models
- Students with knowledge of Excel and a general knowledge of finance and accounting
- Finance professionals who wish to improve their Excel abilities