Financial Modeling | Food & Beverages Sector : Starbucks

Learn projections, financial statements analysis, DCF valuations modeling of Starbucks

What you'll learn

Build P&L statements from a raw data extraction

Forecasting Financial Statement

Learn many important Finance functions in Microsoft Excel

Knowledge of all the essential Excel formulas required for Financial Analysis

Build valuation models from scratch

Requirements

Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365

Description

If you want to learn to create a financial model in Excel, check out this guide. It’ll walk you through creating a fully integrated financial model using Starbuck as an example for the historical years. Let us look at how one can build a financial model from scratch. This financial modeling course will provide a step-by-step guide to creating a financial model. The primary approach taken in this financial modeling guide is Modular. The modular system essentially means building core statements like income statements, balance sheets, and cash flows using different modules/sheets. When creating a financial model in Excel, paying close attention to details is essential. You must also know your way around Excel functions and tools. You cannot just build a financial model once and be over with it. As a result, you must keep tweaking and updating your financial model to ensure accuracy and reliability. The key focus is to prepare each statement step by step and connect all the supporting programs to the core statements on completion. We understand that this may not be clear now. However, you will realize this is very easy as we move forward. To help you get started, we have developed a free financial model of Starbuck that you can download. There has been a lot written about learning financial modeling. However, most of the financial modeling pieces of training are the same. It goes beyond the usual gibberish and explores practical financial modeling used by Investment Bankers and Research Analysts. Financial models are usually built by finance professionals specializing in different areas of finance, like investment banking, equity research, credit research, risk analysis, and portfolio management. 

Overview

Section 1: Introduction

Lecture 1 Introduction to Course

Section 2: Getting Started

Lecture 2 Populating Historicals

Lecture 3 Horizontal Analysis

Lecture 4 Vertical Analysis

Lecture 5 Ratio Analysis

Section 3: Projections

Lecture 6 Revenue Drivers

Lecture 7 Revenue Drivers Continued

Lecture 8 Cost Drivers

Lecture 9 Working Capital

Lecture 10 Depreciation Forecast

Lecture 11 Depreciation Forecast Continued

Lecture 12 Income Statement

Lecture 13 Shareholders Equity Schedule

Section 4: Cash Flow Statement

Lecture 14 Cash Flow Statement Part 1

Lecture 15 Cash Flow Statement Part 2

Lecture 16 Cash Flow Statement Part 3

Lecture 17 Balance sheet

Lecture 18 Balance sheet Continued

Lecture 19 Completing Missing Links

Section 5: DCF Valuation

Lecture 20 DCF Valuation Part 1

Lecture 21 DCF Valuation Part 2

Lecture 22 DCF Valuation Part 3

Financial Analysts/ Managers who want to expand on the current set of skills,Graduates/Post Graduates/CA/CFA,Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills