All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Hands-On Financial Modeling with Microsoft Excel 2019

You're reading from Hands-On Financial Modeling with Microsoft Excel 2019

Product type Book

Published in Jul 2019

Publisher Packt

ISBN-13 9781789534627

Pages 292 pages

Edition 1st Edition

Languages

Concepts

Financial Technology

Author (1):

Shmuel Oluwa

Table of Contents (15) Chapters

Preface

Section 1: Financial Modeling - Overview

Introduction to Financial Modeling and Excel

Steps for Building a Financial Model

Section 2: The Use of Excel - Features and Functions for Financial Modeling

Formulas and Functions - Completing Modeling Tasks with a Single Formula

Applying the Referencing Framework in Excel

Section 3: Building an Integrated Financial Model

Understanding Project and Building Assumptions

Asset and Debt Schedules

Cash Flow Statement

Valuation

Ratio Analysis

Model Testing for Reasonableness and Accuracy

Another Book You May Enjoy

Leave a review - let other readers know what you think

Leave a review - let other readers know what you think

Please share your thoughts on this book with others by leaving a review on the site that you bought it from. If you purchased the book from Amazon, please leave us an honest review on this book's Amazon page. This is vital so that other potential readers can see and use your unbiased opinion to make purchasing decisions, we can understand what our customers think about our products, and our authors can see your feedback on the title that they have worked with Packt to create. It will only take a few minutes of your time, but is valuable to other potential customers, our authors, and Packt. Thank you!

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime}

Authors (1)

Shmuel Oluwa

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.

Read more

See other products by Shmuel Oluwa

Other recommended products

Related to this chapter

Learn Microsoft Office 2019

Learn Microsoft Office 2019

This step by step guide is a comprehensive journey through the Office 2019 applications which include visual and detailed explanations of concepts and the opportunity to practice throughout using workplace examples. You will grasp the learning tools common for all Office applications

May 2020 26 hours 28 minutes

Building Dashboards with Microsoft Dynamics GP 2016

Building Dashboards with Microsoft Dynamics GP 2016

The book shows you in detail how to build great-looking dashboards with Microsoft Dynamics GP. It will take you from creating amazing dashboards using various tools such as Excel 2016, Power BI to Jet Express. We will also cover core topics such as Business Analyzer, Microsoft SQL Reporting services reports, BI360, and more.

Mar 2017 11 hours 48 minutes

Hands-On Artificial Intelligence for Banking

Hands-On Artificial Intelligence for Banking

Hands-On Artificial Intelligence for Banking is a must-have guide for AI developers and machine learning experts looking to build intelligent finance-based applications. This guide will give its readers a complete overview of the global banking business with the help of interesting use-cases, and their implementation using popular Python libraries.

Jul 2020 8 hours 0 minutes

Microsoft Dynamics 365 Enterprise Edition - Financial Management

Microsoft Dynamics 365 Enterprise Edition - Financial Management

Microsoft Dynamics 365 for finance and operations is a rapidly growing application and is widely used in enterprise organizations. Because of its ability to maximize business productivity, it is a fast-growing business application package in the ERP market.

Mar 2018 18 hours 44 minutes

Odoo 10 Implementation Cookbook

Odoo 10 Implementation Cookbook

Odoo is a Python-based ERP system and is completely open source. Odoo is a comprehensive suite of business applications offering a wealth of functionalities that can be deployed to meet your business needs.

Oct 2017 26 hours 52 minutes

Python for Finance

Python for Finance

Python is a free and powerful tool used for quantitative finance and is a popular choice amongst many financial analysts. This book will teach you the basics of quantitative finance, and how they can be implemented by making use of the various Python libraries and modules.This book introduces you to the basic concepts and operations related to Python and teaches you how to work with the various Python libraries like NumPy, Scipy, Matplotlib, and Pandas for quantitative analysis. You will work with time-series data, and implement concepts like stochastics for Monte-Carlo simulation, hedging, derivatives, portfolio optimization and more.This book is a hands-on guide with easy-to-follow examples to help you learn about option theory, quantitative finance, financial modeling, and time series using Python.

Jun 2017 19 hours 32 minutes

Mastering QuickBooks 2020

Mastering QuickBooks 2020

QuickBooks is a bookkeeping software for finance professionals to manage business accounting demands and reports. This book will help you build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and every other accounting-related task crossing your desk at work.

Dec 2019 11 hours 4 minutes

Mastering QuickBooks 2021

Mastering QuickBooks 2021

QuickBooks is a bookkeeping software for managing business accounting demands and reports. With this book, you’ll be able to use QuickBooks Online to build the perfect budget, simplify tax return preparation, manage inventory, track job costs, generate income statements and financial reports, and perform all accounting-related tasks with ease.

Jan 2021 13 hours 48 minutes

Hands-On Machine Learning with Microsoft Excel 2019

Hands-On Machine Learning with Microsoft Excel 2019

Machine learning has become a core necessity for every business and organization. With this book, you will learn to analyze your Excel data to search for patterns and return a series of interesting facts or trends about the data. You will learn to perform machine learning tasks using Excel plugins and APIs without much code required.

Apr 2019 8 hours 28 minutes

Personalised recommendations for you

Based on your interests and search pattern

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

Aug 2023 7 hours 40 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Mastering Tableau 2023

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

Aug 2023 22 hours 48 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Data Engineering with AWS

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

Oct 2023 21 hours 12 minutes

Modern Data Architecture on AWS

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

Aug 2023 14 hours 0 minutes

Practical Guide to Applied Conformal Prediction in Python

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

Dec 2023 8 hours 0 minutes

TinyML Cookbook

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

Nov 2023 22 hours 8 minutes