Data
Reader small image

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

Product typeBook
Published inJul 2019
PublisherPackt
ISBN-139781789534627
Edition1st Edition
Tools
Excel
Concepts
Financial Technology
Right arrow
Author (1)
Shmuel Oluwa
Shmuel Oluwa
author image
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 about Shmuel Oluwa

Right arrow

Creating a loan amortization schedule

Let's assume that you work at a bank and a customer has requested a home loan. However, the customer doesn't want any of the pre-made packages on offer and wants a customized loan for a specific tenure and amount. In such cases, the calculations to compute the detailed schedule might take a lot of time, which is valuable when it comes to dealing with customers. It would be really useful to have a unique model tailored to your needs, which can easily compute values for all kinds of loans. We will now learn how to create one such schedule here, implementing most of the things we have learned in this chapter.

Creating the template

Our first step is to create a common template that...

lock icon
The rest of the page is locked
Previous Page
Chapter 10 of 15, Page 6
Next Page
You have been reading a chapter from
Hands-On Financial Modeling with Microsoft Excel 2019
Published in: Jul 2019Publisher: PacktISBN-13: 9781789534627
© 2019 Packt Publishing Limited All Rights Reserved

Author (1)

author image
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 about 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

BookMay 2020794 pages
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.

BookMar 2017354 pages
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.

BookJul 2020240 pages
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.

BookMar 2018562 pages
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.

BookOct 2017806 pages
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.

BookJun 2017586 pages
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.

BookDec 2019332 pages
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.

BookJan 2021414 pages
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.

BookApr 2019254 pages

Personalised recommendations for you

Based on your interests and search pattern

Et al.

Et al.

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.

BookAug 2023230 pages5
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.

BookDec 2023360 pages4
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.

BookDec 2023360 pages5
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.

BookDec 2023360 pages1
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.

BookDec 2023360 pages5
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.

BookAug 2023684 pages
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.

BookSep 2023258 pages5
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.

BookSep 2023258 pages2
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.

BookOct 2023636 pages5
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.

BookAug 2023420 pages5
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.

BookDec 2023240 pages
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.

BookNov 2023664 pages