Building a Financial Model

The Evaluation of Mining Real Estate

Building a Financial Model

Login to your SavvyInvestor account

This four part series guides you though how to apply a structured approach to financial modeling in Excel. It covers the many hallmarks that make financial models robust; demonstrates best practice techniques in planning model structure; and explains how to forecast the income statement from operating revenues down to operating profit.

Building a Financial Model

In the beginning of this four part series, you will learn the key components required to create robust financial models. Moving forward, you will improve your financial modeling skills by learning how to plan your structure, use data validation and formatting, and test for errors. This course will also explain the importance of planning your model structure and show you how to forecast income statements. Desktop widgets are available as part of the course to provide you with additional video assistance.

Building a Financial Model

In this segment of the four part series, you will learn how to use different approaches to forecast plant, equipment and property and other operating assets. In addition to that, we will demonstrate how to forecast various components of working capital, including accounts receivable, inventories, and accounts payable. Key ratios are introduced to help you build the financial forecast model. Desktop widgets are available as part of the course to provide you with additional video assistance.

Building a Financial Model

In this third segment, we will show you how to forecast debt financial and related interest costs, as well as equity financing and dividends. You will also learn how to use iterative and analytic approaches to manage circular references. Desktop widgets are available as part of the course to provide you with additional video assistance.

Building a Financial Model

In this final segment, we will illustrate how important it is to incorporate error checks in your financial models by showing you how to use different tools provided in Excel. You will also learn how to derive a forecast cash flow statement based on a forecast income statement and balance sheet. And finally, we will show you how to derive a free cash flow statement that can be used for equity valuation. Desktop widgets are available as part of the course to provide you with additional video assistance.

Accounting Fundamentals

Reading Financial Statements

Financial Analysis

Financial Math

Fundamentals of Financial Modeling

Building a Financial Model

Financial Modeling Using VBA

Business Valuation Fundamentals

Behavioural Finance

Capital Markets Fundamentals