Cargando…
Hands-On Financial Modeling with Microsoft Excel 2019 : Build Practical Models for Forecasting, Valuation, Trading, and Growth Analysis Using 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 emphasiz...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing, Limited,
2019.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_on1109765572 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 190727s2019 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d UKMGB |d OCLCO |d OCLCQ |d EBLCP |d OCLCF |d UKAHL |d OCLCQ |d UAB |d CSJ |d OCL |d OCLCO |d K6U |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBB9C8172 |2 bnb | ||
| 016 | 7 | |a 019478455 |2 Uk | |
| 020 | |a 9781789531633 | ||
| 020 | |a 1789531632 | ||
| 020 | |z 9781789534627 |q (pbk.) | ||
| 029 | 1 | |a UKMGB |b 019478455 | |
| 029 | 1 | |a AU@ |b 000067106492 | |
| 035 | |a (OCoLC)1109765572 | ||
| 037 | |a 9781789531633 |b Packt Publishing | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 658.150285554 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Oluwa, Shmuel. | |
| 245 | 1 | 0 | |a Hands-On Financial Modeling with Microsoft Excel 2019 : |b Build Practical Models for Forecasting, Valuation, Trading, and Growth Analysis Using Excel 2019. |
| 260 | |a Birmingham : |b Packt Publishing, Limited, |c 2019. | ||
| 300 | |a 1 online resource (280 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Title Page; Copyright and Credits; Dedication; About Packt; Contributors; Table of Contents; Preface; Section 1: Financial Modeling -- Overview; Chapter 1: Introduction to Financial Modeling and Excel; The main ingredients of a financial model; Investment; Financing; Dividends; Understanding mathematical models; Definitions of financial models; Types of financial models; The 3 statement model; The discounted cash flow model; The comparative companies model; The merger and acquisition model; The leveraged buyout model; Loan repayment schedule; The budget model | |
| 505 | 8 | |a Alternative tools for financial modelingAdvantages of Excel; Excel -- the ideal tool; Summary; Chapter 2: Steps for Building a Financial Model; Discussions with management; Gauging management expectations; Knowing your client's business; Department heads; Building assumptions; Building a template for your model; Historical financial data; Projecting the balance sheet and profit and loss account; Additional schedules and projections; Cash flow statement; Preparing ratio analysis; Valuation; Summary; Section 2: The Use of Excel -- Features and Functions for Financial Modeling | |
| 505 | 8 | |a Chapter 3: Formulas and Functions -- Completing Modeling Tasks with a Single FormulaUnderstanding functions and formulas; Working with lookup functions; The VLOOKUP function; The INDEX function; The MATCH function; The CHOOSE function; Implementing the CHOOSE function; Utility functions; The IF function; The MAX and MIN functions; Implementing the functions; Pivot tables and charts; Implementing pivot tables; Pitfalls to avoid; Protect sheets; Summary; Chapter 4: Applying the Referencing Framework in Excel; Introduction to the framework; Relative referencing; Absolute referencing | |
| 505 | 8 | |a Mixed referencingImplementing the referencing framework; Summary; Section 3: Building an Integrated Financial Model; Chapter 5: Understanding Project and Building Assumptions; Understanding the nature and purpose of a project; Conducting interviews; Historical data; Building assumptions; General assumptions; Profit and loss and balance sheet assumptions; Profit and loss account growth drivers; Year-on-year growth; Compound annual growth rate; Balance sheet growth drivers; Days of inventory; Debtor days; Creditor days; Summary; Chapter 6: Asset and Debt Schedules | |
| 505 | 8 | |a Understanding the BASE and corkscrew conceptsAsset schedule; The straight line method; The reducing balance method; Approaches to modeling assets; The detailed approach; Asset and depreciation schedule; The simple approach; Debt schedule; The complex approach; The simple approach; Creating a loan amortization schedule; Creating the template; Creating the formulas; Using the schedule; Summary; Chapter 7: Cash Flow Statement; Introduction to the cash flow statement; Items not involving the movement of cash; Net change in working capital; Cash flow from investment activities | |
| 500 | |a Cash flow from financing activities | ||
| 520 | |a 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. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Corporations |x Finance |x Mathematical models. | |
| 650 | 0 | |a Corporations |x Finance |x Data processing. | |
| 650 | 7 | |a Corporations |x Finance |x Data processing |2 fast | |
| 650 | 7 | |a Corporations |x Finance |x Mathematical models |2 fast | |
| 758 | |i has work: |a Hands-On financial Modeling with Microsoft Excel 2019 (Work) |1 https://id.oclc.org/worldcat/entity/E39PCYrgg3p3DxqgYFbcmMJmRq |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Oluwa, Shmuel. |t Hands-On Financial Modeling with Microsoft Excel 2019 : Build Practical Models for Forecasting, Valuation, Trading, and Growth Analysis Using Excel 2019. |d Birmingham : Packt Publishing, Limited, ©2019 |z 9781789534627 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=5825933 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n BDZ0040249603 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5825933 | ||
| 994 | |a 92 |b IZTAP | ||