Creating Financial Models

Wouldn’t it be great to look into a crystal ball and know what the future holds for your business? There’s no such ability, but financial modeling gives companies the next best thing. Financial modeling uses mathematical data captured in the present to anticipate what the future is likely to bring. Financial modeling is a powerful tool that can help businesses and investors make informed financial decisions. Understanding finance theory and knowing the model development steps can help you create robust financial models that are consistent with the principles of finance.

In Creating Financial Models, you’ll enhance your financial decision-making process by mastering the skills of financial modeling. You will learn how to create, prepare, and evaluate financial models using Microsoft Excel. You will explore how to evaluate the results of your financial model using different methods of analysis and learn how to communicate model results effectively using the pyramid structure.

Learning Objectives

• Understand the principles of financial modeling
• Apply the pyramid structure
• Evaluate financial models using comparison techniques and sensitivity analysis
• Create effective financial models to solve complex business problems
• Use financial models to inform and guide business decisions