Hands-on financial modeling with Microsoft Excel 365 : build your own practical models for forecasting, valuation, trading, and growth analysis / Shmuel Oluwa
Material type:
TextPublication details: Birmingham: Packt, c2022. Edition: 2nd edDescription: xv, 329 p. : ill. ; 24 cmISBN: 9781803231143Subject(s): Corporations Finance Mathematical models | Corporations Finance Data processing | Microsoft Excel (Computer file)DDC classification: 658.150285554 OLU
| Item type | Current library | Home library | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
English Lending
|
Villa College QI Campus | Villa College Library | 658.150285554 OLU (Browse shelf(Opens below)) | Available | 16604 | ||
|
English Lending
|
Villa College QI Campus | Villa College Library | 658.150285554 OLU (Browse shelf(Opens below)) | Available | 16591 | ||
|
English Lending
|
Villa College QI Campus | Villa College Library | 658.150285554 OLU (Browse shelf(Opens below)) | Available | 16592 |
Browsing Villa College Library shelves Close shelf browser (Hides shelf browser)
Contents Include:
Part 1: Financial modeling overview
1. An Introduction to Financial Modeling and Excel
2.Steps for Building a Financial Model
Part 2: The use of excel features and functions for financial modeling
3.Formulas and Functions - Completing Modeling Tasks with a Single Formula
4.The Referencing Framework in Excel
5. An Introduction to Power Query
Part 3: Building an integrated 3 - Statement Financial Model with valuation by DCF
6. Understanding Project and Building Assumptions
7. Asset and Debt Schedules
8. Preparing a Cash Flow Statement
9. Ratio Analysis
10. Valuation
11. Model Testing for Reasonableness and Accuracy
12. Case Study 1 - Building a Model to Extract a Balance Sheet and Profit and Loss from a Trial Balance
13. Case Study 2 - Creating a Model for Capital Budgeting
Includes Index.
Click on an image to view it in the image viewer
There are no comments on this title.