Financial Modeling and Forecasting Financial Statements

Learn how to build a super-charged Excel spreadsheet to help you and your team easily track any kind of data-sales transactions, inventory levels, project statuses, employee paid time off, student progress, household spending, and more.


Financial reports are not just summaries of the past—they also include predictions for the future. In fact, most financial institutions are more interested in future performance than historical trends. Banks want to know your future cash flow; investors want to know future profits. In this course, Jim and Kay Stice explains how to create forecasted financial statements for your company. Learn how to use past data such as cost of goods sold, depreciation expenses, and levels of inventory, and understand what caused those numbers to fluctuate over time. Then you can learn how to use the information as the basis for forecasting, applying a simple but powerful equation: assets = liability + equity. You get hands-on practice building three different documents: a forecasted income statement, a forecasted balance sheet, and a forecasted statement of cash flow. Throughout the course, Jim and Kay use famous business cases—like Home Depot’s 1985 cash-flow crisis—to illustrate the importance of accurate financial forecasts and their impact on business decisions.

Name Financial Modeling and Forecasting Financial Statements
Language English
Duration 1:54 hours
Sector IT-ITES
Price (INR) FREE
Availablity Available full time
Certification Availability from Knowledge Partner Available
Certification Availability from eSkillIndia Not Available
Pre-Qualification Any

Course Rating

Average Rating:5.0

*   The QP alignment of the course is provided by the Knowledge Partner and the course may not cover the QP in entirety.