Financial Forecasting, Modeling, and Risk Management Course

***Exercise and demo files included***

Forecasting the financial performance and managing the financial risk of a business is crucial for its success. Learn how to create a financial forecasting model using a widely familiar application, Microsoft Excel, and the fundamentals of financial risk management (FRM) with this two-course bundle!

Improve your business decision-making as we build a financial model and forecast based on a fictional company in the first course. Coming into the course, you will need to have a basic understanding of Excel.

In the second course, we will cover the fundamentals of financial risk management, with a focus on practical implementation and application. Particularly, we shall focus on credit risk, interest rate, foreign exchange risk, and operational risk. Please note that this course does not serve as a preparation for the FRM exams.

The courses include instructor files and exercise files so you can practice what you've learned and gain confidence as you go. Students are expected to have a basic knowledge of finance and accounting principles.

What's included?

Financial Forecasting:

• Come to understand the basics of financial modeling and forecasting using Excel

• Know the purpose of financial forecasting

• Build your first financial forecasting model in Excel

• Learn how to build a sound financial model

• Know the role of forecasting in strategic planning

• Go through the three financial statements (balance sheet, income statement, and cash flow statement)

• Learn how to define your forecasting objectives

• Identify key variables and drivers

• Analyze financial forecasts using ratio analysis

• Learn about future trends in forecasting.

Financial Risk Management:

• Distinguish between risk, uncertainty, and randomness

• Distinguish between risk management and risk measurement

• Understand the importance of risk governance

• Describe risk budgeting and understand its role in risk governance

• Realize the importance of managing people, processes, technology, and organizational structure for effective risk management

• Recognize the difference between idiosyncratic and systematic risks

• Define, classify, and distinguish between financial risks

• Identify and understand the principles of credit, foreign exchange, interest rate, and operational risk

• Recognize probability, standard deviation, Value-at-Risk (VaR), and scenario analysis/stress testing as risk measurement metrics

• Distinguish between risk prevention and avoidance

• Define and apply the concepts of self-insurance, risk shifting, and risk transfer

• Realize insurance as a way to transfer risks

• Recognize outsourcing and derivatives as two ways of shifting risk.

This course bundle includes:

1. 10+ hours of video tutorials

2. 70+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion