Hands-On Financial Modeling with Excel for Microsoft 365 - Shmuel Oluwa

Hands-On Financial Modeling with Excel for Microsoft 365 (eBook)

Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis

(Autor)

eBook Download: EPUB
2022
346 Seiten
Packt Publishing (Verlag)
978-1-80324-893-6 (ISBN)
Systemvoraussetzungen
27,59 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen

Financial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Excel for Microsoft 365 explores financial modeling terminologies with the help of Excel.
Starting with the key concepts of Excel, such as formulas and functions, this updated second edition will help you to learn all about referencing frameworks and other advanced components for building financial models. As you proceed, you'll explore the advantages of Power Query, learn how to prepare a 3-statement model, inspect your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. Next, you'll learn how to deal with iterations and provide graphical representations of ratios, before covering best practices for effective model testing. Later, you'll discover how to build a model to extract a statement of comprehensive income and financial position, and understand capital budgeting with the help of end-to-end case studies.
By the end of this financial modeling Excel book, you'll have examined data from various use cases and have developed the skills you need to build financial models to extract the information required to make informed business decisions.


Explore a variety of Excel features, functions, and productivity tips for various aspects of financial modelingKey FeaturesExplore Excel's financial functions and pivot tables with this updated second editionBuild an integrated financial model with Excel for Microsoft 365 from scratchPerform financial analysis with the help of real-world use casesBook DescriptionFinancial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Excel for Microsoft 365 explores financial modeling terminologies with the help of Excel. Starting with the key concepts of Excel, such as formulas and functions, this updated second edition will help you to learn all about referencing frameworks and other advanced components for building financial models. As you proceed, you'll explore the advantages of Power Query, learn how to prepare a 3-statement model, inspect your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. Next, you'll learn how to deal with iterations and provide graphical representations of ratios, before covering best practices for effective model testing. Later, you'll discover how to build a model to extract a statement of comprehensive income and financial position, and understand capital budgeting with the help of end-to-end case studies. By the end of this financial modeling Excel book, you'll have examined data from various use cases and have developed the skills you need to build financial models to extract the information required to make informed business decisions.What you will learnIdentify the growth drivers derived from processing historical data in ExcelUse discounted cash flow (DCF) for efficient investment analysisPrepare detailed asset and debt schedule models in ExcelCalculate profitability ratios using various profit parametersObtain and transform data using Power QueryDive into capital budgeting techniquesApply a Monte Carlo simulation to derive key assumptions for your financial modelBuild a financial model by projecting balance sheets and profit and lossWho this book is forThis book is for data professionals, analysts, traders, business owners, and students who want to develop and implement in-demand financial modeling skills in their finance, analysis, trading, and valuation work. Even if you don't have any experience in data and statistics, this book will help you get started with building financial models. Working knowledge of Excel is a prerequisite.]]>
Erscheint lt. Verlag 17.6.2022
Sprache englisch
Themenwelt Informatik Office Programme Excel
Informatik Office Programme Outlook
Mathematik / Informatik Informatik Theorie / Studium
Recht / Steuern Wirtschaftsrecht
Wirtschaft Betriebswirtschaft / Management
ISBN-10 1-80324-893-9 / 1803248939
ISBN-13 978-1-80324-893-6 / 9781803248936
Haben Sie eine Frage zum Produkt?
EPUBEPUB (Ohne DRM)

Digital Rights Management: ohne DRM
Dieses eBook enthält kein DRM oder Kopier­schutz. Eine Weiter­gabe an Dritte ist jedoch rechtlich nicht zulässig, weil Sie beim Kauf nur die Rechte an der persön­lichen Nutzung erwerben.

Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belle­tristik und Sach­büchern. Der Fließ­text wird dynamisch an die Display- und Schrift­größe ange­passt. Auch für mobile Lese­geräte ist EPUB daher gut geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür die kostenlose Software Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür eine kostenlose App.
Geräteliste und zusätzliche Hinweise

Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.

Mehr entdecken
aus dem Bereich