Hands-On Financial Modeling with Microsoft Excel 2019
This book aims to provide a gateway to financial modeling through easy to follow examples in Excel 2019. It will explore the process of modeling starting from a thorough understanding of the project to gathering historical information and arriving at assumptions. Good modeling practices are emphasized and demonstrated throughout the book.
Offered by
Difficulty Level
Intermediate
Completion Time
9h44m
Language
English
About Book
Who Is This Book For?
This book is for data professionals, analysts, traders, business owners, and students, who want to implement and develop a high in-demand skill of financial modeling in their finance, analysis, trading, and valuation work. This book will also help individuals that have and don't have any experience in data and stats, to get started with building financial models. The book assumes working knowledge with Excel.
Hands-On Financial Modeling with Microsoft Excel 2019
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 9h44m total length
Introduction to Financial Modeling and Excel
Steps for Building a Financial Model
Formulas and Functions - Completing Modeling Tasks with a Single Formula
Applying the Referencing Framework In Excel
Understanding Project and Building Assumptions
Asset and Debt Schedules
Cash Flow Statement
Ratio Analysis
Valuation
Model Testing for Reasonableness and Accuracy
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!