Hands-on financial modeling with Excel for Microsoft 365
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 updat...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Birmingham, UK
Packt Publishing Ltd.
2022
|
| Edition: | Second edition |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Table of Contents An Introduction to Financial Modeling and Excel Steps for Building a Financial Model Formulas and Functions - Completing Modeling Tasks with a Single Formula The Referencing Framework in Excel An Introduction to Power Query Understanding Project and Building Assumptions Asset and Debt Schedules Preparing a Cash Flow Statement Ratio Analysis Valuation Model Testing for Reasonableness and Accuracy Case Study 1 – Building a Model to Extract a Balance Sheet and Profit and Loss from a Trial Balance Case Study 2 – Creating a Model for Capital Budgeting