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 a loan amortization schedule
Creating the template
Our first step is to create a common template that...