O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating the template

Our first step is to create a common template that can be used for all purposes. We will do this by taking the following steps:

  1. The first thing to do is create a template for calculating the loan. We will do this by first creating a two-by-four table for entering the variables in the loan, as follows:

  1. We will now add data validation to the Payments per year field, so that we can choose between four options of payment—semi-monthly, monthly, quarterly, and yearly. For this, we will first create a table containing 4 values—24, 12, 4, and 1, as seen here:
  1. Now, we need to convert this table into a list. We will do that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required