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:
- 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:
- 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:
- Now, we need to convert this table into a list. We will do that ...