Overview

***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 ExcelKnow the purpose of financial forecastingBuild your first financial forecasting model in ExcelLearn how to build a sound financial modelKnow the role of forecasting in strategic planningGo through the three financial statements (balance sheet, income statement, and cash flow statement)Learn how to define your forecasting objectivesIdentify key variables and driversAnalyze financial forecasts using ratio analysisLearn about future trends in forecasting.Financial Risk Management:Distinguish between risk, uncertainty, and randomnessDistinguish between risk management and risk measurementUnderstand the importance of risk governanceDescribe risk budgeting and understand its role in risk governanceRealize the importance of managing people, processes, technology, and organizational structure for effective risk managementRecognize the difference between idiosyncratic and systematic risksDefine, classify, and distinguish between financial risksIdentify and understand the principles of credit, foreign exchange, interest rate, and operational riskRecognize probability, standard deviation, Value-at-Risk (VaR), and scenario analysis/stress testing as risk measurement metricsDistinguish between risk prevention and avoidanceDefine and apply the concepts of self-insurance, risk shifting, and risk transferRealize insurance as a way to transfer risksRecognize outsourcing and derivatives as two ways of shifting risk.This course bundle includes:10+ hours of video tutorials70+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Skills

Reviews