Overview

***Exercise and demo files included***Forecasting the financial performance of a business is crucial for its success. Both established companies and entrepreneurs use financial forecasting to determine how to allocate their resources to address expected expenditures in the coming years. It is essential to use tools that can generate a clear and reliable forecast for the business.Financial modeling and forecasting can improve your business decision-making, and the best way to create a financial model is using a widely familiar application such as Microsoft Excel.This course will discuss a fictional company, for which we will build our financial model and forecast. Coming into the course, you will need to have a basic understanding of Excel. General familiarity with accounting principles will also be beneficial.You'll enjoy 5 hours of video tutorials divided into 38 bite-sized video lessons. The course includes instructor files and exercise files so you can practice what you've learned and gain confidence as you go.In this course, you will: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.This course includes:5+ hours of video tutorials38 individual video lecturesCourse and exercise files to follow alongCertificate of completionHere's what our students are saying.★★★★★ "This tutor displayed a great control and knowledge of the subject. Excellent delivery mode and clear explanations of concepts." -Kehinde Balogun★★★★★ "The value of financial forecasting in strategic planning is well presented. I feel empowered to participate in the strategic planning process at my Bank. In addition, as a credit analyst, I have gained insight into the thought process of loan customers who present financial projections as a loan requirement." -John Paul Onyango★★★★★ "Opened my mind to a different understanding on forecasting" -Wanjun Su

Skills

Reviews