Of course you are – it’s the nature of the job. But if you make some time for this program, you’ll save a lot of time at your job. Don’t work harder, work smarter! This program will empower you with an array of tools, time-saving techniques, and professional enrichment that will make you more efficient in performing your job. It’s taught by Rutgers Business School faculty who have practical experience in using these tools in the financial services industry. This program is taught in four 3-hour modules. Prior knowledge of basic financial tools is recommended.
This program has been approved by the New Jersey Department of Labor for workforce training grants. Funding may be available for those receiving unemployment benefits. Contact us for more information.
This program is intended for financial analysts or any professional that provides guidance to businesses and individuals making investment decisions. This includes portfolio managers, financial planners, risk managers, securities analysts, and money managers. Participants should have had some experience in assessing the performance of stocks, bonds, and other types of investments.
This program would empower you with an array of tools, time-saving techniques, and professional enrichment that will make you more efficient in performing your job. A pre- and post-questionnaire will be given to participants as a demonstrable way of measuring knowledge gained from the program. Curriculum includes for example creating short-cut formulas, building financial models, and devising game theory applications. See the Curriculum tab for more information. The instructors are renowned authorities with deep Wall Street knowledge and extensive award-winning teaching experience.
Excel is by far the most widely used financial program by analysts, but few are aware of its vast capabilities. This module will begin by discussing “short cut” formulas in Excel that will save analysts time in the presence of repetitive tasks. We will then discuss using powerful Excel functions such as Solver, Goal Seek, and Data Tables to solve problems that often occur in financial analysis. Graphing is often the technique that analysts display the output of their work, so we will analyze a variety of graphs ranging from simple Line Charts to advanced Pivot Tables and Bubble Charts as a means of effectively conveying complex relationships. We will discuss capital budgeting and project analysis as an initial complex example that may be efficiently solved in Excel.
Behavioral Finance has become mainstream over the past decade. This module will focus on using Behavioral Finance to gain greater understanding of the financial markets, as well as using techniques to better explain actions in corporate and governmental finance. Most best-selling books are geared towards a general management audience. This module will examine the findings of several books (e.g., The 7 Habits of Highly Effective People, How to Think Like Leonardo DaVinci, The Psychology of Persuasion, The Tipping Point, etc.) with the aim of tailoring their benefits to financial analysts.
This module will focus on building a financial model in Excel that links the Balance Sheet, Income Statement, and Statement of Cash Flows. Financial models contain both historical data and forecasted (pro-forma data). Valuation is one of the key outputs of a financial model. Accordingly, we will discuss a range of valuation techniques and why they may be appropriate for each industry.
Game theory is the study of strategic decision making, a crucial topic for financial analysts. Analysts are often intrigued with the promise of game theory, but they find the topic too theoretical. This module will focus on the most common game theory models and their applicability to financial markets and corporate finance. The modeling of uncertainty is often conducted through simulations. We will utilize simulations in Excel to enable analysts to effectively model uncertainty across a range of financial applications.
NOTE: Modules may not be delivered in this order