Oluwa Hands-On Financial Modeling with Excel for Microsoft 365

Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis
2. Auflage 2022
ISBN: 978-1-80324-893-6
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, 346 Seiten

No detailed description available for "Hands-On Financial Modeling with Excel for Microsoft 365".

Autoren/Hrsg.

Oluwa, Shmuel

Fachgebiete

• Sozialwissenschaften Pädagogik Lehrerausbildung, Unterricht & Didaktik E-Learning, Bildungstechnologie
• Mathematik | Informatik EDV | Informatik EDV & Informatik Allgemein E-Learning
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Automatische Datenerfassung, Datenanalyse

Inhaltsverzeichnis

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

Über Autor(innen)

Oluwa Shmuel:
Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.